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

Line 2799: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

2795: ,p_to_create_utilization IN BOOLEAN
2796: ,x_return_status OUT NOCOPY VARCHAR2
2797: ,p_use_fund_staging_tables IN VARCHAR2
2798: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
2799: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
2800: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
2801: )
2802: IS
2803: l_api_name CONSTANT VARCHAR2(30) := 'Create_Utilization_Rec';

Line 3070: lx_ozf_funds_old_rectype OZF_CHARGEBACK_PVT.ozf_funds_all_b_rectype;

3066: --,p_use_fund_staging_tables IN VARCHAR2
3067: )IS
3068: l_use_fund_staging_tables VARCHAR2(1) := 'F';
3069: lx_ozf_act_budgets_tbl ozf_chargeback_pvt.ozf_act_budgets_table;
3070: lx_ozf_funds_old_rectype OZF_CHARGEBACK_PVT.ozf_funds_all_b_rectype;
3071: lx_ozf_funds_new_rectype OZF_CHARGEBACK_PVT.ozf_funds_all_b_rectype;
3072: BEGIN
3073: Create_Adj_And_Utilization(
3074: p_api_version => p_api_version

Line 3071: lx_ozf_funds_new_rectype OZF_CHARGEBACK_PVT.ozf_funds_all_b_rectype;

3067: )IS
3068: l_use_fund_staging_tables VARCHAR2(1) := 'F';
3069: lx_ozf_act_budgets_tbl ozf_chargeback_pvt.ozf_act_budgets_table;
3070: lx_ozf_funds_old_rectype OZF_CHARGEBACK_PVT.ozf_funds_all_b_rectype;
3071: lx_ozf_funds_new_rectype OZF_CHARGEBACK_PVT.ozf_funds_all_b_rectype;
3072: BEGIN
3073: Create_Adj_And_Utilization(
3074: p_api_version => p_api_version
3075: ,p_init_msg_LIST => p_init_msg_LIST

Line 3129: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

3125: ,x_utilization_id OUT NOCOPY NUMBER
3126: )IS
3127: l_use_fund_staging_tables VARCHAR2(1) := 'F';
3128: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
3129: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
3130: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
3131: l_batch_type VARCHAR2(30);
3132: BEGIN
3133: Create_Adj_And_Utilization(

Line 3197: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

3193: ,x_utilization_id OUT NOCOPY NUMBER
3194: ,p_batch_type IN VARCHAR2
3195: ,p_use_fund_staging_tables IN VARCHAR2
3196: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
3197: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
3198: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
3199: )IS
3200: l_api_name CONSTANT VARCHAR2(30) := 'Create_Adj_and_Utilization';
3201: l_api_version CONSTANT NUMBER := 1.0;

Line 3496: lx_ozf_funds_old_rectype OZF_CHARGEBACK_PVT.ozf_funds_all_b_rectype;

3492: IS
3493: l_fund_int_rec ozf_funds_pvt.fund_rec_int_type;
3494: l_use_fund_staging_tables VARCHAR2(1) := 'F';
3495: lx_ozf_act_budgets_tbl ozf_chargeback_pvt.ozf_act_budgets_table;
3496: lx_ozf_funds_old_rectype OZF_CHARGEBACK_PVT.ozf_funds_all_b_rectype;
3497: lx_ozf_funds_new_rectype OZF_CHARGEBACK_PVT.ozf_funds_all_b_rectype;
3498: BEGIN
3499: Create_Utilization(
3500: p_api_version => p_api_version

Line 3497: lx_ozf_funds_new_rectype OZF_CHARGEBACK_PVT.ozf_funds_all_b_rectype;

3493: l_fund_int_rec ozf_funds_pvt.fund_rec_int_type;
3494: l_use_fund_staging_tables VARCHAR2(1) := 'F';
3495: lx_ozf_act_budgets_tbl ozf_chargeback_pvt.ozf_act_budgets_table;
3496: lx_ozf_funds_old_rectype OZF_CHARGEBACK_PVT.ozf_funds_all_b_rectype;
3497: lx_ozf_funds_new_rectype OZF_CHARGEBACK_PVT.ozf_funds_all_b_rectype;
3498: BEGIN
3499: Create_Utilization(
3500: p_api_version => p_api_version
3501: ,p_init_msg_LIST => p_init_msg_LIST

Line 3553: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

3549: IS
3550: l_fund_int_rec ozf_funds_pvt.fund_rec_int_type;
3551: l_use_fund_staging_tables VARCHAR2(1) := 'F';
3552: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
3553: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
3554: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
3555: l_batch_type VARCHAR2(30);
3556: BEGIN
3557: Create_Utilization(

Line 3618: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

3614: ,x_msg_data OUT NOCOPY VARCHAR2
3615: ,x_msg_count OUT NOCOPY NUMBER
3616: ,p_batch_type IN VARCHAR2
3617: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
3618: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
3619: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
3620: )
3621: IS
3622: l_api_name CONSTANT VARCHAR2(30) := 'Create_Utilization';

Line 6524: -- from Interface Tables' to update the main tables ozf_funds_all_b,

6520: -- update_main_tables
6521: --
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

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 6714: FROM OZF_FUNDS_ALL_B

6710: ROLLUP_EARNED_AMT,
6711: ROLLUP_PAID_AMT,
6712: UTILIZED_AMT,
6713: ROLLUP_UTILIZED_AMT
6714: FROM OZF_FUNDS_ALL_B
6715: WHERE FUND_ID = p_fund_id;
6716:
6717: /* Obj_Fundsum changes */
6718:

Line 6770: FROM OZF_FUNDS_ALL_B

6766: AND fund_id = p_fund_id;
6767:
6768: CURSOR funds_rec_csr(p_fund_id IN NUMBER) IS
6769: SELECT FUND_TYPE
6770: FROM OZF_FUNDS_ALL_B
6771: WHERE FUND_ID = p_fund_id;
6772:
6773: -- fix for bug 16233786
6774:

Line 6865: ozf_utility_pvt.write_conc_log('Updating all the records to table OZF_FUNDS_ALL_B, OZF_ACT_BUDGETS when batch_id is null');

6861: -- For TPA Parallel Execution ER - BUG#9614703 (+)
6862: -- Update the main table with the records from staging tables.
6863:
6864: IF p_batch_id IS NULL THEN
6865: ozf_utility_pvt.write_conc_log('Updating all the records to table OZF_FUNDS_ALL_B, OZF_ACT_BUDGETS when batch_id is null');
6866: ozf_utility_pvt.write_conc_log('p_batch_type: ' || p_batch_type);
6867: ozf_utility_pvt.write_conc_log('p_batch_id: ' || p_batch_id);
6868:
6869: FOR funds_int_rec IN funds_int_csr(p_batch_type)

Line 6891: UPDATE OZF_FUNDS_ALL_B

6887: CLOSE funds_rollup_csr;
6888:
6889: ozf_utility_pvt.write_conc_log('Updating funds record '||funds_int_rec.fund_id);
6890:
6891: UPDATE OZF_FUNDS_ALL_B
6892: SET
6893: BUDGET_AMOUNT_TC = NVL(BUDGET_AMOUNT_TC,0) + NVL(funds_int_rec.BUDGET_AMOUNT_TC,0),
6894: BUDGET_AMOUNT_FC = NVL(BUDGET_AMOUNT_FC,0) + NVL(funds_int_rec.BUDGET_AMOUNT_FC,0),
6895: AVAILABLE_AMOUNT = NVL(AVAILABLE_AMOUNT,0) + NVL(funds_int_rec.AVAILABLE_AMOUNT,0),

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 7353: ozf_utility_pvt.write_conc_log('Updating Records to table OZF_FUNDS_ALL_B, OZF_ACT_BUDGETS for Batch Id: ' || p_batch_id);

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);
7355:
7356: FOR funds_int_rec2 IN funds_int_wp_csr(p_batch_id, p_batch_type)
7357: LOOP

Line 7354: ozf_utility_pvt.write_conc_log('Updating Records to table OZF_FUNDS_ALL_B, OZF_ACT_BUDGETS for Batch Type: ' || p_batch_type);

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);
7355:
7356: FOR funds_int_rec2 IN funds_int_wp_csr(p_batch_id, p_batch_type)
7357: LOOP
7358:

Line 7359: ozf_utility_pvt.write_conc_log('Updating Fund Records to table OZF_FUNDS_ALL_B for Batch Id: ' || p_batch_id);

7355:
7356: FOR funds_int_rec2 IN funds_int_wp_csr(p_batch_id, p_batch_type)
7357: LOOP
7358:
7359: ozf_utility_pvt.write_conc_log('Updating Fund Records to table OZF_FUNDS_ALL_B for Batch Id: ' || p_batch_id);
7360: ozf_utility_pvt.write_conc_log('Fund id : ' || funds_int_rec2.FUND_ID);
7361:
7362: --added for deadlock issue
7363:

Line 7379: UPDATE OZF_FUNDS_ALL_B

7375:
7376: --added for deadlock issue
7377:
7378:
7379: UPDATE OZF_FUNDS_ALL_B
7380: SET
7381: BUDGET_AMOUNT_TC = NVL(BUDGET_AMOUNT_TC,0) + NVL(funds_int_rec2.BUDGET_AMOUNT_TC,0),
7382: BUDGET_AMOUNT_FC = NVL(BUDGET_AMOUNT_FC,0) + NVL(funds_int_rec2.BUDGET_AMOUNT_FC,0),
7383: AVAILABLE_AMOUNT = NVL(AVAILABLE_AMOUNT,0) + NVL(funds_int_rec2.AVAILABLE_AMOUNT,0),

Line 7445: OZF_UTILITY_PVT.write_conc_log('Updating update_rollup_amount from UPDATE_OZF_FUNDS_ALL_B for batch_id='||p_batch_id);

7441: l_fund_rec.rollup_paid_amt := NVL(l_rollup_paid_amt,0) + NVL(funds_int_rec2.ROLLUP_PAID_AMT,0);
7442: l_fund_rec.rollup_utilized_amt := NVL(l_rollup_utilized_amt,0) + NVL(funds_int_rec2.ROLLUP_UTILIZED_AMT,0);
7443:
7444:
7445: OZF_UTILITY_PVT.write_conc_log('Updating update_rollup_amount from UPDATE_OZF_FUNDS_ALL_B for batch_id='||p_batch_id);
7446:
7447:
7448: ozf_funds_pvt.update_rollup_amount(
7449: p_api_version => l_api_version

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