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.OZF_RESALE_COMMON_PVT dependencies on OZF_ACT_BUDGETS_INT

Line 6526: -- ozf_funds_all_b_int, ozf_act_budgets_int.

6522: -- PURPOSE
6523: -- This API is called via concurrent program 'OZF: Update Budgets
6524: -- from Interface Tables' to update the main tables ozf_funds_all_b,
6525: -- ozf_act_budgets with the records from staging tables
6526: -- ozf_funds_all_b_int, ozf_act_budgets_int.
6527: --
6528: -- HISTORY
6529: -- 30-OCT-2009 muthsubr Created for the bug#8867381.
6530: -- 29-NOV-2010 muthsubr For TPA Parallel Execution ER Bug#9614703.

Line 6619: FROM OZF_ACT_BUDGETS_INT

6615: SUM(APPROVED_ORIGINAL_AMOUNT) APPROVED_ORIGINAL_AMOUNT,
6616: SUM(APPROVED_AMOUNT_FC) APPROVED_AMOUNT_FC,
6617: SUM(PARENT_SRC_APPRVD_AMT) PARENT_SRC_APPRVD_AMT,
6618: SUM(SRC_CURR_REQUEST_AMT) SRC_CURR_REQUEST_AMT
6619: FROM OZF_ACT_BUDGETS_INT
6620: WHERE BATCH_TYPE = p_batch_type
6621: group by RESALE_BATCH_ID, ACTIVITY_BUDGET_ID;
6622:
6623:

Line 6627: FROM OZF_FUNDS_ALL_B_INT -- nepanda : changed the table name, as OZF_ACT_BUDGETS_INT will not have any data when its the 1st time accrual is created for the offer.

6623:
6624: CURSOR batch_id_csr(p_batch_type IN VARCHAR) IS
6625: SELECT DISTINCT
6626: RESALE_BATCH_ID
6627: FROM OZF_FUNDS_ALL_B_INT -- nepanda : changed the table name, as OZF_ACT_BUDGETS_INT will not have any data when its the 1st time accrual is created for the offer.
6628: WHERE BATCH_TYPE = p_batch_type;
6629:
6630: CURSOR budgets_int_wp_csr(p_batch_id IN NUMBER, p_batch_type IN VARCHAR) IS
6631: SELECT

Line 6639: FROM OZF_ACT_BUDGETS_INT

6635: SUM(APPROVED_ORIGINAL_AMOUNT) APPROVED_ORIGINAL_AMOUNT,
6636: SUM(APPROVED_AMOUNT_FC) APPROVED_AMOUNT_FC,
6637: SUM(PARENT_SRC_APPRVD_AMT) PARENT_SRC_APPRVD_AMT,
6638: SUM(SRC_CURR_REQUEST_AMT) SRC_CURR_REQUEST_AMT
6639: FROM OZF_ACT_BUDGETS_INT
6640: WHERE RESALE_BATCH_ID = p_batch_id
6641: AND BATCH_TYPE = p_batch_type
6642: group by RESALE_BATCH_ID, ACTIVITY_BUDGET_ID;
6643:

Line 6797: AND EXISTS (SELECT 1 FROM ozf_act_budgets_int where request_id = fut.request_id)

6793: from ozf_resale_lines_all orl,
6794: OZF_RESALE_BATCH_LINE_MAPS_ALL orblm
6795: where orl.resale_line_id = orblm.resale_line_id
6796: and orblm.resale_batch_id = p_batch_id)
6797: AND EXISTS (SELECT 1 FROM ozf_act_budgets_int where request_id = fut.request_id)
6798: GROUP BY
6799: gl_posted_flag,
6800: utilization_type,
6801: plan_type,

Line 7332: DELETE FROM OZF_ACT_BUDGETS_INT WHERE BATCH_TYPE = p_batch_type;

7328: END LOOP;
7329:
7330: -- Delete the staging tables once the records are updated to the main table.
7331: DELETE FROM OZF_FUNDS_ALL_B_INT WHERE BATCH_TYPE = p_batch_type;
7332: DELETE FROM OZF_ACT_BUDGETS_INT WHERE BATCH_TYPE = p_batch_type;
7333:
7334: IF p_batch_type='TP_ACCRUAL' THEN
7335: l_vol_exists :='N';
7336: OPEN ozf_vol_int_exists_csr;

Line 7350: ozf_utility_pvt.write_conc_log('deleted records from staging tables OZF_FUNDS_ALL_B_INT and OZF_ACT_BUDGETS_INT ');

7346: END IF;
7347:
7348: END IF;
7349:
7350: ozf_utility_pvt.write_conc_log('deleted records from staging tables OZF_FUNDS_ALL_B_INT and OZF_ACT_BUDGETS_INT ');
7351:
7352: ELSIF p_batch_id IS NOT NULL THEN
7353: ozf_utility_pvt.write_conc_log('Updating Records to table OZF_FUNDS_ALL_B, OZF_ACT_BUDGETS for Batch Id: ' || p_batch_id);
7354: ozf_utility_pvt.write_conc_log('Updating Records to table OZF_FUNDS_ALL_B, OZF_ACT_BUDGETS for Batch Type: ' || p_batch_type);

Line 7832: ozf_utility_pvt.write_conc_log('deleting records from staging tables OZF_FUNDS_ALL_B_INT and OZF_ACT_BUDGETS_INT for p_batch_type='||p_batch_type);

7828: last_update_date = SYSDATE
7829: WHERE resale_batch_id = p_batch_id;
7830:
7831: -- Delete the staging tables once the records are updated in the main table.
7832: ozf_utility_pvt.write_conc_log('deleting records from staging tables OZF_FUNDS_ALL_B_INT and OZF_ACT_BUDGETS_INT for p_batch_type='||p_batch_type);
7833: DELETE FROM ozf_act_budgets_int WHERE RESALE_BATCH_ID = p_batch_id AND BATCH_TYPE = p_batch_type;
7834: DELETE FROM ozf_funds_all_b_int WHERE RESALE_BATCH_ID = p_batch_id AND BATCH_TYPE = p_batch_type;
7835:
7836: ozf_utility_pvt.write_conc_log('deleted records from staging tables OZF_FUNDS_ALL_B_INT and OZF_ACT_BUDGETS_INT for the Batch Id='||p_batch_id);

Line 7833: DELETE FROM ozf_act_budgets_int WHERE RESALE_BATCH_ID = p_batch_id AND BATCH_TYPE = p_batch_type;

7829: WHERE resale_batch_id = p_batch_id;
7830:
7831: -- Delete the staging tables once the records are updated in the main table.
7832: ozf_utility_pvt.write_conc_log('deleting records from staging tables OZF_FUNDS_ALL_B_INT and OZF_ACT_BUDGETS_INT for p_batch_type='||p_batch_type);
7833: DELETE FROM ozf_act_budgets_int WHERE RESALE_BATCH_ID = p_batch_id AND BATCH_TYPE = p_batch_type;
7834: DELETE FROM ozf_funds_all_b_int WHERE RESALE_BATCH_ID = p_batch_id AND BATCH_TYPE = p_batch_type;
7835:
7836: ozf_utility_pvt.write_conc_log('deleted records from staging tables OZF_FUNDS_ALL_B_INT and OZF_ACT_BUDGETS_INT for the Batch Id='||p_batch_id);
7837:

Line 7836: ozf_utility_pvt.write_conc_log('deleted records from staging tables OZF_FUNDS_ALL_B_INT and OZF_ACT_BUDGETS_INT for the Batch Id='||p_batch_id);

7832: ozf_utility_pvt.write_conc_log('deleting records from staging tables OZF_FUNDS_ALL_B_INT and OZF_ACT_BUDGETS_INT for p_batch_type='||p_batch_type);
7833: DELETE FROM ozf_act_budgets_int WHERE RESALE_BATCH_ID = p_batch_id AND BATCH_TYPE = p_batch_type;
7834: DELETE FROM ozf_funds_all_b_int WHERE RESALE_BATCH_ID = p_batch_id AND BATCH_TYPE = p_batch_type;
7835:
7836: ozf_utility_pvt.write_conc_log('deleted records from staging tables OZF_FUNDS_ALL_B_INT and OZF_ACT_BUDGETS_INT for the Batch Id='||p_batch_id);
7837:
7838: IF p_batch_type='TP_ACCRUAL' THEN
7839: l_vol_exists :='N';
7840: OPEN ozf_vol_int_exists_wp_csr(p_batch_id);