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:
53: -- 29/11/2010 muthsubr Altered px_ozf_funds_new_rectype to px_ozf_funds_new_tbl
54: -- for TPA Parallel Execution ER Bug#9614703.
55:
56: PROCEDURE create_fund_utilization(
57: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
58: ,x_return_status OUT NOCOPY VARCHAR2
59: ,x_msg_count OUT NOCOPY NUMBER
60: ,x_msg_data OUT NOCOPY VARCHAR2
61: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type := ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC
57: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
58: ,x_return_status OUT NOCOPY VARCHAR2
59: ,x_msg_count OUT NOCOPY NUMBER
60: ,x_msg_data OUT NOCOPY VARCHAR2
61: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type := ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC
62: ,x_utilized_amount OUT NOCOPY NUMBER
63: ,p_batch_type IN VARCHAR2
64: ,p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F'
65: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
68: );
69:
70: --nirprasa - added for Bug 9383565
71: PROCEDURE create_fund_utilization (
72: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
73: ,x_return_status OUT NOCOPY VARCHAR2
74: ,x_msg_count OUT NOCOPY NUMBER
75: ,x_msg_data OUT NOCOPY VARCHAR2
76: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type := ozf_actbudgets_pvt.g_miss_act_util_rec
72: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
73: ,x_return_status OUT NOCOPY VARCHAR2
74: ,x_msg_count OUT NOCOPY NUMBER
75: ,x_msg_data OUT NOCOPY VARCHAR2
76: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type := ozf_actbudgets_pvt.g_miss_act_util_rec
77: ,x_utilized_amount OUT NOCOPY NUMBER
78: ,p_batch_type IN VARCHAR2
79: ,p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F'
80: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
83: ,x_utilization_id OUT NOCOPY NUMBER
84: );
85:
86: PROCEDURE create_fund_utilization(
87: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
88: ,x_return_status OUT NOCOPY VARCHAR2
89: ,x_msg_count OUT NOCOPY NUMBER
90: ,x_msg_data OUT NOCOPY VARCHAR2
91: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type := ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC
87: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
88: ,x_return_status OUT NOCOPY VARCHAR2
89: ,x_msg_count OUT NOCOPY NUMBER
90: ,x_msg_data OUT NOCOPY VARCHAR2
91: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type := ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC
92: ,x_utilized_amount OUT NOCOPY NUMBER
93: ,x_utilization_id OUT NOCOPY NUMBER
94: );
95:
210: PROCEDURE process_act_budgets (
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
215: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
216: x_act_budget_id OUT NOCOPY NUMBER
217: );
218:
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
215: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
216: x_act_budget_id OUT NOCOPY NUMBER
217: );
218:
219:
238: PROCEDURE process_act_budgets (
239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,
241: x_msg_data OUT NOCOPY VARCHAR2,
242: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
243: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
244: x_act_budget_id OUT NOCOPY NUMBER,
245: x_utilized_amount OUT NOCOPY NUMBER
246: );
239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,
241: x_msg_data OUT NOCOPY VARCHAR2,
242: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
243: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
244: x_act_budget_id OUT NOCOPY NUMBER,
245: x_utilized_amount OUT NOCOPY NUMBER
246: );
247:
274: PROCEDURE process_act_budgets (
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
279: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
280: x_act_budget_id OUT NOCOPY NUMBER,
281: x_utilized_amount OUT NOCOPY NUMBER,
282: p_batch_type IN VARCHAR2,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
279: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
280: x_act_budget_id OUT NOCOPY NUMBER,
281: x_utilized_amount OUT NOCOPY NUMBER,
282: p_batch_type IN VARCHAR2,
283: p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F',
289: PROCEDURE process_act_budgets (
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
294: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
295: x_act_budget_id OUT NOCOPY NUMBER,
296: x_utilized_amount OUT NOCOPY NUMBER,
297: p_batch_type IN VARCHAR2,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
294: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
295: x_act_budget_id OUT NOCOPY NUMBER,
296: x_utilized_amount OUT NOCOPY NUMBER,
297: p_batch_type IN VARCHAR2,
298: p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F',
306: PROCEDURE process_act_budgets (
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_msg_count OUT NOCOPY NUMBER,
309: x_msg_data OUT NOCOPY VARCHAR2,
310: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
311: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
312: x_act_budget_id OUT NOCOPY NUMBER,
313: x_utilized_amount OUT NOCOPY NUMBER,
314: x_utilization_id OUT NOCOPY NUMBER
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_msg_count OUT NOCOPY NUMBER,
309: x_msg_data OUT NOCOPY VARCHAR2,
310: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
311: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
312: x_act_budget_id OUT NOCOPY NUMBER,
313: x_utilized_amount OUT NOCOPY NUMBER,
314: x_utilization_id OUT NOCOPY NUMBER
315: );