DBA Data[Home] [Help]

APPS.IGI_EFC_UPGRADE dependencies on IGI_EFC_BUDGET_ASSIGNMENT_BCK

Line 2797: SELECT * FROM IGI_EFC_BUDGET_ASSIGNMENT_BCK;

2793: AND psaefc.mult_funding_budgets_flag = 'Y'
2794: );
2795:
2796: CURSOR c_backup_exists IS
2797: SELECT * FROM IGI_EFC_BUDGET_ASSIGNMENT_BCK;
2798:
2799: lc_backup_exists c_backup_exists%ROWTYPE;
2800: lc_c_ledger_info c_ledger_info%ROWTYPE;
2801:

Line 2886: INSERT INTO IGI_EFC_BUDGET_ASSIGNMENT_BCK

2882: CLOSE c_backup_exists;
2883:
2884: BEGIN
2885:
2886: INSERT INTO IGI_EFC_BUDGET_ASSIGNMENT_BCK
2887: (
2888: BUDGET_ENTITY_ID,
2889: LEDGER_ID,
2890: CURRENCY_CODE,

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

3096: EXCEPTION
3097: WHEN OTHERS THEN
3098: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3099: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3100: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM);
3101: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3102: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM;
3103: retcode := -1;
3104: RETURN;

Line 3102: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM;

3098: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3099: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3100: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM);
3101: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3102: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM;
3103: retcode := -1;
3104: RETURN;
3105: END;
3106:

Line 3137: IGI_EFC_BUDGET_ASSIGNMENT_BCK);

3133: FROM GL_BUDORG_BC_OPTIONS
3134: WHERE range_id IN
3135: (SELECT range_id
3136: FROM
3137: IGI_EFC_BUDGET_ASSIGNMENT_BCK);
3138:
3139: EXCEPTION
3140: WHEN OTHERS THEN
3141: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');

Line 3220: IGI_EFC_BUDGET_ASSIGNMENT_BCK);

3216: FROM GL_BUDGET_ASSIGNMENTS
3217: WHERE range_id IN
3218: (SELECT range_id
3219: FROM
3220: IGI_EFC_BUDGET_ASSIGNMENT_BCK);
3221:
3222: EXCEPTION
3223: WHEN OTHERS THEN
3224: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');

Line 3509: IGI_EFC_BUDGET_ASSIGNMENT_BCK);

3505: DELETE FROM GL_BUDORG_BC_OPTIONS
3506: WHERE range_id IN
3507: (SELECT range_id
3508: FROM
3509: IGI_EFC_BUDGET_ASSIGNMENT_BCK);
3510:
3511: DELETE FROM GL_BUDGET_ASSIGNMENT_RANGES
3512: WHERE range_id IN
3513: (SELECT range_id

Line 3515: IGI_EFC_BUDGET_ASSIGNMENT_BCK);

3511: DELETE FROM GL_BUDGET_ASSIGNMENT_RANGES
3512: WHERE range_id IN
3513: (SELECT range_id
3514: FROM
3515: IGI_EFC_BUDGET_ASSIGNMENT_BCK);
3516:
3517: DELETE FROM GL_BUDGET_ASSIGNMENTS
3518: WHERE range_id IN
3519: (SELECT range_id

Line 3521: IGI_EFC_BUDGET_ASSIGNMENT_BCK);

3517: DELETE FROM GL_BUDGET_ASSIGNMENTS
3518: WHERE range_id IN
3519: (SELECT range_id
3520: FROM
3521: IGI_EFC_BUDGET_ASSIGNMENT_BCK);
3522:
3523: EXCEPTION
3524: WHEN OTHERS THEN
3525: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');