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_COMP_PLAN_PVT dependencies on CN_COMP_PLANS

Line 60: FROM cn_comp_plans_all

56: l_num NUMBER;
57: BEGIN
58: SELECT object_version_number
59: INTO l_num
60: FROM cn_comp_plans_all
61: WHERE comp_plan_id = p_id;
62:
63: RETURN l_num;
64: END;

Line 163: FROM cn_comp_plans

159:
160: -- 2. comp plan name must be unique
161: SELECT COUNT (1)
162: INTO l_temp_count
163: FROM cn_comp_plans
164: WHERE NAME = p_comp_plan.NAME AND org_id = p_comp_plan.org_id AND ROWNUM = 1;
165:
166: IF l_temp_count <> 0
167: THEN

Line 289: p_source_object_code => 'CN_COMP_PLANS',

285: x_return_status => x_return_status,
286: x_msg_count => x_msg_count,
287: x_msg_data => x_msg_data,
288: p_source_object_id => x_comp_plan_id,
289: p_source_object_code => 'CN_COMP_PLANS',
290: p_notes => l_note_msg,
291: p_notes_detail => l_note_msg,
292: p_note_type => 'CN_SYSGEN', -- for system generated
293: x_jtf_note_id => l_note_id -- returned

Line 374: FROM cn_comp_plans

370:
371: CURSOR l_old_comp_plan_cr
372: IS
373: SELECT *
374: FROM cn_comp_plans
375: WHERE comp_plan_id = p_comp_plan.comp_plan_id;
376:
377: l_old_comp_plan l_old_comp_plan_cr%ROWTYPE;
378: l_comp_plan comp_plan_rec_type;

Line 382: l_name cn_comp_plans.NAME%TYPE;

378: l_comp_plan comp_plan_rec_type;
379: l_temp_count NUMBER;
380: l_start_date DATE;
381: l_end_date DATE;
382: l_name cn_comp_plans.NAME%TYPE;
383: l_description cn_comp_plans.description%TYPE;
384: l_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;
385: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;
386: l_loading_status VARCHAR2 (50);

Line 383: l_description cn_comp_plans.description%TYPE;

379: l_temp_count NUMBER;
380: l_start_date DATE;
381: l_end_date DATE;
382: l_name cn_comp_plans.NAME%TYPE;
383: l_description cn_comp_plans.description%TYPE;
384: l_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;
385: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;
386: l_loading_status VARCHAR2 (50);
387: l_return_status VARCHAR2 (50);

Line 384: l_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;

380: l_start_date DATE;
381: l_end_date DATE;
382: l_name cn_comp_plans.NAME%TYPE;
383: l_description cn_comp_plans.description%TYPE;
384: l_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;
385: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;
386: l_loading_status VARCHAR2 (50);
387: l_return_status VARCHAR2 (50);
388: l_attribute_category VARCHAR2 (150);

Line 385: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;

381: l_end_date DATE;
382: l_name cn_comp_plans.NAME%TYPE;
383: l_description cn_comp_plans.description%TYPE;
384: l_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;
385: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;
386: l_loading_status VARCHAR2 (50);
387: l_return_status VARCHAR2 (50);
388: l_attribute_category VARCHAR2 (150);
389: l_attribute1 VARCHAR2 (150);

Line 445: FROM cn_comp_plans

441:
442: -- 2. comp plan name must be unique
443: SELECT COUNT (1)
444: INTO l_temp_count
445: FROM cn_comp_plans
446: WHERE NAME = p_comp_plan.NAME AND comp_plan_id <> p_comp_plan.comp_plan_id AND org_id = p_comp_plan.org_id AND ROWNUM = 1;
447:
448: IF l_temp_count <> 0
449: THEN

Line 590: FROM cn_comp_plans

586: -- since srp assignments always within role assignments, then we
587: -- don't need to check those
588: SELECT org_id
589: INTO l_org_id
590: FROM cn_comp_plans
591: WHERE comp_plan_id = l_comp_plan_id;
592:
593: --- *** Business Events *** ---
594: business_event

Line 600: cn_comp_plans_pkg.begin_record (x_operation => 'UPDATE',

596: p_pre_or_post => 'pre',
597: p_comp_plan => p_comp_plan);
598:
599:
600: cn_comp_plans_pkg.begin_record (x_operation => 'UPDATE',
601: x_rowid => g_rowid,
602: x_comp_plan_id => l_comp_plan_id,
603: x_name => l_name,
604: x_description => l_description,

Line 665: p_source_object_code => 'CN_COMP_PLANS',

661: x_return_status => x_return_status,
662: x_msg_count => x_msg_count,
663: x_msg_data => x_msg_data,
664: p_source_object_id => l_old_comp_plan.comp_plan_id,
665: p_source_object_code => 'CN_COMP_PLANS',
666: p_notes => l_note_msg,
667: p_notes_detail => l_note_msg,
668: p_note_type => 'CN_SYSGEN', -- for system generated
669: x_jtf_note_id => l_note_id -- returned

Line 692: p_source_object_code => 'CN_COMP_PLANS',

688: x_return_status => x_return_status,
689: x_msg_count => x_msg_count,
690: x_msg_data => x_msg_data,
691: p_source_object_id => l_old_comp_plan.comp_plan_id,
692: p_source_object_code => 'CN_COMP_PLANS',
693: p_notes => l_note_msg,
694: p_notes_detail => l_note_msg,
695: p_note_type => 'CN_SYSGEN', -- for system generated
696: x_jtf_note_id => l_note_id -- returned

Line 716: p_source_object_code => 'CN_COMP_PLANS',

712: x_return_status => x_return_status,
713: x_msg_count => x_msg_count,
714: x_msg_data => x_msg_data,
715: p_source_object_id => l_old_comp_plan.comp_plan_id,
716: p_source_object_code => 'CN_COMP_PLANS',
717: p_notes => l_note_msg,
718: p_notes_detail => l_note_msg,
719: p_note_type => 'CN_SYSGEN', -- for system generated
720: x_jtf_note_id => l_note_id -- returned

Line 742: p_source_object_code => 'CN_COMP_PLANS',

738: x_return_status => x_return_status,
739: x_msg_count => x_msg_count,
740: x_msg_data => x_msg_data,
741: p_source_object_id => l_old_comp_plan.comp_plan_id,
742: p_source_object_code => 'CN_COMP_PLANS',
743: p_notes => l_note_msg,
744: p_notes_detail => l_note_msg,
745: p_note_type => 'CN_SYSGEN', -- for system generated
746: x_jtf_note_id => l_note_id -- returned

Line 768: p_source_object_code => 'CN_COMP_PLANS',

764: x_return_status => x_return_status,
765: x_msg_count => x_msg_count,
766: x_msg_data => x_msg_data,
767: p_source_object_id => l_old_comp_plan.comp_plan_id,
768: p_source_object_code => 'CN_COMP_PLANS',
769: p_notes => l_note_msg,
770: p_notes_detail => l_note_msg,
771: p_note_type => 'CN_SYSGEN', -- for system generated
772: x_jtf_note_id => l_note_id -- returned

Line 785: p_source_object_code => 'CN_COMP_PLANS',

781: x_return_status => x_return_status,
782: x_msg_count => x_msg_count,
783: x_msg_data => x_msg_data,
784: p_source_object_id => l_old_comp_plan.comp_plan_id,
785: p_source_object_code => 'CN_COMP_PLANS',
786: p_notes => l_consolidated_note,
787: p_notes_detail => l_consolidated_note,
788: p_note_type => 'CN_SYSGEN', -- for system generated
789: x_jtf_note_id => l_note_id -- returned

Line 862: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;

858: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Comp_Plan';
859: l_api_version CONSTANT NUMBER := 1.0;
860: l_temp_count NUMBER;
861: l_dummy_row_id VARCHAR2 (18);
862: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;
863: l_note_msg VARCHAR2 (240);
864: l_note_id NUMBER;
865: l_org_id NUMBER := -999;
866: l_cp_name cn_comp_plans.NAME%TYPE := NULL;

Line 866: l_cp_name cn_comp_plans.NAME%TYPE := NULL;

862: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;
863: l_note_msg VARCHAR2 (240);
864: l_note_id NUMBER;
865: l_org_id NUMBER := -999;
866: l_cp_name cn_comp_plans.NAME%TYPE := NULL;
867: BEGIN
868: -- Standard Start of API savepoint
869: SAVEPOINT delete_comp_plan;
870:

Line 892: SELECT NAME INTO l_cp_name from CN_COMP_PLANS where comp_plan_id = l_comp_plan_id;

888: l_org_id := p_comp_plan.org_id;
889: l_comp_plan_id := p_comp_plan.comp_plan_id;
890: -- delete the comp plan
891: BEGIN
892: SELECT NAME INTO l_cp_name from CN_COMP_PLANS where comp_plan_id = l_comp_plan_id;
893: EXCEPTION
894: WHEN OTHERS THEN
895: NULL;
896: END;

Line 905: cn_comp_plans_pkg.begin_record (x_operation => 'DELETE',

901: (p_operation => 'delete',
902: p_pre_or_post => 'pre',
903: p_comp_plan => p_comp_plan);
904:
905: cn_comp_plans_pkg.begin_record (x_operation => 'DELETE',
906: x_rowid => l_dummy_row_id,
907: x_comp_plan_id => l_comp_plan_id,
908: x_name => NULL,
909: x_last_update_date => NULL,

Line 1056: FROM cn_comp_plans

1052:
1053: CURSOR l_comp_plan_cr
1054: IS
1055: SELECT *
1056: FROM cn_comp_plans
1057: WHERE UPPER (NAME) LIKE UPPER (p_search_name)
1058: AND status_code = DECODE (p_search_status, 'NULL', status_code, p_search_status)
1059: AND TRUNC (start_date) >= TRUNC (NVL (p_search_date, start_date))
1060: ORDER BY NAME;

Line 1177: FROM cn_comp_plans

1173:
1174: CURSOR l_comp_plan_cr
1175: IS
1176: SELECT *
1177: FROM cn_comp_plans
1178: WHERE comp_plan_id = p_comp_plan_id;
1179:
1180: l_comp_plan l_comp_plan_cr%ROWTYPE;
1181: BEGIN

Line 1432: FROM cn_comp_plans

1428:
1429: CURSOR l_old_comp_plan_cr
1430: IS
1431: SELECT *
1432: FROM cn_comp_plans
1433: WHERE comp_plan_id = p_comp_plan.comp_plan_id;
1434:
1435: l_old_comp_plan l_old_comp_plan_cr%ROWTYPE;
1436: l_loading_status VARCHAR2 (50);

Line 1533: cn_comp_plans_pkg.end_record (x_rowid => l_dummy_row_id,

1529:
1530: IF l_loading_status = 'VALID_PLAN' THEN
1531:
1532: -- call table handler
1533: cn_comp_plans_pkg.end_record (x_rowid => l_dummy_row_id,
1534: x_comp_plan_id => p_comp_plan.comp_plan_id,
1535: x_name => l_old_comp_plan.NAME,
1536: x_description => l_old_comp_plan.description,
1537: x_start_date => l_old_comp_plan.start_date,

Line 1547: FROM cn_comp_plans

1543: END IF;
1544:
1545: SELECT status_code
1546: INTO l_status_code
1547: FROM cn_comp_plans
1548: WHERE comp_plan_id = p_comp_plan.comp_plan_id;
1549:
1550: IF l_status_code <> 'COMPLETE'
1551: THEN

Line 1605: l_comp_plan_name cn_comp_plans.NAME%TYPE;

1601: )
1602: IS
1603: l_rev_class_total NUMBER := 0;
1604: l_rev_class_total_unique NUMBER := 0;
1605: l_comp_plan_name cn_comp_plans.NAME%TYPE;
1606: l_rc_overlap VARCHAR2 (03);
1607:
1608: /* CURSOR check_overlap_curs IS
1609: SELECT count(value_external_id), count( distinct value_external_id)

Line 1679: FROM cn_comp_plans

1675: SELECT NAME,
1676: NVL (p_rc_overlap, allow_rev_class_overlap)
1677: INTO l_comp_plan_name,
1678: l_rc_overlap
1679: FROM cn_comp_plans
1680: WHERE comp_plan_id = p_comp_plan_id;
1681: EXCEPTION
1682: WHEN NO_DATA_FOUND
1683: THEN

Line 1705: result := CN_COMP_PLANS_PKG.check_unique_rev_class(p_comp_plan_id, l_comp_plan_name, l_rc_overlap);

1701: l_rev_class_total_unique;
1702:
1703: CLOSE check_overlap_curs; */
1704:
1705: result := CN_COMP_PLANS_PKG.check_unique_rev_class(p_comp_plan_id, l_comp_plan_name, l_rc_overlap);
1706:
1707:
1708: IF (result = false)
1709: THEN

Line 1786: p_comp_plan_id IN CN_COMP_PLANS.COMP_PLAN_ID%TYPE,

1782: p_api_version IN NUMBER,
1783: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1784: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1785: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1786: p_comp_plan_id IN CN_COMP_PLANS.COMP_PLAN_ID%TYPE,
1787: p_org_id IN NUMBER,
1788: x_return_status OUT NOCOPY VARCHAR2,
1789: x_msg_count OUT NOCOPY NUMBER,
1790: x_msg_data OUT NOCOPY VARCHAR2,

Line 1791: x_comp_plan_id OUT NOCOPY CN_COMP_PLANS.COMP_PLAN_ID%TYPE) IS

1787: p_org_id IN NUMBER,
1788: x_return_status OUT NOCOPY VARCHAR2,
1789: x_msg_count OUT NOCOPY NUMBER,
1790: x_msg_data OUT NOCOPY VARCHAR2,
1791: x_comp_plan_id OUT NOCOPY CN_COMP_PLANS.COMP_PLAN_ID%TYPE) IS
1792: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Comp_Plan';
1793:
1794: l_api_version CONSTANT NUMBER := 1.0;
1795:

Line 1798: Select * from cn_comp_plans_all

1794: l_api_version CONSTANT NUMBER := 1.0;
1795:
1796:
1797: CURSOR get_comp_plan_data IS
1798: Select * from cn_comp_plans_all
1799: Where comp_plan_id = p_comp_plan_id
1800: And org_id = p_org_id;
1801:
1802: CURSOR get_quota_assign_data IS