18: ****************************************************************
19: */
20: PROCEDURE fetch_all_resources (
21: p_resource_rec IN gme_resource_txns_gtmp%ROWTYPE
22: ,x_resource_tbl OUT NOCOPY gme_common_pvt.resource_transactions_tab
23: ,x_return_status OUT NOCOPY VARCHAR2
24: ,p_active_trans IN NUMBER DEFAULT 0);
25:
26: PROCEDURE create_resource_trans (
46:
47: PROCEDURE fetch_active_resources (
48: p_resource_rec IN gme_resource_txns_gtmp%ROWTYPE
49: ,p_calling_mode IN VARCHAR2 DEFAULT NULL --bug#5609683
50: ,x_resource_tbl OUT NOCOPY gme_common_pvt.resource_transactions_tab
51: ,x_return_status OUT NOCOPY VARCHAR2);
52:
53: PROCEDURE resource_dtl_process (
54: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE