DBA Data[Home] [Help]

APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_ACTBUDGETS_PVT

Line 303: G_OFFER_CURRENCY := OZF_ACTBUDGETS_PVT.Get_Object_Currency(

299: -- reduced
300: l_fu_new_amt_rem := l_fu_old_amt_rem + p_fu_diff_acctd_amt_rem;
301: -- Functional Currency and Universal Currency are derived in the calling routine
302: --- Derive Offer Currency Here
303: G_OFFER_CURRENCY := OZF_ACTBUDGETS_PVT.Get_Object_Currency(
304: p_object => l_fu_plan_type
305: ,p_object_id => l_fu_plan_id
306: ,x_return_status => l_return_status
307: );

Line 1711: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1707: l_fund_curr_code VARCHAR2(15);
1708: l_plan_curr_code VARCHAR2(15);
1709: l_accrual_curr_code VARCHAR2(15);
1710:
1711: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1712: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
1713:
1714: --Bug5333804
1715: -- Reverted back for Bugfix 5154157

Line 1712: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

1708: l_plan_curr_code VARCHAR2(15);
1709: l_accrual_curr_code VARCHAR2(15);
1710:
1711: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1712: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
1713:
1714: --Bug5333804
1715: -- Reverted back for Bugfix 5154157
1716: CURSOR csr_source_fund(cv_offer_id IN NUMBER, cv_fund_id IN NUMBER) IS

Line 1774: l_plan_curr_code := OZF_ACTBUDGETS_PVT.Get_Object_Currency(

1770: FETCH csr_source_fund INTO l_fund_id, l_fund_curr_code, l_fu_plan_type, l_fu_plan_id, l_accrual_curr_code;
1771:
1772: -- bug 5059770
1773: -- Modified for Bugfix 5333804
1774: l_plan_curr_code := OZF_ACTBUDGETS_PVT.Get_Object_Currency(
1775: p_object => l_fu_plan_type
1776: ,p_object_id => l_fu_plan_id
1777: ,x_return_status => l_return_status
1778: );

Line 4138: l_offer_currency := OZF_ACTBUDGETS_PVT.Get_Object_Currency(

4134: l_performance_flag := FND_API.g_false;
4135: END IF;
4136: END IF;
4137: ELSIF l_requirement_type = 'AMOUNT' THEN
4138: l_offer_currency := OZF_ACTBUDGETS_PVT.Get_Object_Currency(
4139: p_object => 'OFFR'
4140: ,p_object_id => p_offer_id
4141: ,x_return_status => l_return_status
4142: );

Line 4257: l_offer_currency := OZF_ACTBUDGETS_PVT.Get_Object_Currency(

4253: l_performance_flag := FND_API.g_false;
4254: END IF;
4255: END IF;
4256: ELSIF l_requirement_type = 'AMOUNT' THEN
4257: l_offer_currency := OZF_ACTBUDGETS_PVT.Get_Object_Currency(
4258: p_object => 'OFFR'
4259: ,p_object_id => p_offer_id
4260: ,x_return_status => l_return_status
4261: );

Line 6680: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

6676: l_prorate_earnings_flag VARCHAR2(1);
6677: l_util_id NUMBER;
6678: l_ignore NUMBER;
6679: l_funds_util_flt funds_util_flt_type := p_funds_util_flt;
6680: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
6681: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
6682: l_act_budget_id NUMBER;
6683: l_total_pay_over_flag BOOLEAN;
6684: l_original_old_total_amount NUMBER;

Line 6681: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

6677: l_util_id NUMBER;
6678: l_ignore NUMBER;
6679: l_funds_util_flt funds_util_flt_type := p_funds_util_flt;
6680: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
6681: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
6682: l_act_budget_id NUMBER;
6683: l_total_pay_over_flag BOOLEAN;
6684: l_original_old_total_amount NUMBER;
6685: l_convert_exchange_rate NUMBER;

Line 8785: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

8781: l_utilization_id NUMBER;
8782: l_total_scan_unit NUMBER;
8783: l_old_scan_unit_rem NUMBER;
8784: l_new_scan_unit_rem NUMBER;
8785: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
8786: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
8787:
8788: CURSOR csr_scan_over_utilized(cv_claim_id IN NUMBER) IS
8789: SELECT lu.claim_line_util_id

Line 8786: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

8782: l_total_scan_unit NUMBER;
8783: l_old_scan_unit_rem NUMBER;
8784: l_new_scan_unit_rem NUMBER;
8785: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
8786: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
8787:
8788: CURSOR csr_scan_over_utilized(cv_claim_id IN NUMBER) IS
8789: SELECT lu.claim_line_util_id
8790: ,lu.activity_product_id