APPS.CN_API dependencies on CN_ROLES

Line 1193: RETURN cn_roles.role_id%TYPE IS

1189: --| Function Name : get_role_id
1190: --| Desc : Get the role id using the role name
1191: --| ---------------------------------------------------------------------=
1192: FUNCTION get_role_id ( p_role_name VARCHAR2 )
1193: RETURN cn_roles.role_id%TYPE IS
1194:
1195: l_role_id cn_roles.role_id%TYPE;
1196:
1197: BEGIN

Line 1195: l_role_id cn_roles.role_id%TYPE;

1191: --| ---------------------------------------------------------------------=
1192: FUNCTION get_role_id ( p_role_name VARCHAR2 )
1193: RETURN cn_roles.role_id%TYPE IS
1194:
1195: l_role_id cn_roles.role_id%TYPE;
1196:
1197: BEGIN
1198: -- added uppers to avoid FTS for bug 5075017
1199: SELECT role_id

Line 1201: FROM cn_roles

1197: BEGIN
1198: -- added uppers to avoid FTS for bug 5075017
1199: SELECT role_id
1200: INTO l_role_id
1201: FROM cn_roles
1202: WHERE Upper(name) = Upper(p_role_name) ;
1203:
1204: RETURN l_role_id;
1205:

Line 1216: RETURN cn_roles.name%TYPE IS

1212: --| Function Name : get_role_name
1213: --| Desc : Get the role name using the role id
1214: --| ---------------------------------------------------------------------=
1215: FUNCTION get_role_name ( p_role_id VARCHAR2 )
1216: RETURN cn_roles.name%TYPE IS
1217:
1218: l_role_name cn_roles.name%TYPE;
1219:
1220: BEGIN

Line 1218: l_role_name cn_roles.name%TYPE;

1214: --| ---------------------------------------------------------------------=
1215: FUNCTION get_role_name ( p_role_id VARCHAR2 )
1216: RETURN cn_roles.name%TYPE IS
1217:
1218: l_role_name cn_roles.name%TYPE;
1219:
1220: BEGIN
1221: SELECT name
1222: INTO l_role_name

Line 1223: FROM cn_roles

1219:
1220: BEGIN
1221: SELECT name
1222: INTO l_role_name
1223: FROM cn_roles
1224: WHERE role_id = p_role_id ;
1225:
1226: RETURN l_role_name;
1227:

Line 1241: p_role_name IN cn_roles.name%type,

1237: -- --------------------------------------------------------------------------=
1238: FUNCTION get_srp_role_id
1239: (p_emp_num IN cn_salesreps.employee_number%type,
1240: p_type IN cn_salesreps.TYPE%type,
1241: p_role_name IN cn_roles.name%type,
1242: p_start_date IN cn_srp_roles.start_date%type,
1243: p_end_date IN cn_srp_roles.end_date%TYPE,
1244: p_org_id IN cn_salesreps.org_id%type
1245: ) RETURN cn_srp_roles.srp_role_id%TYPE IS

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

1288: END get_srp_role_id;
1289:
1290: -- --------------------------------------------------------------------------=
1291: -- Function : get_role_plan_id
1292: -- Desc : get the role_plan_id if it exists in cn_roles
1293: -- --------------------------------------------------------------------------=
1294: FUNCTION get_role_plan_id
1295: (
1296: p_role_name IN VARCHAR2,

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

1334: END get_role_plan_id;
1335:
1336: -- --------------------------------------------------------------------------=
1337: -- Function : get_role_pmt_plan_id
1338: -- Desc : get the role_pmt_plan_id if it exists in cn_roles_pmt_plans
1339: -- --------------------------------------------------------------------------=
1340: FUNCTION get_role_pmt_plan_id
1341: (
1342: p_role_name IN VARCHAR2,

Line 3100: RETURN cn_roles.name%TYPE IS

3096:
3097: FUNCTION get_role_name_2 (period_id NUMBER,
3098: -- payrun_id NUMBER,
3099: salesrep_id NUMBER)
3100: RETURN cn_roles.name%TYPE IS
3101: l_role_name cn_roles.name%TYPE;
3102: l_role_str VARCHAR2(1000):= '';
3103: l_start_date DATE;
3104: CURSOR get_role_cursor(l_period_id NUMBER,

Line 3101: l_role_name cn_roles.name%TYPE;

3097: FUNCTION get_role_name_2 (period_id NUMBER,
3098: -- payrun_id NUMBER,
3099: salesrep_id NUMBER)
3100: RETURN cn_roles.name%TYPE IS
3101: l_role_name cn_roles.name%TYPE;
3102: l_role_str VARCHAR2(1000):= '';
3103: l_start_date DATE;
3104: CURSOR get_role_cursor(l_period_id NUMBER,
3105: l_salesrep_id IN NUMBER)

Line 3110: cn_roles r

3106: IS
3107: SELECT distinct r.name role_name,assign.start_date
3108: FROM cn_srp_periods srp,
3109: cn_srp_plan_assigns assign,
3110: cn_roles r
3111: WHERE assign.srp_plan_assign_id(+)= srp.srp_plan_assign_id
3112: AND srp.period_id = l_period_id
3113: AND assign.role_id = r.role_id(+)
3114: AND srp.salesrep_id = l_salesrep_id