11: -- HISTORY
12: -- 02/23/2001 mpande CREATED
13:
14: PROCEDURE create_fund_utilization(
15: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
16: ,x_return_status OUT NOCOPY VARCHAR2
17: ,x_msg_count OUT NOCOPY NUMBER
18: ,x_msg_data OUT NOCOPY VARCHAR2
19: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type := ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC
15: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
16: ,x_return_status OUT NOCOPY VARCHAR2
17: ,x_msg_count OUT NOCOPY NUMBER
18: ,x_msg_data OUT NOCOPY VARCHAR2
19: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type := ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC
20: );
21:
22: /*****************************************************************************************/
23: -- NAME
29: -- 02/23/2001 mpande CREATED
30: -- 06/21/2004 yzhao UPDATED added x_utilized_amount to return actual utilized amount
31:
32: PROCEDURE create_fund_utilization(
33: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER
36: ,x_msg_data OUT NOCOPY VARCHAR2
37: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type := ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC
33: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER
36: ,x_msg_data OUT NOCOPY VARCHAR2
37: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type := ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC
38: ,x_utilized_amount OUT NOCOPY NUMBER
39: );
40:
41: /* =========================================================
154: PROCEDURE process_act_budgets (
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
159: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
160: x_act_budget_id OUT NOCOPY NUMBER
161: );
162:
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
159: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
160: x_act_budget_id OUT NOCOPY NUMBER
161: );
162:
163:
182: PROCEDURE process_act_budgets (
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
187: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
188: x_act_budget_id OUT NOCOPY NUMBER,
189: x_utilized_amount OUT NOCOPY NUMBER
190: );
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
187: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
188: x_act_budget_id OUT NOCOPY NUMBER,
189: x_utilized_amount OUT NOCOPY NUMBER
190: );
191: