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_PMT_PLANS_PVT dependencies on CN_PMT_PLANS

Line 48: -- Desc : check if the pmt_plan_id exists in cn_pmt_plans

44: END valid_role_name;
45:
46: -- ----------------------------------------------------------------------------*
47: -- Function : valid_pmt_plan_id
48: -- Desc : check if the pmt_plan_id exists in cn_pmt_plans
49: -- ---------------------------------------------------------------------------*
50: FUNCTION valid_pmt_plan_id
51: (
52: p_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE,

Line 52: p_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE,

48: -- Desc : check if the pmt_plan_id exists in cn_pmt_plans
49: -- ---------------------------------------------------------------------------*
50: FUNCTION valid_pmt_plan_id
51: (
52: p_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE,
53: p_org_id cn_pmt_plans.org_id%TYPE
54: ) RETURN BOOLEAN IS
55:
56: CURSOR l_cur(l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE, l_org_id cn_pmt_plans.org_id%TYPE) IS

Line 53: p_org_id cn_pmt_plans.org_id%TYPE

49: -- ---------------------------------------------------------------------------*
50: FUNCTION valid_pmt_plan_id
51: (
52: p_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE,
53: p_org_id cn_pmt_plans.org_id%TYPE
54: ) RETURN BOOLEAN IS
55:
56: CURSOR l_cur(l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE, l_org_id cn_pmt_plans.org_id%TYPE) IS
57: SELECT *

Line 56: CURSOR l_cur(l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE, l_org_id cn_pmt_plans.org_id%TYPE) IS

52: p_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE,
53: p_org_id cn_pmt_plans.org_id%TYPE
54: ) RETURN BOOLEAN IS
55:
56: CURSOR l_cur(l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE, l_org_id cn_pmt_plans.org_id%TYPE) IS
57: SELECT *
58: FROM cn_pmt_plans
59: WHERE pmt_plan_id = l_pmt_plan_id
60: AND org_id = l_org_id;

Line 58: FROM cn_pmt_plans

54: ) RETURN BOOLEAN IS
55:
56: CURSOR l_cur(l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE, l_org_id cn_pmt_plans.org_id%TYPE) IS
57: SELECT *
58: FROM cn_pmt_plans
59: WHERE pmt_plan_id = l_pmt_plan_id
60: AND org_id = l_org_id;
61:
62: l_rec l_cur%ROWTYPE;

Line 117: x_pmt_plan_id OUT NOCOPY cn_pmt_plans.pmt_plan_id%TYPE,

113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_role_pmt_plan_rec IN role_pmt_plan_rec_type,
116: x_role_id OUT NOCOPY cn_roles.role_id%TYPE,
117: x_pmt_plan_id OUT NOCOPY cn_pmt_plans.pmt_plan_id%TYPE,
118: p_loading_status IN VARCHAR2,
119: x_loading_status OUT NOCOPY VARCHAR2
120: ) IS
121:

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

120: ) IS
121:
122: l_api_name CONSTANT VARCHAR2(30) := 'check_valid_insert';
123:
124: CURSOR l_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_pmt_plans.org_id%TYPE) IS
125: SELECT start_date, end_date, pmt_plan_id
126: FROM cn_role_pmt_plans
127: WHERE role_id = l_role_id
128: AND org_id = l_org_id;

Line 130: CURSOR l_pp_cur(l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE, l_org_id cn_pmt_plans.org_id%TYPE) IS

126: FROM cn_role_pmt_plans
127: WHERE role_id = l_role_id
128: AND org_id = l_org_id;
129:
130: CURSOR l_pp_cur(l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE, l_org_id cn_pmt_plans.org_id%TYPE) IS
131: SELECT start_date, end_date
132: FROM cn_pmt_plans
133: WHERE pmt_plan_id = l_pmt_plan_id
134: AND org_id = l_org_id;

Line 132: FROM cn_pmt_plans

128: AND org_id = l_org_id;
129:
130: CURSOR l_pp_cur(l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE, l_org_id cn_pmt_plans.org_id%TYPE) IS
131: SELECT start_date, end_date
132: FROM cn_pmt_plans
133: WHERE pmt_plan_id = l_pmt_plan_id
134: AND org_id = l_org_id;
135:
136: l_pp_rec l_pp_cur%ROWTYPE;

Line 137: l_pp_payment_group_code cn_pmt_plans.payment_group_code%TYPE;

133: WHERE pmt_plan_id = l_pmt_plan_id
134: AND org_id = l_org_id;
135:
136: l_pp_rec l_pp_cur%ROWTYPE;
137: l_pp_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
138: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
139:
140: BEGIN
141:

Line 138: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;

134: AND org_id = l_org_id;
135:
136: l_pp_rec l_pp_cur%ROWTYPE;
137: l_pp_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
138: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
139:
140: BEGIN
141:
142: -- Initialize API return status to success

Line 193: -- pmt_plan_id must exist in cn_pmt_plans

189: ELSE
190: x_role_id := cn_api.get_role_id(p_role_pmt_plan_rec.role_name);
191: END IF;
192:
193: -- pmt_plan_id must exist in cn_pmt_plans
194: IF NOT valid_pmt_plan_id(p_role_pmt_plan_rec.pmt_plan_id, p_role_pmt_plan_rec.org_id) THEN
195: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
196: fnd_message.set_name('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
197: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec.pmt_plan_name);

Line 272: from cn_pmt_plans

268: LOOP
269:
270: select payment_group_code into
271: l_payment_group_code
272: from cn_pmt_plans
273: where pmt_plan_id = l_rec.pmt_plan_id;
274:
275: select payment_group_code into
276: l_pp_payment_group_code

Line 277: from cn_pmt_plans

273: where pmt_plan_id = l_rec.pmt_plan_id;
274:
275: select payment_group_code into
276: l_pp_payment_group_code
277: from cn_pmt_plans
278: where pmt_plan_id = p_role_pmt_plan_rec.pmt_plan_id
279: and org_id = p_role_pmt_plan_rec.org_id;
280:
281: IF ((cn_api.date_range_overlap(l_rec.start_date,

Line 361: x_pmt_plan_id OUT NOCOPY cn_pmt_plans.pmt_plan_id%TYPE,

357: p_role_pmt_plan_rec_old IN role_pmt_plan_rec_type,
358: p_role_pmt_plan_rec_new IN role_pmt_plan_rec_type,
359: x_role_pmt_plan_id_old OUT NOCOPY cn_role_pmt_plans.role_pmt_plan_id%TYPE,
360: x_role_id OUT NOCOPY cn_roles.role_id%TYPE,
361: x_pmt_plan_id OUT NOCOPY cn_pmt_plans.pmt_plan_id%TYPE,
362: x_date_update_only OUT NOCOPY VARCHAR2,
363: p_loading_status IN VARCHAR2,
364: x_loading_status OUT NOCOPY VARCHAR2
365: ) IS

Line 385: CURSOR l_pp_cur(l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE) IS

381: WHERE role_pmt_plan_id = l_role_pmt_plan_id;
382:
383: l_old_rec l_old_cur%ROWTYPE;
384:
385: CURSOR l_pp_cur(l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE) IS
386: SELECT start_date, end_date
387: FROM cn_pmt_plans
388: WHERE pmt_plan_id = l_pmt_plan_id;
389:

Line 387: FROM cn_pmt_plans

383: l_old_rec l_old_cur%ROWTYPE;
384:
385: CURSOR l_pp_cur(l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE) IS
386: SELECT start_date, end_date
387: FROM cn_pmt_plans
388: WHERE pmt_plan_id = l_pmt_plan_id;
389:
390: l_pp_rec l_pp_cur%ROWTYPE;
391:

Line 533: -- new pmt_plan_name must exist in cn_pmt_plans

529: END IF;
530: END IF;
531:
532: -- if new pmt_plan_name is not missing then
533: -- new pmt_plan_name must exist in cn_pmt_plans
534: IF (p_role_pmt_plan_rec_new.pmt_plan_name <> fnd_api.g_miss_char) THEN
535: x_pmt_plan_id := cn_api.get_pp_id(p_role_pmt_plan_rec_new.pmt_plan_name,p_role_pmt_plan_rec_new.org_id);
536: IF (x_pmt_plan_id IS NULL) THEN
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 823: CURSOR l_cur (l_org_id cn_pmt_plans.org_id%TYPE) IS

819: from cn_srp_roles
820: where role_id = p_role_id
821: ;
822: */
823: CURSOR l_cur (l_org_id cn_pmt_plans.org_id%TYPE) IS
824: select csr.*
825: from cn_srp_roles csr, cn_salesreps cs
826: where csr.role_id = p_role_id
827: and csr.salesrep_id = cs.salesrep_id

Line 1077: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;

1073: l_api_name CONSTANT VARCHAR2(30) := 'Create_Role_Pmt_Plan';
1074: l_api_version CONSTANT NUMBER := 1.0;
1075: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE;
1076: l_role_id cn_roles.role_id%TYPE;
1077: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
1078:
1079:
1080: -- Declaration for user hooks
1081: l_rec role_pmt_plan_rec_type;

Line 1256: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;

1252: l_api_name CONSTANT VARCHAR2(30) := 'Update_Role_Pmt_Plan';
1253: l_api_version CONSTANT NUMBER := 1.0;
1254: l_role_pmt_plan_id_old cn_role_pmt_plans.role_pmt_plan_id%TYPE;
1255: l_role_id cn_roles.role_id%TYPE;
1256: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
1257: l_date_update_only VARCHAR2(1);
1258:
1259: -- Declaration for user hooks
1260: l_rec_old role_pmt_plan_rec_type;