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_ROLES

Line 152: -- Desc : check if the role_name exists in cn_roles

148: END;
149:
150: -- ----------------------------------------------------------------------------*
151: -- Function : valid_role_name
152: -- Desc : check if the role_name exists in cn_roles
153: -- ---------------------------------------------------------------------------*
154: FUNCTION valid_role_name
155: (
156: p_role_name cn_roles.name%TYPE

Line 156: p_role_name cn_roles.name%TYPE

152: -- Desc : check if the role_name exists in cn_roles
153: -- ---------------------------------------------------------------------------*
154: FUNCTION valid_role_name
155: (
156: p_role_name cn_roles.name%TYPE
157: ) RETURN BOOLEAN IS
158:
159: CURSOR l_cur(l_role_name cn_roles.name%TYPE) IS
160: SELECT *

Line 159: CURSOR l_cur(l_role_name cn_roles.name%TYPE) IS

155: (
156: p_role_name cn_roles.name%TYPE
157: ) RETURN BOOLEAN IS
158:
159: CURSOR l_cur(l_role_name cn_roles.name%TYPE) IS
160: SELECT *
161: FROM cn_roles
162: WHERE name = l_role_name;
163:

Line 161: FROM cn_roles

157: ) RETURN BOOLEAN IS
158:
159: CURSOR l_cur(l_role_name cn_roles.name%TYPE) IS
160: SELECT *
161: FROM cn_roles
162: WHERE name = l_role_name;
163:
164: l_rec l_cur%ROWTYPE;
165:

Line 213: -- Desc : check if the pay_group_id exists in cn_roles

209: END valid_pay_groups_name;
210:
211: -- ----------------------------------------------------------------------------*
212: -- Function : valid_role_pay_group_id
213: -- Desc : check if the pay_group_id exists in cn_roles
214: -- ---------------------------------------------------------------------------*
215: FUNCTION valid_role_pay_group_id
216: (
217: p_role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE

Line 373: x_role_id OUT NOCOPY cn_roles.role_id%TYPE,

369: x_return_status OUT NOCOPY VARCHAR2,
370: x_msg_count OUT NOCOPY NUMBER,
371: x_msg_data OUT NOCOPY VARCHAR2,
372: p_role_pay_groups_rec IN role_pay_groups_rec_type,
373: x_role_id OUT NOCOPY cn_roles.role_id%TYPE,
374: x_pay_group_id OUT NOCOPY cn_role_pay_groups.pay_group_id%TYPE,
375: p_loading_status IN VARCHAR2,
376: x_loading_status OUT NOCOPY VARCHAR2
377: ) IS

Line 386: CURSOR l_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_role_pay_groups.org_id%TYPE) IS

382: l_loading_status VARCHAR2(100);
383: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
384:
385:
386: CURSOR l_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_role_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:

Line 440: -- role_name must exist in cn_roles

436: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN
437: RAISE FND_API.G_EXC_ERROR ;
438: END IF;
439:
440: -- role_name must exist in cn_roles
441: IF NOT valid_role_name(p_role_pay_groups_rec.role_name) THEN
442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
443: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
444: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pay_groups_rec.role_name);

Line 722: (p_role_id IN cn_roles.role_id%TYPE,

718: -- --------------------------------------------------------------------------*
719: -- Procedure: srp_plan_assignment_for_delete
720: -- --------------------------------------------------------------------------*
721: PROCEDURE srp_plan_assignment_for_delete
722: (p_role_id IN cn_roles.role_id%TYPE,
723: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
724: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
725: p_org_id IN cn_salesreps.org_id%TYPE,
726: x_return_status OUT NOCOPY VARCHAR2,

Line 794: l_role_id cn_roles.role_id%TYPE;

790:
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:

Line 825: CURSOR get_role_plans(p_role_id cn_roles.role_id%TYPE,p_org_id cn_role_plans.org_id%TYPE) IS

821: AND
822: ((end_Date_active is null)
823: OR (end_Date_active IS NOT NULL AND end_Date_active BETWEEN p_role_pay_groups_rec.start_date AND p_role_pay_groups_rec.end_date));
824:
825: CURSOR get_role_plans(p_role_id cn_roles.role_id%TYPE,p_org_id cn_role_plans.org_id%TYPE) IS
826: SELECT role_plan_id
827: FROM cn_role_plans
828: WHERE role_id = p_role_id and org_id=p_org_id;
829:

Line 842: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS

838: WHERE role_id = p_role_id
839: AND salesrep_id = p_salesrep_id and org_id=p_org_id;
840:
841: /*
842: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS
843: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
844: FROM cn_srp_roles WHERE role_id = l_role_id and org_id=l_org_id;
845: */
846: --raj reddy for bug fix 8845580

Line 847: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS

843: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
844: FROM cn_srp_roles WHERE role_id = l_role_id and org_id=l_org_id;
845: */
846: --raj reddy for bug fix 8845580
847: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS
848: SELECT sr.srp_role_id,sr.salesrep_id,sr.start_date,sr.end_date,sr.org_id
849: FROM jtf_rs_Salesreps s,
850: cn_srp_roles sr
851: WHERE sr.salesrep_id = s.salesrep_id

Line 1195: l_role_id cn_roles.role_id%TYPE;

1191:
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;

Line 1216: CURSOR get_role_plans(l_role_id cn_roles.role_id%TYPE,l_org_id cn_role_plans.org_id%TYPE) IS

1212: WHERE salesrep_id = p_salesrep_id and org_id=p_org_id;
1213:
1214: --Changed the cursor to fetch role_plans for the role_id passed
1215:
1216: CURSOR get_role_plans(l_role_id cn_roles.role_id%TYPE,l_org_id cn_role_plans.org_id%TYPE) IS
1217: SELECT role_plan_id,role_id
1218: FROM cn_role_plans
1219: WHERE role_id =l_role_id and org_id=l_org_id;
1220: