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_PMT_PLANS

Line 398: -- Desc : get the role_pmt_plan_id if it exists in cn_role_pmt_plans

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: -- --------------------------------------------------------------------------+
400: FUNCTION get_role_pmt_plan_id
401: (
402: p_role_name IN VARCHAR2,

Line 407: ) RETURN cn_role_pmt_plans.role_pmt_plan_id%TYPE;

403: p_pmt_plan_name IN VARCHAR2,
404: p_start_date IN DATE,
405: p_end_date IN DATE,
406: p_org_id IN NUMBER
407: ) RETURN cn_role_pmt_plans.role_pmt_plan_id%TYPE;
408: -- --------------------------------------------------------------------------+
409: -- Function : get_srp_role_plan_id
410: -- Desc : get the srp_role_plan_id if it exists in cn_srp_roles
411: -- --------------------------------------------------------------------------+