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 291: p_source_object_code => 'CN_COMP_PLANS',

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

Line 376: FROM cn_comp_plans

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

Line 384: l_name cn_comp_plans.NAME%TYPE;

380: l_comp_plan comp_plan_rec_type;
381: l_temp_count NUMBER;
382: l_start_date DATE;
383: l_end_date DATE;
384: l_name cn_comp_plans.NAME%TYPE;
385: l_description cn_comp_plans.description%TYPE;
386: l_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;
387: l_sum_trx CN_COMP_PLANS.SUM_TRX_FLAG%TYPE;
388: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;

Line 385: l_description cn_comp_plans.description%TYPE;

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

Line 386: l_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;

382: l_start_date DATE;
383: l_end_date DATE;
384: l_name cn_comp_plans.NAME%TYPE;
385: l_description cn_comp_plans.description%TYPE;
386: l_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;
387: l_sum_trx CN_COMP_PLANS.SUM_TRX_FLAG%TYPE;
388: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;
389: l_loading_status VARCHAR2 (50);
390: l_return_status VARCHAR2 (50);

Line 387: l_sum_trx CN_COMP_PLANS.SUM_TRX_FLAG%TYPE;

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

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

384: l_name cn_comp_plans.NAME%TYPE;
385: l_description cn_comp_plans.description%TYPE;
386: l_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;
387: l_sum_trx CN_COMP_PLANS.SUM_TRX_FLAG%TYPE;
388: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;
389: l_loading_status VARCHAR2 (50);
390: l_return_status VARCHAR2 (50);
391: l_attribute_category VARCHAR2 (150);
392: l_attribute1 VARCHAR2 (150);

Line 448: FROM cn_comp_plans

444:
445: -- 2. comp plan name must be unique
446: SELECT COUNT (1)
447: INTO l_temp_count
448: FROM cn_comp_plans
449: 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;
450:
451: IF l_temp_count <> 0
452: THEN

Line 598: FROM cn_comp_plans

594: -- since srp assignments always within role assignments, then we
595: -- don't need to check those
596: SELECT org_id
597: INTO l_org_id
598: FROM cn_comp_plans
599: WHERE comp_plan_id = l_comp_plan_id;
600:
601: --- *** Business Events *** ---
602: business_event

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

604: p_pre_or_post => 'pre',
605: p_comp_plan => p_comp_plan);
606:
607:
608: cn_comp_plans_pkg.begin_record (x_operation => 'UPDATE',
609: x_rowid => g_rowid,
610: x_comp_plan_id => l_comp_plan_id,
611: x_name => l_name,
612: x_description => l_description,

Line 674: p_source_object_code => 'CN_COMP_PLANS',

670: x_return_status => x_return_status,
671: x_msg_count => x_msg_count,
672: x_msg_data => x_msg_data,
673: p_source_object_id => l_old_comp_plan.comp_plan_id,
674: p_source_object_code => 'CN_COMP_PLANS',
675: p_notes => l_note_msg,
676: p_notes_detail => l_note_msg,
677: p_note_type => 'CN_SYSGEN', -- for system generated
678: x_jtf_note_id => l_note_id -- returned

Line 701: p_source_object_code => 'CN_COMP_PLANS',

697: x_return_status => x_return_status,
698: x_msg_count => x_msg_count,
699: x_msg_data => x_msg_data,
700: p_source_object_id => l_old_comp_plan.comp_plan_id,
701: p_source_object_code => 'CN_COMP_PLANS',
702: p_notes => l_note_msg,
703: p_notes_detail => l_note_msg,
704: p_note_type => 'CN_SYSGEN', -- for system generated
705: x_jtf_note_id => l_note_id -- returned

Line 725: p_source_object_code => 'CN_COMP_PLANS',

721: x_return_status => x_return_status,
722: x_msg_count => x_msg_count,
723: x_msg_data => x_msg_data,
724: p_source_object_id => l_old_comp_plan.comp_plan_id,
725: p_source_object_code => 'CN_COMP_PLANS',
726: p_notes => l_note_msg,
727: p_notes_detail => l_note_msg,
728: p_note_type => 'CN_SYSGEN', -- for system generated
729: x_jtf_note_id => l_note_id -- returned

Line 751: p_source_object_code => 'CN_COMP_PLANS',

747: x_return_status => x_return_status,
748: x_msg_count => x_msg_count,
749: x_msg_data => x_msg_data,
750: p_source_object_id => l_old_comp_plan.comp_plan_id,
751: p_source_object_code => 'CN_COMP_PLANS',
752: p_notes => l_note_msg,
753: p_notes_detail => l_note_msg,
754: p_note_type => 'CN_SYSGEN', -- for system generated
755: x_jtf_note_id => l_note_id -- returned

Line 777: p_source_object_code => 'CN_COMP_PLANS',

773: x_return_status => x_return_status,
774: x_msg_count => x_msg_count,
775: x_msg_data => x_msg_data,
776: p_source_object_id => l_old_comp_plan.comp_plan_id,
777: p_source_object_code => 'CN_COMP_PLANS',
778: p_notes => l_note_msg,
779: p_notes_detail => l_note_msg,
780: p_note_type => 'CN_SYSGEN', -- for system generated
781: x_jtf_note_id => l_note_id -- returned

Line 794: p_source_object_code => 'CN_COMP_PLANS',

790: x_return_status => x_return_status,
791: x_msg_count => x_msg_count,
792: x_msg_data => x_msg_data,
793: p_source_object_id => l_old_comp_plan.comp_plan_id,
794: p_source_object_code => 'CN_COMP_PLANS',
795: p_notes => l_consolidated_note,
796: p_notes_detail => l_consolidated_note,
797: p_note_type => 'CN_SYSGEN', -- for system generated
798: x_jtf_note_id => l_note_id -- returned

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

867: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Comp_Plan';
868: l_api_version CONSTANT NUMBER := 1.0;
869: l_temp_count NUMBER;
870: l_dummy_row_id VARCHAR2 (18);
871: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;
872: l_note_msg VARCHAR2 (240);
873: l_note_id NUMBER;
874: l_org_id NUMBER := -999;
875: l_cp_name cn_comp_plans.NAME%TYPE := NULL;

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

871: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;
872: l_note_msg VARCHAR2 (240);
873: l_note_id NUMBER;
874: l_org_id NUMBER := -999;
875: l_cp_name cn_comp_plans.NAME%TYPE := NULL;
876: BEGIN
877: -- Standard Start of API savepoint
878: SAVEPOINT delete_comp_plan;
879:

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

897: l_org_id := p_comp_plan.org_id;
898: l_comp_plan_id := p_comp_plan.comp_plan_id;
899: -- delete the comp plan
900: BEGIN
901: SELECT NAME INTO l_cp_name from CN_COMP_PLANS where comp_plan_id = l_comp_plan_id;
902: EXCEPTION
903: WHEN OTHERS THEN
904: NULL;
905: END;

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

910: (p_operation => 'delete',
911: p_pre_or_post => 'pre',
912: p_comp_plan => p_comp_plan);
913:
914: cn_comp_plans_pkg.begin_record (x_operation => 'DELETE',
915: x_rowid => l_dummy_row_id,
916: x_comp_plan_id => l_comp_plan_id,
917: x_name => NULL,
918: x_last_update_date => NULL,

Line 1066: FROM cn_comp_plans

1062:
1063: CURSOR l_comp_plan_cr
1064: IS
1065: SELECT *
1066: FROM cn_comp_plans
1067: WHERE UPPER (NAME) LIKE UPPER (p_search_name)
1068: AND status_code = DECODE (p_search_status, 'NULL', status_code, p_search_status)
1069: AND TRUNC (start_date) >= TRUNC (NVL (p_search_date, start_date))
1070: ORDER BY NAME;

Line 1187: FROM cn_comp_plans

1183:
1184: CURSOR l_comp_plan_cr
1185: IS
1186: SELECT *
1187: FROM cn_comp_plans
1188: WHERE comp_plan_id = p_comp_plan_id;
1189:
1190: l_comp_plan l_comp_plan_cr%ROWTYPE;
1191: BEGIN

Line 1444: FROM cn_comp_plans

1440:
1441: CURSOR l_old_comp_plan_cr
1442: IS
1443: SELECT *
1444: FROM cn_comp_plans
1445: WHERE comp_plan_id = p_comp_plan.comp_plan_id;
1446:
1447: l_old_comp_plan l_old_comp_plan_cr%ROWTYPE;
1448: l_loading_status VARCHAR2 (50);

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

1542:
1543: IF l_loading_status = 'VALID_PLAN' THEN
1544:
1545: -- call table handler
1546: cn_comp_plans_pkg.end_record (x_rowid => l_dummy_row_id,
1547: x_comp_plan_id => p_comp_plan.comp_plan_id,
1548: x_name => l_old_comp_plan.NAME,
1549: x_description => l_old_comp_plan.description,
1550: x_start_date => l_old_comp_plan.start_date,

Line 1561: FROM cn_comp_plans

1557: END IF;
1558:
1559: SELECT status_code
1560: INTO l_status_code
1561: FROM cn_comp_plans
1562: WHERE comp_plan_id = p_comp_plan.comp_plan_id;
1563:
1564: IF l_status_code <> 'COMPLETE'
1565: THEN

Line 1620: l_comp_plan_name cn_comp_plans.NAME%TYPE;

1616: )
1617: IS
1618: l_rev_class_total NUMBER := 0;
1619: l_rev_class_total_unique NUMBER := 0;
1620: l_comp_plan_name cn_comp_plans.NAME%TYPE;
1621: l_rc_overlap VARCHAR2 (03);
1622: l_sum_trx VARCHAR2(03);
1623:
1624: /* CURSOR check_overlap_curs IS

Line 1697: FROM cn_comp_plans

1693: sum_trx_flag
1694: INTO l_comp_plan_name,
1695: l_rc_overlap,
1696: l_sum_trx
1697: FROM cn_comp_plans
1698: WHERE comp_plan_id = p_comp_plan_id;
1699: EXCEPTION
1700: WHEN NO_DATA_FOUND
1701: THEN

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

1719: l_rev_class_total_unique;
1720:
1721: CLOSE check_overlap_curs; */
1722:
1723: result := CN_COMP_PLANS_PKG.check_unique_rev_class(p_comp_plan_id, l_comp_plan_name, l_rc_overlap,l_sum_trx);
1724:
1725:
1726: IF (result = false)
1727: THEN

Line 1804: p_comp_plan_id IN CN_COMP_PLANS.COMP_PLAN_ID%TYPE,

1800: p_api_version IN NUMBER,
1801: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1802: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1803: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1804: p_comp_plan_id IN CN_COMP_PLANS.COMP_PLAN_ID%TYPE,
1805: p_org_id IN NUMBER,
1806: x_return_status OUT NOCOPY VARCHAR2,
1807: x_msg_count OUT NOCOPY NUMBER,
1808: x_msg_data OUT NOCOPY VARCHAR2,

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

1805: p_org_id IN NUMBER,
1806: x_return_status OUT NOCOPY VARCHAR2,
1807: x_msg_count OUT NOCOPY NUMBER,
1808: x_msg_data OUT NOCOPY VARCHAR2,
1809: x_comp_plan_id OUT NOCOPY CN_COMP_PLANS.COMP_PLAN_ID%TYPE) IS
1810: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Comp_Plan';
1811:
1812: l_api_version CONSTANT NUMBER := 1.0;
1813:

Line 1816: Select * from cn_comp_plans_all

1812: l_api_version CONSTANT NUMBER := 1.0;
1813:
1814:
1815: CURSOR get_comp_plan_data IS
1816: Select * from cn_comp_plans_all
1817: Where comp_plan_id = p_comp_plan_id
1818: And org_id = p_org_id;
1819:
1820: CURSOR get_quota_assign_data IS