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_SRP_PAYEE_ASSIGNS_PVT dependencies on CN_SALESREPS

Line 15: x_salesrep_name cn_salesreps.name%TYPE;

11: old_start_date DATE,
12: old_end_date DATE,
13: old_org_id NUMBER) IS
14:
15: x_salesrep_name cn_salesreps.name%TYPE;
16: BEGIN
17: IF fnd_profile.value('CN_MARK_EVENTS') = 'Y' THEN
18: SELECT name
19: INTO x_salesrep_name

Line 20: FROM cn_salesreps

16: BEGIN
17: IF fnd_profile.value('CN_MARK_EVENTS') = 'Y' THEN
18: SELECT name
19: INTO x_salesrep_name
20: FROM cn_salesreps
21: WHERE salesrep_id = old_salesrep_id
22: AND org_id = old_org_id;
23:
24: cn_mark_events_pkg.mark_event_srp_payee_assign

Line 44: x_salesrep_name cn_salesreps.name%TYPE;

40: new_start_date DATE,
41: new_end_date DATE,
42: new_org_id NUMBER) IS
43:
44: x_salesrep_name cn_salesreps.name%TYPE;
45: BEGIN
46: IF fnd_profile.value('CN_MARK_EVENTS') = 'Y' THEN
47: SELECT name
48: INTO x_salesrep_name

Line 49: FROM cn_salesreps

45: BEGIN
46: IF fnd_profile.value('CN_MARK_EVENTS') = 'Y' THEN
47: SELECT name
48: INTO x_salesrep_name
49: FROM cn_salesreps
50: WHERE salesrep_id = new_salesrep_id
51: AND org_id = new_org_id;
52:
53: cn_mark_events_pkg.mark_event_srp_payee_assign

Line 78: x_salesrep_name cn_salesreps.name%TYPE;

74: new_start_date DATE,
75: new_end_date DATE,
76: new_org_id NUMBER) IS
77:
78: x_salesrep_name cn_salesreps.name%TYPE;
79: BEGIN
80: IF fnd_profile.value('CN_MARK_EVENTS') = 'Y' THEN
81: SELECT name
82: INTO x_salesrep_name

Line 83: FROM cn_salesreps

79: BEGIN
80: IF fnd_profile.value('CN_MARK_EVENTS') = 'Y' THEN
81: SELECT name
82: INTO x_salesrep_name
83: FROM cn_salesreps
84: WHERE salesrep_id = new_salesrep_id
85: AND org_id = new_org_id;
86:
87: IF (new_payee_id <> old_payee_id) THEN

Line 237: l_srp_name cn_salesreps.name%TYPE;

233: l_sd DATE;
234: l_ed DATE;
235: l_end_of_time CONSTANT DATE := to_date('12/31/9999','MM/DD/YYYY');
236: l_end_date DATE := nvl(p_end_date, l_end_of_time);
237: l_srp_name cn_salesreps.name%TYPE;
238: l_payee_name cn_salesreps.name%TYPE;
239: l_emp_num cn_salesreps.employee_number%TYPE;
240: l_pe_name cn_quotas.name%TYPE;
241: l_quota_id NUMBER;

Line 238: l_payee_name cn_salesreps.name%TYPE;

234: l_ed DATE;
235: l_end_of_time CONSTANT DATE := to_date('12/31/9999','MM/DD/YYYY');
236: l_end_date DATE := nvl(p_end_date, l_end_of_time);
237: l_srp_name cn_salesreps.name%TYPE;
238: l_payee_name cn_salesreps.name%TYPE;
239: l_emp_num cn_salesreps.employee_number%TYPE;
240: l_pe_name cn_quotas.name%TYPE;
241: l_quota_id NUMBER;
242:

Line 239: l_emp_num cn_salesreps.employee_number%TYPE;

235: l_end_of_time CONSTANT DATE := to_date('12/31/9999','MM/DD/YYYY');
236: l_end_date DATE := nvl(p_end_date, l_end_of_time);
237: l_srp_name cn_salesreps.name%TYPE;
238: l_payee_name cn_salesreps.name%TYPE;
239: l_emp_num cn_salesreps.employee_number%TYPE;
240: l_pe_name cn_quotas.name%TYPE;
241: l_quota_id NUMBER;
242:
243: CURSOR get_pgs is

Line 265: FROM cn_salesreps

261: --+
262: -- get name and number
263: SELECT name, employee_number
264: INTO l_payee_name, l_emp_num
265: FROM cn_salesreps
266: WHERE salesrep_id = p_payee_id
267: AND org_id = p_org_id;
268:
269: SELECT COUNT(1)

Line 271: FROM cn_salesreps

267: AND org_id = p_org_id;
268:
269: SELECT COUNT(1)
270: INTO l_count
271: FROM cn_salesreps
272: WHERE salesrep_id = p_payee_id
273: AND org_id = p_org_id
274: AND start_date_active <= p_start_date
275: AND ((end_date_active IS NULL AND p_end_date IS NULL ) OR

Line 331: FROM cn_salesreps

327: THEN
328: -- get salesrep name
329: SELECT name
330: INTO l_srp_name
331: FROM cn_salesreps
332: WHERE salesrep_id = p_salesrep_id
333: AND org_id = p_org_id;
334: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_HAVE_PAYEE');
335: FND_MESSAGE.SET_TOKEN('PLAN_NAME', l_pe_name);

Line 483: l_payee_name cn_salesreps.name%TYPE;

479: l_comp_plan_id NUMBER;
480: l_salesrep_id NUMBER;
481: l_org_id NUMBER;
482: l_count NUMBER;
483: l_payee_name cn_salesreps.name%TYPE;
484: l_note_msg VARCHAR2(240);
485: l_note_id NUMBER;
486:
487: BEGIN

Line 580: FROM cn_salesreps

576: end if;
577:
578: -- add note for srp_quota_assigns
579: SELECT name INTO l_payee_name
580: FROM cn_salesreps
581: WHERE salesrep_id = p_payee_id
582: AND org_id = l_org_id;
583:
584: fnd_message.set_name('CN', 'CN_PAYEE_CRE_NOTE');

Line 688: l_payee_name cn_salesreps.name%TYPE;

684: := 'Update_Srp_Payee_Assigns';
685: l_api_version CONSTANT NUMBER := 1.0;
686: l_comp_plan_id NUMBER;
687: l_end_of_time date := to_date('12/31/9999','MM/DD/YYYY');
688: l_payee_name cn_salesreps.name%TYPE;
689: l_old_payee_name cn_salesreps.name%TYPE;
690:
691: CURSOR get_old_payee_rec(l_srp_payee_asgn_id number) IS
692: SELECT srp_quota_assign_id, payee_id, start_date, end_date,

Line 689: l_old_payee_name cn_salesreps.name%TYPE;

685: l_api_version CONSTANT NUMBER := 1.0;
686: l_comp_plan_id NUMBER;
687: l_end_of_time date := to_date('12/31/9999','MM/DD/YYYY');
688: l_payee_name cn_salesreps.name%TYPE;
689: l_old_payee_name cn_salesreps.name%TYPE;
690:
691: CURSOR get_old_payee_rec(l_srp_payee_asgn_id number) IS
692: SELECT srp_quota_assign_id, payee_id, start_date, end_date,
693: quota_id, salesrep_id, org_id, object_version_number

Line 885: FROM cn_salesreps

881: -- add note for srp_payee_assigns
882: l_notemsg := NULL;
883: IF (l_old_rec.payee_id <> p_payee_id) THEN
884: SELECT name INTO l_old_payee_name
885: FROM cn_salesreps
886: WHERE salesrep_id = l_old_rec.payee_id
887: AND org_id = l_old_rec.org_id;
888: SELECT name INTO l_payee_name
889: FROM cn_salesreps

Line 889: FROM cn_salesreps

885: FROM cn_salesreps
886: WHERE salesrep_id = l_old_rec.payee_id
887: AND org_id = l_old_rec.org_id;
888: SELECT name INTO l_payee_name
889: FROM cn_salesreps
890: WHERE salesrep_id = p_payee_id
891: AND org_id = l_old_rec.org_id;
892:
893: get_note('PAYEE', l_old_payee_name, l_payee_name, l_notemsg);

Line 1094: l_payee_name cn_salesreps.name%TYPE;

1090: l_srp_quota_assign_id NUMBER;
1091: l_note_id NUMBER;
1092: l_note_msg VARCHAR2(240);
1093: l_payee_id NUMBER;
1094: l_payee_name cn_salesreps.name%TYPE;
1095:
1096: BEGIN
1097: -- Standard Start of API savepoint
1098: SAVEPOINT delete_srp_payee_assigns;

Line 1153: FROM cn_salesreps

1149: old_org_id => l_org_id);
1150:
1151: -- add note for srp_quota_assigns
1152: SELECT name INTO l_payee_name
1153: FROM cn_salesreps
1154: WHERE salesrep_id = l_payee_id
1155: AND org_id = l_org_id;
1156:
1157: fnd_message.set_name('CN', 'CN_PAYEE_DEL_NOTE');