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 113: from cn_pay_groups

109:
110: -- get pay groups start and end dates
111: select start_date, end_date
112: into l_pg_start_date, l_pg_end_date
113: from cn_pay_groups
114: where pay_group_id = l_pay_group_id;
115:
116: -- get intersection with pay group start and end dates
117: get_date_range_intersect(

Line 163: p_pay_group_name cn_pay_groups.name%TYPE,

159: -- Desc : check if the comp_plan_name exists in cn_comp_plans
160: -- ---------------------------------------------------------------------------*
161: FUNCTION valid_pay_groups_name
162: (
163: p_pay_group_name cn_pay_groups.name%TYPE,
164: p_org_id cn_pay_groups.org_id%TYPE
165: ) RETURN BOOLEAN IS
166:
167: CURSOR l_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS

Line 164: p_org_id cn_pay_groups.org_id%TYPE

160: -- ---------------------------------------------------------------------------*
161: FUNCTION valid_pay_groups_name
162: (
163: p_pay_group_name cn_pay_groups.name%TYPE,
164: p_org_id cn_pay_groups.org_id%TYPE
165: ) RETURN BOOLEAN IS
166:
167: CURSOR l_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
168: SELECT *

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

163: p_pay_group_name cn_pay_groups.name%TYPE,
164: p_org_id cn_pay_groups.org_id%TYPE
165: ) RETURN BOOLEAN IS
166:
167: CURSOR l_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
168: SELECT *
169: FROM cn_pay_groups
170: WHERE name = l_pay_group_name and org_id =l_org_id;
171:

Line 169: FROM cn_pay_groups

165: ) RETURN BOOLEAN IS
166:
167: CURSOR l_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
168: SELECT *
169: FROM cn_pay_groups
170: WHERE name = l_pay_group_name and org_id =l_org_id;
171:
172: l_rec l_cur%ROWTYPE;
173:

Line 250: RETURN cn_pay_groups.pay_group_id%TYPE IS

246:
247: END is_exist;
248:
249: FUNCTION get_pg_id ( p_pay_group_name VARCHAR2,p_org_id NUMBER )
250: RETURN cn_pay_groups.pay_group_id%TYPE IS
251:
252: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
253:
254: BEGIN

Line 252: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;

248:
249: FUNCTION get_pg_id ( p_pay_group_name VARCHAR2,p_org_id NUMBER )
250: RETURN cn_pay_groups.pay_group_id%TYPE IS
251:
252: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
253:
254: BEGIN
255: SELECT pay_group_id
256: INTO l_pay_group_id

Line 257: FROM cn_pay_groups

253:
254: BEGIN
255: SELECT pay_group_id
256: INTO l_pay_group_id
257: FROM cn_pay_groups
258: WHERE name = p_pay_group_name and org_id=p_org_id;
259:
260: RETURN l_pay_group_id;
261:

Line 273: RETURN cn_pay_groups.name%TYPE IS

269: --| Function Name : get_pay_group_name
270: --| Desc : Get the pay group name using the pay group id
271: --| ---------------------------------------------------------------------=
272: FUNCTION get_pg_name (p_pay_group_id VARCHAR2 )
273: RETURN cn_pay_groups.name%TYPE IS
274:
275: l_pay_group_name cn_pay_groups.name%TYPE;
276:
277: BEGIN

Line 275: l_pay_group_name cn_pay_groups.name%TYPE;

271: --| ---------------------------------------------------------------------=
272: FUNCTION get_pg_name (p_pay_group_id VARCHAR2 )
273: RETURN cn_pay_groups.name%TYPE IS
274:
275: l_pay_group_name cn_pay_groups.name%TYPE;
276:
277: BEGIN
278: SELECT name
279: INTO l_pay_group_name

Line 280: FROM cn_pay_groups

276:
277: BEGIN
278: SELECT name
279: INTO l_pay_group_name
280: FROM cn_pay_groups
281: WHERE pay_group_id = p_pay_group_id ;
282:
283: RETURN l_pay_group_name;
284:

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

364: SELECT start_date, end_date, pay_group_id
365: FROM cn_role_pay_groups
366: WHERE role_id = l_role_id and org_id=l_org_id;
367:
368: CURSOR l_cp_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
369: SELECT start_date, end_date
370: FROM cn_pay_groups
371: WHERE name = l_pay_group_name and org_id=l_org_id;
372:

Line 370: FROM cn_pay_groups

366: WHERE role_id = l_role_id and org_id=l_org_id;
367:
368: CURSOR l_cp_cur(l_pay_group_name cn_pay_groups.name%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
369: SELECT start_date, end_date
370: FROM cn_pay_groups
371: WHERE name = l_pay_group_name and org_id=l_org_id;
372:
373: l_cp_rec l_cp_cur%ROWTYPE;
374:

Line 429: -- pay_group_name must exist in cn_pay_groups

425: RAISE fnd_api.g_exc_error;
426: ELSE
427: x_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);
428: END IF;
429: -- pay_group_name must exist in cn_pay_groups
430: IF NOT valid_pay_groups_name(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id) THEN
431: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
432: fnd_message.set_name('CN', 'CN_RL_ASGN_PG_NOT_EXIST');
433: fnd_message.set_token('PAY_GROUP',p_role_pay_groups_rec.pay_groups_name);

Line 448: FROM cn_pay_groups

444: -- pay group.
445: --
446: SELECT COUNT(1)
447: INTO l_count
448: FROM cn_pay_groups
449: WHERE (( p_role_pay_groups_rec.start_date NOT BETWEEN start_date AND end_date )
450: OR (p_role_pay_groups_rec.end_date NOT BETWEEN start_date AND end_date))
451: AND pay_group_id = x_pay_group_id;
452:

Line 772: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;

768: l_api_name CONSTANT VARCHAR2(30) := 'Create_Role_Pay_Groups';
769: l_api_version CONSTANT NUMBER := 1.0;
770: l_role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE;
771: l_role_id cn_roles.role_id%TYPE;
772: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
773: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
774: l_loading_status VARCHAR2(100);
775:
776: -- Declaration for user hooks

Line 938: FROM cn_pay_groups

934: -- if S-PG end date is null and PG end date is not null,
935: -- that is OK
936: SELECT COUNT(1)
937: INTO l_count
938: FROM cn_pay_groups
939: WHERE (l_rec.start_date NOT BETWEEN start_date AND end_date OR
940: (l_rec.end_date IS NOT NULL AND
941: l_rec.end_date NOT BETWEEN start_date AND end_date))
942: AND pay_group_id = l_pay_group_id;

Line 1146: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;

1142: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Role_Pay_Groups';
1143: l_api_version CONSTANT NUMBER := 1.0;
1144: l_role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE;
1145: l_role_id cn_roles.role_id%TYPE;
1146: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1147: l_org_id cn_pay_groups.org_id%TYPE;
1148: -- Declaration for user hooks
1149: l_rec role_pay_groups_rec_type;
1150: l_OAI_array JTF_USR_HKS.oai_data_array_type;

Line 1147: l_org_id cn_pay_groups.org_id%TYPE;

1143: l_api_version CONSTANT NUMBER := 1.0;
1144: l_role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE;
1145: l_role_id cn_roles.role_id%TYPE;
1146: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1147: l_org_id cn_pay_groups.org_id%TYPE;
1148: -- Declaration for user hooks
1149: l_rec role_pay_groups_rec_type;
1150: l_OAI_array JTF_USR_HKS.oai_data_array_type;
1151: l_bind_data_id NUMBER ;

Line 1186: 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

1182: and org_id=p_org_id;
1183:
1184:
1185:
1186: 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
1187: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
1188: FROM cn_srp_roles
1189: WHERE role_id = l_role_id
1190: AND salesrep_id IN (select salesrep_id from cn_srp_pay_groups where pay_group_id=l_pay_group_id)