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_FUNDS_ALL_B_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 6550: FROM OZF_FUNDS_ALL_B_INT

6546:
6547:
6548: CURSOR batch_id_int_csr(p_batch_type IN VARCHAR) IS
6549: SELECT DISTINCT RESALE_BATCH_ID
6550: FROM OZF_FUNDS_ALL_B_INT
6551: WHERE BATCH_TYPE = p_batch_type;
6552:
6553: CURSOR funds_int_csr (p_batch_type IN VARCHAR) IS
6554: SELECT

Line 6577: FROM OZF_FUNDS_ALL_B_INT

6573: SUM(ROLLUP_EARNED_AMT) ROLLUP_EARNED_AMT,
6574: SUM(ROLLUP_PAID_AMT) ROLLUP_PAID_AMT,
6575: SUM(UTILIZED_AMT) UTILIZED_AMT,
6576: SUM(ROLLUP_UTILIZED_AMT) ROLLUP_UTILIZED_AMT
6577: FROM OZF_FUNDS_ALL_B_INT
6578: WHERE BATCH_TYPE = p_batch_type
6579: GROUP BY RESALE_BATCH_ID, FUND_ID;
6580:
6581: CURSOR funds_int_wp_csr(p_batch_id IN NUMBER, p_batch_type IN VARCHAR) IS

Line 6605: FROM OZF_FUNDS_ALL_B_INT

6601: SUM(ROLLUP_EARNED_AMT) ROLLUP_EARNED_AMT,
6602: SUM(ROLLUP_PAID_AMT) ROLLUP_PAID_AMT,
6603: SUM(UTILIZED_AMT) UTILIZED_AMT,
6604: SUM(ROLLUP_UTILIZED_AMT) ROLLUP_UTILIZED_AMT
6605: FROM OZF_FUNDS_ALL_B_INT
6606: WHERE RESALE_BATCH_ID = p_batch_id
6607: AND BATCH_TYPE = p_batch_type
6608: GROUP BY RESALE_BATCH_ID, FUND_ID;
6609:

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 7331: DELETE FROM OZF_FUNDS_ALL_B_INT WHERE BATCH_TYPE = p_batch_type;

7327: AND status_code in ('PENDING_CLOSE','PENDING_ACCRUALS');
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';

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 7834: DELETE FROM ozf_funds_all_b_int WHERE RESALE_BATCH_ID = p_batch_id AND BATCH_TYPE = p_batch_type;

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:
7838: IF p_batch_type='TP_ACCRUAL' THEN

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);