[Home] [Help]
17: * History *
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:
23: ,x_return_status OUT NOCOPY VARCHAR2
24: ,p_active_trans IN NUMBER DEFAULT 0);
25:
26: PROCEDURE create_resource_trans (
27: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
28: ,x_tran_rec OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE
29: ,x_return_status OUT NOCOPY VARCHAR2);
30:
31: PROCEDURE delete_resource_trans (
24: ,p_active_trans IN NUMBER DEFAULT 0);
25:
26: PROCEDURE create_resource_trans (
27: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
28: ,x_tran_rec OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE
29: ,x_return_status OUT NOCOPY VARCHAR2);
30:
31: PROCEDURE delete_resource_trans (
32: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
28: ,x_tran_rec OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE
29: ,x_return_status OUT NOCOPY VARCHAR2);
30:
31: PROCEDURE delete_resource_trans (
32: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
33: ,x_return_status OUT NOCOPY VARCHAR2);
34:
35: PROCEDURE update_resource_trans (
36: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
32: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
33: ,x_return_status OUT NOCOPY VARCHAR2);
34:
35: PROCEDURE update_resource_trans (
36: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
37: ,x_return_status OUT NOCOPY VARCHAR2);
38:
39: PROCEDURE consolidate_batch_resources (
40: p_batch_id IN NUMBER
40: p_batch_id IN NUMBER
41: ,x_return_status OUT NOCOPY VARCHAR2);
42:
43: PROCEDURE build_resource_tran (
44: p_tmp_rec IN gme_resource_txns_gtmp%ROWTYPE
45: ,p_resource_rec OUT NOCOPY gme_resource_txns%ROWTYPE);
46:
47: PROCEDURE fetch_active_resources (
48: p_resource_rec IN gme_resource_txns_gtmp%ROWTYPE
44: p_tmp_rec IN gme_resource_txns_gtmp%ROWTYPE
45: ,p_resource_rec OUT NOCOPY gme_resource_txns%ROWTYPE);
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: