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

Line 2776: -- 27/10/2009 muthsubr Added px_ozf_act_budgets_tbl, p_use_fund_staging_tables

2772: -- PARAMETERS
2773: --
2774: --
2775: -- NOTES
2776: -- 27/10/2009 muthsubr Added px_ozf_act_budgets_tbl, p_use_fund_staging_tables
2777: -- px_ozf_funds_old_rectype, px_ozf_funds_new_rectype
2778: -- for bug#8867381.
2779: -- 29/11/2010 muthsubr Altered px_ozf_funds_new_rectype to px_ozf_funds_new_tbl
2780: -- for JMS ER Bug#9614703.

Line 2798: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table

2794: ,p_justification IN VARCHAR2
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

Line 2978: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.

2974: l_pric_price_adj_rec.liSt_line_id := NULL;
2975:
2976:
2977: -- For Bug#8867381, introduced p_use_fund_staging_tables for staging table impln of chargeback flow
2978: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
2979: -- and px_ozf_funds_old_rectype for taking the funds old values
2980: -- For JMS ER Bug#9614703
2981: -- and changed px_ozf_funds_new_rectype to px_ozf_funds_new_tbl.
2982:

Line 2998: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl

2994: ,x_msg_count => l_msg_count
2995: ,x_utilization_id => l_utilization_id ---ER 13333298
2996: ,p_batch_type => p_batch_type
2997: ,p_use_fund_staging_tables => p_use_fund_staging_tables
2998: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl
2999: ,px_ozf_funds_old_rectype => px_ozf_funds_old_rectype
3000: ,px_ozf_funds_new_tbl => px_ozf_funds_new_tbl -- For JMS ER Bug#9614703
3001: );
3002: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 3046: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.

3042: -- It them inserts the price adjustmetns AND utilization
3043: --
3044: -- PARAMETERS
3045: -- p_use_fund_staging_tables for staging table impln of chargeback flow
3046: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
3047: -- and px_ozf_funds_old_rectype for taking the funds old values
3048: -- and px_ozf_funds_new_rectype for taking the new values after updation.
3049: --
3050: -- NOTES

Line 3069: lx_ozf_act_budgets_tbl ozf_chargeback_pvt.ozf_act_budgets_table;

3065: ,x_msg_count OUT NOCOPY NUMBER
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(

Line 3086: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl

3082: ,x_return_status => x_return_status
3083: ,x_msg_data => x_msg_data
3084: ,x_msg_count => x_msg_count
3085: ,p_use_fund_staging_tables => l_use_fund_staging_tables
3086: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl
3087: ,px_ozf_funds_old_rectype => lx_ozf_funds_old_rectype
3088: ,px_ozf_funds_new_rectype => lx_ozf_funds_new_rectype
3089: );
3090: END Create_Adj_And_Utilization;

Line 3104: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.

3100: -- It them inserts the price adjustmetns AND utilization
3101: --
3102: -- PARAMETERS
3103: -- p_use_fund_staging_tables for staging table impln of chargeback flow
3104: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
3105: -- and px_ozf_funds_old_rectype for taking the funds old values
3106: -- and px_ozf_funds_new_tbl for taking the new values after updation.
3107: --
3108: -- NOTES

Line 3128: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;

3124: ,x_msg_count OUT NOCOPY NUMBER
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

Line 3148: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl

3144: ,x_msg_count => x_msg_count
3145: ,x_utilization_id => x_utilization_id ---ER 13333298
3146: ,p_batch_type => l_batch_type
3147: ,p_use_fund_staging_tables => l_use_fund_staging_tables
3148: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl
3149: ,px_ozf_funds_old_rectype => lx_ozf_funds_old_rectype
3150: ,px_ozf_funds_new_tbl => lx_ozf_funds_new_tbl
3151: );
3152: END Create_Adj_And_Utilization;

Line 3170: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.

3166: -- p_adj_rec IN ozf_chargeback_price_adj_all%rowtype
3167: -- p_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type
3168: -- p_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
3169: -- p_use_fund_staging_tables for staging table impln of chargeback flow
3170: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
3171: -- and px_ozf_funds_old_rectype for taking the funds old values
3172: -- and px_ozf_funds_new_rectype for taking the new values after updation.
3173: --
3174: -- NOTES

Line 3175: -- 27/10/2009 muthsubr Added px_ozf_act_budgets_tbl, p_use_fund_staging_tables

3171: -- and px_ozf_funds_old_rectype for taking the funds old values
3172: -- and px_ozf_funds_new_rectype for taking the new values after updation.
3173: --
3174: -- NOTES
3175: -- 27/10/2009 muthsubr Added px_ozf_act_budgets_tbl, p_use_fund_staging_tables
3176: -- px_ozf_funds_old_rectype, px_ozf_funds_new_rectype
3177: -- for bug#8867381.
3178: -- 29/11/2010 muthsubr Altered px_ozf_funds_new_rectype to px_ozf_funds_new_tbl
3179: -- for bug#9614703 for JMS ER.

Line 3196: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table

3192: ,x_msg_count OUT NOCOPY NUMBER
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';

Line 3368: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.

3364:
3365: BEGIN
3366: --
3367: -- For Bug#8867381, introduced p_use_fund_staging_tables for staging table impln of chargeback flow
3368: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
3369: -- and px_ozf_funds_old_rectype for taking the funds old values
3370: -- For JMS ER Bug#9614703
3371: -- and changed px_ozf_funds_new_rectype to px_ozf_funds_new_tbl.
3372: OZF_FUND_ADJUSTMENT_PVT.Process_Act_Budgets (

Line 3382: px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl,

3378: x_act_budget_id => l_act_budget_id,
3379: x_utilized_amount => l_utilized_amount,
3380: p_batch_type => p_batch_type,
3381: p_use_fund_staging_tables => p_use_fund_staging_tables,
3382: px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl,
3383: px_ozf_funds_old_rectype => px_ozf_funds_old_rectype,
3384: px_ozf_funds_new_tbl => px_ozf_funds_new_tbl, -- For JMS ER Bug#9614703
3385: x_utilization_id => l_utilization_id
3386: );

Line 3495: lx_ozf_act_budgets_tbl ozf_chargeback_pvt.ozf_act_budgets_table;

3491: )
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(

Line 3514: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl

3510: ,p_approver_id => p_approver_id
3511: ,x_return_status => x_return_status
3512: ,x_msg_data => x_msg_data
3513: ,x_msg_count => x_msg_count
3514: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl
3515: ,px_ozf_funds_old_rectype => lx_ozf_funds_old_rectype
3516: ,px_ozf_funds_new_rectype => lx_ozf_funds_new_rectype
3517: );
3518: END Create_Utilization;

Line 3552: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;

3548: )
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

Line 3573: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl

3569: ,x_return_status => x_return_status
3570: ,x_msg_data => x_msg_data
3571: ,x_msg_count => x_msg_count
3572: ,p_batch_type => l_batch_type
3573: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl
3574: ,px_ozf_funds_old_rectype => lx_ozf_funds_old_rectype
3575: ,px_ozf_funds_new_tbl => lx_ozf_funds_new_tbl
3576: );
3577: END Create_Utilization;

Line 3589: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.

3585: -- This procedure creates utilization
3586: --
3587: -- PARAMETERS
3588: -- p_use_fund_staging_tables for staging table impln of chargeback flow
3589: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
3590: -- and px_ozf_funds_old_rectype for taking the funds old values
3591: -- and px_ozf_funds_new_rectype for taking the new values after updation.
3592:
3593: --

Line 3595: -- 27/10/2009 muthsubr Added px_ozf_act_budgets_tbl, p_use_fund_staging_tables

3591: -- and px_ozf_funds_new_rectype for taking the new values after updation.
3592:
3593: --
3594: -- NOTES
3595: -- 27/10/2009 muthsubr Added px_ozf_act_budgets_tbl, p_use_fund_staging_tables
3596: -- px_ozf_funds_old_rectype, px_ozf_funds_new_rectype
3597: -- for bug#8867381.
3598: -- 29/11/2010 muthsubr Altered px_ozf_funds_new_rectype to px_ozf_funds_new_tbl
3599: -- for JMS ER Bug#9614703.

Line 3617: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table

3613: ,x_return_status OUT NOCOPY VARCHAR2
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

Line 3791: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.

3787: IF l_line_int_rec.duplicated_adjustment_id = -1 THEN
3788: -- Create utilization using int rec
3789:
3790: -- For Bug#8867381, introduced p_use_fund_staging_tables for staging table impln of chargeback flow
3791: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
3792: -- and px_ozf_funds_old_rectype for taking the funds old values
3793: -- For JMS ER Bug#9614703
3794: -- and changed px_ozf_funds_new_rectype to px_ozf_funds_new_tbl.
3795: Create_Utilization_record(

Line 3811: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl

3807: ,p_justification => l_justification
3808: ,p_to_create_utilization =>l_to_create_utilization
3809: ,x_return_status => l_return_status
3810: ,p_use_fund_staging_tables => p_use_fund_staging_tables
3811: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl
3812: ,px_ozf_funds_old_rectype => px_ozf_funds_old_rectype
3813: ,px_ozf_funds_new_tbl => px_ozf_funds_new_tbl -- JMS ER Bug#9614703
3814: );
3815: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3838: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.

3834: -- AND the create one FOR the current int rec.
3835: -- creat utilization using int rec
3836:
3837: -- For Bug#8867381, introduced p_use_fund_staging_tables for staging table impln of chargeback flow
3838: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
3839: -- and px_ozf_funds_old_rectype for taking the funds old values
3840: -- For JMS ER Bug#9614703
3841: -- and changed px_ozf_funds_new_rectype to px_ozf_funds_new_tbl.
3842: Create_Utilization_record(

Line 3858: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl

3854: ,p_justification => l_justification
3855: ,p_to_create_utilization =>l_to_create_utilization
3856: ,x_return_status => l_return_status
3857: ,p_use_fund_staging_tables => p_use_fund_staging_tables
3858: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl
3859: ,px_ozf_funds_old_rectype => px_ozf_funds_old_rectype
3860: ,px_ozf_funds_new_tbl => px_ozf_funds_new_tbl -- JMS ER Bug#9614703
3861: );
3862: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3906: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.

3902: l_line_int_rec.calculated_price := l_dup_adj_rec.priced_unit_price;
3903:
3904:
3905: -- For Bug#8867381, introduced p_use_fund_staging_tables for staging table impln of chargeback flow
3906: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
3907: -- and px_ozf_funds_old_rectype for taking the funds old values
3908: -- For JMS ER Bug#9614703
3909: -- and changed px_ozf_funds_new_rectype to px_ozf_funds_new_tbl.
3910: Create_Utilization_record(

Line 3926: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl

3922: ,p_justification => l_justification
3923: ,p_to_create_utilization =>l_to_create_utilization
3924: ,x_return_status => l_return_status
3925: ,p_use_fund_staging_tables => p_use_fund_staging_tables
3926: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl
3927: ,px_ozf_funds_old_rectype => px_ozf_funds_old_rectype
3928: ,px_ozf_funds_new_tbl => px_ozf_funds_new_tbl -- JMS ER Bug#9614703
3929: );
3930: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3952: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.

3948: END IF;
3949: -- Create utilization using int rec
3950:
3951: -- For Bug#8867381, introduced p_use_fund_staging_tables for staging table impln of chargeback flow
3952: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
3953: -- and px_ozf_funds_old_rectype for taking the funds old values
3954: -- For JMS ER Bug#9614703
3955: -- and changed px_ozf_funds_new_rectype to px_ozf_funds_new_tbl.
3956: Create_Utilization_record(

Line 3972: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl

3968: ,p_justification => l_justification
3969: ,p_to_create_utilization =>l_to_create_utilization
3970: ,x_return_status => l_return_status
3971: ,p_use_fund_staging_tables => p_use_fund_staging_tables
3972: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl
3973: ,px_ozf_funds_old_rectype => px_ozf_funds_old_rectype
3974: ,px_ozf_funds_new_tbl => px_ozf_funds_new_tbl -- JMS ER Bug#9614703
3975: );
3976: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 6525: -- ozf_act_budgets with the records from staging 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
6529: -- 30-OCT-2009 muthsubr Created for the bug#8867381.

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 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 6972: UPDATE ozf_act_budgets

6968:
6969: FOR budgets_int_rec IN budgets_int_csr(p_batch_type)
6970: LOOP
6971:
6972: UPDATE ozf_act_budgets
6973: SET request_amount = NVL(request_amount, 0) + NVL(budgets_int_rec.REQUEST_AMOUNT,0)
6974: ,src_curr_request_amt = NVL(src_curr_request_amt, 0) + NVL(budgets_int_rec.SRC_CURR_REQUEST_AMT,0)
6975: ,approved_amount = NVL(approved_amount, 0) + NVL(budgets_int_rec.APPROVED_AMOUNT,0)
6976: ,approved_original_amount = NVL(approved_original_amount, 0) + NVL(budgets_int_rec.APPROVED_ORIGINAL_AMOUNT,0)

Line 6985: ozf_utility_pvt.write_conc_log('Updating ozf_act_budgets record ' || budgets_int_rec.ACTIVITY_BUDGET_ID);

6981: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
6982: ,object_version_number = NVL (object_version_number,0) + 1
6983: WHERE activity_budget_id = budgets_int_rec.ACTIVITY_BUDGET_ID;
6984:
6985: ozf_utility_pvt.write_conc_log('Updating ozf_act_budgets record ' || budgets_int_rec.ACTIVITY_BUDGET_ID);
6986:
6987: END LOOP;
6988:
6989:

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

7462: LOOP
7463:
7464: l_activity_budget_id := budgets_int_rec2.ACTIVITY_BUDGET_ID;
7465:
7466: ozf_utility_pvt.write_conc_log('Updating Budget Records to table OZF_ACT_BUDGETS for Batch Id: ' || p_batch_id);
7467: ozf_utility_pvt.write_conc_log('Activity Budget id1 : ' || l_activity_budget_id);
7468: UPDATE ozf_act_budgets
7469: SET request_amount = NVL(request_amount, 0) + NVL(budgets_int_rec2.REQUEST_AMOUNT,0)
7470: ,src_curr_request_amt = NVL(src_curr_request_amt, 0) + NVL(budgets_int_rec2.SRC_CURR_REQUEST_AMT,0)

Line 7468: UPDATE ozf_act_budgets

7464: l_activity_budget_id := budgets_int_rec2.ACTIVITY_BUDGET_ID;
7465:
7466: ozf_utility_pvt.write_conc_log('Updating Budget Records to table OZF_ACT_BUDGETS for Batch Id: ' || p_batch_id);
7467: ozf_utility_pvt.write_conc_log('Activity Budget id1 : ' || l_activity_budget_id);
7468: UPDATE ozf_act_budgets
7469: SET request_amount = NVL(request_amount, 0) + NVL(budgets_int_rec2.REQUEST_AMOUNT,0)
7470: ,src_curr_request_amt = NVL(src_curr_request_amt, 0) + NVL(budgets_int_rec2.SRC_CURR_REQUEST_AMT,0)
7471: ,approved_amount = NVL(approved_amount, 0) + NVL(budgets_int_rec2.APPROVED_AMOUNT,0)
7472: ,approved_original_amount = NVL(approved_original_amount, 0) + NVL(budgets_int_rec2.APPROVED_ORIGINAL_AMOUNT,0)

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