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_ROLE_PAY_GROUPS_PVT dependencies on CN_PAY_GROUPS

Line 136: from cn_pay_groups

132:
133: -- get pay groups start and end dates
134: select start_date, end_date
135: into l_pg_start_date, l_pg_end_date
136: from cn_pay_groups
137: where pay_group_id = l_pay_group_id;
138:
139: -- get intersection with pay group start and end dates
140: get_date_range_intersect(

Line 186: p_pay_group_name cn_pay_groups.name%TYPE,

182: -- Desc : check if the comp_plan_name exists in cn_comp_plans
183: -- ---------------------------------------------------------------------------*
184: FUNCTION valid_pay_groups_name
185: (
186: p_pay_group_name cn_pay_groups.name%TYPE,
187: p_org_id cn_pay_groups.org_id%TYPE
188: ) RETURN BOOLEAN IS
189:
190: CURSOR l_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS

Line 187: p_org_id cn_pay_groups.org_id%TYPE

183: -- ---------------------------------------------------------------------------*
184: FUNCTION valid_pay_groups_name
185: (
186: p_pay_group_name cn_pay_groups.name%TYPE,
187: p_org_id cn_pay_groups.org_id%TYPE
188: ) RETURN BOOLEAN IS
189:
190: CURSOR l_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
191: SELECT *

Line 190: CURSOR l_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS

186: p_pay_group_name cn_pay_groups.name%TYPE,
187: p_org_id cn_pay_groups.org_id%TYPE
188: ) RETURN BOOLEAN IS
189:
190: CURSOR l_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
191: SELECT *
192: FROM cn_pay_groups
193: WHERE name = l_pay_group_name and org_id =l_org_id;
194:

Line 192: FROM cn_pay_groups

188: ) RETURN BOOLEAN IS
189:
190: CURSOR l_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
191: SELECT *
192: FROM cn_pay_groups
193: WHERE name = l_pay_group_name and org_id =l_org_id;
194:
195: l_rec l_cur%ROWTYPE;
196:

Line 273: RETURN cn_pay_groups.pay_group_id%TYPE IS

269:
270: END is_exist;
271:
272: FUNCTION get_pg_id ( p_pay_group_name VARCHAR2,p_org_id NUMBER )
273: RETURN cn_pay_groups.pay_group_id%TYPE IS
274:
275: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
276:
277: BEGIN

Line 275: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;

271:
272: FUNCTION get_pg_id ( p_pay_group_name VARCHAR2,p_org_id NUMBER )
273: RETURN cn_pay_groups.pay_group_id%TYPE IS
274:
275: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
276:
277: BEGIN
278: SELECT pay_group_id
279: INTO l_pay_group_id

Line 280: FROM cn_pay_groups

276:
277: BEGIN
278: SELECT pay_group_id
279: INTO l_pay_group_id
280: FROM cn_pay_groups
281: WHERE name = p_pay_group_name and org_id=p_org_id;
282:
283: RETURN l_pay_group_id;
284:

Line 296: RETURN cn_pay_groups.name%TYPE IS

292: --| Function Name : get_pay_group_name
293: --| Desc : Get the pay group name using the pay group id
294: --| ---------------------------------------------------------------------=
295: FUNCTION get_pg_name (p_pay_group_id VARCHAR2 )
296: RETURN cn_pay_groups.name%TYPE IS
297:
298: l_pay_group_name cn_pay_groups.name%TYPE;
299:
300: BEGIN

Line 298: l_pay_group_name cn_pay_groups.name%TYPE;

294: --| ---------------------------------------------------------------------=
295: FUNCTION get_pg_name (p_pay_group_id VARCHAR2 )
296: RETURN cn_pay_groups.name%TYPE IS
297:
298: l_pay_group_name cn_pay_groups.name%TYPE;
299:
300: BEGIN
301: SELECT name
302: INTO l_pay_group_name

Line 303: FROM cn_pay_groups

299:
300: BEGIN
301: SELECT name
302: INTO l_pay_group_name
303: FROM cn_pay_groups
304: WHERE pay_group_id = p_pay_group_id ;
305:
306: RETURN l_pay_group_name;
307:

Line 391: CURSOR l_cp_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS

387: SELECT start_date, end_date, pay_group_id
388: FROM cn_role_pay_groups
389: WHERE role_id = l_role_id and org_id=l_org_id;
390:
391: CURSOR l_cp_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
392: SELECT start_date, end_date
393: FROM cn_pay_groups
394: WHERE name = l_pay_group_name and org_id=l_org_id;
395:

Line 393: FROM cn_pay_groups

389: WHERE role_id = l_role_id and org_id=l_org_id;
390:
391: CURSOR l_cp_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
392: SELECT start_date, end_date
393: FROM cn_pay_groups
394: WHERE name = l_pay_group_name and org_id=l_org_id;
395:
396: l_cp_rec l_cp_cur%ROWTYPE;
397:

Line 452: -- pay_group_name must exist in cn_pay_groups

448: RAISE fnd_api.g_exc_error;
449: ELSE
450: x_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);
451: END IF;
452: -- pay_group_name must exist in cn_pay_groups
453: IF NOT valid_pay_groups_name(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id) THEN
454: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
455: fnd_message.set_name('CN', 'CN_RL_ASGN_PG_NOT_EXIST');
456: fnd_message.set_token('PAY_GROUP',p_role_pay_groups_rec.pay_groups_name);

Line 471: FROM cn_pay_groups

467: -- pay group.
468: --
469: SELECT COUNT(1)
470: INTO l_count
471: FROM cn_pay_groups
472: WHERE (( p_role_pay_groups_rec.start_date NOT BETWEEN start_date AND end_date )
473: OR (p_role_pay_groups_rec.end_date NOT BETWEEN start_date AND end_date))
474: AND pay_group_id = x_pay_group_id;
475:

Line 795: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;

791: l_api_name CONSTANT VARCHAR2(30) := 'Create_Role_Pay_Groups';
792: l_api_version CONSTANT NUMBER := 1.0;
793: l_role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE;
794: l_role_id cn_roles.role_id%TYPE;
795: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
796: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
797: l_loading_status VARCHAR2(100);
798:
799: -- Declaration for user hooks

Line 988: FROM cn_pay_groups

984: -- if S-PG end date is null and PG end date is not null,
985: -- that is OK
986: SELECT COUNT(1)
987: INTO l_count
988: FROM cn_pay_groups
989: WHERE (l_rec.start_date NOT BETWEEN start_date AND end_date OR
990: (l_rec.end_date IS NOT NULL AND
991: l_rec.end_date NOT BETWEEN start_date AND end_date))
992: AND pay_group_id = l_pay_group_id;

Line 1196: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;

1192: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Role_Pay_Groups';
1193: l_api_version CONSTANT NUMBER := 1.0;
1194: l_role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE;
1195: l_role_id cn_roles.role_id%TYPE;
1196: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1197: l_org_id cn_pay_groups.org_id%TYPE;
1198: -- Declaration for user hooks
1199: l_rec role_pay_groups_rec_type;
1200: l_OAI_array JTF_USR_HKS.oai_data_array_type;

Line 1197: l_org_id cn_pay_groups.org_id%TYPE;

1193: l_api_version CONSTANT NUMBER := 1.0;
1194: l_role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE;
1195: l_role_id cn_roles.role_id%TYPE;
1196: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1197: l_org_id cn_pay_groups.org_id%TYPE;
1198: -- Declaration for user hooks
1199: l_rec role_pay_groups_rec_type;
1200: l_OAI_array JTF_USR_HKS.oai_data_array_type;
1201: l_bind_data_id NUMBER ;

Line 1236: CURSOR get_salesreps(l_role_id NUMBER,l_pay_group_id cn_pay_groups.pay_group_id%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS

1232: and org_id=p_org_id;
1233:
1234:
1235:
1236: CURSOR get_salesreps(l_role_id NUMBER,l_pay_group_id cn_pay_groups.pay_group_id%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
1237: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
1238: FROM cn_srp_roles
1239: WHERE role_id = l_role_id
1240: AND salesrep_id IN (select salesrep_id from cn_srp_pay_groups where pay_group_id=l_pay_group_id)