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_COMP_PLANS

Line 46: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;

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);
50: l_note_id NUMBER;

Line 51: l_cp_name cn_comp_plans.NAME%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;
52: l_pe_name cn_quotas.NAME%TYPE;
53:
54: CURSOR objversion_cur IS
55: SELECT object_version_number

Line 128: FROM cn_comp_plans c, cn_quotas_v q

124:
125: -- 3. quota dates must overlap plan dates
126: SELECT COUNT (1)
127: INTO l_temp_count
128: FROM cn_comp_plans c, cn_quotas_v q
129: WHERE c.comp_plan_id = p_quota_assign.comp_plan_id
130: AND q.quota_id = p_quota_assign.quota_id
131: AND GREATEST (c.start_date, q.start_date) <=
132: LEAST (NVL (c.end_date, g_end_of_time),

Line 213: cn_comp_plans_pkg.set_status (x_comp_plan_id => l_comp_plan_id,

209: x_quota_sequence => p_quota_assign.quota_sequence,
210: x_quota_id_old => NULL,
211: x_org_id => l_org_id
212: );
213: cn_comp_plans_pkg.set_status (x_comp_plan_id => l_comp_plan_id,
214: x_quota_id => NULL,
215: x_rate_schedule_id => NULL,
216: x_status_code => 'INCOMPLETE',
217: x_event => NULL

Line 230: FROM cn_comp_plans

226: WHERE quota_id = l_quota_id;
227:
228: SELECT NAME
229: INTO l_cp_name
230: FROM cn_comp_plans
231: WHERE comp_plan_id = l_comp_plan_id;
232:
233: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_AS');
234: fnd_message.set_token ('PE_NAME', l_pe_name);

Line 244: p_source_object_code => 'CN_COMP_PLANS',

240: x_msg_count => x_msg_count,
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',

Line 356: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;

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);
360: l_org_id cn_quota_assigns.org_id%TYPE;

Line 363: l_cp_name cn_comp_plans.NAME%TYPE;

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;
365: l_consolidated_note VARCHAR2(2000);
366: old_seq CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE;
367:

Line 471: FROM cn_comp_plans c, cn_quotas_v q

467:
468: -- 3. quota dates must overlap plan dates
469: SELECT COUNT (1)
470: INTO l_temp_count
471: FROM cn_comp_plans c, cn_quotas_v q
472: WHERE c.comp_plan_id = p_quota_assign.comp_plan_id
473: AND q.quota_id = p_quota_assign.quota_id
474: AND GREATEST (c.start_date, q.start_date) <=
475: LEAST (NVL (c.end_date, g_end_of_time),

Line 548: cn_comp_plans_pkg.set_status (x_comp_plan_id => l_comp_plan_id,

544: x_quota_sequence => p_quota_assign.quota_sequence,
545: x_quota_id_old => l_old_quota_assign.quota_id,
546: x_org_id => l_org_id
547: );
548: cn_comp_plans_pkg.set_status (x_comp_plan_id => l_comp_plan_id,
549: x_quota_id => NULL,
550: x_rate_schedule_id => NULL,
551: x_status_code => 'INCOMPLETE',
552: x_event => NULL

Line 566: FROM cn_comp_plans

562: WHERE quota_id = l_quota_id;
563:
564: SELECT NAME
565: INTO l_cp_name
566: FROM cn_comp_plans
567: WHERE comp_plan_id = l_comp_plan_id;
568:
569: fnd_message.set_name ('CN', 'CN_PA_CP_QA_CALC_SEQ_NOTES');
570: fnd_message.set_token ('PE_NAME', l_pe_name);

Line 585: FROM cn_comp_plans

581: WHERE quota_id = l_quota_id;
582:
583: SELECT NAME
584: INTO l_cp_name
585: FROM cn_comp_plans
586: WHERE comp_plan_id = l_comp_plan_id;
587:
588: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_AS');
589: fnd_message.set_token ('PE_NAME', l_pe_name);

Line 600: p_source_object_code => 'CN_COMP_PLANS',

596: x_msg_count => x_msg_count,
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',

Line 626: p_source_object_code => 'CN_COMP_PLANS',

622: x_return_status => x_return_status,
623: x_msg_count => x_msg_count,
624: x_msg_data => x_msg_data,
625: p_source_object_id => l_comp_plan_id,
626: p_source_object_code => 'CN_COMP_PLANS',
627: p_notes => l_note_msg,
628: p_notes_detail => l_note_msg,
629: p_note_type => 'CN_SYSGEN',
630: -- for system generated

Line 643: p_source_object_code => 'CN_COMP_PLANS',

639: x_return_status => x_return_status,
640: x_msg_count => x_msg_count,
641: x_msg_data => x_msg_data,
642: p_source_object_id => l_comp_plan_id,
643: p_source_object_code => 'CN_COMP_PLANS',
644: p_notes => l_consolidated_note,
645: p_notes_detail => l_consolidated_note,
646: p_note_type => 'CN_SYSGEN', -- for system generated
647: x_jtf_note_id => l_note_id -- returned

Line 738: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;

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;
742: l_cp_name cn_comp_plans.NAME%TYPE;

Line 742: l_cp_name cn_comp_plans.NAME%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;
744: BEGIN
745: -- Standard Start of API savepoint
746: SAVEPOINT delete_quota_assign;

Line 792: cn_comp_plans_pkg.set_status (x_comp_plan_id => l_comp_plan_id,

788: x_quota_sequence => NULL,
789: x_quota_id_old => NULL,
790: x_org_id => l_org_id
791: );
792: cn_comp_plans_pkg.set_status (x_comp_plan_id => l_comp_plan_id,
793: x_quota_id => NULL,
794: x_rate_schedule_id => NULL,
795: x_status_code => 'INCOMPLETE',
796: x_event => NULL

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 809: FROM cn_comp_plans

805: WHERE quota_id = l_quota_id;
806:
807: SELECT NAME
808: INTO l_cp_name
809: FROM cn_comp_plans
810: WHERE comp_plan_id = l_comp_plan_id;
811:
812: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_UNAS');
813: fnd_message.set_token ('PE_NAME', l_pe_name);

Line 822: p_source_object_code => 'CN_COMP_PLANS',

818: x_return_status => x_return_status,
819: x_msg_count => x_msg_count,
820: x_msg_data => x_msg_data,
821: p_source_object_id => l_comp_plan_id,
822: p_source_object_code => 'CN_COMP_PLANS',
823: p_notes => l_note_msg,
824: p_notes_detail => l_note_msg,
825: p_note_type => 'CN_SYSGEN',
826: -- for system generated