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.IGI_EFC_UPGRADE dependencies on GL_BUDORG_BC_OPTIONS

Line 44: -- PLSQL Table corresponding to IGI_UPG_GL_BUDORG_BC_OPTIONS

40:
41: -- Array of Segment Records
42: TYPE segment_rec_index_type IS TABLE OF NUMBER;
43:
44: -- PLSQL Table corresponding to IGI_UPG_GL_BUDORG_BC_OPTIONS
45: TYPE BC_OPTIONS_TAB IS TABLE OF IGI_UPG_GL_BUDORG_BC_OPTIONS%ROWTYPE;
46:
47: -- Stores table of segment records
48: segment_tab SEGMENT_TYPE;

Line 45: TYPE BC_OPTIONS_TAB IS TABLE OF IGI_UPG_GL_BUDORG_BC_OPTIONS%ROWTYPE;

41: -- Array of Segment Records
42: TYPE segment_rec_index_type IS TABLE OF NUMBER;
43:
44: -- PLSQL Table corresponding to IGI_UPG_GL_BUDORG_BC_OPTIONS
45: TYPE BC_OPTIONS_TAB IS TABLE OF IGI_UPG_GL_BUDORG_BC_OPTIONS%ROWTYPE;
46:
47: -- Stores table of segment records
48: segment_tab SEGMENT_TYPE;
49:

Line 136: FROM IGI_UPG_GL_BUDORG_BC_OPTIONS IGIBC,

132: -- This cursor fetches budgets associated to the give account range
133: CURSOR C_BC_OPTIONS (pp_range_id NUMBER)
134: IS
135: SELECT IGIBC.*,BV.BUDGET_NAME BUDGET_NAME
136: FROM IGI_UPG_GL_BUDORG_BC_OPTIONS IGIBC,
137: GL_BUDGET_VERSIONS BV
138: WHERE IGIBC.RANGE_ID = pp_range_id AND
139: IGIBC.FUNDING_BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
140: ;

Line 1372: SELECT * FROM IGI_UPG_GL_BUDORG_BC_OPTIONS

1368:
1369: -- This cursor fetches all the budgets associated to p_range_id
1370: CURSOR C_BC_OPTIONS (p_range_id NUMBER)
1371: IS
1372: SELECT * FROM IGI_UPG_GL_BUDORG_BC_OPTIONS
1373: WHERE RANGE_ID = p_range_id;
1374:
1375: TYPE non_overlapping_ranges_tab IS TABLE OF C_NON_OVERLAPPING_RANGES%ROWTYPE;
1376:

Line 1702: INSERT INTO GL_BUDORG_BC_OPTIONS

1698: lc_non_overlapping_ranges(i).attribute14,
1699: lc_non_overlapping_ranges(i).attribute15
1700: );
1701:
1702: INSERT INTO GL_BUDORG_BC_OPTIONS
1703: (
1704: RANGE_ID,
1705: FUNDING_BUDGET_VERSION_ID,
1706: FUNDS_CHECK_LEVEL_CODE,

Line 1726: FROM IGI_UPG_GL_BUDORG_BC_OPTIONS

1722: CREATION_DATE,
1723: LAST_UPDATED_BY,
1724: LAST_UPDATE_LOGIN,
1725: LAST_UPDATE_DATE
1726: FROM IGI_UPG_GL_BUDORG_BC_OPTIONS
1727: WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1728:
1729:
1730: INSERT_ENTITY(lc_non_overlapping_ranges(i).ledger_id,

Line 1741: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;

1737: retcode := l_retcode;
1738: RETURN;
1739: END IF;
1740:
1741: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1742:
1743: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1744:
1745:

Line 1768: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;

1764: RETURN;
1765: END IF;
1766:
1767:
1768: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1769:
1770: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1771: EXCEPTION
1772: WHEN OTHERS THEN

Line 1816: UPDATE IGI_UPG_GL_BUDORG_BC_OPTIONS

1812:
1813:
1814: BEGIN
1815:
1816: UPDATE IGI_UPG_GL_BUDORG_BC_OPTIONS
1817: SET RANGE_ID = lc_exact_merge_range1.range_id
1818: WHERE RANGE_ID = lc_exact_merge_range2.range_id;
1819:
1820: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_exact_merge_range2.range_id;

Line 2504: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS

2500: l_inserted := FALSE;
2501: FOR k IN 1..lc_merge_range2_bc.COUNT LOOP
2502: IF l_final_budget_ranges(i).budget_tab(j) = lc_merge_range2_bc(k).funding_budget_version_id THEN
2503: BEGIN
2504: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS
2505: (
2506: RANGE_ID,
2507: FUNDING_BUDGET_VERSION_ID,
2508: FUNDS_CHECK_LEVEL_CODE,

Line 2532: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1');

2528: sysdate
2529: );
2530: EXCEPTION
2531: WHEN OTHERS THEN
2532: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1');
2533: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2534: ||'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM);
2535: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2536: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM;

Line 2534: ||'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM);

2530: EXCEPTION
2531: WHEN OTHERS THEN
2532: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1');
2533: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2534: ||'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM);
2535: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2536: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM;
2537: retcode := -1;
2538: RETURN;

Line 2536: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM;

2532: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1');
2533: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2534: ||'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM);
2535: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2536: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM;
2537: retcode := -1;
2538: RETURN;
2539: END;
2540: l_inserted := TRUE;

Line 2827: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS

2823: FOR k IN 1..lc_merge_range1_bc.COUNT LOOP
2824: IF l_final_budget_ranges(i).budget_tab(j) = lc_merge_range1_bc(k).funding_budget_version_id
2825: THEN
2826: BEGIN
2827: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS
2828: (
2829: RANGE_ID,
2830: FUNDING_BUDGET_VERSION_ID,
2831: FUNDS_CHECK_LEVEL_CODE,

Line 2856: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2');

2852: );
2853: EXCEPTION
2854: WHEN OTHERS THEN
2855: fnd_file.put_line(fnd_file.output, 'Error inserting records into
2856: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2');
2857: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2858: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM);
2859: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2860: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM;

Line 2858: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM);

2854: WHEN OTHERS THEN
2855: fnd_file.put_line(fnd_file.output, 'Error inserting records into
2856: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2');
2857: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2858: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM);
2859: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2860: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM;
2861: retcode := -1;
2862: RETURN;

Line 2860: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM;

2856: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2');
2857: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2858: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM);
2859: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2860: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM;
2861: retcode := -1;
2862: RETURN;
2863: END;
2864: l_inserted := TRUE;

Line 2873: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS

2869: FOR r IN 1..lc_merge_range2_bc.COUNT LOOP
2870: IF l_final_budget_ranges(i).budget_tab(j) = lc_merge_range2_bc(r).funding_budget_version_id
2871: THEN
2872: BEGIN
2873: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS
2874: (
2875: RANGE_ID,
2876: FUNDING_BUDGET_VERSION_ID,
2877: FUNDS_CHECK_LEVEL_CODE,

Line 2902: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4');

2898: );
2899: EXCEPTION
2900: WHEN OTHERS THEN
2901: fnd_file.put_line(fnd_file.output, 'Error inserting records into
2902: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4');
2903: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2904: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4 '||SQLERRM);
2905: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2906: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4 '||SQLERRM;

Line 2904: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4 '||SQLERRM);

2900: WHEN OTHERS THEN
2901: fnd_file.put_line(fnd_file.output, 'Error inserting records into
2902: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4');
2903: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2904: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4 '||SQLERRM);
2905: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2906: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4 '||SQLERRM;
2907: retcode := -1;
2908: RETURN;

Line 2906: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4 '||SQLERRM;

2902: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4');
2903: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2904: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4 '||SQLERRM);
2905: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2906: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4 '||SQLERRM;
2907: retcode := -1;
2908: RETURN;
2909: END;
2910: l_inserted := TRUE;

Line 2937: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE

2933: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE
2934: range_id = lc_merge_range2.range_id OR
2935: range_id = lc_merge_range1.range_id;
2936:
2937: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE
2938: range_id = lc_merge_range2.range_id OR
2939: range_id = lc_merge_range1.range_id;
2940: EXCEPTION
2941: WHEN OTHERS THEN

Line 3222: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS;

3218: -- has been added to ensure that no data exists
3219: BEGIN
3220:
3221: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT;
3222: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS;
3223:
3224: EXCEPTION
3225: WHEN OTHERS THEN
3226: fnd_file.put_line(fnd_file.output, 'Purging of tables failed');

Line 3501: FROM GL_BUDORG_BC_OPTIONS

3497: CREATION_DATE,
3498: LAST_UPDATED_BY,
3499: LAST_UPDATE_LOGIN,
3500: LAST_UPDATE_DATE
3501: FROM GL_BUDORG_BC_OPTIONS
3502: WHERE range_id IN
3503: (SELECT range_id
3504: FROM
3505: IGI_EFC_BUDGET_ASSIGNMENT_BCK);

Line 3836: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS

3832:
3833:
3834: BEGIN
3835:
3836: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS
3837: (
3838: RANGE_ID,
3839: FUNDING_BUDGET_VERSION_ID,
3840: FUNDS_CHECK_LEVEL_CODE,

Line 3860: FROM GL_BUDORG_BC_OPTIONS

3856: CREATION_DATE,
3857: LAST_UPDATED_BY,
3858: LAST_UPDATE_LOGIN,
3859: LAST_UPDATE_DATE
3860: FROM GL_BUDORG_BC_OPTIONS
3861: WHERE range_id IN
3862: (SELECT range_id
3863: FROM
3864: IGI_UPG_GL_BUDGET_ASSIGNMENT);

Line 3870: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM);

3866: EXCEPTION
3867: WHEN OTHERS THEN
3868: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3869: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3870: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM);
3871: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3872: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM;
3873: retcode := -1;
3874: RETURN;

Line 3872: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM;

3868: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3869: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3870: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM);
3871: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3872: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM;
3873: retcode := -1;
3874: RETURN;
3875: END;
3876:

Line 3883: DELETE FROM GL_BUDORG_BC_OPTIONS

3879: IF p_mode = 1 THEN
3880:
3881: BEGIN
3882:
3883: DELETE FROM GL_BUDORG_BC_OPTIONS
3884: WHERE range_id IN
3885: (SELECT range_id
3886: FROM
3887: IGI_EFC_BUDGET_ASSIGNMENT_BCK);