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 129: -- Desc : check if the role_name exists in cn_roles

125: END;
126:
127: -- ----------------------------------------------------------------------------*
128: -- Function : valid_role_name
129: -- Desc : check if the role_name exists in cn_roles
130: -- ---------------------------------------------------------------------------*
131: FUNCTION valid_role_name
132: (
133: p_role_name cn_roles.name%TYPE

Line 133: p_role_name cn_roles.name%TYPE

129: -- Desc : check if the role_name exists in cn_roles
130: -- ---------------------------------------------------------------------------*
131: FUNCTION valid_role_name
132: (
133: p_role_name cn_roles.name%TYPE
134: ) RETURN BOOLEAN IS
135:
136: CURSOR l_cur(l_role_name cn_roles.name%TYPE) IS
137: SELECT *

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

132: (
133: p_role_name cn_roles.name%TYPE
134: ) RETURN BOOLEAN IS
135:
136: CURSOR l_cur(l_role_name cn_roles.name%TYPE) IS
137: SELECT *
138: FROM cn_roles
139: WHERE name = l_role_name;
140:

Line 138: FROM cn_roles

134: ) RETURN BOOLEAN IS
135:
136: CURSOR l_cur(l_role_name cn_roles.name%TYPE) IS
137: SELECT *
138: FROM cn_roles
139: WHERE name = l_role_name;
140:
141: l_rec l_cur%ROWTYPE;
142:

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

186: END valid_pay_groups_name;
187:
188: -- ----------------------------------------------------------------------------*
189: -- Function : valid_role_pay_group_id
190: -- Desc : check if the pay_group_id exists in cn_roles
191: -- ---------------------------------------------------------------------------*
192: FUNCTION valid_role_pay_group_id
193: (
194: p_role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE

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

346: x_return_status OUT NOCOPY VARCHAR2,
347: x_msg_count OUT NOCOPY NUMBER,
348: x_msg_data OUT NOCOPY VARCHAR2,
349: p_role_pay_groups_rec IN role_pay_groups_rec_type,
350: x_role_id OUT NOCOPY cn_roles.role_id%TYPE,
351: x_pay_group_id OUT NOCOPY cn_role_pay_groups.pay_group_id%TYPE,
352: p_loading_status IN VARCHAR2,
353: x_loading_status OUT NOCOPY VARCHAR2
354: ) IS

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

359: l_loading_status VARCHAR2(100);
360: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
361:
362:
363: CURSOR l_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_role_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:

Line 417: -- role_name must exist in cn_roles

413: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN
414: RAISE FND_API.G_EXC_ERROR ;
415: END IF;
416:
417: -- role_name must exist in cn_roles
418: IF NOT valid_role_name(p_role_pay_groups_rec.role_name) THEN
419: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
420: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
421: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pay_groups_rec.role_name);

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

695: -- --------------------------------------------------------------------------*
696: -- Procedure: srp_plan_assignment_for_delete
697: -- --------------------------------------------------------------------------*
698: PROCEDURE srp_plan_assignment_for_delete
699: (p_role_id IN cn_roles.role_id%TYPE,
700: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
701: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
702: p_org_id IN cn_salesreps.org_id%TYPE,
703: x_return_status OUT NOCOPY VARCHAR2,

Line 771: l_role_id cn_roles.role_id%TYPE;

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

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

785: SELECT role_id, srp_role_id,start_date, nvl(end_date,l_null_date) end_date,org_id
786: FROM cn_srp_roles
787: WHERE salesrep_id = p_salesrep_id and org_id=p_org_id;
788:
789: CURSOR get_role_plans(p_role_id cn_roles.role_id%TYPE,p_org_id cn_role_plans.org_id%TYPE) IS
790: SELECT role_plan_id
791: FROM cn_role_plans
792: WHERE role_id = p_role_id and org_id=p_org_id;
793:

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

801: FROM cn_srp_plan_assigns
802: WHERE role_id = p_role_id
803: AND salesrep_id = p_salesrep_id and org_id=p_org_id;
804:
805: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS
806: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
807: FROM cn_srp_roles WHERE role_id = l_role_id and org_id=l_org_id;
808:
809:

Line 1145: l_role_id cn_roles.role_id%TYPE;

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

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

1162: WHERE salesrep_id = p_salesrep_id and org_id=p_org_id;
1163:
1164: --Changed the cursor to fetch role_plans for the role_id passed
1165:
1166: CURSOR get_role_plans(l_role_id cn_roles.role_id%TYPE,l_org_id cn_role_plans.org_id%TYPE) IS
1167: SELECT role_plan_id,role_id
1168: FROM cn_role_plans
1169: WHERE role_id =l_role_id and org_id=l_org_id;
1170: