DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT dependencies on OZF_ACTBUDGETS_PVT

Line 1: PACKAGE BODY ozf_actbudgets_pvt AS

1: PACKAGE BODY ozf_actbudgets_pvt AS
2: /*$Header: ozfvbdgb.pls 120.21.12010000.4 2008/10/31 09:27:55 nirprasa ship $*/
3: -- NAME
4: -- OZF_ACTBUDGETS_PVT
5: --

Line 4: -- OZF_ACTBUDGETS_PVT

1: PACKAGE BODY ozf_actbudgets_pvt AS
2: /*$Header: ozfvbdgb.pls 120.21.12010000.4 2008/10/31 09:27:55 nirprasa ship $*/
3: -- NAME
4: -- OZF_ACTBUDGETS_PVT
5: --
6: -- HISTORY
7: -- 04/12/2000 sugupta CREATED
8: -- 25-Jun-2000 choang Commented out show errors and uncommented exit

Line 93: g_package_name CONSTANT VARCHAR2 (30) := 'OZF_ACTBUDGETS_PVT';

89: -- request_currency -- act_budget_used_by_id Currency
90: -- approved_in_currency -- budget_source_id Currency
91: ----------------------------------------------------------------------------------------------------
92:
93: g_package_name CONSTANT VARCHAR2 (30) := 'OZF_ACTBUDGETS_PVT';
94: g_file_name CONSTANT VARCHAR2 (12) := 'ozfvbdgb.pls';
95: g_cons_fund_mode CONSTANT VARCHAR2 (30) := 'ADJUST';
96: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');
97: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');

Line 5486: -- p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

5482: -- PARAMETERS
5483: -- x_return_status OUT NOCOPY VARCHAR2,
5484: -- x_msg_count OUT NOCOPY NUMBER,
5485: -- x_msg_data OUT NOCOPY VARCHAR2,
5486: -- p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
5487:
5488: -- NOTES
5489: -- HISTORY
5490: -- 09/24/2002 feliu Create.

Line 5497: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

5493: PROCEDURE create_child_act_budget (
5494: x_return_status OUT NOCOPY VARCHAR2,
5495: x_msg_count OUT NOCOPY NUMBER,
5496: x_msg_data OUT NOCOPY VARCHAR2,
5497: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
5498: p_exchange_rate_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
5499: ) IS
5500:
5501: l_return_status VARCHAR2 (10) := fnd_api.g_ret_sts_success;

Line 5516: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

5512: l_converted_amt NUMBER;
5513: l_amount_remaining NUMBER := p_act_budgets_rec.approved_amount;
5514: l_obj_currency VARCHAR2 (30) := p_act_budgets_rec.request_currency; -- object currency.
5515: l_obj_id NUMBER; -- campaign currency
5516: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
5517: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
5518: l_act_budget_id NUMBER;
5519: l_rate NUMBER;
5520:

Line 5517: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

5513: l_amount_remaining NUMBER := p_act_budgets_rec.approved_amount;
5514: l_obj_currency VARCHAR2 (30) := p_act_budgets_rec.request_currency; -- object currency.
5515: l_obj_id NUMBER; -- campaign currency
5516: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
5517: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
5518: l_act_budget_id NUMBER;
5519: l_rate NUMBER;
5520:
5521: CURSOR c_parent_source (p_object_id IN NUMBER) IS

Line 5638: ozf_actbudgets_pvt.create_act_budgets (

5634: l_act_budgets_rec.approval_date := SYSDATE;
5635: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
5636: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
5637:
5638: ozf_actbudgets_pvt.create_act_budgets (
5639: p_api_version=> l_api_version
5640: ,x_return_status=> l_return_status
5641: ,x_msg_count=> l_msg_count
5642: ,x_msg_data=> l_msg_data

Line 5863: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_ACTBUDGETS_PVT';

5859: x_msg_count OUT NOCOPY NUMBER,
5860: x_msg_data OUT NOCOPY VARCHAR2
5861: )
5862: IS
5863: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_ACTBUDGETS_PVT';
5864: L_API_VERSION CONSTANT NUMBER := 1.0;
5865: L_API_NAME CONSTANT VARCHAR2(30) := 'update_reconcile_objfundsum';
5866: L_FULL_NAME CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
5867:

Line 6183: END ozf_actbudgets_pvt;

6179: );
6180: END update_reconcile_objfundsum;
6181:
6182:
6183: END ozf_actbudgets_pvt;