APPS.CN_API dependencies on CN_ROLES

Line 1215: RETURN cn_roles.role_id%TYPE IS

1211: --| Function Name : get_role_id
1212: --| Desc : Get the role id using the role name
1213: --| ---------------------------------------------------------------------=
1214: FUNCTION get_role_id ( p_role_name VARCHAR2 )
1215: RETURN cn_roles.role_id%TYPE IS
1216:
1217: l_role_id cn_roles.role_id%TYPE;
1218:
1219: BEGIN

Line 1217: l_role_id cn_roles.role_id%TYPE;

1213: --| ---------------------------------------------------------------------=
1214: FUNCTION get_role_id ( p_role_name VARCHAR2 )
1215: RETURN cn_roles.role_id%TYPE IS
1216:
1217: l_role_id cn_roles.role_id%TYPE;
1218:
1219: BEGIN
1220: -- added uppers to avoid FTS for bug 5075017
1221: SELECT role_id

Line 1223: FROM cn_roles

1219: BEGIN
1220: -- added uppers to avoid FTS for bug 5075017
1221: SELECT role_id
1222: INTO l_role_id
1223: FROM cn_roles
1224: WHERE Upper(name) = Upper(p_role_name) ;
1225:
1226: RETURN l_role_id;
1227:

Line 1238: RETURN cn_roles.name%TYPE IS

1234: --| Function Name : get_role_name
1235: --| Desc : Get the role name using the role id
1236: --| ---------------------------------------------------------------------=
1237: FUNCTION get_role_name ( p_role_id VARCHAR2 )
1238: RETURN cn_roles.name%TYPE IS
1239:
1240: l_role_name cn_roles.name%TYPE;
1241:
1242: BEGIN

Line 1240: l_role_name cn_roles.name%TYPE;

1236: --| ---------------------------------------------------------------------=
1237: FUNCTION get_role_name ( p_role_id VARCHAR2 )
1238: RETURN cn_roles.name%TYPE IS
1239:
1240: l_role_name cn_roles.name%TYPE;
1241:
1242: BEGIN
1243: SELECT name
1244: INTO l_role_name

Line 1245: FROM cn_roles

1241:
1242: BEGIN
1243: SELECT name
1244: INTO l_role_name
1245: FROM cn_roles
1246: WHERE role_id = p_role_id ;
1247:
1248: RETURN l_role_name;
1249:

Line 1263: p_role_name IN cn_roles.name%type,

1259: -- --------------------------------------------------------------------------=
1260: FUNCTION get_srp_role_id
1261: (p_emp_num IN cn_salesreps.employee_number%type,
1262: p_type IN cn_salesreps.TYPE%type,
1263: p_role_name IN cn_roles.name%type,
1264: p_start_date IN cn_srp_roles.start_date%type,
1265: p_end_date IN cn_srp_roles.end_date%TYPE,
1266: p_org_id IN cn_salesreps.org_id%type
1267: ) RETURN cn_srp_roles.srp_role_id%TYPE IS

Line 1314: -- Desc : get the role_plan_id if it exists in cn_roles

1310: END get_srp_role_id;
1311:
1312: -- --------------------------------------------------------------------------=
1313: -- Function : get_role_plan_id
1314: -- Desc : get the role_plan_id if it exists in cn_roles
1315: -- --------------------------------------------------------------------------=
1316: FUNCTION get_role_plan_id
1317: (
1318: p_role_name IN VARCHAR2,

Line 1360: -- Desc : get the role_pmt_plan_id if it exists in cn_roles_pmt_plans

1356: END get_role_plan_id;
1357:
1358: -- --------------------------------------------------------------------------=
1359: -- Function : get_role_pmt_plan_id
1360: -- Desc : get the role_pmt_plan_id if it exists in cn_roles_pmt_plans
1361: -- --------------------------------------------------------------------------=
1362: FUNCTION get_role_pmt_plan_id
1363: (
1364: p_role_name IN VARCHAR2,

Line 3124: RETURN cn_roles.name%TYPE IS

3120:
3121: FUNCTION get_role_name_2 (period_id NUMBER,
3122: -- payrun_id NUMBER,
3123: salesrep_id NUMBER)
3124: RETURN cn_roles.name%TYPE IS
3125: l_role_name cn_roles.name%TYPE;
3126: l_role_str VARCHAR2(1000):= '';
3127: l_start_date DATE;
3128:

Line 3125: l_role_name cn_roles.name%TYPE;

3121: FUNCTION get_role_name_2 (period_id NUMBER,
3122: -- payrun_id NUMBER,
3123: salesrep_id NUMBER)
3124: RETURN cn_roles.name%TYPE IS
3125: l_role_name cn_roles.name%TYPE;
3126: l_role_str VARCHAR2(1000):= '';
3127: l_start_date DATE;
3128:
3129: CURSOR get_role_cursor(l_period_id NUMBER,

Line 3152: cn_roles r

3148:
3149: /*SELECT distinct r.name role_name,assign.start_date
3150: FROM cn_srp_periods srp,
3151: cn_srp_plan_assigns assign,
3152: cn_roles r
3153: WHERE assign.srp_plan_assign_id(+)= srp.srp_plan_assign_id
3154: AND srp.period_id = l_period_id
3155: AND assign.role_id = r.role_id(+)
3156: AND srp.salesrep_id = l_salesrep_id