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