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_QUOTA_ASSIGN_PVT dependencies on CN_QUOTA_ASSIGNS

Line 45: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;

41: l_temp_count NUMBER;
42: l_msg_count NUMBER;
43: l_msg_data VARCHAR2 (2000);
44: l_quota_id cn_quotas.quota_id%TYPE;
45: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
46: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
47: l_org_id cn_quota_assigns.org_id%TYPE;
48: l_quota_tbl cn_calc_sql_exps_pvt.num_tbl_type;
49: l_note_msg VARCHAR2 (240);

Line 47: l_org_id cn_quota_assigns.org_id%TYPE;

43: l_msg_data VARCHAR2 (2000);
44: l_quota_id cn_quotas.quota_id%TYPE;
45: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
46: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
47: l_org_id cn_quota_assigns.org_id%TYPE;
48: l_quota_tbl cn_calc_sql_exps_pvt.num_tbl_type;
49: l_note_msg VARCHAR2 (240);
50: l_note_id NUMBER;
51: l_cp_name cn_comp_plans.NAME%TYPE;

Line 56: FROM cn_quota_assigns

52: l_pe_name cn_quotas.NAME%TYPE;
53:
54: CURSOR objversion_cur IS
55: SELECT object_version_number
56: FROM cn_quota_assigns
57: WHERE quota_assign_id = p_quota_assign.quota_assign_id;
58:
59: BEGIN
60: -- Standard Start of API savepoint

Line 104: FROM cn_quota_assigns

100:
101: -- 2. quota assign name must be unique
102: SELECT COUNT (1)
103: INTO l_temp_count
104: FROM cn_quota_assigns
105: WHERE comp_plan_id = p_quota_assign.comp_plan_id
106: AND quota_id = p_quota_assign.quota_id
107: AND ROWNUM = 1;
108:

Line 167: FROM cn_quota_assigns

163: -- for each PE in this loop, make sure it exists in plan with
164: -- lower seq number
165: SELECT COUNT (1)
166: INTO l_temp_count
167: FROM cn_quota_assigns
168: WHERE comp_plan_id = p_quota_assign.comp_plan_id
169: AND quota_id = l_quota_tbl (i)
170: AND quota_sequence < p_quota_assign.quota_sequence;
171:

Line 204: cn_quota_assigns_pkg.begin_record

200: l_comp_plan_id,
201: l_org_id
202: FROM DUAL;
203:
204: cn_quota_assigns_pkg.begin_record
205: (x_operation => 'INSERT',
206: x_quota_id => l_quota_id,
207: x_comp_plan_id => l_comp_plan_id,
208: x_quota_assign_id => p_quota_assign.quota_assign_id,

Line 245: --'CN_QUOTA_ASSIGNS',

241: x_msg_data => x_msg_data,
242: p_source_object_id => l_comp_plan_id,
243: --l_quota_assign_id,
244: p_source_object_code => 'CN_COMP_PLANS',
245: --'CN_QUOTA_ASSIGNS',
246: p_notes => l_note_msg,
247: p_notes_detail => l_note_msg,
248: p_note_type => 'CN_SYSGEN',
249: -- for system generated

Line 343: FROM cn_quota_assigns

339:
340: CURSOR l_old_quota_assign_cr
341: IS
342: SELECT *
343: FROM cn_quota_assigns
344: WHERE quota_assign_id = p_quota_assign.quota_assign_id;
345:
346: CURSOR objversion_cur IS
347: SELECT object_version_number

Line 348: FROM cn_quota_assigns

344: WHERE quota_assign_id = p_quota_assign.quota_assign_id;
345:
346: CURSOR objversion_cur IS
347: SELECT object_version_number
348: FROM cn_quota_assigns
349: WHERE quota_assign_id = p_quota_assign.quota_assign_id;
350:
351: l_old_quota_assign l_old_quota_assign_cr%ROWTYPE;
352: l_quota_assign quota_assign_rec_type;

Line 355: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;

351: l_old_quota_assign l_old_quota_assign_cr%ROWTYPE;
352: l_quota_assign quota_assign_rec_type;
353: l_temp_count NUMBER;
354: l_quota_id cn_quotas.quota_id%TYPE;
355: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
356: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
357: l_quota_tbl cn_calc_sql_exps_pvt.num_tbl_type;
358: l_msg_count NUMBER;
359: l_msg_data VARCHAR2 (2000);

Line 360: l_org_id cn_quota_assigns.org_id%TYPE;

356: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
357: l_quota_tbl cn_calc_sql_exps_pvt.num_tbl_type;
358: l_msg_count NUMBER;
359: l_msg_data VARCHAR2 (2000);
360: l_org_id cn_quota_assigns.org_id%TYPE;
361: l_note_msg VARCHAR2 (240);
362: l_note_id NUMBER;
363: l_cp_name cn_comp_plans.NAME%TYPE;
364: l_pe_name cn_quotas.NAME%TYPE;

Line 366: old_seq CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE;

362: l_note_id NUMBER;
363: l_cp_name cn_comp_plans.NAME%TYPE;
364: l_pe_name cn_quotas.NAME%TYPE;
365: l_consolidated_note VARCHAR2(2000);
366: old_seq CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE;
367:
368: BEGIN
369: -- Standard Start of API savepoint
370: SAVEPOINT update_quota_assign;

Line 407: select count(1) into l_temp_count from cn_quota_assigns where quota_id = p_quota_assign.quota_id and comp_plan_id = p_quota_assign.comp_plan_id;

403: RAISE fnd_api.g_exc_error;
404: END IF;
405:
406: -- Getting Old Sequence
407: select count(1) into l_temp_count from cn_quota_assigns where quota_id = p_quota_assign.quota_id and comp_plan_id = p_quota_assign.comp_plan_id;
408:
409: IF l_temp_count <> 0
410: THEN
411: select QUOTA_SEQUENCE into old_seq from cn_quota_assigns where quota_id = p_quota_assign.quota_id and comp_plan_id = p_quota_assign.comp_plan_id;

Line 411: select QUOTA_SEQUENCE into old_seq from cn_quota_assigns where quota_id = p_quota_assign.quota_id and comp_plan_id = p_quota_assign.comp_plan_id;

407: select count(1) into l_temp_count from cn_quota_assigns where quota_id = p_quota_assign.quota_id and comp_plan_id = p_quota_assign.comp_plan_id;
408:
409: IF l_temp_count <> 0
410: THEN
411: select QUOTA_SEQUENCE into old_seq from cn_quota_assigns where quota_id = p_quota_assign.quota_id and comp_plan_id = p_quota_assign.comp_plan_id;
412: ELSE
413: old_seq := p_quota_assign.quota_sequence;
414: END IF;
415:

Line 420: FROM cn_quota_assigns

416:
417: -- 2. quota assign name must be unique
418: SELECT COUNT (1)
419: INTO l_temp_count
420: FROM cn_quota_assigns
421: WHERE comp_plan_id = p_quota_assign.comp_plan_id
422: AND quota_id = p_quota_assign.quota_id
423: AND quota_assign_id <> p_quota_assign.quota_assign_id
424: AND ROWNUM = 1;

Line 511: FROM cn_quota_assigns

507: -- for each PE in this loop, make sure it exists in plan with
508: -- lower seq number
509: SELECT COUNT (1)
510: INTO l_temp_count
511: FROM cn_quota_assigns
512: WHERE comp_plan_id = p_quota_assign.comp_plan_id
513: AND quota_id = l_quota_tbl (i)
514: AND quota_sequence < p_quota_assign.quota_sequence;
515:

Line 539: cn_quota_assigns_pkg.begin_record

535: fnd_msg_pub.ADD;
536: RAISE fnd_api.g_exc_error;
537: END IF;
538:
539: cn_quota_assigns_pkg.begin_record
540: (x_operation => 'UPDATE',
541: x_quota_id => l_quota_id,
542: x_comp_plan_id => l_comp_plan_id,
543: x_quota_assign_id => p_quota_assign.quota_assign_id,

Line 601: --'CN_QUOTA_ASSIGNS',

597: x_msg_data => x_msg_data,
598: p_source_object_id => l_comp_plan_id,
599: --l_quota_assign_id,
600: p_source_object_code => 'CN_COMP_PLANS',
601: --'CN_QUOTA_ASSIGNS',
602: p_notes => l_note_msg,
603: p_notes_detail => l_note_msg,
604: p_note_type => 'CN_SYSGEN',
605: -- for system generated

Line 737: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;

733: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Quota_Assign';
734: l_api_version CONSTANT NUMBER := 1.0;
735: l_temp_count NUMBER;
736: l_quota_id cn_quotas.quota_id%TYPE;
737: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
738: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
739: l_org_id cn_quota_assigns.org_id%TYPE;
740: l_note_msg VARCHAR2 (240);
741: l_note_id NUMBER;

Line 739: l_org_id cn_quota_assigns.org_id%TYPE;

735: l_temp_count NUMBER;
736: l_quota_id cn_quotas.quota_id%TYPE;
737: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
738: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
739: l_org_id cn_quota_assigns.org_id%TYPE;
740: l_note_msg VARCHAR2 (240);
741: l_note_id NUMBER;
742: l_cp_name cn_comp_plans.NAME%TYPE;
743: l_pe_name cn_quotas.NAME%TYPE;

Line 773: FROM cn_quota_assigns

769: -- do comp plan quota assignment
770: BEGIN
771: SELECT quota_assign_id, quota_id, comp_plan_id, org_id
772: INTO l_quota_assign_id, l_quota_id, l_comp_plan_id, l_org_id
773: FROM cn_quota_assigns
774: WHERE quota_assign_id = p_quota_assign.quota_assign_id;
775: EXCEPTION
776: WHEN NO_DATA_FOUND
777: THEN

Line 783: cn_quota_assigns_pkg.begin_record

779: fnd_msg_pub.ADD;
780: RAISE fnd_api.g_exc_unexpected_error;
781: END;
782:
783: cn_quota_assigns_pkg.begin_record
784: (x_operation => 'DELETE',
785: x_quota_id => l_quota_id,
786: x_comp_plan_id => l_comp_plan_id,
787: x_quota_assign_id => l_quota_assign_id,

Line 799: -- During deltion the logical parent is CN_COMP_PLANS for CN_QUOTA_ASSIGNS

795: x_status_code => 'INCOMPLETE',
796: x_event => NULL
797: );
798:
799: -- During deltion the logical parent is CN_COMP_PLANS for CN_QUOTA_ASSIGNS
800: IF (l_quota_id > 0 AND l_comp_plan_id > 0)
801: THEN
802: SELECT NAME
803: INTO l_pe_name

Line 921: FROM cn_quota_assigns qa, cn_quotas_v q

917: SELECT q.NAME, q.description, q.start_date, q.end_date,
918: qa.quota_assign_id, qa.quota_id, qa.comp_plan_id,
919: NVL (qa.quota_sequence, 0) quota_sequence,
920: qa.object_version_number, qa.org_id
921: FROM cn_quota_assigns qa, cn_quotas_v q
922: WHERE qa.comp_plan_id = p_comp_plan_id
923: AND qa.quota_id = q.quota_id
924: ORDER BY quota_sequence;
925: BEGIN