DBA Data[Home] [Help]

APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on OZF_UTILITY_PVT

Line 65: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table

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
66: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
67: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
68: );
69:

Line 66: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

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
66: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
67: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
68: );
69:
70: --nirprasa - added for Bug 9383565

Line 67: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table

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
66: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
67: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
68: );
69:
70: --nirprasa - added for Bug 9383565
71: PROCEDURE create_fund_utilization (

Line 80: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table

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
81: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
82: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
83: ,x_utilization_id OUT NOCOPY NUMBER
84: );

Line 81: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

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
81: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
82: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
83: ,x_utilization_id OUT NOCOPY NUMBER
84: );
85:

Line 82: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table

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
81: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
82: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
83: ,x_utilization_id OUT NOCOPY NUMBER
84: );
85:
86: PROCEDURE create_fund_utilization(

Line 284: px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table,

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',
284: px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table,
285: px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype,
286: px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
287: );
288:

Line 285: px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype,

281: x_utilized_amount OUT NOCOPY NUMBER,
282: p_batch_type IN VARCHAR2,
283: p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F',
284: px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table,
285: px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype,
286: px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
287: );
288:
289: PROCEDURE process_act_budgets (

Line 286: px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table

282: p_batch_type IN VARCHAR2,
283: p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F',
284: px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table,
285: px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype,
286: px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
287: );
288:
289: PROCEDURE process_act_budgets (
290: x_return_status OUT NOCOPY VARCHAR2,

Line 299: px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table,

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',
299: px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table,
300: px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype,
301: px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table,
302: x_utilization_id OUT NOCOPY NUMBER
303: );

Line 300: px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype,

296: x_utilized_amount OUT NOCOPY NUMBER,
297: p_batch_type IN VARCHAR2,
298: p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F',
299: px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table,
300: px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype,
301: px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table,
302: x_utilization_id OUT NOCOPY NUMBER
303: );
304:

Line 301: px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table,

297: p_batch_type IN VARCHAR2,
298: p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F',
299: px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table,
300: px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype,
301: px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table,
302: x_utilization_id OUT NOCOPY NUMBER
303: );
304:
305: --nirprasa - added for Bug 9383565