eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_API dependencies on CN_ROLE_PLANS

Line 386: -- Desc : get the role_plan_id if it exists in cn_role_plans

382:
383: --PRAGMA RESTRICT_REFERENCES (get_role_name,WNDS,WNPS);
384: -- --------------------------------------------------------------------------+
385: -- Function : get_role_plan_id
386: -- Desc : get the role_plan_id if it exists in cn_role_plans
387: -- --------------------------------------------------------------------------+
388: FUNCTION get_role_plan_id
389: (
390: p_role_name IN VARCHAR2,

Line 395: ) RETURN cn_role_plans.role_plan_id%TYPE;

391: p_comp_plan_name IN VARCHAR2,
392: p_start_date IN DATE,
393: p_end_date IN DATE,
394: p_org_id IN NUMBER
395: ) RETURN cn_role_plans.role_plan_id%TYPE;
396: -- --------------------------------------------------------------------------+
397: -- Function : get_role_pmt_plan_id
398: -- Desc : get the role_pmt_plan_id if it exists in cn_role_pmt_plans
399: -- --------------------------------------------------------------------------+