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_QUOTAS

Line 44: l_quota_id cn_quotas.quota_id%TYPE;

40: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 52: l_pe_name cn_quotas.NAME%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
56: FROM cn_quota_assigns

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 225: FROM cn_quotas_all

221: IF (l_quota_id > 0 AND l_comp_plan_id > 0)
222: THEN
223: SELECT NAME
224: INTO l_pe_name
225: FROM cn_quotas_all
226: WHERE quota_id = l_quota_id;
227:
228: SELECT NAME
229: INTO l_cp_name

Line 354: l_quota_id cn_quotas.quota_id%TYPE;

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

Line 364: l_pe_name cn_quotas.NAME%TYPE;

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:
368: BEGIN

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 561: FROM cn_quotas_all

557: IF (p_quota_assign.quota_sequence <> old_seq)
558: THEN
559: SELECT NAME
560: INTO l_pe_name
561: FROM cn_quotas_all
562: WHERE quota_id = l_quota_id;
563:
564: SELECT NAME
565: INTO l_cp_name

Line 580: FROM cn_quotas_all

576: ELSE IF (l_quota_id > 0 AND l_comp_plan_id > 0)
577: THEN
578: SELECT NAME
579: INTO l_pe_name
580: FROM cn_quotas_all
581: WHERE quota_id = l_quota_id;
582:
583: SELECT NAME
584: INTO l_cp_name

Line 611: FROM cn_quotas_all

607: );*/
608:
609: SELECT NAME
610: INTO l_pe_name
611: FROM cn_quotas_all
612: WHERE quota_id = l_old_quota_assign.quota_id;
613:
614: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_UNAS');
615: fnd_message.set_token ('PE_NAME', l_pe_name);

Line 736: l_quota_id cn_quotas.quota_id%TYPE;

732: IS
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);

Line 743: l_pe_name cn_quotas.NAME%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;
747:

Line 804: FROM cn_quotas_all

800: IF (l_quota_id > 0 AND l_comp_plan_id > 0)
801: THEN
802: SELECT NAME
803: INTO l_pe_name
804: FROM cn_quotas_all
805: WHERE quota_id = l_quota_id;
806:
807: SELECT NAME
808: INTO l_cp_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