DBA Data[Home] [Help]

APPS.OZF_FUND_RECONCILE_PVT dependencies on OZF_ACTBUDGETS_PVT

Line 716: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

712: l_api_version NUMBER := 1.0;
713: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
714: l_api_name VARCHAR2 (60) := 'reconcile_budget_line';
715: l_act_budget_id NUMBER;
716: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
717: l_source_from_par_flag VARCHAR2 (1);
718: l_fund_source VARCHAR2 (1) := 'T';
719: --l_parent_source_rec_obj c_parent_source_obj%ROWTYPE;
720: l_dummy NUMBER;

Line 874: ozf_actbudgets_pvt.create_act_budgets (

870: l_act_budgets_rec.approved_amount := l_act_budgets_rec.request_amount ;
871:
872: -- -- nepanda : fix for bug # 14062938 - Transfer Record to be created in case of both +ve and -ve total amount
873: IF NVL (l_parent_source_rec.total_amount, 0) <> 0 THEN
874: ozf_actbudgets_pvt.create_act_budgets (
875: p_api_version=> l_api_version
876: ,x_return_status=> l_return_status
877: ,x_msg_count=> x_msg_count
878: ,x_msg_data=> x_msg_data

Line 952: ozf_actbudgets_pvt.create_act_budgets (

948: fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');
949:
950:
951: IF NVL (l_act_budgets_rec.request_amount, 0) > 0 THEN
952: ozf_actbudgets_pvt.create_act_budgets (
953: p_api_version=> l_api_version
954: ,x_return_status=> l_return_status
955: ,x_msg_count=> x_msg_count
956: ,x_msg_data=> x_msg_data

Line 1062: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1058: l_object_id NUMBER;
1059: l_budget_id NUMBER;
1060: l_period_end_date DATE;
1061: l_period_start_date DATE;
1062: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1063: l_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1064: l_act_budget_id NUMBER;
1065: l_total_budget NUMBER;
1066: l_tot_recal_comm_amt NUMBER;

Line 1063: l_util_rec ozf_actbudgets_pvt.act_util_rec_type;

1059: l_budget_id NUMBER;
1060: l_period_end_date DATE;
1061: l_period_start_date DATE;
1062: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1063: l_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1064: l_act_budget_id NUMBER;
1065: l_total_budget NUMBER;
1066: l_tot_recal_comm_amt NUMBER;
1067: l_count NUMBER := 1;

Line 1436: ozf_actbudgets_pvt.create_act_budgets (

1432: ozf_utility_pvt.debug_message ('Create act budget: ');
1433: END IF;
1434:
1435: IF l_act_budgets_rec.request_amount > 0 THEN
1436: ozf_actbudgets_pvt.create_act_budgets (
1437: p_api_version=> l_api_version
1438: ,x_return_status=> l_return_status
1439: ,x_msg_count=> l_msg_count
1440: ,x_msg_data=> l_msg_data

Line 1737: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1733: l_full_name CONSTANT VARCHAR2 (80) := g_pkg_name
1734: || '.'
1735: || l_api_name;
1736: l_act_budget_id NUMBER;
1737: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1738: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
1739: l_converted_amt NUMBER;
1740: l_object_currency VARCHAR2(15) := p_object_currency;
1741:

Line 1738: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

1734: || '.'
1735: || l_api_name;
1736: l_act_budget_id NUMBER;
1737: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1738: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
1739: l_converted_amt NUMBER;
1740: l_object_currency VARCHAR2(15) := p_object_currency;
1741:
1742: BEGIN

Line 2168: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2164: l_api_version CONSTANT NUMBER := 1.0;
2165: l_api_name CONSTANT VARCHAR2 (50) := 'transferring_unutilized_amount';
2166: l_full_name CONSTANT VARCHAR2(60)
2167: := g_pkg_name || '.' || l_api_name;
2168: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2169: l_util_rec ozf_actbudgets_pvt.act_util_rec_type;
2170: l_original_budget NUMBER := p_original_budget;
2171: l_committed_amt NUMBER;
2172: l_earned_amt NUMBER;

Line 2169: l_util_rec ozf_actbudgets_pvt.act_util_rec_type;

2165: l_api_name CONSTANT VARCHAR2 (50) := 'transferring_unutilized_amount';
2166: l_full_name CONSTANT VARCHAR2(60)
2167: := g_pkg_name || '.' || l_api_name;
2168: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2169: l_util_rec ozf_actbudgets_pvt.act_util_rec_type;
2170: l_original_budget NUMBER := p_original_budget;
2171: l_committed_amt NUMBER;
2172: l_earned_amt NUMBER;
2173: l_msg_count NUMBER;

Line 2312: /* l_object_currency := ozf_actbudgets_pvt.get_object_currency(

2308: ,l_act_budgets_rec.status_code
2309: );
2310:
2311: l_act_budgets_rec.approved_amount := l_old_fund_obj.amount; -- in arc_Act_used_by currency
2312: /* l_object_currency := ozf_actbudgets_pvt.get_object_currency(
2313: l_old_fund_obj.object_type
2314: ,l_old_fund_obj.object_id
2315: ,x_return_status);
2316: ozf_utility_pvt.convert_currency (

Line 2342: ozf_actbudgets_pvt.create_act_budgets (

2338: IF G_DEBUG THEN
2339: ozf_utility_pvt.write_conc_log('Create transfer record for original budget: ' || l_old_fund_obj.amount);
2340: END IF;
2341:
2342: ozf_actbudgets_pvt.create_act_budgets (
2343: p_api_version=> l_api_version
2344: ,x_return_status=> l_return_status
2345: ,x_msg_count=> l_msg_count
2346: ,x_msg_data=> l_msg_data

Line 2387: ozf_actbudgets_pvt.create_act_budgets(

2383: IF G_DEBUG THEN
2384: ozf_utility_pvt.write_conc_log( 'Create budget request for new budget: ' || l_old_fund_obj.plan_curr_amount);
2385: END IF;
2386:
2387: ozf_actbudgets_pvt.create_act_budgets(
2388: p_api_version=> l_api_version
2389: ,x_return_status=> l_return_status
2390: ,x_msg_count=> x_msg_count
2391: ,x_msg_data=> x_msg_data