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_ADJUSTMENT_EXT_PVT dependencies on OZF_ACCRUAL_ENGINE

Line 782: --nirprasa,ER 8399134 replace sysdate by OZF_ACCRUAL_ENGINE.G_FAE_START_DATE

778: l_act_budgets_rec.transfer_type := 'UTILIZED';
779:
780: l_act_util_rec.utilization_type :='ADJUSTMENT';
781: l_act_util_rec.product_level_type := 'PRODUCT';
782: --nirprasa,ER 8399134 replace sysdate by OZF_ACCRUAL_ENGINE.G_FAE_START_DATE
783: l_act_util_rec.adjustment_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE; --SYSDATE;
784: l_act_util_rec.cust_account_id := l_offer_info.beneficiary_account_id;
785:
786: FOR j IN l_order_line_tbl.first .. l_order_line_tbl.last

Line 783: l_act_util_rec.adjustment_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE; --SYSDATE;

779:
780: l_act_util_rec.utilization_type :='ADJUSTMENT';
781: l_act_util_rec.product_level_type := 'PRODUCT';
782: --nirprasa,ER 8399134 replace sysdate by OZF_ACCRUAL_ENGINE.G_FAE_START_DATE
783: l_act_util_rec.adjustment_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE; --SYSDATE;
784: l_act_util_rec.cust_account_id := l_offer_info.beneficiary_account_id;
785:
786: FOR j IN l_order_line_tbl.first .. l_order_line_tbl.last
787: LOOP

Line 878: ,p_conv_date => OZF_ACCRUAL_ENGINE.G_FAE_START_DATE

874: ozf_utility_pvt.convert_currency (x_return_status => x_return_status
875: ,p_from_currency => l_order_line_tbl(j).transactional_curr_code
876: ,p_to_currency => l_offer_info.transaction_currency_code
877: ,p_conv_type => l_exchange_rate_type
878: ,p_conv_date => OZF_ACCRUAL_ENGINE.G_FAE_START_DATE
879: ,p_from_amount => l_util_amount
880: ,x_to_amount => l_conv_util_amount
881: ,x_rate => l_rate
882: );

Line 984: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

980: IF l_util_amount > 0 THEN
981: l_act_util_rec.adjustment_type :='STANDARD'; -- Seeded Data for Backdated Positive Adj
982: l_act_util_rec.adjustment_type_id := -5; -- Seeded Data for Backdated Positive Adj
983: --nirprasa,ER 8399134
984: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
985: ELSE
986: l_act_util_rec.adjustment_type :='DECREASE_EARNED'; -- Seeded Data for Backdated Negative Adj
987: l_act_util_rec.adjustment_type_id := -4; -- Seeded Data for Backdated Negative Adj
988: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

Line 988: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

984: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
985: ELSE
986: l_act_util_rec.adjustment_type :='DECREASE_EARNED'; -- Seeded Data for Backdated Negative Adj
987: l_act_util_rec.adjustment_type_id := -4; -- Seeded Data for Backdated Negative Adj
988: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
989: END IF;
990:
991:
992:

Line 1703: ,p_conv_date => OZF_ACCRUAL_ENGINE.G_FAE_START_DATE

1699:
1700: --Since it is increased earned always so no change for
1701: ozf_utility_pvt.convert_currency (x_return_status => l_return_status
1702: ,p_conv_type => l_conv_type --7030415
1703: ,p_conv_date => OZF_ACCRUAL_ENGINE.G_FAE_START_DATE
1704: ,p_from_currency => l_order_line_tbl(j).transactional_curr_code
1705: ,p_to_currency => l_offer_info.transaction_currency_code
1706: ,p_from_amount => l_unit_selling_price
1707: ,x_to_amount => l_conv_price

Line 1881: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

1877: l_utilization_amount := NVL(l_utilization_amount,0) - NVL(l_adj_amount,0);
1878:
1879: l_act_budgets_rec.request_amount := l_utilization_amount;
1880: l_act_budgets_rec.approved_amount := l_utilization_amount;
1881: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
1882:
1883: ----end of booked orders
1884:
1885: write_conc_log('calling ozf_fund_adjustment_pvt.process_act_budgets');

Line 4650: ,p_conv_date => OZF_ACCRUAL_ENGINE.G_FAE_START_DATE

4646:
4647: --Since it is increased earned always so no change for
4648: ozf_utility_pvt.convert_currency (x_return_status => l_return_status
4649: ,p_conv_type => l_conv_type --7030415
4650: ,p_conv_date => OZF_ACCRUAL_ENGINE.G_FAE_START_DATE
4651: ,p_from_currency => p_line_rec.transactional_curr_code
4652: ,p_to_currency => l_offer_info.transaction_currency_code
4653: ,p_from_amount => p_line_rec.unit_selling_price
4654: ,x_to_amount => l_conv_price

Line 4693: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

4689: write_conc_log('l_utilization_amount : '||l_utilization_amount);
4690:
4691: l_act_budgets_rec.request_amount := l_utilization_amount;
4692: l_act_budgets_rec.approved_amount := l_utilization_amount;
4693: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
4694:
4695: IF l_utilization_amount > 0 THEN
4696: l_act_util_rec.adjustment_type :='STANDARD'; -- Seeded Data for Backdated Positive Adj
4697: l_act_util_rec.adjustment_type_id := -5; -- Seeded Data for Backdated Positive Adj

Line 4699: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

4695: IF l_utilization_amount > 0 THEN
4696: l_act_util_rec.adjustment_type :='STANDARD'; -- Seeded Data for Backdated Positive Adj
4697: l_act_util_rec.adjustment_type_id := -5; -- Seeded Data for Backdated Positive Adj
4698: --nirprasa,ER 8399134
4699: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
4700: ELSE
4701: l_act_util_rec.adjustment_type :='DECREASE_EARNED'; -- Seeded Data for Backdated Negative Adj
4702: l_act_util_rec.adjustment_type_id := -4; -- Seeded Data for Backdated Negative Adj
4703: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

Line 4703: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

4699: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
4700: ELSE
4701: l_act_util_rec.adjustment_type :='DECREASE_EARNED'; -- Seeded Data for Backdated Negative Adj
4702: l_act_util_rec.adjustment_type_id := -4; -- Seeded Data for Backdated Negative Adj
4703: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
4704: END IF;
4705:
4706: ----end of booked orders
4707:

Line 4954: --nirprasa,ER 8399134 replace sysdate by OZF_ACCRUAL_ENGINE.G_FAE_START_DATE

4950: l_act_budgets_rec.transfer_type := 'UTILIZED';
4951:
4952: l_act_util_rec.utilization_type :='ADJUSTMENT';
4953: l_act_util_rec.product_level_type := 'PRODUCT';
4954: --nirprasa,ER 8399134 replace sysdate by OZF_ACCRUAL_ENGINE.G_FAE_START_DATE
4955: l_act_util_rec.adjustment_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
4956: l_act_util_rec.cust_account_id := l_offer_info.beneficiary_account_id;
4957:
4958: IF g_debug_flag = 'Y' THEN

Line 4955: l_act_util_rec.adjustment_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

4951:
4952: l_act_util_rec.utilization_type :='ADJUSTMENT';
4953: l_act_util_rec.product_level_type := 'PRODUCT';
4954: --nirprasa,ER 8399134 replace sysdate by OZF_ACCRUAL_ENGINE.G_FAE_START_DATE
4955: l_act_util_rec.adjustment_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
4956: l_act_util_rec.cust_account_id := l_offer_info.beneficiary_account_id;
4957:
4958: IF g_debug_flag = 'Y' THEN
4959: write_conc_log('order header id: ' || p_ldets_rec.list_header_id);

Line 5241: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

5237: IF l_util_amount > 0 THEN
5238: l_act_util_rec.adjustment_type :='STANDARD'; -- Seeded Data for Backdated Positive Adj
5239: l_act_util_rec.adjustment_type_id := -5; -- Seeded Data for Backdated Positive Adj
5240: --nirprasa,ER 8399134
5241: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
5242: ELSE
5243: l_act_util_rec.adjustment_type :='DECREASE_EARNED'; -- Seeded Data for Backdated Negative Adj
5244: l_act_util_rec.adjustment_type_id := -4; -- Seeded Data for Backdated Negative Adj
5245: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

Line 5245: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

5241: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
5242: ELSE
5243: l_act_util_rec.adjustment_type :='DECREASE_EARNED'; -- Seeded Data for Backdated Negative Adj
5244: l_act_util_rec.adjustment_type_id := -4; -- Seeded Data for Backdated Negative Adj
5245: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
5246: END IF;
5247:
5248:
5249: IF l_util_amount <> 0 THEN

Line 5452: --nirprasa,ER 8399134 replace sysdate by OZF_ACCRUAL_ENGINE.G_FAE_START_DATE

5448: l_act_budgets_rec.transfer_type := 'UTILIZED';
5449:
5450: l_act_util_rec.utilization_type :='ADJUSTMENT';
5451: l_act_util_rec.product_level_type := 'PRODUCT';
5452: --nirprasa,ER 8399134 replace sysdate by OZF_ACCRUAL_ENGINE.G_FAE_START_DATE
5453: l_act_util_rec.adjustment_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
5454: l_act_util_rec.cust_account_id := l_offer_info.beneficiary_account_id;
5455:
5456: IF g_debug_flag = 'Y' THEN

Line 5453: l_act_util_rec.adjustment_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

5449:
5450: l_act_util_rec.utilization_type :='ADJUSTMENT';
5451: l_act_util_rec.product_level_type := 'PRODUCT';
5452: --nirprasa,ER 8399134 replace sysdate by OZF_ACCRUAL_ENGINE.G_FAE_START_DATE
5453: l_act_util_rec.adjustment_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
5454: l_act_util_rec.cust_account_id := l_offer_info.beneficiary_account_id;
5455:
5456: IF g_debug_flag = 'Y' THEN
5457: write_conc_log('List header id: ' || p_ldets_rec.list_header_id);

Line 5637: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

5633: IF l_util_amount > 0 THEN
5634: l_act_util_rec.adjustment_type :='STANDARD'; -- Seeded Data for Backdated Positive Adj
5635: l_act_util_rec.adjustment_type_id := -5; -- Seeded Data for Backdated Positive Adj
5636: --nirprasa,ER 8399134
5637: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
5638: ELSE
5639: l_act_util_rec.adjustment_type :='DECREASE_EARNED'; -- Seeded Data for Backdated Negative Adj
5640: l_act_util_rec.adjustment_type_id := -4; -- Seeded Data for Backdated Negative Adj
5641: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

Line 5641: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

5637: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
5638: ELSE
5639: l_act_util_rec.adjustment_type :='DECREASE_EARNED'; -- Seeded Data for Backdated Negative Adj
5640: l_act_util_rec.adjustment_type_id := -4; -- Seeded Data for Backdated Negative Adj
5641: l_act_util_rec.exchange_rate_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
5642: END IF;
5643:
5644:
5645:

Line 6644: p_conv_date => OZF_ACCRUAL_ENGINE.G_FAE_START_DATE,

6640: x_return_status => l_return_status,
6641: p_from_currency => backdate_adj_rec(i).plan_currency_code,
6642: p_to_currency => backdate_adj_rec(i).currency_code,
6643: p_conv_type => backdate_adj_rec(i).exchange_rate_type, -- nirprasa added for bug 7030415
6644: p_conv_date => OZF_ACCRUAL_ENGINE.G_FAE_START_DATE,
6645: p_from_amount => l_util_amount,
6646: x_to_amount => l_converted_util_amount,
6647: x_rate => l_rate
6648: );

Line 6707: --nirprasa,12.2 instead of sysdate use OZF_ACCRUAL_ENGINE.G_FAE_START_DATE

6703: l_act_util_rec.cust_account_id := backdate_adj_rec(i).cust_account_id;
6704: l_act_util_rec.org_id := l_org_id; -- Added for bugfix 6278466
6705: l_act_util_rec.price_adjustment_id := backdate_adj_rec(i).price_adjustment_id;
6706: --l_act_util_rec.volume_offer_tiers_id := backdate_adj_rec(i).volume_offer_tiers_id;
6707: --nirprasa,12.2 instead of sysdate use OZF_ACCRUAL_ENGINE.G_FAE_START_DATE
6708: l_act_util_rec.adjustment_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
6709: --SYSDATE;
6710: -- yzhao: 07/06/2004 11.5.10 populate order id, line id, original utilization id
6711: l_act_util_rec.object_type := backdate_adj_rec(i).object_type;

Line 6708: l_act_util_rec.adjustment_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;

6704: l_act_util_rec.org_id := l_org_id; -- Added for bugfix 6278466
6705: l_act_util_rec.price_adjustment_id := backdate_adj_rec(i).price_adjustment_id;
6706: --l_act_util_rec.volume_offer_tiers_id := backdate_adj_rec(i).volume_offer_tiers_id;
6707: --nirprasa,12.2 instead of sysdate use OZF_ACCRUAL_ENGINE.G_FAE_START_DATE
6708: l_act_util_rec.adjustment_date := OZF_ACCRUAL_ENGINE.G_FAE_START_DATE;
6709: --SYSDATE;
6710: -- yzhao: 07/06/2004 11.5.10 populate order id, line id, original utilization id
6711: l_act_util_rec.object_type := backdate_adj_rec(i).object_type;
6712: l_act_util_rec.object_id := backdate_adj_rec(i).object_id;

Line 7111: l_fund_amt_tbl ozf_accrual_engine.ozf_fund_amt_tbl_type;

7107: x_return_status OUT NOCOPY VARCHAR2,
7108: x_msg_count OUT NOCOPY NUMBER,
7109: x_msg_data OUT NOCOPY VARCHAR2
7110: ) IS
7111: l_fund_amt_tbl ozf_accrual_engine.ozf_fund_amt_tbl_type;
7112: l_api_name VARCHAR2(30):= 'process_accrual';
7113: l_full_name VARCHAR2(60):= g_pkg_name ||'.'||l_api_name||' : ' ;
7114: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type := p_act_budgets_rec;
7115: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;

Line 7187: ozf_accrual_engine.calculate_accrual_amount (

7183: FETCH c_adj_info INTO l_adj_info;
7184: CLOSE c_adj_info;
7185: END IF;
7186:
7187: ozf_accrual_engine.calculate_accrual_amount (
7188: x_return_status=> x_return_status,
7189: p_src_id=> p_qp_list_header_id,
7190: p_earned_amt=> p_earned_amt,
7191: -- yzhao: 02/23/2004 11.5.10 added following 3 parameters to return customer-product qualified budgets only

Line 8182: ,p_conv_date => OZF_ACCRUAL_ENGINE.G_FAE_START_DATE

8178:
8179:
8180: ozf_utility_pvt.convert_currency (x_return_status => l_return_status
8181: ,p_conv_type => l_conv_type --7030415
8182: ,p_conv_date => OZF_ACCRUAL_ENGINE.G_FAE_START_DATE
8183: --l_order_line_info.actual_shipment_date
8184: ,p_from_currency => l_order_line_info.transactional_curr_code
8185: ,p_to_currency => l_transaction_currency_code
8186: ,p_from_amount => l_selling_price