338: ,x_utilized_amount OUT NOCOPY NUMBER
339: ,p_resale_batch_id IN NUMBER
340: ,p_batch_type IN VARCHAR2
341: ,p_use_fund_staging_tables IN VARCHAR2
342: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
343: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
344: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
345: );
346:
339: ,p_resale_batch_id IN NUMBER
340: ,p_batch_type IN VARCHAR2
341: ,p_use_fund_staging_tables IN VARCHAR2
342: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
343: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
344: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
345: );
346:
347: --nirprasa - added for Bug 9383565
340: ,p_batch_type IN VARCHAR2
341: ,p_use_fund_staging_tables IN VARCHAR2
342: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
343: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
344: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
345: );
346:
347: --nirprasa - added for Bug 9383565
348: PROCEDURE create_act_budgets(
360: ,x_utilized_amount OUT NOCOPY NUMBER
361: ,p_resale_batch_id IN NUMBER
362: ,p_batch_type IN VARCHAR2
363: ,p_use_fund_staging_tables IN VARCHAR2
364: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
365: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
366: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
367: ,x_utilization_id OUT NOCOPY NUMBER
368: );
361: ,p_resale_batch_id IN NUMBER
362: ,p_batch_type IN VARCHAR2
363: ,p_use_fund_staging_tables IN VARCHAR2
364: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
365: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
366: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
367: ,x_utilization_id OUT NOCOPY NUMBER
368: );
369:
362: ,p_batch_type IN VARCHAR2
363: ,p_use_fund_staging_tables IN VARCHAR2
364: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
365: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
366: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
367: ,x_utilization_id OUT NOCOPY NUMBER
368: );
369:
370: PROCEDURE create_act_budgets (
514: ,p_act_util_rec IN act_util_rec_type := NULL
515: ,x_utilized_amount OUT NOCOPY NUMBER
516: ,p_batch_type IN VARCHAR2
517: ,p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F'
518: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
519: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
520: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
521: );
522:
515: ,x_utilized_amount OUT NOCOPY NUMBER
516: ,p_batch_type IN VARCHAR2
517: ,p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F'
518: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
519: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
520: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
521: );
522:
523: PROCEDURE update_act_budgets(
516: ,p_batch_type IN VARCHAR2
517: ,p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F'
518: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
519: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
520: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
521: );
522:
523: PROCEDURE update_act_budgets(
524: p_api_version IN NUMBER
541: ,p_act_util_rec IN act_util_rec_type := NULL
542: ,x_utilized_amount OUT NOCOPY NUMBER
543: ,p_batch_type IN VARCHAR2
544: ,p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F'
545: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
546: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
547: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
548: ,x_utilization_id OUT NOCOPY NUMBER
549: );
542: ,x_utilized_amount OUT NOCOPY NUMBER
543: ,p_batch_type IN VARCHAR2
544: ,p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F'
545: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
546: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
547: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
548: ,x_utilization_id OUT NOCOPY NUMBER
549: );
550:
543: ,p_batch_type IN VARCHAR2
544: ,p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F'
545: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
546: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
547: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
548: ,x_utilization_id OUT NOCOPY NUMBER
549: );
550:
551: /****************************************************************************/