[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE INSERT_ENTITY(p_ledger_id gl_budget_assignment_ranges.budget_entity_id%TYPE,
p_entity_id gl_budget_assignment_ranges.ledger_id%TYPE,
errbuf OUT NOCOPY VARCHAR2,
retcode OUT NOCOPY NUMBER)
IS
l_exists BOOLEAN;
fnd_file.put_line(fnd_file.log, 'Module: INSERT_ENTITY '||'Insertion failed '||SQLERRM);
errbuf := 'Module: INSERT_ENTITY '||'Insertion failed '||SQLERRM;
END INSERT_ENTITY;
SELECT IGIGL.*,ent.NAME BUDGET_NAME,led.NAME LEDGER_NAME
FROM IGI_UPG_GL_BUDGET_ASSIGNMENT IGIGL,
gl_budget_entities ent,
GL_LEDGERS led
WHERE IGIGL.RANGE_ID = pp_range_id
AND IGIGL.budget_entity_id = ent.budget_entity_id
AND IGIGL.ledger_id = led.ledger_id
;
SELECT IGIBC.*,BV.BUDGET_NAME BUDGET_NAME
FROM IGI_UPG_GL_BUDORG_BC_OPTIONS IGIBC,
GL_BUDGET_VERSIONS BV
WHERE IGIBC.RANGE_ID = pp_range_id AND
IGIBC.FUNDING_BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
;
SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
WHERE NOT EXISTS
(SELECT 1 FROM
IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
WHERE BA1.RANGE_ID <> BA2.RANGE_ID
AND BA2.ledger_id = BA1.ledger_id
AND BA2.currency_code = BA1.currency_code
AND NVL(BA1.SEGMENT1_LOW,'X') <= NVL(BA2.SEGMENT1_HIGH,'X')
AND NVL(BA1.SEGMENT1_HIGH,'X') >= NVL(BA2.SEGMENT1_LOW,'X')
AND NVL(BA1.SEGMENT2_LOW,'X') <= NVL(BA2.SEGMENT2_HIGH,'X')
AND NVL(BA1.SEGMENT2_HIGH,'X') >= NVL(BA2.SEGMENT2_LOW,'X')
AND NVL(BA1.SEGMENT3_LOW,'X') <= NVL(BA2.SEGMENT3_HIGH,'X')
AND NVL(BA1.SEGMENT3_HIGH,'X') >= NVL(BA2.SEGMENT3_LOW,'X')
AND NVL(BA1.SEGMENT4_LOW,'X') <= NVL(BA2.SEGMENT4_HIGH,'X')
AND NVL(BA1.SEGMENT4_HIGH,'X') >= NVL(BA2.SEGMENT4_LOW,'X')
AND NVL(BA1.SEGMENT5_LOW,'X') <= NVL(BA2.SEGMENT5_HIGH,'X')
AND NVL(BA1.SEGMENT5_HIGH,'X') >= NVL(BA2.SEGMENT5_LOW,'X')
AND NVL(BA1.SEGMENT6_LOW,'X') <= NVL(BA2.SEGMENT6_HIGH,'X')
AND NVL(BA1.SEGMENT6_HIGH,'X') >= NVL(BA2.SEGMENT6_LOW,'X')
AND NVL(BA1.SEGMENT7_LOW,'X') <= NVL(BA2.SEGMENT7_HIGH,'X')
AND NVL(BA1.SEGMENT7_HIGH,'X') >= NVL(BA2.SEGMENT7_LOW,'X')
AND NVL(BA1.SEGMENT8_LOW,'X') <= NVL(BA2.SEGMENT8_HIGH,'X')
AND NVL(BA1.SEGMENT8_HIGH,'X') >= NVL(BA2.SEGMENT8_LOW,'X')
AND NVL(BA1.SEGMENT9_LOW,'X') <= NVL(BA2.SEGMENT9_HIGH,'X')
AND NVL(BA1.SEGMENT9_HIGH,'X') >= NVL(BA2.SEGMENT9_LOW,'X')
AND NVL(BA1.SEGMENT10_LOW,'X') <= NVL(BA2.SEGMENT10_HIGH,'X')
AND NVL(BA1.SEGMENT10_HIGH,'X') >= NVL(BA2.SEGMENT10_LOW,'X')
AND NVL(BA1.SEGMENT11_LOW,'X') <= NVL(BA2.SEGMENT11_HIGH,'X')
AND NVL(BA1.SEGMENT11_HIGH,'X') >= NVL(BA2.SEGMENT11_LOW,'X')
AND NVL(BA1.SEGMENT12_LOW,'X') <= NVL(BA2.SEGMENT12_HIGH,'X')
AND NVL(BA1.SEGMENT12_HIGH,'X') >= NVL(BA2.SEGMENT12_LOW,'X')
AND NVL(BA1.SEGMENT13_LOW,'X') <= NVL(BA2.SEGMENT13_HIGH,'X')
AND NVL(BA1.SEGMENT13_HIGH,'X') >= NVL(BA2.SEGMENT13_LOW,'X')
AND NVL(BA1.SEGMENT14_LOW,'X') <= NVL(BA2.SEGMENT14_HIGH,'X')
AND NVL(BA1.SEGMENT14_HIGH,'X') >= NVL(BA2.SEGMENT14_LOW,'X')
AND NVL(BA1.SEGMENT15_LOW,'X') <= NVL(BA2.SEGMENT15_HIGH,'X')
AND NVL(BA1.SEGMENT15_HIGH,'X') >= NVL(BA2.SEGMENT15_LOW,'X')
AND NVL(BA1.SEGMENT16_LOW,'X') <= NVL(BA2.SEGMENT16_HIGH,'X')
AND NVL(BA1.SEGMENT16_HIGH,'X') >= NVL(BA2.SEGMENT16_LOW,'X')
AND NVL(BA1.SEGMENT17_LOW,'X') <= NVL(BA2.SEGMENT17_HIGH,'X')
AND NVL(BA1.SEGMENT17_HIGH,'X') >= NVL(BA2.SEGMENT17_LOW,'X')
AND NVL(BA1.SEGMENT18_LOW,'X') <= NVL(BA2.SEGMENT18_HIGH,'X')
AND NVL(BA1.SEGMENT18_HIGH,'X') >= NVL(BA2.SEGMENT18_LOW,'X')
AND NVL(BA1.SEGMENT19_LOW,'X') <= NVL(BA2.SEGMENT19_HIGH,'X')
AND NVL(BA1.SEGMENT19_HIGH,'X') >= NVL(BA2.SEGMENT19_LOW,'X')
AND NVL(BA1.SEGMENT20_LOW,'X') <= NVL(BA2.SEGMENT20_HIGH,'X')
AND NVL(BA1.SEGMENT20_HIGH,'X') >= NVL(BA2.SEGMENT20_LOW,'X')
AND NVL(BA1.SEGMENT21_LOW,'X') <= NVL(BA2.SEGMENT21_HIGH,'X')
AND NVL(BA1.SEGMENT21_HIGH,'X') >= NVL(BA2.SEGMENT21_LOW,'X')
AND NVL(BA1.SEGMENT22_LOW,'X') <= NVL(BA2.SEGMENT22_HIGH,'X')
AND NVL(BA1.SEGMENT22_HIGH,'X') >= NVL(BA2.SEGMENT22_LOW,'X')
AND NVL(BA1.SEGMENT23_LOW,'X') <= NVL(BA2.SEGMENT23_HIGH,'X')
AND NVL(BA1.SEGMENT23_HIGH,'X') >= NVL(BA2.SEGMENT23_LOW,'X')
AND NVL(BA1.SEGMENT24_LOW,'X') <= NVL(BA2.SEGMENT24_HIGH,'X')
AND NVL(BA1.SEGMENT24_HIGH,'X') >= NVL(BA2.SEGMENT24_LOW,'X')
AND NVL(BA1.SEGMENT25_LOW,'X') <= NVL(BA2.SEGMENT25_HIGH,'X')
AND NVL(BA1.SEGMENT25_HIGH,'X') >= NVL(BA2.SEGMENT25_LOW,'X')
AND NVL(BA1.SEGMENT26_LOW,'X') <= NVL(BA2.SEGMENT26_HIGH,'X')
AND NVL(BA1.SEGMENT26_HIGH,'X') >= NVL(BA2.SEGMENT26_LOW,'X')
AND NVL(BA1.SEGMENT27_LOW,'X') <= NVL(BA2.SEGMENT27_HIGH,'X')
AND NVL(BA1.SEGMENT27_HIGH,'X') >= NVL(BA2.SEGMENT27_LOW,'X')
AND NVL(BA1.SEGMENT28_LOW,'X') <= NVL(BA2.SEGMENT28_HIGH,'X')
AND NVL(BA1.SEGMENT28_HIGH,'X') >= NVL(BA2.SEGMENT28_LOW,'X')
AND NVL(BA1.SEGMENT29_LOW,'X') <= NVL(BA2.SEGMENT29_HIGH,'X')
AND NVL(BA1.SEGMENT29_HIGH,'X') >= NVL(BA2.SEGMENT29_LOW,'X')
AND NVL(BA1.SEGMENT30_LOW,'X') <= NVL(BA2.SEGMENT30_HIGH,'X')
AND NVL(BA1.SEGMENT30_HIGH,'X') >= NVL(BA2.SEGMENT30_LOW,'X')
);
SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
WHERE EXISTS
(SELECT 1 FROM
IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
WHERE
BA2.range_id = p_range_id
AND BA2.ledger_id = BA1.ledger_id
AND BA2.currency_code = BA1.currency_code
AND BA1.RANGE_ID <> BA2.RANGE_ID
AND NVL(BA1.SEGMENT1_LOW,'X') = NVL(BA2.SEGMENT1_LOW,'X')
AND NVL(BA1.SEGMENT1_HIGH,'X') = NVL(BA2.SEGMENT1_HIGH,'X')
AND NVL(BA1.SEGMENT2_LOW,'X') = NVL(BA2.SEGMENT2_LOW,'X')
AND NVL(BA1.SEGMENT2_HIGH,'X') = NVL(BA2.SEGMENT2_HIGH,'X')
AND NVL(BA1.SEGMENT3_LOW,'X') = NVL(BA2.SEGMENT3_LOW,'X')
AND NVL(BA1.SEGMENT3_HIGH,'X') = NVL(BA2.SEGMENT3_HIGH,'X')
AND NVL(BA1.SEGMENT4_LOW,'X') = NVL(BA2.SEGMENT4_LOW,'X')
AND NVL(BA1.SEGMENT4_HIGH,'X') = NVL(BA2.SEGMENT4_HIGH,'X')
AND NVL(BA1.SEGMENT5_LOW,'X') = NVL(BA2.SEGMENT5_LOW,'X')
AND NVL(BA1.SEGMENT5_HIGH,'X') = NVL(BA2.SEGMENT5_HIGH,'X')
AND NVL(BA1.SEGMENT6_LOW,'X') = NVL(BA2.SEGMENT6_LOW,'X')
AND NVL(BA1.SEGMENT6_HIGH,'X') = NVL(BA2.SEGMENT6_HIGH,'X')
AND NVL(BA1.SEGMENT7_LOW,'X') = NVL(BA2.SEGMENT7_LOW,'X')
AND NVL(BA1.SEGMENT7_HIGH,'X') = NVL(BA2.SEGMENT7_HIGH,'X')
AND NVL(BA1.SEGMENT8_LOW,'X') = NVL(BA2.SEGMENT8_LOW,'X')
AND NVL(BA1.SEGMENT8_HIGH,'X') = NVL(BA2.SEGMENT8_HIGH,'X')
AND NVL(BA1.SEGMENT9_LOW,'X') = NVL(BA2.SEGMENT9_LOW,'X')
AND NVL(BA1.SEGMENT9_HIGH,'X') = NVL(BA2.SEGMENT9_HIGH,'X')
AND NVL(BA1.SEGMENT10_LOW,'X') = NVL(BA2.SEGMENT10_LOW,'X')
AND NVL(BA1.SEGMENT10_HIGH,'X') = NVL(BA2.SEGMENT10_HIGH,'X')
AND NVL(BA1.SEGMENT11_LOW,'X') = NVL(BA2.SEGMENT11_LOW,'X')
AND NVL(BA1.SEGMENT11_HIGH,'X') = NVL(BA2.SEGMENT11_HIGH,'X')
AND NVL(BA1.SEGMENT12_LOW,'X') = NVL(BA2.SEGMENT12_LOW,'X')
AND NVL(BA1.SEGMENT12_HIGH,'X') = NVL(BA2.SEGMENT12_HIGH,'X')
AND NVL(BA1.SEGMENT13_LOW,'X') = NVL(BA2.SEGMENT13_LOW,'X')
AND NVL(BA1.SEGMENT13_HIGH,'X') = NVL(BA2.SEGMENT13_HIGH,'X')
AND NVL(BA1.SEGMENT14_LOW,'X') = NVL(BA2.SEGMENT14_LOW,'X')
AND NVL(BA1.SEGMENT14_HIGH,'X') = NVL(BA2.SEGMENT14_HIGH,'X')
AND NVL(BA1.SEGMENT15_LOW,'X') = NVL(BA2.SEGMENT15_LOW,'X')
AND NVL(BA1.SEGMENT15_HIGH,'X') = NVL(BA2.SEGMENT15_HIGH,'X')
AND NVL(BA1.SEGMENT16_LOW,'X') = NVL(BA2.SEGMENT16_LOW,'X')
AND NVL(BA1.SEGMENT16_HIGH,'X') = NVL(BA2.SEGMENT16_HIGH,'X')
AND NVL(BA1.SEGMENT17_LOW,'X') = NVL(BA2.SEGMENT17_LOW,'X')
AND NVL(BA1.SEGMENT17_HIGH,'X') = NVL(BA2.SEGMENT17_HIGH,'X')
AND NVL(BA1.SEGMENT18_LOW,'X') = NVL(BA2.SEGMENT18_LOW,'X')
AND NVL(BA1.SEGMENT18_HIGH,'X') = NVL(BA2.SEGMENT18_HIGH,'X')
AND NVL(BA1.SEGMENT19_LOW,'X') = NVL(BA2.SEGMENT19_LOW,'X')
AND NVL(BA1.SEGMENT19_HIGH,'X') = NVL(BA2.SEGMENT19_HIGH,'X')
AND NVL(BA1.SEGMENT20_LOW,'X') = NVL(BA2.SEGMENT20_LOW,'X')
AND NVL(BA1.SEGMENT20_HIGH,'X') = NVL(BA2.SEGMENT20_HIGH,'X')
AND NVL(BA1.SEGMENT21_LOW,'X') = NVL(BA2.SEGMENT21_LOW,'X')
AND NVL(BA1.SEGMENT21_HIGH,'X') = NVL(BA2.SEGMENT21_HIGH,'X')
AND NVL(BA1.SEGMENT22_LOW,'X') = NVL(BA2.SEGMENT22_LOW,'X')
AND NVL(BA1.SEGMENT22_HIGH,'X') = NVL(BA2.SEGMENT22_HIGH,'X')
AND NVL(BA1.SEGMENT23_LOW,'X') = NVL(BA2.SEGMENT23_LOW,'X')
AND NVL(BA1.SEGMENT23_HIGH,'X') = NVL(BA2.SEGMENT23_HIGH,'X')
AND NVL(BA1.SEGMENT24_LOW,'X') = NVL(BA2.SEGMENT24_LOW,'X')
AND NVL(BA1.SEGMENT24_HIGH,'X') = NVL(BA2.SEGMENT24_HIGH,'X')
AND NVL(BA1.SEGMENT25_LOW,'X') = NVL(BA2.SEGMENT25_LOW,'X')
AND NVL(BA1.SEGMENT25_HIGH,'X') = NVL(BA2.SEGMENT25_HIGH,'X')
AND NVL(BA1.SEGMENT26_LOW,'X') = NVL(BA2.SEGMENT26_LOW,'X')
AND NVL(BA1.SEGMENT26_HIGH,'X') = NVL(BA2.SEGMENT26_HIGH,'X')
AND NVL(BA1.SEGMENT27_LOW,'X') = NVL(BA2.SEGMENT27_LOW,'X')
AND NVL(BA1.SEGMENT27_HIGH,'X') = NVL(BA2.SEGMENT27_HIGH,'X')
AND NVL(BA1.SEGMENT28_LOW,'X') = NVL(BA2.SEGMENT28_LOW,'X')
AND NVL(BA1.SEGMENT28_HIGH,'X') = NVL(BA2.SEGMENT28_HIGH,'X')
AND NVL(BA1.SEGMENT29_LOW,'X') = NVL(BA2.SEGMENT29_LOW,'X')
AND NVL(BA1.SEGMENT29_HIGH,'X') = NVL(BA2.SEGMENT29_HIGH,'X')
AND NVL(BA1.SEGMENT30_LOW,'X') = NVL(BA2.SEGMENT30_LOW,'X')
AND NVL(BA1.SEGMENT30_HIGH,'X') = NVL(BA2.SEGMENT30_HIGH,'X')
);
SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
WHERE EXISTS
(SELECT 1 FROM
IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
WHERE
BA2.range_id = p_range_id
AND BA2.ledger_id = BA1.ledger_id
AND BA2.currency_code = BA1.currency_code
AND BA1.RANGE_ID <> BA2.RANGE_ID
AND NVL(BA1.SEGMENT1_LOW,'X') <= NVL(BA2.SEGMENT1_HIGH,'X')
AND NVL(BA1.SEGMENT1_HIGH,'X') >= NVL(BA2.SEGMENT1_LOW,'X')
AND NVL(BA1.SEGMENT2_LOW,'X') <= NVL(BA2.SEGMENT2_HIGH,'X')
AND NVL(BA1.SEGMENT2_HIGH,'X') >= NVL(BA2.SEGMENT2_LOW,'X')
AND NVL(BA1.SEGMENT3_LOW,'X') <= NVL(BA2.SEGMENT3_HIGH,'X')
AND NVL(BA1.SEGMENT3_HIGH,'X') >= NVL(BA2.SEGMENT3_LOW,'X')
AND NVL(BA1.SEGMENT4_LOW,'X') <= NVL(BA2.SEGMENT4_HIGH,'X')
AND NVL(BA1.SEGMENT4_HIGH,'X') >= NVL(BA2.SEGMENT4_LOW,'X')
AND NVL(BA1.SEGMENT5_LOW,'X') <= NVL(BA2.SEGMENT5_HIGH,'X')
AND NVL(BA1.SEGMENT5_HIGH,'X') >= NVL(BA2.SEGMENT5_LOW,'X')
AND NVL(BA1.SEGMENT6_LOW,'X') <= NVL(BA2.SEGMENT6_HIGH,'X')
AND NVL(BA1.SEGMENT6_HIGH,'X') >= NVL(BA2.SEGMENT6_LOW,'X')
AND NVL(BA1.SEGMENT7_LOW,'X') <= NVL(BA2.SEGMENT7_HIGH,'X')
AND NVL(BA1.SEGMENT7_HIGH,'X') >= NVL(BA2.SEGMENT7_LOW,'X')
AND NVL(BA1.SEGMENT8_LOW,'X') <= NVL(BA2.SEGMENT8_HIGH,'X')
AND NVL(BA1.SEGMENT8_HIGH,'X') >= NVL(BA2.SEGMENT8_LOW,'X')
AND NVL(BA1.SEGMENT9_LOW,'X') <= NVL(BA2.SEGMENT9_HIGH,'X')
AND NVL(BA1.SEGMENT9_HIGH,'X') >= NVL(BA2.SEGMENT9_LOW,'X')
AND NVL(BA1.SEGMENT10_LOW,'X') <= NVL(BA2.SEGMENT10_HIGH,'X')
AND NVL(BA1.SEGMENT10_HIGH,'X') >= NVL(BA2.SEGMENT10_LOW,'X')
AND NVL(BA1.SEGMENT11_LOW,'X') <= NVL(BA2.SEGMENT11_HIGH,'X')
AND NVL(BA1.SEGMENT11_HIGH,'X') >= NVL(BA2.SEGMENT11_LOW,'X')
AND NVL(BA1.SEGMENT12_LOW,'X') <= NVL(BA2.SEGMENT12_HIGH,'X')
AND NVL(BA1.SEGMENT12_HIGH,'X') >= NVL(BA2.SEGMENT12_LOW,'X')
AND NVL(BA1.SEGMENT13_LOW,'X') <= NVL(BA2.SEGMENT13_HIGH,'X')
AND NVL(BA1.SEGMENT13_HIGH,'X') >= NVL(BA2.SEGMENT13_LOW,'X')
AND NVL(BA1.SEGMENT14_LOW,'X') <= NVL(BA2.SEGMENT14_HIGH,'X')
AND NVL(BA1.SEGMENT14_HIGH,'X') >= NVL(BA2.SEGMENT14_LOW,'X')
AND NVL(BA1.SEGMENT15_LOW,'X') <= NVL(BA2.SEGMENT15_HIGH,'X')
AND NVL(BA1.SEGMENT15_HIGH,'X') >= NVL(BA2.SEGMENT15_LOW,'X')
AND NVL(BA1.SEGMENT16_LOW,'X') <= NVL(BA2.SEGMENT16_HIGH,'X')
AND NVL(BA1.SEGMENT16_HIGH,'X') >= NVL(BA2.SEGMENT16_LOW,'X')
AND NVL(BA1.SEGMENT17_LOW,'X') <= NVL(BA2.SEGMENT17_HIGH,'X')
AND NVL(BA1.SEGMENT17_HIGH,'X') >= NVL(BA2.SEGMENT17_LOW,'X')
AND NVL(BA1.SEGMENT18_LOW,'X') <= NVL(BA2.SEGMENT18_HIGH,'X')
AND NVL(BA1.SEGMENT18_HIGH,'X') >= NVL(BA2.SEGMENT18_LOW,'X')
AND NVL(BA1.SEGMENT19_LOW,'X') <= NVL(BA2.SEGMENT19_HIGH,'X')
AND NVL(BA1.SEGMENT19_HIGH,'X') >= NVL(BA2.SEGMENT19_LOW,'X')
AND NVL(BA1.SEGMENT20_LOW,'X') <= NVL(BA2.SEGMENT20_HIGH,'X')
AND NVL(BA1.SEGMENT20_HIGH,'X') >= NVL(BA2.SEGMENT20_LOW,'X')
AND NVL(BA1.SEGMENT21_LOW,'X') <= NVL(BA2.SEGMENT21_HIGH,'X')
AND NVL(BA1.SEGMENT21_HIGH,'X') >= NVL(BA2.SEGMENT21_LOW,'X')
AND NVL(BA1.SEGMENT22_LOW,'X') <= NVL(BA2.SEGMENT22_HIGH,'X')
AND NVL(BA1.SEGMENT22_HIGH,'X') >= NVL(BA2.SEGMENT22_LOW,'X')
AND NVL(BA1.SEGMENT23_LOW,'X') <= NVL(BA2.SEGMENT23_HIGH,'X')
AND NVL(BA1.SEGMENT23_HIGH,'X') >= NVL(BA2.SEGMENT23_LOW,'X')
AND NVL(BA1.SEGMENT24_LOW,'X') <= NVL(BA2.SEGMENT24_HIGH,'X')
AND NVL(BA1.SEGMENT24_HIGH,'X') >= NVL(BA2.SEGMENT24_LOW,'X')
AND NVL(BA1.SEGMENT25_LOW,'X') <= NVL(BA2.SEGMENT25_HIGH,'X')
AND NVL(BA1.SEGMENT25_HIGH,'X') >= NVL(BA2.SEGMENT25_LOW,'X')
AND NVL(BA1.SEGMENT26_LOW,'X') <= NVL(BA2.SEGMENT26_HIGH,'X')
AND NVL(BA1.SEGMENT26_HIGH,'X') >= NVL(BA2.SEGMENT26_LOW,'X')
AND NVL(BA1.SEGMENT27_LOW,'X') <= NVL(BA2.SEGMENT27_HIGH,'X')
AND NVL(BA1.SEGMENT27_HIGH,'X') >= NVL(BA2.SEGMENT27_LOW,'X')
AND NVL(BA1.SEGMENT28_LOW,'X') <= NVL(BA2.SEGMENT28_HIGH,'X')
AND NVL(BA1.SEGMENT28_HIGH,'X') >= NVL(BA2.SEGMENT28_LOW,'X')
AND NVL(BA1.SEGMENT29_LOW,'X') <= NVL(BA2.SEGMENT29_HIGH,'X')
AND NVL(BA1.SEGMENT29_HIGH,'X') >= NVL(BA2.SEGMENT29_LOW,'X')
AND NVL(BA1.SEGMENT30_LOW,'X') <= NVL(BA2.SEGMENT30_HIGH,'X')
AND NVL(BA1.SEGMENT30_HIGH,'X') >= NVL(BA2.SEGMENT30_LOW,'X')
);
SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1;
SELECT * FROM IGI_UPG_GL_BUDORG_BC_OPTIONS
WHERE RANGE_ID = p_range_id;
l_inserted BOOLEAN;
SELECT gl_budget_assignment_ranges_s.NEXTVAL
INTO l_range_id_seq
FROM dual;
SELECT gl_budget_assignment_ranges_s.NEXTVAL
INTO l_actual_range_id
FROM dual;
INSERT INTO IGI_EFC_UPG_BACKUP_INFO (range_id) VALUES (l_actual_range_id);
INSERT INTO GL_BUDGET_ASSIGNMENT_RANGES
(
BUDGET_ENTITY_ID,
LEDGER_ID,
CURRENCY_CODE,
ENTRY_CODE,
RANGE_ID,
STATUS,
LAST_UPDATE_DATE,
AUTOMATIC_ENCUMBRANCE_FLAG,
CREATED_BY,
CREATION_DATE,
FUNDS_CHECK_LEVEL_CODE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
SEQUENCE_NUMBER,
SEGMENT1_LOW,
SEGMENT1_HIGH,
SEGMENT2_LOW,
SEGMENT2_HIGH,
SEGMENT3_LOW,
SEGMENT3_HIGH,
SEGMENT4_LOW,
SEGMENT4_HIGH,
SEGMENT5_LOW,
SEGMENT5_HIGH,
SEGMENT6_LOW,
SEGMENT6_HIGH,
SEGMENT7_LOW,
SEGMENT7_HIGH,
SEGMENT8_LOW,
SEGMENT8_HIGH,
SEGMENT9_LOW,
SEGMENT9_HIGH,
SEGMENT10_LOW,
SEGMENT10_HIGH,
SEGMENT11_LOW,
SEGMENT11_HIGH,
SEGMENT12_LOW,
SEGMENT12_HIGH,
SEGMENT13_LOW,
SEGMENT13_HIGH,
SEGMENT14_LOW,
SEGMENT14_HIGH,
SEGMENT15_LOW,
SEGMENT15_HIGH,
SEGMENT16_LOW,
SEGMENT16_HIGH,
SEGMENT17_LOW,
SEGMENT17_HIGH,
SEGMENT18_LOW,
SEGMENT18_HIGH,
SEGMENT19_LOW,
SEGMENT19_HIGH,
SEGMENT20_LOW,
SEGMENT20_HIGH,
SEGMENT21_LOW,
SEGMENT21_HIGH,
SEGMENT22_LOW,
SEGMENT22_HIGH,
SEGMENT23_LOW,
SEGMENT23_HIGH,
SEGMENT24_LOW,
SEGMENT24_HIGH,
SEGMENT25_LOW,
SEGMENT25_HIGH,
SEGMENT26_LOW,
SEGMENT26_HIGH,
SEGMENT27_LOW,
SEGMENT27_HIGH,
SEGMENT28_LOW,
SEGMENT28_HIGH,
SEGMENT29_LOW,
SEGMENT29_HIGH,
SEGMENT30_LOW,
SEGMENT30_HIGH,
AMOUNT_TYPE,
BOUNDARY_CODE,
CONTEXT,
FUNDING_BUDGET_VERSION_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
)
VALUES (
lc_non_overlapping_ranges(i).budget_entity_id,
lc_non_overlapping_ranges(i).ledger_id,
lc_non_overlapping_ranges(i).currency_code,
lc_non_overlapping_ranges(i).entry_code,
l_actual_range_id,
'A',
sysdate,
lc_non_overlapping_ranges(i).automatic_encumbrance_flag,
lc_non_overlapping_ranges(i).created_by,
lc_non_overlapping_ranges(i).creation_date,
lc_non_overlapping_ranges(i).funds_check_level_code,
lc_non_overlapping_ranges(i).last_updated_by,
lc_non_overlapping_ranges(i).last_update_login,
lc_non_overlapping_ranges(i).sequence_number,
lc_non_overlapping_ranges(i).SEGMENT1_LOW,
lc_non_overlapping_ranges(i).SEGMENT1_HIGH,
lc_non_overlapping_ranges(i).SEGMENT2_LOW,
lc_non_overlapping_ranges(i).SEGMENT2_HIGH,
lc_non_overlapping_ranges(i).SEGMENT3_LOW,
lc_non_overlapping_ranges(i).SEGMENT3_HIGH,
lc_non_overlapping_ranges(i).SEGMENT4_LOW,
lc_non_overlapping_ranges(i).SEGMENT4_HIGH,
lc_non_overlapping_ranges(i).SEGMENT5_LOW,
lc_non_overlapping_ranges(i).SEGMENT5_HIGH,
lc_non_overlapping_ranges(i).SEGMENT6_LOW,
lc_non_overlapping_ranges(i).SEGMENT6_HIGH,
lc_non_overlapping_ranges(i).SEGMENT7_LOW,
lc_non_overlapping_ranges(i).SEGMENT7_HIGH,
lc_non_overlapping_ranges(i).SEGMENT8_LOW,
lc_non_overlapping_ranges(i).SEGMENT8_HIGH,
lc_non_overlapping_ranges(i).SEGMENT9_LOW,
lc_non_overlapping_ranges(i).SEGMENT9_HIGH,
lc_non_overlapping_ranges(i).SEGMENT10_LOW,
lc_non_overlapping_ranges(i).SEGMENT10_HIGH,
lc_non_overlapping_ranges(i).SEGMENT11_LOW,
lc_non_overlapping_ranges(i).SEGMENT11_HIGH,
lc_non_overlapping_ranges(i).SEGMENT12_LOW,
lc_non_overlapping_ranges(i).SEGMENT12_HIGH,
lc_non_overlapping_ranges(i).SEGMENT13_LOW,
lc_non_overlapping_ranges(i).SEGMENT13_HIGH,
lc_non_overlapping_ranges(i).SEGMENT14_LOW,
lc_non_overlapping_ranges(i).SEGMENT14_HIGH,
lc_non_overlapping_ranges(i).SEGMENT15_LOW,
lc_non_overlapping_ranges(i).SEGMENT15_HIGH,
lc_non_overlapping_ranges(i).SEGMENT16_LOW,
lc_non_overlapping_ranges(i).SEGMENT16_HIGH,
lc_non_overlapping_ranges(i).SEGMENT17_LOW,
lc_non_overlapping_ranges(i).SEGMENT17_HIGH,
lc_non_overlapping_ranges(i).SEGMENT18_LOW,
lc_non_overlapping_ranges(i).SEGMENT18_HIGH,
lc_non_overlapping_ranges(i).SEGMENT19_LOW,
lc_non_overlapping_ranges(i).SEGMENT19_HIGH,
lc_non_overlapping_ranges(i).SEGMENT20_LOW,
lc_non_overlapping_ranges(i).SEGMENT20_HIGH,
lc_non_overlapping_ranges(i).SEGMENT21_LOW,
lc_non_overlapping_ranges(i).SEGMENT21_HIGH,
lc_non_overlapping_ranges(i).SEGMENT22_LOW,
lc_non_overlapping_ranges(i).SEGMENT22_HIGH,
lc_non_overlapping_ranges(i).SEGMENT23_LOW,
lc_non_overlapping_ranges(i).SEGMENT23_HIGH,
lc_non_overlapping_ranges(i).SEGMENT24_LOW,
lc_non_overlapping_ranges(i).SEGMENT24_HIGH,
lc_non_overlapping_ranges(i).SEGMENT25_LOW,
lc_non_overlapping_ranges(i).SEGMENT25_HIGH,
lc_non_overlapping_ranges(i).SEGMENT26_LOW,
lc_non_overlapping_ranges(i).SEGMENT26_HIGH,
lc_non_overlapping_ranges(i).SEGMENT27_LOW,
lc_non_overlapping_ranges(i).SEGMENT27_HIGH,
lc_non_overlapping_ranges(i).SEGMENT28_LOW,
lc_non_overlapping_ranges(i).SEGMENT28_HIGH,
lc_non_overlapping_ranges(i).SEGMENT29_LOW,
lc_non_overlapping_ranges(i).SEGMENT29_HIGH,
lc_non_overlapping_ranges(i).SEGMENT30_LOW,
lc_non_overlapping_ranges(i).SEGMENT30_HIGH,
lc_non_overlapping_ranges(i).amount_type,
lc_non_overlapping_ranges(i).boundary_code,
lc_non_overlapping_ranges(i).context,
lc_non_overlapping_ranges(i).funding_budget_version_id,
lc_non_overlapping_ranges(i).program_application_id,
lc_non_overlapping_ranges(i).program_id,
lc_non_overlapping_ranges(i).program_update_date,
lc_non_overlapping_ranges(i).request_id,
lc_non_overlapping_ranges(i).attribute1,
lc_non_overlapping_ranges(i).attribute2,
lc_non_overlapping_ranges(i).attribute3,
lc_non_overlapping_ranges(i).attribute4,
lc_non_overlapping_ranges(i).attribute5,
lc_non_overlapping_ranges(i).attribute6,
lc_non_overlapping_ranges(i).attribute7,
lc_non_overlapping_ranges(i).attribute8,
lc_non_overlapping_ranges(i).attribute9,
lc_non_overlapping_ranges(i).attribute10,
lc_non_overlapping_ranges(i).attribute11,
lc_non_overlapping_ranges(i).attribute12,
lc_non_overlapping_ranges(i).attribute13,
lc_non_overlapping_ranges(i).attribute14,
lc_non_overlapping_ranges(i).attribute15
);
INSERT INTO GL_BUDORG_BC_OPTIONS
(
RANGE_ID,
FUNDING_BUDGET_VERSION_ID,
FUNDS_CHECK_LEVEL_CODE,
AMOUNT_TYPE,
BOUNDARY_CODE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE
)
SELECT
l_actual_range_id,
FUNDING_BUDGET_VERSION_ID,
FUNDS_CHECK_LEVEL_CODE,
AMOUNT_TYPE,
BOUNDARY_CODE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE
FROM IGI_UPG_GL_BUDORG_BC_OPTIONS
WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
INSERT_ENTITY(lc_non_overlapping_ranges(i).ledger_id,
lc_non_overlapping_ranges(i).budget_entity_id,
l_errbuf,
l_retcode);
DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
UPDATE IGI_UPG_GL_BUDORG_BC_OPTIONS
SET RANGE_ID = lc_exact_merge_range1.range_id
WHERE RANGE_ID = lc_exact_merge_range2.range_id;
DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_exact_merge_range2.range_id;
SELECT max(sequence_number)+1
INTO l_seq_number1
FROM IGI_UPG_GL_BUDGET_ASSIGNMENT
WHERE
budget_entity_id = lc_merge_range2.budget_entity_id;
SELECT max(sequence_number)+1
INTO l_seq_number2
FROM GL_BUDGET_ASSIGNMENT_RANGES
WHERE
budget_entity_id = lc_merge_range2.budget_entity_id;
INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT
(
BUDGET_ENTITY_ID,
LEDGER_ID,
CURRENCY_CODE,
ENTRY_CODE,
RANGE_ID,
STATUS,
LAST_UPDATE_DATE,
AUTOMATIC_ENCUMBRANCE_FLAG,
CREATED_BY,
CREATION_DATE,
FUNDS_CHECK_LEVEL_CODE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
SEQUENCE_NUMBER,
SEGMENT1_LOW,
SEGMENT1_HIGH,
SEGMENT2_LOW,
SEGMENT2_HIGH,
SEGMENT3_LOW,
SEGMENT3_HIGH,
SEGMENT4_LOW,
SEGMENT4_HIGH,
SEGMENT5_LOW,
SEGMENT5_HIGH,
SEGMENT6_LOW,
SEGMENT6_HIGH,
SEGMENT7_LOW,
SEGMENT7_HIGH,
SEGMENT8_LOW,
SEGMENT8_HIGH,
SEGMENT9_LOW,
SEGMENT9_HIGH,
SEGMENT10_LOW,
SEGMENT10_HIGH,
SEGMENT11_LOW,
SEGMENT11_HIGH,
SEGMENT12_LOW,
SEGMENT12_HIGH,
SEGMENT13_LOW,
SEGMENT13_HIGH,
SEGMENT14_LOW,
SEGMENT14_HIGH,
SEGMENT15_LOW,
SEGMENT15_HIGH,
SEGMENT16_LOW,
SEGMENT16_HIGH,
SEGMENT17_LOW,
SEGMENT17_HIGH,
SEGMENT18_LOW,
SEGMENT18_HIGH,
SEGMENT19_LOW,
SEGMENT19_HIGH,
SEGMENT20_LOW,
SEGMENT20_HIGH,
SEGMENT21_LOW,
SEGMENT21_HIGH,
SEGMENT22_LOW,
SEGMENT22_HIGH,
SEGMENT23_LOW,
SEGMENT23_HIGH,
SEGMENT24_LOW,
SEGMENT24_HIGH,
SEGMENT25_LOW,
SEGMENT25_HIGH,
SEGMENT26_LOW,
SEGMENT26_HIGH,
SEGMENT27_LOW,
SEGMENT27_HIGH,
SEGMENT28_LOW,
SEGMENT28_HIGH,
SEGMENT29_LOW,
SEGMENT29_HIGH,
SEGMENT30_LOW,
SEGMENT30_HIGH,
AMOUNT_TYPE,
BOUNDARY_CODE,
CONTEXT,
FUNDING_BUDGET_VERSION_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
)
VALUES (
lc_merge_range2.budget_entity_id,
lc_merge_range2.ledger_id,
lc_merge_range2.currency_code,
lc_merge_range2.entry_code,
l_range_id_seq,
lc_merge_range2.status,
sysdate,
lc_merge_range2.automatic_encumbrance_flag,
lc_merge_range2.created_by,
lc_merge_range2.creation_date,
lc_merge_range2.funds_check_level_code,
lc_merge_range2.last_updated_by,
lc_merge_range2.last_update_login,
l_seq_number,
l_final_budget_ranges(i).segment_range_tab(1).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(1).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(2).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(2).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(3).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(3).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(4).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(4).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(5).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(5).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(6).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(6).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(7).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(7).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(8).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(8).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(9).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(9).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(10).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(10).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(11).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(11).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(12).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(12).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(13).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(13).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(14).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(14).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(15).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(15).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(16).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(16).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(17).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(17).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(18).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(18).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(19).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(19).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(20).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(20).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(21).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(21).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(22).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(22).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(23).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(23).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(24).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(24).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(25).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(25).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(26).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(26).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(27).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(27).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(28).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(28).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(29).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(29).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(30).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(30).SEGMENT_HIGH,
lc_merge_range2.amount_type,
lc_merge_range2.boundary_code,
lc_merge_range2.context,
lc_merge_range2.funding_budget_version_id,
lc_merge_range2.program_application_id,
lc_merge_range2.program_id,
lc_merge_range2.program_update_date,
lc_merge_range2.request_id,
lc_merge_range2.attribute1,
lc_merge_range2.attribute2,
lc_merge_range2.attribute3,
lc_merge_range2.attribute4,
lc_merge_range2.attribute5,
lc_merge_range2.attribute6,
lc_merge_range2.attribute7,
lc_merge_range2.attribute8,
lc_merge_range2.attribute9,
lc_merge_range2.attribute10,
lc_merge_range2.attribute11,
lc_merge_range2.attribute12,
lc_merge_range2.attribute13,
lc_merge_range2.attribute14,
lc_merge_range2.attribute15
);
fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1');
||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM);
errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM;
l_inserted := FALSE;
INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS
(
RANGE_ID,
FUNDING_BUDGET_VERSION_ID,
FUNDS_CHECK_LEVEL_CODE,
AMOUNT_TYPE,
BOUNDARY_CODE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE
)
VALUES
(
l_range_id_seq,
lc_merge_range2_bc(k).funding_budget_version_id,
lc_merge_range2_bc(k).funds_check_level_code,
lc_merge_range2_bc(k).amount_type,
lc_merge_range2_bc(k).boundary_code,
lc_merge_range2_bc(k).created_by,
lc_merge_range2_bc(k).creation_date,
lc_merge_range2_bc(k).last_updated_by,
lc_merge_range2_bc(k).last_update_login,
sysdate
);
fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1');
||'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM);
errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM;
l_inserted := TRUE;
IF NOT l_inserted THEN
fnd_file.put_line(fnd_file.output, 'Insertion failed - Reason not explicit in merge 1');
fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit in merge 1');
errbuf := 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit in merge 1';
SELECT max(sequence_number)+1
INTO l_seq_number1
FROM IGI_UPG_GL_BUDGET_ASSIGNMENT
WHERE
budget_entity_id = lc_merge_range1.budget_entity_id;
SELECT max(sequence_number)+1
INTO l_seq_number2
FROM GL_BUDGET_ASSIGNMENT_RANGES
WHERE
budget_entity_id = lc_merge_range1.budget_entity_id;
INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT
(
BUDGET_ENTITY_ID,
LEDGER_ID,
CURRENCY_CODE,
ENTRY_CODE,
RANGE_ID,
STATUS,
LAST_UPDATE_DATE,
AUTOMATIC_ENCUMBRANCE_FLAG,
CREATED_BY,
CREATION_DATE,
FUNDS_CHECK_LEVEL_CODE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
SEQUENCE_NUMBER,
SEGMENT1_LOW,
SEGMENT1_HIGH,
SEGMENT2_LOW,
SEGMENT2_HIGH,
SEGMENT3_LOW,
SEGMENT3_HIGH,
SEGMENT4_LOW,
SEGMENT4_HIGH,
SEGMENT5_LOW,
SEGMENT5_HIGH,
SEGMENT6_LOW,
SEGMENT6_HIGH,
SEGMENT7_LOW,
SEGMENT7_HIGH,
SEGMENT8_LOW,
SEGMENT8_HIGH,
SEGMENT9_LOW,
SEGMENT9_HIGH,
SEGMENT10_LOW,
SEGMENT10_HIGH,
SEGMENT11_LOW,
SEGMENT11_HIGH,
SEGMENT12_LOW,
SEGMENT12_HIGH,
SEGMENT13_LOW,
SEGMENT13_HIGH,
SEGMENT14_LOW,
SEGMENT14_HIGH,
SEGMENT15_LOW,
SEGMENT15_HIGH,
SEGMENT16_LOW,
SEGMENT16_HIGH,
SEGMENT17_LOW,
SEGMENT17_HIGH,
SEGMENT18_LOW,
SEGMENT18_HIGH,
SEGMENT19_LOW,
SEGMENT19_HIGH,
SEGMENT20_LOW,
SEGMENT20_HIGH,
SEGMENT21_LOW,
SEGMENT21_HIGH,
SEGMENT22_LOW,
SEGMENT22_HIGH,
SEGMENT23_LOW,
SEGMENT23_HIGH,
SEGMENT24_LOW,
SEGMENT24_HIGH,
SEGMENT25_LOW,
SEGMENT25_HIGH,
SEGMENT26_LOW,
SEGMENT26_HIGH,
SEGMENT27_LOW,
SEGMENT27_HIGH,
SEGMENT28_LOW,
SEGMENT28_HIGH,
SEGMENT29_LOW,
SEGMENT29_HIGH,
SEGMENT30_LOW,
SEGMENT30_HIGH,
AMOUNT_TYPE,
BOUNDARY_CODE,
CONTEXT,
FUNDING_BUDGET_VERSION_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
)
VALUES (
lc_merge_range1.budget_entity_id,
lc_merge_range1.ledger_id,
lc_merge_range1.currency_code,
lc_merge_range1.entry_code,
l_range_id_seq,
lc_merge_range1.status,
sysdate,
lc_merge_range1.automatic_encumbrance_flag,
lc_merge_range1.created_by,
lc_merge_range1.creation_date,
lc_merge_range1.funds_check_level_code,
lc_merge_range1.last_updated_by,
lc_merge_range1.last_update_login,
l_seq_number,
l_final_budget_ranges(i).segment_range_tab(1).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(1).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(2).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(2).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(3).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(3).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(4).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(4).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(5).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(5).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(6).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(6).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(7).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(7).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(8).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(8).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(9).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(9).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(10).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(10).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(11).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(11).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(12).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(12).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(13).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(13).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(14).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(14).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(15).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(15).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(16).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(16).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(17).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(17).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(18).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(18).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(19).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(19).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(20).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(20).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(21).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(21).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(22).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(22).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(23).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(23).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(24).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(24).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(25).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(25).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(26).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(26).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(27).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(27).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(28).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(28).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(29).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(29).SEGMENT_HIGH,
l_final_budget_ranges(i).segment_range_tab(30).SEGMENT_LOW,
l_final_budget_ranges(i).segment_range_tab(30).SEGMENT_HIGH,
lc_merge_range1.amount_type,
lc_merge_range1.boundary_code,
lc_merge_range1.context,
lc_merge_range1.funding_budget_version_id,
lc_merge_range1.program_application_id,
lc_merge_range1.program_id,
lc_merge_range1.program_update_date,
lc_merge_range1.request_id,
lc_merge_range1.attribute1,
lc_merge_range1.attribute2,
lc_merge_range1.attribute3,
lc_merge_range1.attribute4,
lc_merge_range1.attribute5,
lc_merge_range1.attribute6,
lc_merge_range1.attribute7,
lc_merge_range1.attribute8,
lc_merge_range1.attribute9,
lc_merge_range1.attribute10,
lc_merge_range1.attribute11,
lc_merge_range1.attribute12,
lc_merge_range1.attribute13,
lc_merge_range1.attribute14,
lc_merge_range1.attribute15
);
fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2');
||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM);
errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM;
l_inserted := FALSE;
INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS
(
RANGE_ID,
FUNDING_BUDGET_VERSION_ID,
FUNDS_CHECK_LEVEL_CODE,
AMOUNT_TYPE,
BOUNDARY_CODE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE
)
VALUES
(
l_range_id_seq,
lc_merge_range1_bc(k).funding_budget_version_id,
lc_merge_range1_bc(k).funds_check_level_code,
lc_merge_range1_bc(k).amount_type,
lc_merge_range1_bc(k).boundary_code,
lc_merge_range1_bc(k).created_by,
lc_merge_range1_bc(k).creation_date,
lc_merge_range1_bc(k).last_updated_by,
lc_merge_range1_bc(k).last_update_login,
sysdate
);
fnd_file.put_line(fnd_file.output, 'Error inserting records into
IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2');
fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM);
errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM;
l_inserted := TRUE;
IF NOT l_inserted THEN
FOR r IN 1..lc_merge_range2_bc.COUNT LOOP
IF l_final_budget_ranges(i).budget_tab(j) = lc_merge_range2_bc(r).funding_budget_version_id
THEN
BEGIN
INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS
(
RANGE_ID,
FUNDING_BUDGET_VERSION_ID,
FUNDS_CHECK_LEVEL_CODE,
AMOUNT_TYPE,
BOUNDARY_CODE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE
)
VALUES
(
l_range_id_seq,
lc_merge_range2_bc(r).funding_budget_version_id,
lc_merge_range2_bc(r).funds_check_level_code,
lc_merge_range2_bc(r).amount_type,
lc_merge_range2_bc(r).boundary_code,
lc_merge_range2_bc(r).created_by,
lc_merge_range2_bc(r).creation_date,
lc_merge_range2_bc(r).last_updated_by,
lc_merge_range2_bc(r).last_update_login,
sysdate
);
fnd_file.put_line(fnd_file.output, 'Error inserting records into
IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4');
fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4 '||SQLERRM);
errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4 '||SQLERRM;
l_inserted := TRUE;
IF NOT l_inserted THEN
fnd_file.put_line(fnd_file.output, 'Insertion failed - Reason not explicit');
fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit');
errbuf := 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit';
DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE
range_id = lc_merge_range2.range_id OR
range_id = lc_merge_range1.range_id;
DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE
range_id = lc_merge_range2.range_id OR
range_id = lc_merge_range1.range_id;
SELECT 1 FROM DUAL WHERE EXISTS
(
SELECT 1 FROM GL_BUDGET_ASSIGNMENT_RANGES BA1
WHERE EXISTS
(SELECT 1 FROM
GL_BUDGET_ASSIGNMENT_RANGES BA2
WHERE
BA2.ledger_id = BA1.ledger_id
AND BA2.currency_code = BA1.currency_code
AND BA1.RANGE_ID <> BA2.RANGE_ID
AND NVL(BA1.SEGMENT1_LOW,'X') <= NVL(BA2.SEGMENT1_HIGH,'X')
AND NVL(BA1.SEGMENT1_HIGH,'X') >= NVL(BA2.SEGMENT1_LOW,'X')
AND NVL(BA1.SEGMENT2_LOW,'X') <= NVL(BA2.SEGMENT2_HIGH,'X')
AND NVL(BA1.SEGMENT2_HIGH,'X') >= NVL(BA2.SEGMENT2_LOW,'X')
AND NVL(BA1.SEGMENT3_LOW,'X') <= NVL(BA2.SEGMENT3_HIGH,'X')
AND NVL(BA1.SEGMENT3_HIGH,'X') >= NVL(BA2.SEGMENT3_LOW,'X')
AND NVL(BA1.SEGMENT4_LOW,'X') <= NVL(BA2.SEGMENT4_HIGH,'X')
AND NVL(BA1.SEGMENT4_HIGH,'X') >= NVL(BA2.SEGMENT4_LOW,'X')
AND NVL(BA1.SEGMENT5_LOW,'X') <= NVL(BA2.SEGMENT5_HIGH,'X')
AND NVL(BA1.SEGMENT5_HIGH,'X') >= NVL(BA2.SEGMENT5_LOW,'X')
AND NVL(BA1.SEGMENT6_LOW,'X') <= NVL(BA2.SEGMENT6_HIGH,'X')
AND NVL(BA1.SEGMENT6_HIGH,'X') >= NVL(BA2.SEGMENT6_LOW,'X')
AND NVL(BA1.SEGMENT7_LOW,'X') <= NVL(BA2.SEGMENT7_HIGH,'X')
AND NVL(BA1.SEGMENT7_HIGH,'X') >= NVL(BA2.SEGMENT7_LOW,'X')
AND NVL(BA1.SEGMENT8_LOW,'X') <= NVL(BA2.SEGMENT8_HIGH,'X')
AND NVL(BA1.SEGMENT8_HIGH,'X') >= NVL(BA2.SEGMENT8_LOW,'X')
AND NVL(BA1.SEGMENT9_LOW,'X') <= NVL(BA2.SEGMENT9_HIGH,'X')
AND NVL(BA1.SEGMENT9_HIGH,'X') >= NVL(BA2.SEGMENT9_LOW,'X')
AND NVL(BA1.SEGMENT10_LOW,'X') <= NVL(BA2.SEGMENT10_HIGH,'X')
AND NVL(BA1.SEGMENT10_HIGH,'X') >= NVL(BA2.SEGMENT10_LOW,'X')
AND NVL(BA1.SEGMENT11_LOW,'X') <= NVL(BA2.SEGMENT11_HIGH,'X')
AND NVL(BA1.SEGMENT11_HIGH,'X') >= NVL(BA2.SEGMENT11_LOW,'X')
AND NVL(BA1.SEGMENT12_LOW,'X') <= NVL(BA2.SEGMENT12_HIGH,'X')
AND NVL(BA1.SEGMENT12_HIGH,'X') >= NVL(BA2.SEGMENT12_LOW,'X')
AND NVL(BA1.SEGMENT13_LOW,'X') <= NVL(BA2.SEGMENT13_HIGH,'X')
AND NVL(BA1.SEGMENT13_HIGH,'X') >= NVL(BA2.SEGMENT13_LOW,'X')
AND NVL(BA1.SEGMENT14_LOW,'X') <= NVL(BA2.SEGMENT14_HIGH,'X')
AND NVL(BA1.SEGMENT14_HIGH,'X') >= NVL(BA2.SEGMENT14_LOW,'X')
AND NVL(BA1.SEGMENT15_LOW,'X') <= NVL(BA2.SEGMENT15_HIGH,'X')
AND NVL(BA1.SEGMENT15_HIGH,'X') >= NVL(BA2.SEGMENT15_LOW,'X')
AND NVL(BA1.SEGMENT16_LOW,'X') <= NVL(BA2.SEGMENT16_HIGH,'X')
AND NVL(BA1.SEGMENT16_HIGH,'X') >= NVL(BA2.SEGMENT16_LOW,'X')
AND NVL(BA1.SEGMENT17_LOW,'X') <= NVL(BA2.SEGMENT17_HIGH,'X')
AND NVL(BA1.SEGMENT17_HIGH,'X') >= NVL(BA2.SEGMENT17_LOW,'X')
AND NVL(BA1.SEGMENT18_LOW,'X') <= NVL(BA2.SEGMENT18_HIGH,'X')
AND NVL(BA1.SEGMENT18_HIGH,'X') >= NVL(BA2.SEGMENT18_LOW,'X')
AND NVL(BA1.SEGMENT19_LOW,'X') <= NVL(BA2.SEGMENT19_HIGH,'X')
AND NVL(BA1.SEGMENT19_HIGH,'X') >= NVL(BA2.SEGMENT19_LOW,'X')
AND NVL(BA1.SEGMENT20_LOW,'X') <= NVL(BA2.SEGMENT20_HIGH,'X')
AND NVL(BA1.SEGMENT20_HIGH,'X') >= NVL(BA2.SEGMENT20_LOW,'X')
AND NVL(BA1.SEGMENT21_LOW,'X') <= NVL(BA2.SEGMENT21_HIGH,'X')
AND NVL(BA1.SEGMENT21_HIGH,'X') >= NVL(BA2.SEGMENT21_LOW,'X')
AND NVL(BA1.SEGMENT22_LOW,'X') <= NVL(BA2.SEGMENT22_HIGH,'X')
AND NVL(BA1.SEGMENT22_HIGH,'X') >= NVL(BA2.SEGMENT22_LOW,'X')
AND NVL(BA1.SEGMENT23_LOW,'X') <= NVL(BA2.SEGMENT23_HIGH,'X')
AND NVL(BA1.SEGMENT23_HIGH,'X') >= NVL(BA2.SEGMENT23_LOW,'X')
AND NVL(BA1.SEGMENT24_LOW,'X') <= NVL(BA2.SEGMENT24_HIGH,'X')
AND NVL(BA1.SEGMENT24_HIGH,'X') >= NVL(BA2.SEGMENT24_LOW,'X')
AND NVL(BA1.SEGMENT25_LOW,'X') <= NVL(BA2.SEGMENT25_HIGH,'X')
AND NVL(BA1.SEGMENT25_HIGH,'X') >= NVL(BA2.SEGMENT25_LOW,'X')
AND NVL(BA1.SEGMENT26_LOW,'X') <= NVL(BA2.SEGMENT26_HIGH,'X')
AND NVL(BA1.SEGMENT26_HIGH,'X') >= NVL(BA2.SEGMENT26_LOW,'X')
AND NVL(BA1.SEGMENT27_LOW,'X') <= NVL(BA2.SEGMENT27_HIGH,'X')
AND NVL(BA1.SEGMENT27_HIGH,'X') >= NVL(BA2.SEGMENT27_LOW,'X')
AND NVL(BA1.SEGMENT28_LOW,'X') <= NVL(BA2.SEGMENT28_HIGH,'X')
AND NVL(BA1.SEGMENT28_HIGH,'X') >= NVL(BA2.SEGMENT28_LOW,'X')
AND NVL(BA1.SEGMENT29_LOW,'X') <= NVL(BA2.SEGMENT29_HIGH,'X')
AND NVL(BA1.SEGMENT29_HIGH,'X') >= NVL(BA2.SEGMENT29_LOW,'X')
AND NVL(BA1.SEGMENT30_LOW,'X') <= NVL(BA2.SEGMENT30_HIGH,'X')
AND NVL(BA1.SEGMENT30_HIGH,'X') >= NVL(BA2.SEGMENT30_LOW,'X')
)
AND BA1.RANGE_ID NOT IN (
SELECT RANGE_ID FROM GL_BUDGET_ASSIGNMENT_RANGES BA3
WHERE
BA3.LEDGER_ID = BA1.LEDGER_ID AND
BA3.CURRENCY_CODE = BA1.CURRENCY_CODE AND
EXISTS
(SELECT 1 FROM
GL_BUDGET_ASSIGNMENT_RANGES BA4
WHERE
BA4.ledger_id = BA3.ledger_id
AND BA4.currency_code = BA3.currency_code
AND BA3.RANGE_ID <> BA4.RANGE_ID
AND NVL(BA3.SEGMENT1_LOW,'X') = NVL(BA4.SEGMENT1_LOW,'X')
AND NVL(BA3.SEGMENT1_HIGH,'X') = NVL(BA4.SEGMENT1_HIGH,'X')
AND NVL(BA3.SEGMENT2_LOW,'X') = NVL(BA4.SEGMENT2_LOW,'X')
AND NVL(BA3.SEGMENT2_HIGH,'X') = NVL(BA4.SEGMENT2_HIGH,'X')
AND NVL(BA3.SEGMENT3_LOW,'X') = NVL(BA4.SEGMENT3_LOW,'X')
AND NVL(BA3.SEGMENT3_HIGH,'X') = NVL(BA4.SEGMENT3_HIGH,'X')
AND NVL(BA3.SEGMENT4_LOW,'X') = NVL(BA4.SEGMENT4_LOW,'X')
AND NVL(BA3.SEGMENT4_HIGH,'X') = NVL(BA4.SEGMENT4_HIGH,'X')
AND NVL(BA3.SEGMENT5_LOW,'X') = NVL(BA4.SEGMENT5_LOW,'X')
AND NVL(BA3.SEGMENT5_HIGH,'X') = NVL(BA4.SEGMENT5_HIGH,'X')
AND NVL(BA3.SEGMENT6_LOW,'X') = NVL(BA4.SEGMENT6_LOW,'X')
AND NVL(BA3.SEGMENT6_HIGH,'X') = NVL(BA4.SEGMENT6_HIGH,'X')
AND NVL(BA3.SEGMENT7_LOW,'X') = NVL(BA4.SEGMENT7_LOW,'X')
AND NVL(BA3.SEGMENT7_HIGH,'X') = NVL(BA4.SEGMENT7_HIGH,'X')
AND NVL(BA3.SEGMENT8_LOW,'X') = NVL(BA4.SEGMENT8_LOW,'X')
AND NVL(BA3.SEGMENT8_HIGH,'X') = NVL(BA4.SEGMENT8_HIGH,'X')
AND NVL(BA3.SEGMENT9_LOW,'X') = NVL(BA4.SEGMENT9_LOW,'X')
AND NVL(BA3.SEGMENT9_HIGH,'X') = NVL(BA4.SEGMENT9_HIGH,'X')
AND NVL(BA3.SEGMENT10_LOW,'X') = NVL(BA4.SEGMENT10_LOW,'X')
AND NVL(BA3.SEGMENT10_HIGH,'X') = NVL(BA4.SEGMENT10_HIGH,'X')
AND NVL(BA3.SEGMENT11_LOW,'X') = NVL(BA4.SEGMENT11_LOW,'X')
AND NVL(BA3.SEGMENT11_HIGH,'X') = NVL(BA4.SEGMENT11_HIGH,'X')
AND NVL(BA3.SEGMENT12_LOW,'X') = NVL(BA4.SEGMENT12_LOW,'X')
AND NVL(BA3.SEGMENT12_HIGH,'X') = NVL(BA4.SEGMENT12_HIGH,'X')
AND NVL(BA3.SEGMENT13_LOW,'X') = NVL(BA4.SEGMENT13_LOW,'X')
AND NVL(BA3.SEGMENT13_HIGH,'X') = NVL(BA4.SEGMENT13_HIGH,'X')
AND NVL(BA3.SEGMENT14_LOW,'X') = NVL(BA4.SEGMENT14_LOW,'X')
AND NVL(BA3.SEGMENT14_HIGH,'X') = NVL(BA4.SEGMENT14_HIGH,'X')
AND NVL(BA3.SEGMENT15_LOW,'X') = NVL(BA4.SEGMENT15_LOW,'X')
AND NVL(BA3.SEGMENT15_HIGH,'X') = NVL(BA4.SEGMENT15_HIGH,'X')
AND NVL(BA3.SEGMENT16_LOW,'X') = NVL(BA4.SEGMENT16_LOW,'X')
AND NVL(BA3.SEGMENT16_HIGH,'X') = NVL(BA4.SEGMENT16_HIGH,'X')
AND NVL(BA3.SEGMENT17_LOW,'X') = NVL(BA4.SEGMENT17_LOW,'X')
AND NVL(BA3.SEGMENT17_HIGH,'X') = NVL(BA4.SEGMENT17_HIGH,'X')
AND NVL(BA3.SEGMENT18_LOW,'X') = NVL(BA4.SEGMENT18_LOW,'X')
AND NVL(BA3.SEGMENT18_HIGH,'X') = NVL(BA4.SEGMENT18_HIGH,'X')
AND NVL(BA3.SEGMENT19_LOW,'X') = NVL(BA4.SEGMENT19_LOW,'X')
AND NVL(BA3.SEGMENT19_HIGH,'X') = NVL(BA4.SEGMENT19_HIGH,'X')
AND NVL(BA3.SEGMENT20_LOW,'X') = NVL(BA4.SEGMENT20_LOW,'X')
AND NVL(BA3.SEGMENT20_HIGH,'X') = NVL(BA4.SEGMENT20_HIGH,'X')
AND NVL(BA3.SEGMENT21_LOW,'X') = NVL(BA4.SEGMENT21_LOW,'X')
AND NVL(BA3.SEGMENT21_HIGH,'X') = NVL(BA4.SEGMENT21_HIGH,'X')
AND NVL(BA3.SEGMENT22_LOW,'X') = NVL(BA4.SEGMENT22_LOW,'X')
AND NVL(BA3.SEGMENT22_HIGH,'X') = NVL(BA4.SEGMENT22_HIGH,'X')
AND NVL(BA3.SEGMENT23_LOW,'X') = NVL(BA4.SEGMENT23_LOW,'X')
AND NVL(BA3.SEGMENT23_HIGH,'X') = NVL(BA4.SEGMENT23_HIGH,'X')
AND NVL(BA3.SEGMENT24_LOW,'X') = NVL(BA4.SEGMENT24_LOW,'X')
AND NVL(BA3.SEGMENT24_HIGH,'X') = NVL(BA4.SEGMENT24_HIGH,'X')
AND NVL(BA3.SEGMENT25_LOW,'X') = NVL(BA4.SEGMENT25_LOW,'X')
AND NVL(BA3.SEGMENT25_HIGH,'X') = NVL(BA4.SEGMENT25_HIGH,'X')
AND NVL(BA3.SEGMENT26_LOW,'X') = NVL(BA4.SEGMENT26_LOW,'X')
AND NVL(BA3.SEGMENT26_HIGH,'X') = NVL(BA4.SEGMENT26_HIGH,'X')
AND NVL(BA3.SEGMENT27_LOW,'X') = NVL(BA4.SEGMENT27_LOW,'X')
AND NVL(BA3.SEGMENT27_HIGH,'X') = NVL(BA4.SEGMENT27_HIGH,'X')
AND NVL(BA3.SEGMENT28_LOW,'X') = NVL(BA4.SEGMENT28_LOW,'X')
AND NVL(BA3.SEGMENT28_HIGH,'X') = NVL(BA4.SEGMENT28_HIGH,'X')
AND NVL(BA3.SEGMENT29_LOW,'X') = NVL(BA4.SEGMENT29_LOW,'X')
AND NVL(BA3.SEGMENT29_HIGH,'X') = NVL(BA4.SEGMENT29_HIGH,'X')
AND NVL(BA3.SEGMENT30_LOW,'X') = NVL(BA4.SEGMENT30_LOW,'X')
AND NVL(BA3.SEGMENT30_HIGH,'X') = NVL(BA4.SEGMENT30_HIGH,'X')
))
AND EXISTS
(SELECT 1
FROM GL_BUDGET_ENTITIES glent
WHERE
BA1.ledger_id = glent.ledger_id AND
EXISTS (
SELECT 1
FROM PSA_EFC_OPTIONS psaefc
WHERE psaefc.set_of_books_id = glent.ledger_id
AND psaefc.mult_funding_budgets_flag = 'Y'
))
);
SELECT DISTINCT glent.ledger_id
FROM gl_budget_entities glent
WHERE EXISTS (
SELECT 1
FROM psa_efc_options psaefc
WHERE psaefc.set_of_books_id = glent.ledger_id
AND psaefc.mult_funding_budgets_flag = 'Y'
);
SELECT * FROM IGI_EFC_BUDGET_ASSIGNMENT_BCK;
DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT;
DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS;
INSERT INTO IGI_EFC_BUDGET_ASSIGNMENT_BCK
(
BUDGET_ENTITY_ID,
LEDGER_ID,
CURRENCY_CODE,
ENTRY_CODE,
RANGE_ID,
STATUS,
LAST_UPDATE_DATE,
AUTOMATIC_ENCUMBRANCE_FLAG,
CREATED_BY,
CREATION_DATE,
FUNDS_CHECK_LEVEL_CODE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
SEQUENCE_NUMBER,
SEGMENT1_LOW,
SEGMENT1_HIGH,
SEGMENT2_LOW,
SEGMENT2_HIGH,
SEGMENT3_LOW,
SEGMENT3_HIGH,
SEGMENT4_LOW,
SEGMENT4_HIGH,
SEGMENT5_LOW,
SEGMENT5_HIGH,
SEGMENT6_LOW,
SEGMENT6_HIGH,
SEGMENT7_LOW,
SEGMENT7_HIGH,
SEGMENT8_LOW,
SEGMENT8_HIGH,
SEGMENT9_LOW,
SEGMENT9_HIGH,
SEGMENT10_LOW,
SEGMENT10_HIGH,
SEGMENT11_LOW,
SEGMENT11_HIGH,
SEGMENT12_LOW,
SEGMENT12_HIGH,
SEGMENT13_LOW,
SEGMENT13_HIGH,
SEGMENT14_LOW,
SEGMENT14_HIGH,
SEGMENT15_LOW,
SEGMENT15_HIGH,
SEGMENT16_LOW,
SEGMENT16_HIGH,
SEGMENT17_LOW,
SEGMENT17_HIGH,
SEGMENT18_LOW,
SEGMENT18_HIGH,
SEGMENT19_LOW,
SEGMENT19_HIGH,
SEGMENT20_LOW,
SEGMENT20_HIGH,
SEGMENT21_LOW,
SEGMENT21_HIGH,
SEGMENT22_LOW,
SEGMENT22_HIGH,
SEGMENT23_LOW,
SEGMENT23_HIGH,
SEGMENT24_LOW,
SEGMENT24_HIGH,
SEGMENT25_LOW,
SEGMENT25_HIGH,
SEGMENT26_LOW,
SEGMENT26_HIGH,
SEGMENT27_LOW,
SEGMENT27_HIGH,
SEGMENT28_LOW,
SEGMENT28_HIGH,
SEGMENT29_LOW,
SEGMENT29_HIGH,
SEGMENT30_LOW,
SEGMENT30_HIGH,
AMOUNT_TYPE,
BOUNDARY_CODE,
CONTEXT,
FUNDING_BUDGET_VERSION_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
)
SELECT
BUDGET_ENTITY_ID,
LEDGER_ID,
CURRENCY_CODE,
ENTRY_CODE,
RANGE_ID,
STATUS,
LAST_UPDATE_DATE,
AUTOMATIC_ENCUMBRANCE_FLAG,
CREATED_BY,
CREATION_DATE,
FUNDS_CHECK_LEVEL_CODE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
SEQUENCE_NUMBER,
SEGMENT1_LOW,
SEGMENT1_HIGH,
SEGMENT2_LOW,
SEGMENT2_HIGH,
SEGMENT3_LOW,
SEGMENT3_HIGH,
SEGMENT4_LOW,
SEGMENT4_HIGH,
SEGMENT5_LOW,
SEGMENT5_HIGH,
SEGMENT6_LOW,
SEGMENT6_HIGH,
SEGMENT7_LOW,
SEGMENT7_HIGH,
SEGMENT8_LOW,
SEGMENT8_HIGH,
SEGMENT9_LOW,
SEGMENT9_HIGH,
SEGMENT10_LOW,
SEGMENT10_HIGH,
SEGMENT11_LOW,
SEGMENT11_HIGH,
SEGMENT12_LOW,
SEGMENT12_HIGH,
SEGMENT13_LOW,
SEGMENT13_HIGH,
SEGMENT14_LOW,
SEGMENT14_HIGH,
SEGMENT15_LOW,
SEGMENT15_HIGH,
SEGMENT16_LOW,
SEGMENT16_HIGH,
SEGMENT17_LOW,
SEGMENT17_HIGH,
SEGMENT18_LOW,
SEGMENT18_HIGH,
SEGMENT19_LOW,
SEGMENT19_HIGH,
SEGMENT20_LOW,
SEGMENT20_HIGH,
SEGMENT21_LOW,
SEGMENT21_HIGH,
SEGMENT22_LOW,
SEGMENT22_HIGH,
SEGMENT23_LOW,
SEGMENT23_HIGH,
SEGMENT24_LOW,
SEGMENT24_HIGH,
SEGMENT25_LOW,
SEGMENT25_HIGH,
SEGMENT26_LOW,
SEGMENT26_HIGH,
SEGMENT27_LOW,
SEGMENT27_HIGH,
SEGMENT28_LOW,
SEGMENT28_HIGH,
SEGMENT29_LOW,
SEGMENT29_HIGH,
SEGMENT30_LOW,
SEGMENT30_HIGH,
AMOUNT_TYPE,
BOUNDARY_CODE,
CONTEXT,
FUNDING_BUDGET_VERSION_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM GL_BUDGET_ASSIGNMENT_RANGES gar
WHERE exists (SELECT 1
FROM gl_budget_entities glent
WHERE
gar.ledger_id = glent.ledger_id AND
EXISTS (
SELECT 1
FROM psa_efc_options psaefc
WHERE psaefc.set_of_books_id = glent.ledger_id
AND psaefc.mult_funding_budgets_flag = 'Y'
));
fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM);
errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM;
INSERT INTO IGI_BUDORG_BC_OPTIONS_BCK
(
RANGE_ID,
FUNDING_BUDGET_VERSION_ID,
FUNDS_CHECK_LEVEL_CODE,
AMOUNT_TYPE,
BOUNDARY_CODE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE
)
SELECT
RANGE_ID,
FUNDING_BUDGET_VERSION_ID,
FUNDS_CHECK_LEVEL_CODE,
AMOUNT_TYPE,
BOUNDARY_CODE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE
FROM GL_BUDORG_BC_OPTIONS
WHERE range_id IN
(SELECT range_id
FROM
IGI_EFC_BUDGET_ASSIGNMENT_BCK);
fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
IGI_BUDORG_BC_OPTIONS_BCK =>'||SQLERRM);
errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
IGI_BUDORG_BC_OPTIONS_BCK =>'||SQLERRM;
INSERT INTO IGI_GL_BUDGET_ASSIGN_BCK
(
LEDGER_ID,
BUDGET_ENTITY_ID,
CURRENCY_CODE,
CODE_COMBINATION_ID,
RANGE_ID,
ENTRY_CODE,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
AUTOMATIC_ENCUMBRANCE_FLAG,
FUNDS_CHECK_LEVEL_CODE,
ORDERING_VALUE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
CONTEXT,
AMOUNT_TYPE,
BOUNDARY_CODE,
FUNDING_BUDGET_VERSION_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID
)
SELECT
LEDGER_ID,
BUDGET_ENTITY_ID,
CURRENCY_CODE,
CODE_COMBINATION_ID,
RANGE_ID,
ENTRY_CODE,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
AUTOMATIC_ENCUMBRANCE_FLAG,
FUNDS_CHECK_LEVEL_CODE,
ORDERING_VALUE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
CONTEXT,
AMOUNT_TYPE,
BOUNDARY_CODE,
FUNDING_BUDGET_VERSION_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID
FROM GL_BUDGET_ASSIGNMENTS
WHERE range_id IN
(SELECT range_id
FROM
IGI_EFC_BUDGET_ASSIGNMENT_BCK);
fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
IGI_GL_BUDGET_ASSIGN_BCK =>'||SQLERRM);
errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
IGI_GL_BUDGET_ASSIGN_BCK =>'||SQLERRM;
INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT
(
BUDGET_ENTITY_ID,
LEDGER_ID,
CURRENCY_CODE,
ENTRY_CODE,
RANGE_ID,
STATUS,
LAST_UPDATE_DATE,
AUTOMATIC_ENCUMBRANCE_FLAG,
CREATED_BY,
CREATION_DATE,
FUNDS_CHECK_LEVEL_CODE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
SEQUENCE_NUMBER,
SEGMENT1_LOW,
SEGMENT1_HIGH,
SEGMENT2_LOW,
SEGMENT2_HIGH,
SEGMENT3_LOW,
SEGMENT3_HIGH,
SEGMENT4_LOW,
SEGMENT4_HIGH,
SEGMENT5_LOW,
SEGMENT5_HIGH,
SEGMENT6_LOW,
SEGMENT6_HIGH,
SEGMENT7_LOW,
SEGMENT7_HIGH,
SEGMENT8_LOW,
SEGMENT8_HIGH,
SEGMENT9_LOW,
SEGMENT9_HIGH,
SEGMENT10_LOW,
SEGMENT10_HIGH,
SEGMENT11_LOW,
SEGMENT11_HIGH,
SEGMENT12_LOW,
SEGMENT12_HIGH,
SEGMENT13_LOW,
SEGMENT13_HIGH,
SEGMENT14_LOW,
SEGMENT14_HIGH,
SEGMENT15_LOW,
SEGMENT15_HIGH,
SEGMENT16_LOW,
SEGMENT16_HIGH,
SEGMENT17_LOW,
SEGMENT17_HIGH,
SEGMENT18_LOW,
SEGMENT18_HIGH,
SEGMENT19_LOW,
SEGMENT19_HIGH,
SEGMENT20_LOW,
SEGMENT20_HIGH,
SEGMENT21_LOW,
SEGMENT21_HIGH,
SEGMENT22_LOW,
SEGMENT22_HIGH,
SEGMENT23_LOW,
SEGMENT23_HIGH,
SEGMENT24_LOW,
SEGMENT24_HIGH,
SEGMENT25_LOW,
SEGMENT25_HIGH,
SEGMENT26_LOW,
SEGMENT26_HIGH,
SEGMENT27_LOW,
SEGMENT27_HIGH,
SEGMENT28_LOW,
SEGMENT28_HIGH,
SEGMENT29_LOW,
SEGMENT29_HIGH,
SEGMENT30_LOW,
SEGMENT30_HIGH,
AMOUNT_TYPE,
BOUNDARY_CODE,
CONTEXT,
FUNDING_BUDGET_VERSION_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
)
SELECT
BUDGET_ENTITY_ID,
LEDGER_ID,
CURRENCY_CODE,
ENTRY_CODE,
RANGE_ID,
STATUS,
LAST_UPDATE_DATE,
AUTOMATIC_ENCUMBRANCE_FLAG,
CREATED_BY,
CREATION_DATE,
FUNDS_CHECK_LEVEL_CODE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
SEQUENCE_NUMBER,
SEGMENT1_LOW,
SEGMENT1_HIGH,
SEGMENT2_LOW,
SEGMENT2_HIGH,
SEGMENT3_LOW,
SEGMENT3_HIGH,
SEGMENT4_LOW,
SEGMENT4_HIGH,
SEGMENT5_LOW,
SEGMENT5_HIGH,
SEGMENT6_LOW,
SEGMENT6_HIGH,
SEGMENT7_LOW,
SEGMENT7_HIGH,
SEGMENT8_LOW,
SEGMENT8_HIGH,
SEGMENT9_LOW,
SEGMENT9_HIGH,
SEGMENT10_LOW,
SEGMENT10_HIGH,
SEGMENT11_LOW,
SEGMENT11_HIGH,
SEGMENT12_LOW,
SEGMENT12_HIGH,
SEGMENT13_LOW,
SEGMENT13_HIGH,
SEGMENT14_LOW,
SEGMENT14_HIGH,
SEGMENT15_LOW,
SEGMENT15_HIGH,
SEGMENT16_LOW,
SEGMENT16_HIGH,
SEGMENT17_LOW,
SEGMENT17_HIGH,
SEGMENT18_LOW,
SEGMENT18_HIGH,
SEGMENT19_LOW,
SEGMENT19_HIGH,
SEGMENT20_LOW,
SEGMENT20_HIGH,
SEGMENT21_LOW,
SEGMENT21_HIGH,
SEGMENT22_LOW,
SEGMENT22_HIGH,
SEGMENT23_LOW,
SEGMENT23_HIGH,
SEGMENT24_LOW,
SEGMENT24_HIGH,
SEGMENT25_LOW,
SEGMENT25_HIGH,
SEGMENT26_LOW,
SEGMENT26_HIGH,
SEGMENT27_LOW,
SEGMENT27_HIGH,
SEGMENT28_LOW,
SEGMENT28_HIGH,
SEGMENT29_LOW,
SEGMENT29_HIGH,
SEGMENT30_LOW,
SEGMENT30_HIGH,
AMOUNT_TYPE,
BOUNDARY_CODE,
CONTEXT,
FUNDING_BUDGET_VERSION_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM GL_BUDGET_ASSIGNMENT_RANGES gar
WHERE exists (SELECT 1
FROM GL_BUDGET_ENTITIES glent
WHERE
gar.ledger_id = glent.ledger_id AND
EXISTS (
SELECT 1
FROM PSA_EFC_OPTIONS psaefc
WHERE psaefc.set_of_books_id = glent.ledger_id
AND psaefc.mult_funding_budgets_flag = 'Y'
));
fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM);
errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM;
INSERT INTO IGI_UPG_GL_BUDORG_BC_OPTIONS
(
RANGE_ID,
FUNDING_BUDGET_VERSION_ID,
FUNDS_CHECK_LEVEL_CODE,
AMOUNT_TYPE,
BOUNDARY_CODE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE
)
SELECT
RANGE_ID,
FUNDING_BUDGET_VERSION_ID,
FUNDS_CHECK_LEVEL_CODE,
AMOUNT_TYPE,
BOUNDARY_CODE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE
FROM GL_BUDORG_BC_OPTIONS
WHERE range_id IN
(SELECT range_id
FROM
IGI_UPG_GL_BUDGET_ASSIGNMENT);
fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM);
errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM;
DELETE FROM GL_BUDORG_BC_OPTIONS
WHERE range_id IN
(SELECT range_id
FROM
IGI_EFC_BUDGET_ASSIGNMENT_BCK);
DELETE FROM GL_BUDGET_ASSIGNMENT_RANGES
WHERE range_id IN
(SELECT range_id
FROM
IGI_EFC_BUDGET_ASSIGNMENT_BCK);
DELETE FROM GL_BUDGET_ASSIGNMENTS
WHERE range_id IN
(SELECT range_id
FROM
IGI_EFC_BUDGET_ASSIGNMENT_BCK);