DBA Data[Home] [Help]

APPS.IGI_EFC_UPGRADE dependencies on IGI_EFC_BUDGET_ASSIGNMENT_BCK

Line 3149: SELECT * FROM IGI_EFC_BUDGET_ASSIGNMENT_BCK;

3145:
3146: -- This cursor is used to determine whether the upgrade has been run in
3147: -- final mode or not. When run in final mode this table is populated.
3148: CURSOR c_backup_exists IS
3149: SELECT * FROM IGI_EFC_BUDGET_ASSIGNMENT_BCK;
3150:
3151: lc_backup_exists c_backup_exists%ROWTYPE;
3152: lc_c_ledger_info c_ledger_info%ROWTYPE;
3153:

Line 3251: -- Backup all existing data into IGI_EFC_BUDGET_ASSIGNMENT_BCK

3247: END IF;
3248: CLOSE c_backup_exists;
3249:
3250:
3251: -- Backup all existing data into IGI_EFC_BUDGET_ASSIGNMENT_BCK
3252: BEGIN
3253:
3254: INSERT INTO IGI_EFC_BUDGET_ASSIGNMENT_BCK
3255: (

Line 3254: INSERT INTO IGI_EFC_BUDGET_ASSIGNMENT_BCK

3250:
3251: -- Backup all existing data into IGI_EFC_BUDGET_ASSIGNMENT_BCK
3252: BEGIN
3253:
3254: INSERT INTO IGI_EFC_BUDGET_ASSIGNMENT_BCK
3255: (
3256: BUDGET_ENTITY_ID,
3257: LEDGER_ID,
3258: CURRENCY_CODE,

Line 3468: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM);

3464: EXCEPTION
3465: WHEN OTHERS THEN
3466: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3467: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3468: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM);
3469: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3470: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM;
3471: retcode := -1;
3472: RETURN;

Line 3470: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM;

3466: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3467: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3468: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM);
3469: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3470: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM;
3471: retcode := -1;
3472: RETURN;
3473: END;
3474:

Line 3505: IGI_EFC_BUDGET_ASSIGNMENT_BCK);

3501: FROM GL_BUDORG_BC_OPTIONS
3502: WHERE range_id IN
3503: (SELECT range_id
3504: FROM
3505: IGI_EFC_BUDGET_ASSIGNMENT_BCK);
3506:
3507: EXCEPTION
3508: WHEN OTHERS THEN
3509: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');

Line 3588: IGI_EFC_BUDGET_ASSIGNMENT_BCK);

3584: FROM GL_BUDGET_ASSIGNMENTS
3585: WHERE range_id IN
3586: (SELECT range_id
3587: FROM
3588: IGI_EFC_BUDGET_ASSIGNMENT_BCK);
3589:
3590: EXCEPTION
3591: WHEN OTHERS THEN
3592: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');

Line 3887: IGI_EFC_BUDGET_ASSIGNMENT_BCK);

3883: DELETE FROM GL_BUDORG_BC_OPTIONS
3884: WHERE range_id IN
3885: (SELECT range_id
3886: FROM
3887: IGI_EFC_BUDGET_ASSIGNMENT_BCK);
3888:
3889: DELETE FROM GL_BUDGET_ASSIGNMENT_RANGES
3890: WHERE range_id IN
3891: (SELECT range_id

Line 3893: IGI_EFC_BUDGET_ASSIGNMENT_BCK);

3889: DELETE FROM GL_BUDGET_ASSIGNMENT_RANGES
3890: WHERE range_id IN
3891: (SELECT range_id
3892: FROM
3893: IGI_EFC_BUDGET_ASSIGNMENT_BCK);
3894:
3895: DELETE FROM GL_BUDGET_ASSIGNMENTS
3896: WHERE range_id IN
3897: (SELECT range_id

Line 3899: IGI_EFC_BUDGET_ASSIGNMENT_BCK);

3895: DELETE FROM GL_BUDGET_ASSIGNMENTS
3896: WHERE range_id IN
3897: (SELECT range_id
3898: FROM
3899: IGI_EFC_BUDGET_ASSIGNMENT_BCK);
3900:
3901: EXCEPTION
3902: WHEN OTHERS THEN
3903: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');