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 42: TYPE BC_OPTIONS_TAB IS TABLE OF IGI_UPG_GL_BUDORG_BC_OPTIONS%ROWTYPE;

38: TYPE segment_type IS TABLE OF segment_rec;
39:
40: TYPE segment_rec_index_type IS TABLE OF NUMBER;
41:
42: TYPE BC_OPTIONS_TAB IS TABLE OF IGI_UPG_GL_BUDORG_BC_OPTIONS%ROWTYPE;
43:
44:
45: segment_tab SEGMENT_TYPE;
46: budget_range_tab BUDGET_RANGE_TYPE;

Line 69: FROM IGI_UPG_GL_BUDORG_BC_OPTIONS IGIBC,

65:
66: CURSOR C_BC_OPTIONS (pp_range_id NUMBER)
67: IS
68: SELECT IGIBC.*,BV.BUDGET_NAME BUDGET_NAME
69: FROM IGI_UPG_GL_BUDORG_BC_OPTIONS IGIBC,
70: GL_BUDGET_VERSIONS BV
71: WHERE IGIBC.RANGE_ID = pp_range_id AND
72: IGIBC.FUNDING_BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
73: ;

Line 1144: SELECT * FROM IGI_UPG_GL_BUDORG_BC_OPTIONS

1140:
1141:
1142: CURSOR C_BC_OPTIONS (p_range_id NUMBER)
1143: IS
1144: SELECT * FROM IGI_UPG_GL_BUDORG_BC_OPTIONS
1145: WHERE RANGE_ID = p_range_id;
1146:
1147: TYPE non_overlapping_ranges_tab IS TABLE OF C_NON_OVERLAPPING_RANGES%ROWTYPE;
1148:

Line 1449: INSERT INTO GL_BUDORG_BC_OPTIONS

1445: lc_non_overlapping_ranges(i).attribute14,
1446: lc_non_overlapping_ranges(i).attribute15
1447: );
1448:
1449: INSERT INTO GL_BUDORG_BC_OPTIONS
1450: (
1451: RANGE_ID,
1452: FUNDING_BUDGET_VERSION_ID,
1453: FUNDS_CHECK_LEVEL_CODE,

Line 1473: FROM IGI_UPG_GL_BUDORG_BC_OPTIONS

1469: CREATION_DATE,
1470: LAST_UPDATED_BY,
1471: LAST_UPDATE_LOGIN,
1472: LAST_UPDATE_DATE
1473: FROM IGI_UPG_GL_BUDORG_BC_OPTIONS
1474: WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1475:
1476:
1477: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;

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

1473: FROM IGI_UPG_GL_BUDORG_BC_OPTIONS
1474: WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1475:
1476:
1477: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1478:
1479: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1480:
1481:

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

1500: RETURN;
1501: END IF;
1502:
1503:
1504: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1505:
1506: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1507: EXCEPTION
1508: WHEN OTHERS THEN

Line 1545: UPDATE IGI_UPG_GL_BUDORG_BC_OPTIONS

1541:
1542:
1543: BEGIN
1544:
1545: UPDATE IGI_UPG_GL_BUDORG_BC_OPTIONS
1546: SET RANGE_ID = lc_exact_merge_range1.range_id
1547: WHERE RANGE_ID = lc_exact_merge_range2.range_id;
1548:
1549: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_exact_merge_range2.range_id;

Line 2201: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS

2197: FOR j IN 1..l_final_budget_ranges(i).budget_tab.COUNT LOOP
2198: FOR k IN 1..lc_merge_range2_bc.COUNT LOOP
2199: IF l_final_budget_ranges(i).budget_tab(j) = lc_merge_range2_bc(k).funding_budget_version_id THEN
2200: BEGIN
2201: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS
2202: (
2203: RANGE_ID,
2204: FUNDING_BUDGET_VERSION_ID,
2205: FUNDS_CHECK_LEVEL_CODE,

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

2225: sysdate
2226: );
2227: EXCEPTION
2228: WHEN OTHERS THEN
2229: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1');
2230: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2231: ||'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM);
2232: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2233: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM;

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

2227: EXCEPTION
2228: WHEN OTHERS THEN
2229: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1');
2230: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2231: ||'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM);
2232: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2233: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM;
2234: retcode := -1;
2235: RETURN;

Line 2233: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM;

2229: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1');
2230: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2231: ||'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM);
2232: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2233: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM;
2234: retcode := -1;
2235: RETURN;
2236: END;
2237: EXIT;

Line 2504: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS

2500: FOR k IN 1..lc_merge_range1_bc.COUNT LOOP
2501: IF l_final_budget_ranges(i).budget_tab(j) = lc_merge_range1_bc(k).funding_budget_version_id
2502: 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 2533: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2');

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

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

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

Line 2537: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM;

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

Line 2546: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS

2542: END IF;
2543: IF l_final_budget_ranges(i).budget_tab(j) = lc_merge_range2_bc(k).funding_budget_version_id
2544: THEN
2545: BEGIN
2546: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS
2547: (
2548: RANGE_ID,
2549: FUNDING_BUDGET_VERSION_ID,
2550: FUNDS_CHECK_LEVEL_CODE,

Line 2575: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 3');

2571: );
2572: EXCEPTION
2573: WHEN OTHERS THEN
2574: fnd_file.put_line(fnd_file.output, 'Error inserting records into
2575: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 3');
2576: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2577: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 3 '||SQLERRM);
2578: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2579: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 3 '||SQLERRM;

Line 2577: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 3 '||SQLERRM);

2573: WHEN OTHERS THEN
2574: fnd_file.put_line(fnd_file.output, 'Error inserting records into
2575: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 3');
2576: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2577: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 3 '||SQLERRM);
2578: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2579: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 3 '||SQLERRM;
2580: retcode := -1;
2581: RETURN;

Line 2579: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 3 '||SQLERRM;

2575: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 3');
2576: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2577: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 3 '||SQLERRM);
2578: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2579: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 3 '||SQLERRM;
2580: retcode := -1;
2581: RETURN;
2582: END;
2583: EXIT;

Line 2597: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE

2593: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE
2594: range_id = lc_merge_range2.range_id OR
2595: range_id = lc_merge_range1.range_id;
2596:
2597: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE
2598: range_id = lc_merge_range2.range_id OR
2599: range_id = lc_merge_range1.range_id;
2600: EXCEPTION
2601: WHEN OTHERS THEN

Line 2857: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS;

2853:
2854: BEGIN
2855:
2856: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT;
2857: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS;
2858:
2859: EXCEPTION
2860: WHEN OTHERS THEN
2861: fnd_file.put_line(fnd_file.output, 'Purging of tables failed');

Line 3133: FROM GL_BUDORG_BC_OPTIONS

3129: CREATION_DATE,
3130: LAST_UPDATED_BY,
3131: LAST_UPDATE_LOGIN,
3132: LAST_UPDATE_DATE
3133: FROM GL_BUDORG_BC_OPTIONS
3134: WHERE range_id IN
3135: (SELECT range_id
3136: FROM
3137: IGI_EFC_BUDGET_ASSIGNMENT_BCK);

Line 3460: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS

3456:
3457:
3458: BEGIN
3459:
3460: INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS
3461: (
3462: RANGE_ID,
3463: FUNDING_BUDGET_VERSION_ID,
3464: FUNDS_CHECK_LEVEL_CODE,

Line 3484: FROM GL_BUDORG_BC_OPTIONS

3480: CREATION_DATE,
3481: LAST_UPDATED_BY,
3482: LAST_UPDATE_LOGIN,
3483: LAST_UPDATE_DATE
3484: FROM GL_BUDORG_BC_OPTIONS
3485: WHERE range_id IN
3486: (SELECT range_id
3487: FROM
3488: IGI_UPG_GL_BUDGET_ASSIGNMENT);

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

3490: EXCEPTION
3491: WHEN OTHERS THEN
3492: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3493: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3494: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM);
3495: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3496: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM;
3497: retcode := -1;
3498: RETURN;

Line 3496: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM;

3492: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3493: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3494: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM);
3495: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3496: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM;
3497: retcode := -1;
3498: RETURN;
3499: END;
3500:

Line 3505: DELETE FROM GL_BUDORG_BC_OPTIONS

3501: IF p_mode = 1 THEN
3502:
3503: BEGIN
3504:
3505: DELETE FROM GL_BUDORG_BC_OPTIONS
3506: WHERE range_id IN
3507: (SELECT range_id
3508: FROM
3509: IGI_EFC_BUDGET_ASSIGNMENT_BCK);