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
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
49: ,p_calling_mode IN VARCHAR2 DEFAULT NULL --bug#5609683
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:
150: /*
151: x_batch_id OUT NOCOPY NUMBER,
152: x_line_id OUT NOCOPY NUMBER,
153: */
154: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
155: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
156: ,
157: /*end*/
158: x_return_status OUT NOCOPY VARCHAR2);
151: x_batch_id OUT NOCOPY NUMBER,
152: x_line_id OUT NOCOPY NUMBER,
153: */
154: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
155: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
156: ,
157: /*end*/
158: x_return_status OUT NOCOPY VARCHAR2);
159:
203: /*
204: x_batch_id OUT NOCOPY NUMBER,
205: x_poc_trans_id OUT NOCOPY NUMBER,
206: */
207: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
208: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
209: ,
210: /*end*/
211: x_return_status OUT NOCOPY VARCHAR2);
204: x_batch_id OUT NOCOPY NUMBER,
205: x_poc_trans_id OUT NOCOPY NUMBER,
206: */
207: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
208: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
209: ,
210: /*end*/
211: x_return_status OUT NOCOPY VARCHAR2);
212:
254: /*
255: x_batch_id OUT NOCOPY NUMBER,
256: x_poc_trans_id OUT NOCOPY NUMBER,
257: */
258: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
259: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
260: ,
261: /*end*/
262: x_return_status OUT NOCOPY VARCHAR2);
255: x_batch_id OUT NOCOPY NUMBER,
256: x_poc_trans_id OUT NOCOPY NUMBER,
257: */
258: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
259: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
260: ,
261: /*end*/
262: x_return_status OUT NOCOPY VARCHAR2);
263:
303: /*
304: x_batch_id OUT NOCOPY NUMBER,
305: x_poc_trans_id OUT NOCOPY NUMBER,
306: */
307: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
308: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
309: ,
310: /*end */
311: x_return_status OUT NOCOPY VARCHAR2);
304: x_batch_id OUT NOCOPY NUMBER,
305: x_poc_trans_id OUT NOCOPY NUMBER,
306: */
307: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
308: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
309: ,
310: /*end */
311: x_return_status OUT NOCOPY VARCHAR2);
312:
322: , x_batch_id OUT NOCOPY NUMBER
323: , x_return_status OUT NOCOPY VARCHAR2);
324: */
325: PROCEDURE end_cmplt_actual_rsrc_txn (
326: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
327: ,p_reason_name IN VARCHAR2
328: ,p_instance_no IN NUMBER
329: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
330: ,x_return_status OUT NOCOPY VARCHAR2);
325: PROCEDURE end_cmplt_actual_rsrc_txn (
326: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
327: ,p_reason_name IN VARCHAR2
328: ,p_instance_no IN NUMBER
329: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
330: ,x_return_status OUT NOCOPY VARCHAR2);
331: END gme_resource_engine_pvt;