DBA Data[Home] [Help]

APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on OZF_ACTBUDGETS_PVT

Line 15: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

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

Line 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

Line 33: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

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

Line 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:

Line 57: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

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

Line 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

Line 72: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

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

Line 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

Line 87: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

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

Line 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:

Line 214: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

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:

Line 215: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

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:

Line 242: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

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: );

Line 243: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

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:

Line 278: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

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,

Line 279: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

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',

Line 293: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

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,

Line 294: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

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',

Line 310: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

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

Line 311: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

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: );