how to give path to custom page tpl for content type
If I understood your question correctly, you are looking for hook_menu. You can find the API here. 

An Example:

function mymodule_menu() {
    $items['test_insights'] = array(
      'page callback' =&gt; 'mymodule_test_insights',
      'page arguments' =&gt; array(),
    );
    return $items;
  }

//The callback function
function mymodule_test_insights(){
    //Do the necessary actions
    return $something;
}


Note: After implementing the hook_menu you have to clear the drupal cache to access the URL.

To add content type specific page tpl you have to use theme_hook_suggestions by implementing template_preprocess_page. You can add the below code in the template.php file of your theme

Example:

function themeName_preprocess_page(&amp;$vars, $hook) { //themeName change to your theme name
  if (isset($vars['node'])) {
  // If the node type is "test_insights" the template suggestion will be "page--test--insights.tpl.php".
   $vars['theme_hook_suggestions'][] = 'page__'. str_replace('_', '--', $vars['node']-&gt;type);
  }
}