[Home] [Help]
824:
825: write_conc_log ('remaining adjustment amount: ' || l_util_amount);
826:
827: IF l_util_amount > 0 THEN
828: l_act_util_rec.adjustment_type :='STANDARD'; -- Seeded Data for Backdated Positive Adj
829: l_act_util_rec.adjustment_type_id := -5; -- Seeded Data for Backdated Positive Adj
830: ELSE
831: l_act_util_rec.adjustment_type :='DECREASE_EARNED'; -- Seeded Data for Backdated Negative Adj
832: l_act_util_rec.adjustment_type_id := -4; -- Seeded Data for Backdated Negative Adj
1453: IF l_offer_info.beneficiary_account_id IS NULL THEN
1454: l_act_util_rec.cust_account_id := l_cust_number;
1455: END IF;
1456:
1457: l_act_util_rec.adjustment_type :='STANDARD'; -- Seeded Data for Backdated Positive Adj
1458: l_act_util_rec.adjustment_type_id := -5; -- Seeded Data for Backdated Positive Adj
1459:
1460:
1461: --For booked orders get the total volume and the discount based on the
1698: --
1699: -- PURPOSE
1700: -- This API is called from the concurrent process Post Backdated Adjusted Offer
1701: -- PARAMETERS
1702: -- x_errbuf OUT NOCOPY VARCHAR2 STANDARD OUT NOCOPY PARAMETER
1703: -- x_retcode OUT NOCOPY NUMBER STANDARD OUT NOCOPY PARAMETER
1704: -- NOTES
1705: -- HISTORY
1706: -- 4/18/2002 Mumu Pande Create.
1699: -- PURPOSE
1700: -- This API is called from the concurrent process Post Backdated Adjusted Offer
1701: -- PARAMETERS
1702: -- x_errbuf OUT NOCOPY VARCHAR2 STANDARD OUT NOCOPY PARAMETER
1703: -- x_retcode OUT NOCOPY NUMBER STANDARD OUT NOCOPY PARAMETER
1704: -- NOTES
1705: -- HISTORY
1706: -- 4/18/2002 Mumu Pande Create.
1707: -- 07/05/2005 feliu fix following issues
2668: l_act_budgets_rec.parent_src_curr := backdate_adj_rec(i).currency_code;
2669: l_act_util_rec.utilization_type :='ADJUSTMENT';
2670:
2671: IF l_util_amount > 0 THEN
2672: l_act_util_rec.adjustment_type :='STANDARD'; -- Seeded Data for Backdated Positive Adj
2673: l_act_util_rec.adjustment_type_id := -5; -- Seeded Data for Backdated Positive Adj
2674: ELSE
2675: l_act_util_rec.adjustment_type :='DECREASE_EARNED'; -- Seeded Data for Backdated Negative Adj
2676: l_act_util_rec.adjustment_type_id := -4; -- Seeded Data for Backdated Negative Adj
2910: --
2911: -- PURPOSE
2912: --
2913: -- PARAMETERS
2914: -- x_errbuf OUT NOCOPY VARCHAR2 STANDARD OUT NOCOPY PARAMETER
2915: -- x_retcode OUT NOCOPY NUMBER STANDARD OUT NOCOPY PARAMETER
2916: -- NOTES
2917: -- HISTORY
2918: -- 7/30/2002 Mumu Pande Create.
2911: -- PURPOSE
2912: --
2913: -- PARAMETERS
2914: -- x_errbuf OUT NOCOPY VARCHAR2 STANDARD OUT NOCOPY PARAMETER
2915: -- x_retcode OUT NOCOPY NUMBER STANDARD OUT NOCOPY PARAMETER
2916: -- NOTES
2917: -- HISTORY
2918: -- 7/30/2002 Mumu Pande Create.
2919: -- 06/02/2005 Feliu rewrite to fix following issue:
3303: l_act_budgets_rec.approved_amount := l_act_budgets_rec.request_amount;
3304: l_act_budgets_rec.approved_in_currency := l_util_curr;
3305:
3306: IF l_adj_amount > 0 THEN
3307: l_act_util_rec.adjustment_type :='STANDARD'; -- Seeded Data for Backdated Positive Adj
3308: l_act_util_rec.adjustment_type_id := -7; -- Seeded Data for Backdated Positive Adj
3309: ELSE
3310: l_act_util_rec.adjustment_type :='DECREASE_EARNED'; -- Seeded Data for Backdated Negative Adj
3311: l_act_util_rec.adjustment_type_id := -6; -- Seeded Data for Backdated Negative Adj
5386: -- this adjustment is to adjust utilized amount in all cases so its not backdated adjustment
5387: -- also it is not for earned so it is not volume offer adjustment either.
5388: -- set to backdated until decision is made.
5389: IF l_adj_amount > 0 THEN
5390: l_act_util_rec.adjustment_type :='STANDARD'; -- Seeded Data for Backdated Positive Adj
5391: l_act_util_rec.adjustment_type_id := -5; -- Seeded Data for Backdated Positive Adj
5392: ELSE
5393: l_act_util_rec.adjustment_type :='DECREASE_EARNED'; -- Seeded Data for Backdated Negative Adj
5394: l_act_util_rec.adjustment_type_id := -4; -- Seeded Data for Backdated Negative Adj