DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PVT dependencies on OZF_ACTBUDGETS_PVT

Line 198: l_util_rec ozf_actbudgets_pvt.act_util_rec_type;

194: l_set_of_book_id NUMBER;
195: l_sob_type_code VARCHAR2 (30);
196: l_fc_code VARCHAR2 (150);
197: l_paid_amt NUMBER;
198: l_util_rec ozf_actbudgets_pvt.act_util_rec_type;
199: l_gl_posted_flag VARCHAR2(1);
200: l_offer_type VARCHAR2 (30);
201: l_volume_offer_type VARCHAR2 (30);
202: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;

Line 796: ozf_actbudgets_pvt.get_object_currency (

792: END IF;
793: END IF;
794:
795: l_plan_currency :=
796: ozf_actbudgets_pvt.get_object_currency (
797: l_utilization_rec.plan_type
798: ,l_utilization_rec.plan_id
799: ,l_return_status
800: );

Line 2194: OZF_ACTBUDGETS_PVT.update_reconcile_objfundsum(

2190: /*
2191: --Added for bug 7425189, Call update_reconcile_objfundsum for reconcile flow.
2192: IF l_utilization_rec.adjustment_desc IN (l_fund_reconc_msg,l_act_bud_cst_msg)
2193: AND l_utilization_rec.exchange_rate_date IS NOT NULL THEN
2194: OZF_ACTBUDGETS_PVT.update_reconcile_objfundsum(
2195: p_api_version => 1.0,
2196: p_init_msg_list => Fnd_Api.G_FALSE,
2197: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
2198: p_objfundsum_rec => l_objfundsum_rec,

Line 2652: ozf_actbudgets_pvt.get_object_currency (

2648: ozf_utility_pvt.debug_message ( l_full_name
2649: || ': update');
2650: END IF;
2651: l_plan_currency :=
2652: ozf_actbudgets_pvt.get_object_currency (
2653: l_utilization_rec.plan_type
2654: ,l_utilization_rec.plan_id
2655: ,l_return_status
2656: );

Line 4272: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

4268: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
4269: ,x_return_status OUT NOCOPY VARCHAR2
4270: ,x_msg_count OUT NOCOPY NUMBER
4271: ,x_msg_data OUT NOCOPY VARCHAR2
4272: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
4273: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
4274: ,x_act_budget_id OUT NOCOPY NUMBER
4275: ) IS
4276: l_utilization_id NUMBER;

Line 4273: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

4269: ,x_return_status OUT NOCOPY VARCHAR2
4270: ,x_msg_count OUT NOCOPY NUMBER
4271: ,x_msg_data OUT NOCOPY VARCHAR2
4272: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
4273: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
4274: ,x_act_budget_id OUT NOCOPY NUMBER
4275: ) IS
4276: l_utilization_id NUMBER;
4277: BEGIN

Line 4305: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

4301: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
4302: ,x_return_status OUT NOCOPY VARCHAR2
4303: ,x_msg_count OUT NOCOPY NUMBER
4304: ,x_msg_data OUT NOCOPY VARCHAR2
4305: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
4306: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
4307: ,x_act_budget_id OUT NOCOPY NUMBER
4308: ,x_utilization_id OUT NOCOPY NUMBER
4309: )IS

Line 4306: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

4302: ,x_return_status OUT NOCOPY VARCHAR2
4303: ,x_msg_count OUT NOCOPY NUMBER
4304: ,x_msg_data OUT NOCOPY VARCHAR2
4305: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
4306: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
4307: ,x_act_budget_id OUT NOCOPY NUMBER
4308: ,x_utilization_id OUT NOCOPY NUMBER
4309: )IS
4310: l_api_version CONSTANT NUMBER := 1.0;

Line 4336: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type := p_act_budgets_rec;

4332: AND transfer_type = 'UTILIZED';
4333: */
4334:
4335:
4336: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type := p_act_budgets_rec;
4337: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;
4338: l_offer_type VARCHAR2 (30);
4339: l_activity_product_id NUMBER;
4340: l_scan_value NUMBER;

Line 4337: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;

4333: */
4334:
4335:
4336: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type := p_act_budgets_rec;
4337: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;
4338: l_offer_type VARCHAR2 (30);
4339: l_activity_product_id NUMBER;
4340: l_scan_value NUMBER;
4341: l_utilized_amount NUMBER;

Line 4554: l_act_util_rec.fund_request_currency_code := OZF_ACTBUDGETS_PVT.get_object_currency (

4550: IF l_act_util_rec.plan_currency_code IS NULL
4551: OR l_act_util_rec.plan_currency_code = FND_API.G_MISS_CHAR THEN
4552: l_act_util_rec.plan_currency_code := l_act_budgets_rec.request_currency;
4553: END IF;
4554: l_act_util_rec.fund_request_currency_code := OZF_ACTBUDGETS_PVT.get_object_currency (
4555: l_act_budgets_rec.arc_act_budget_used_by
4556: ,l_act_budgets_rec.act_budget_used_by_id
4557: ,l_return_status
4558: );