APPS.CN_API dependencies on CN_ROLES

Line 373: RETURN cn_roles.role_id%TYPE;

369: --| Function Name : get_role_id
370: --| Desc : Get the role id using the role name
371: --| ---------------------------------------------------------------------+
372: FUNCTION get_role_id ( p_role_name VARCHAR2 )
373: RETURN cn_roles.role_id%TYPE;
374:
375: --PRAGMA RESTRICT_REFERENCES (get_role_id,WNDS,WNPS);
376: --| ---------------------------------------------------------------------+
377: --| Function Name : get_role_name

Line 381: RETURN cn_roles.name%TYPE;

377: --| Function Name : get_role_name
378: --| Desc : Get the role name using the role ID
379: --| ---------------------------------------------------------------------+
380: FUNCTION get_role_name ( p_role_id VARCHAR2 )
381: RETURN cn_roles.name%TYPE;
382:
383: --PRAGMA RESTRICT_REFERENCES (get_role_name,WNDS,WNPS);
384: -- --------------------------------------------------------------------------+
385: -- Function : get_role_plan_id

Line 415: p_role_name IN cn_roles.name%type,

411: -- --------------------------------------------------------------------------+
412: FUNCTION get_srp_role_id
413: (p_emp_num IN cn_salesreps.employee_number%type,
414: p_type IN cn_salesreps.TYPE%type,
415: p_role_name IN cn_roles.name%type,
416: p_start_date IN cn_srp_roles.start_date%type,
417: p_end_date IN cn_srp_roles.end_date%TYPE,
418: p_org_id IN cn_salesreps.org_id%type
419: ) RETURN cn_srp_roles.srp_role_id%TYPE;

Line 882: RETURN cn_roles.name%TYPE;

878: FUNCTION Test_Function( p_function_name IN VARCHAR2) RETURN NUMBER;
879:
880: FUNCTION get_role_name_2 (period_id NUMBER,
881: salesrep_id NUMBER)
882: RETURN cn_roles.name%TYPE;
883:
884: END CN_API;