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 IGI_UPG_GL_BUDGET_ASSIGNMENT

Line 58: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT IGIGL,

54: IS
55: CURSOR C_UPG_GL_BUDGET_ASSIGNMENT (pp_range_id NUMBER)
56: IS
57: SELECT IGIGL.*,ent.NAME BUDGET_NAME,led.NAME LEDGER_NAME
58: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT IGIGL,
59: gl_budget_entities ent,
60: GL_LEDGERS led
61: WHERE IGIGL.RANGE_ID = pp_range_id
62: AND IGIGL.budget_entity_id = ent.budget_entity_id

Line 920: TYPE BUD_ASSIGN_TAB IS TABLE OF IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;

916: retcode OUT NOCOPY NUMBER
917: )
918: IS
919:
920: TYPE BUD_ASSIGN_TAB IS TABLE OF IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
921:
922:
923: CURSOR C_NON_OVERLAPPING_RANGES IS
924: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1

Line 924: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1

920: TYPE BUD_ASSIGN_TAB IS TABLE OF IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
921:
922:
923: CURSOR C_NON_OVERLAPPING_RANGES IS
924: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
925: WHERE NOT EXISTS
926: (SELECT 1 FROM
927: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
928: WHERE BA1.RANGE_ID <> BA2.RANGE_ID

Line 927: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2

923: CURSOR C_NON_OVERLAPPING_RANGES IS
924: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
925: WHERE NOT EXISTS
926: (SELECT 1 FROM
927: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
928: WHERE BA1.RANGE_ID <> BA2.RANGE_ID
929: AND BA2.ledger_id = BA1.ledger_id
930: AND BA2.currency_code = BA1.currency_code
931: AND NVL(BA1.SEGMENT1_LOW,'X') <= NVL(BA2.SEGMENT1_HIGH,'X')

Line 995: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1

991:
992: );
993:
994: CURSOR C_EXACT_OVERLAPPING_RANGE(p_range_id NUMBER) IS
995: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
996: WHERE EXISTS
997: (SELECT 1 FROM
998: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
999: WHERE

Line 998: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2

994: CURSOR C_EXACT_OVERLAPPING_RANGE(p_range_id NUMBER) IS
995: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
996: WHERE EXISTS
997: (SELECT 1 FROM
998: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
999: WHERE
1000: BA2.range_id = p_range_id
1001: AND BA2.ledger_id = BA1.ledger_id
1002: AND BA2.currency_code = BA1.currency_code

Line 1067: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1

1063: AND NVL(BA1.SEGMENT30_HIGH,'X') = NVL(BA2.SEGMENT30_HIGH,'X')
1064: );
1065:
1066: CURSOR C_OVERLAPPING_RANGE(p_range_id NUMBER) IS
1067: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
1068: WHERE EXISTS
1069: (SELECT 1 FROM
1070: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
1071: WHERE

Line 1070: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2

1066: CURSOR C_OVERLAPPING_RANGE(p_range_id NUMBER) IS
1067: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
1068: WHERE EXISTS
1069: (SELECT 1 FROM
1070: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
1071: WHERE
1072: BA2.range_id = p_range_id
1073: AND BA2.ledger_id = BA1.ledger_id
1074: AND BA2.currency_code = BA1.currency_code

Line 1139: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1;

1135: AND NVL(BA1.SEGMENT30_HIGH,'X') >= NVL(BA2.SEGMENT30_LOW,'X')
1136: );
1137:
1138: CURSOR C_ALL_RANGES IS
1139: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1;
1140:
1141:
1142: CURSOR C_BC_OPTIONS (p_range_id NUMBER)
1143: IS

Line 1151: lc_exact_merge_range1 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;

1147: TYPE non_overlapping_ranges_tab IS TABLE OF C_NON_OVERLAPPING_RANGES%ROWTYPE;
1148:
1149: lc_non_overlapping_ranges non_overlapping_ranges_tab;
1150:
1151: lc_exact_merge_range1 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1152: lc_exact_merge_range1_bc BC_OPTIONS_TAB;
1153:
1154: lc_exact_merge_range2 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1155: lc_exact_merge_range2_bc BC_OPTIONS_TAB;

Line 1154: lc_exact_merge_range2 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;

1150:
1151: lc_exact_merge_range1 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1152: lc_exact_merge_range1_bc BC_OPTIONS_TAB;
1153:
1154: lc_exact_merge_range2 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1155: lc_exact_merge_range2_bc BC_OPTIONS_TAB;
1156:
1157:
1158:

Line 1159: lc_merge_range1 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;

1155: lc_exact_merge_range2_bc BC_OPTIONS_TAB;
1156:
1157:
1158:
1159: lc_merge_range1 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1160: lc_merge_range1_bc BC_OPTIONS_TAB;
1161:
1162: lc_merge_range2 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1163: lc_merge_range2_bc BC_OPTIONS_TAB;

Line 1162: lc_merge_range2 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;

1158:
1159: lc_merge_range1 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1160: lc_merge_range1_bc BC_OPTIONS_TAB;
1161:
1162: lc_merge_range2 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1163: lc_merge_range2_bc BC_OPTIONS_TAB;
1164:
1165: p_segment1 segment_range_rec;
1166: p_segment2 segment_range_rec;

Line 1479: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT 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:
1482:
1483: EXCEPTION

Line 1506: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;

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
1509: fnd_file.put_line(fnd_file.output, 'Error processing demerged data - prelim mode');
1510: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'

Line 1549: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_exact_merge_range2.range_id;

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;
1550:
1551: EXCEPTION
1552: WHEN OTHERS THEN
1553: fnd_file.put_line(fnd_file.output, 'Error merging data which overlaps exactly');

Line 1955: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT

1951: l_seq_number2 NUMBER;
1952: BEGIN
1953: SELECT max(sequence_number)+1
1954: INTO l_seq_number1
1955: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT
1956: WHERE
1957: budget_entity_id = lc_merge_range2.budget_entity_id;
1958:
1959: SELECT max(sequence_number)+1

Line 1988: INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT

1984: END IF;
1985:
1986: BEGIN
1987:
1988: INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT
1989: (
1990: BUDGET_ENTITY_ID,
1991: LEDGER_ID,
1992: CURRENCY_CODE,

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

2186: lc_merge_range2.attribute15
2187: );
2188: EXCEPTION
2189: WHEN OTHERS THEN
2190: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1');
2191: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2192: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM);
2193: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM;
2194: retcode := -1;

Line 2192: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM);

2188: EXCEPTION
2189: WHEN OTHERS THEN
2190: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1');
2191: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2192: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM);
2193: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM;
2194: retcode := -1;
2195: RETURN;
2196: END;

Line 2193: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM;

2189: WHEN OTHERS THEN
2190: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1');
2191: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2192: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM);
2193: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM;
2194: retcode := -1;
2195: RETURN;
2196: END;
2197: FOR j IN 1..l_final_budget_ranges(i).budget_tab.COUNT LOOP

Line 2254: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT

2250: l_seq_number2 NUMBER;
2251: BEGIN
2252: SELECT max(sequence_number)+1
2253: INTO l_seq_number1
2254: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT
2255: WHERE
2256: budget_entity_id = lc_merge_range1.budget_entity_id;
2257:
2258: SELECT max(sequence_number)+1

Line 2287: INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT

2283: END IF;
2284:
2285: BEGIN
2286:
2287: INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT
2288: (
2289: BUDGET_ENTITY_ID,
2290: LEDGER_ID,
2291: CURRENCY_CODE,

Line 2490: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2');

2486: );
2487:
2488: EXCEPTION
2489: WHEN OTHERS THEN
2490: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2');
2491: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2492: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM);
2493: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2494: IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM;

Line 2492: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM);

2488: EXCEPTION
2489: WHEN OTHERS THEN
2490: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2');
2491: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2492: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM);
2493: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2494: IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM;
2495: retcode := -1;
2496: RETURN;

Line 2494: IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM;

2490: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2');
2491: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2492: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM);
2493: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2494: IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM;
2495: retcode := -1;
2496: RETURN;
2497: END;
2498:

Line 2593: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE

2589: END IF;
2590: END LOOP; -- End l_final_budget_ranges FOR LOOP
2591:
2592: BEGIN
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

Line 2856: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT;

2852: END IF;
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

Line 3236: INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT

3232: END IF; -- If mode is Final mode
3233:
3234: BEGIN
3235:
3236: INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT
3237: (
3238: BUDGET_ENTITY_ID,
3239: LEDGER_ID,
3240: CURRENCY_CODE,

Line 3450: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM);

3446: EXCEPTION
3447: WHEN OTHERS THEN
3448: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3449: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3450: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM);
3451: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3452: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM;
3453: retcode := -1;
3454: RETURN;

Line 3452: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM;

3448: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3449: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3450: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM);
3451: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3452: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM;
3453: retcode := -1;
3454: RETURN;
3455: END;
3456:

Line 3488: IGI_UPG_GL_BUDGET_ASSIGNMENT);

3484: FROM GL_BUDORG_BC_OPTIONS
3485: WHERE range_id IN
3486: (SELECT range_id
3487: FROM
3488: IGI_UPG_GL_BUDGET_ASSIGNMENT);
3489:
3490: EXCEPTION
3491: WHEN OTHERS THEN
3492: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');