eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_RESOURCE_ENGINE_PVT dependencies on GME_RESOURCE_TXNS

Line 52: p_resource_rec IN gme_resource_txns_gtmp%ROWTYPE

48: E - Error
49: U - Unexpected error
50: =============================================================================================*/
51: PROCEDURE fetch_all_resources (
52: p_resource_rec IN gme_resource_txns_gtmp%ROWTYPE
53: ,x_resource_tbl OUT NOCOPY gme_common_pvt.resource_transactions_tab
54: ,x_return_status OUT NOCOPY VARCHAR2
55: ,p_active_trans IN NUMBER DEFAULT 0 -- B3425554
56: )

Line 99: FOR ' SELECT * FROM GME_RESOURCE_TXNS_GTMP

95: END IF;
96:
97: IF l_cursor = 1 THEN
98: OPEN get_rsrc
99: FOR ' SELECT * FROM GME_RESOURCE_TXNS_GTMP
100: WHERE '
101: || l_where USING p_resource_rec.poc_trans_id;
102: ELSIF l_cursor = 2 THEN
103: OPEN get_rsrc

Line 104: FOR ' SELECT * FROM GME_RESOURCE_TXNS_GTMP

100: WHERE '
101: || l_where USING p_resource_rec.poc_trans_id;
102: ELSIF l_cursor = 2 THEN
103: OPEN get_rsrc
104: FOR ' SELECT * FROM GME_RESOURCE_TXNS_GTMP
105: WHERE '
106: || l_where USING p_resource_rec.doc_id;
107: END IF;
108:

Line 159: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE

155: E - Error
156: U - Unexpected error
157: =============================================================================================*/
158: PROCEDURE create_resource_trans (
159: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
160: ,x_tran_rec OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE
161: ,x_return_status OUT NOCOPY VARCHAR2)
162: IS
163: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_RESOURCE_TRANS';

Line 160: ,x_tran_rec OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE

156: U - Unexpected error
157: =============================================================================================*/
158: PROCEDURE create_resource_trans (
159: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
160: ,x_tran_rec OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE
161: ,x_return_status OUT NOCOPY VARCHAR2)
162: IS
163: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_RESOURCE_TRANS';
164: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

Line 165: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;

161: ,x_return_status OUT NOCOPY VARCHAR2)
162: IS
163: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_RESOURCE_TRANS';
164: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
165: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
166: BEGIN
167: IF g_debug <= gme_debug.g_log_procedure THEN
168: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
169: || l_api_name);

Line 182: IF NOT gme_resource_txns_gtmp_dbl.insert_row

178: END IF;
179:
180: l_gme_tran_rec.action_code := 'ADD';
181:
182: IF NOT gme_resource_txns_gtmp_dbl.insert_row
183: (p_resource_txns => l_gme_tran_rec
184: ,x_resource_txns => x_tran_rec) THEN
185: RAISE fnd_api.g_exc_error;
186: END IF;

Line 225: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE

221: E - Error
222: U - Unexpected error
223: =============================================================================================*/
224: PROCEDURE delete_resource_trans (
225: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
226: ,x_return_status OUT NOCOPY VARCHAR2)
227: IS
228: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
229: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_RESOURCE_TRANS';

Line 228: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;

224: PROCEDURE delete_resource_trans (
225: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
226: ,x_return_status OUT NOCOPY VARCHAR2)
227: IS
228: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
229: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_RESOURCE_TRANS';
230: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
231: BEGIN
232: IF g_debug <= gme_debug.g_log_procedure THEN

Line 240: DELETE FROM gme_resource_txns_gtmp

236:
237: l_gme_tran_rec := p_tran_rec;
238:
239: IF p_tran_rec.action_code = 'ADD' THEN
240: DELETE FROM gme_resource_txns_gtmp
241: WHERE poc_trans_id = p_tran_rec.poc_trans_id;
242: ELSE
243: l_gme_tran_rec.action_code := 'DEL';
244:

Line 245: IF NOT gme_resource_txns_gtmp_dbl.update_row

241: WHERE poc_trans_id = p_tran_rec.poc_trans_id;
242: ELSE
243: l_gme_tran_rec.action_code := 'DEL';
244:
245: IF NOT gme_resource_txns_gtmp_dbl.update_row
246: (p_resource_txns => l_gme_tran_rec) THEN
247: RAISE fnd_api.g_exc_error;
248: END IF;
249: END IF;

Line 288: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE

284: E - Error
285: U - Unexpected error
286: =============================================================================================*/
287: PROCEDURE update_resource_trans (
288: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
289: ,x_return_status OUT NOCOPY VARCHAR2)
290: IS
291: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_RESOURCE_TRANS';
292: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

Line 293: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;

289: ,x_return_status OUT NOCOPY VARCHAR2)
290: IS
291: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_RESOURCE_TRANS';
292: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
293: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
294: BEGIN
295: IF g_debug <= gme_debug.g_log_procedure THEN
296: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
297: || l_api_name);

Line 312: IF NOT gme_resource_txns_gtmp_dbl.update_row

308: gme_debug.put_line ( 'Calling UPDATE rec trans id:'
309: || TO_CHAR (p_tran_rec.poc_trans_id) );
310: END IF;
311:
312: IF NOT gme_resource_txns_gtmp_dbl.update_row
313: (p_resource_txns => l_gme_tran_rec) THEN
314: RAISE fnd_api.g_exc_error;
315: END IF;
316:

Line 385: FROM gme_resource_txns

381:
382: CURSOR cur_get_prev_rec (v_poc_id NUMBER)
383: IS
384: SELECT *
385: FROM gme_resource_txns
386: WHERE poc_trans_id = v_poc_id;
387:
388: l_debug VARCHAR2 (2000);
389: l_prev_rec cur_get_prev_rec%ROWTYPE;

Line 390: l_resource_rec gme_resource_txns_gtmp%ROWTYPE;

386: WHERE poc_trans_id = v_poc_id;
387:
388: l_debug VARCHAR2 (2000);
389: l_prev_rec cur_get_prev_rec%ROWTYPE;
390: l_resource_rec gme_resource_txns_gtmp%ROWTYPE;
391: l_tran_rec gme_resource_txns%ROWTYPE;
392: l_resource_tbl gme_common_pvt.resource_transactions_tab;
393: l_trans_date DATE;
394: l_org_id NUMBER;

Line 391: l_tran_rec gme_resource_txns%ROWTYPE;

387:
388: l_debug VARCHAR2 (2000);
389: l_prev_rec cur_get_prev_rec%ROWTYPE;
390: l_resource_rec gme_resource_txns_gtmp%ROWTYPE;
391: l_tran_rec gme_resource_txns%ROWTYPE;
392: l_resource_tbl gme_common_pvt.resource_transactions_tab;
393: l_trans_date DATE;
394: l_org_id NUMBER;
395: l_period_id INTEGER;

Line 397: l_in_tran_rec gme_resource_txns%ROWTYPE;

393: l_trans_date DATE;
394: l_org_id NUMBER;
395: l_period_id INTEGER;
396:
397: l_in_tran_rec gme_resource_txns%ROWTYPE;
398:
399: CURSOR cur_get_org_id (v_batch_id NUMBER)
400: IS
401: SELECT organization_id

Line 465: IF NOT gme_resource_txns_dbl.insert_row (l_tran_rec, l_tran_rec) THEN

461: END IF;
462:
463:
464: --Rishi Varma B3856541 02-09-2004 end
465: IF NOT gme_resource_txns_dbl.insert_row (l_tran_rec, l_tran_rec) THEN
466: RAISE insert_failure;
467: END IF;
468:
469: IF l_tran_rec.completed_ind = 1

Line 529: IF NOT gme_resource_txns_dbl.insert_row (l_prev_rec

525: ,x_period_id => l_period_id) THEN
526: RAISE fnd_api.g_exc_error;
527: END IF;
528:
529: IF NOT gme_resource_txns_dbl.insert_row (l_prev_rec
530: ,l_prev_rec) THEN
531: RAISE insert_failure;
532: ELSE
533: --Bug#4917189 Susruth D. Added below updated to make sure only we update the reverse_id but not any

Line 546: IF NOT gme_resource_txns_dbl.update_row (l_in_tran_rec) THEN

542: || ' UPD action code: poc_trans_id of the reversal txn is '
543: || l_prev_rec.poc_trans_id);
544: END IF;
545: /*
546: IF NOT gme_resource_txns_dbl.update_row (l_in_tran_rec) THEN
547: RAISE update_failure;
548: END IF;*/
549: UPDATE gme_resource_txns
550: SET reverse_id = l_prev_rec.poc_trans_id

Line 549: UPDATE gme_resource_txns

545: /*
546: IF NOT gme_resource_txns_dbl.update_row (l_in_tran_rec) THEN
547: RAISE update_failure;
548: END IF;*/
549: UPDATE gme_resource_txns
550: SET reverse_id = l_prev_rec.poc_trans_id
551: WHERE poc_trans_id = l_in_tran_rec.poc_trans_id;
552:
553:

Line 587: IF NOT gme_resource_txns_dbl.insert_row (l_tran_rec

583: ,x_period_id => l_period_id) THEN
584: RAISE fnd_api.g_exc_error;
585: END IF;
586:
587: IF NOT gme_resource_txns_dbl.insert_row (l_tran_rec
588: ,l_tran_rec) THEN
589: RAISE insert_failure;
590: END IF;
591:

Line 612: ELSIF NOT gme_resource_txns_dbl.update_row (l_tran_rec) THEN

608: RAISE gmf_cost_failure;
609: END IF;
610: -- End Bug 5903208
611:
612: ELSIF NOT gme_resource_txns_dbl.update_row (l_tran_rec) THEN
613: RAISE update_failure;
614: END IF;
615: ELSIF (l_resource_rec.action_code = 'DEL') THEN
616: IF l_resource_rec.completed_ind = 1 THEN

Line 620: IF NOT gme_resource_txns_dbl.delete_row (l_tran_rec) THEN

616: IF l_resource_rec.completed_ind = 1 THEN
617: IF l_tran_rec.resource_usage = 0 THEN
618: l_tran_rec.delete_mark := 1;
619:
620: IF NOT gme_resource_txns_dbl.delete_row (l_tran_rec) THEN
621: RAISE update_failure;
622: END IF;
623: ELSE
624: l_tran_rec.resource_usage :=

Line 657: IF NOT gme_resource_txns_dbl.insert_row (l_tran_rec

653: ,x_period_id => l_period_id) THEN
654: RAISE fnd_api.g_exc_error;
655: END IF;
656:
657: IF NOT gme_resource_txns_dbl.insert_row (l_tran_rec
658: ,l_tran_rec) THEN
659: RAISE insert_failure;
660: ELSE
661: --Bug#4917189 Susruth D. Added below updated to make sure only we update the reverse_id but not any

Line 674: /*IF NOT gme_resource_txns_dbl.update_row (l_in_tran_rec) THEN

670: || ' DEL action code: poc_trans_id of the reversal txn is '
671: || l_tran_rec.poc_trans_id);
672: END IF;
673:
674: /*IF NOT gme_resource_txns_dbl.update_row (l_in_tran_rec) THEN
675: RAISE update_failure;
676: END IF;*/
677: UPDATE gme_resource_txns
678: SET reverse_id = l_tran_rec.poc_trans_id

Line 677: UPDATE gme_resource_txns

673:
674: /*IF NOT gme_resource_txns_dbl.update_row (l_in_tran_rec) THEN
675: RAISE update_failure;
676: END IF;*/
677: UPDATE gme_resource_txns
678: SET reverse_id = l_tran_rec.poc_trans_id
679: WHERE poc_trans_id = l_in_tran_rec.poc_trans_id;
680:
681: --

Line 703: IF NOT gme_resource_txns_dbl.delete_row (l_tran_rec) THEN

699:
700: END IF;
701: END IF;
702: ELSE
703: IF NOT gme_resource_txns_dbl.delete_row (l_tran_rec) THEN
704: RAISE update_failure;
705: END IF;
706: END IF;
707: END IF;

Line 750: p_tmp_rec IN gme_resource_txns_gtmp%ROWTYPE

746: p_tmp_rec The resource transaction rec of the temporary tblle
747: p_resource_rec The resource transaction rec.
748: =============================================================================================*/
749: PROCEDURE build_resource_tran (
750: p_tmp_rec IN gme_resource_txns_gtmp%ROWTYPE
751: ,p_resource_rec OUT NOCOPY gme_resource_txns%ROWTYPE)
752: IS
753: l_api_name CONSTANT VARCHAR2 (30) := 'build_resource_tran';
754: BEGIN

Line 751: ,p_resource_rec OUT NOCOPY gme_resource_txns%ROWTYPE)

747: p_resource_rec The resource transaction rec.
748: =============================================================================================*/
749: PROCEDURE build_resource_tran (
750: p_tmp_rec IN gme_resource_txns_gtmp%ROWTYPE
751: ,p_resource_rec OUT NOCOPY gme_resource_txns%ROWTYPE)
752: IS
753: l_api_name CONSTANT VARCHAR2 (30) := 'build_resource_tran';
754: BEGIN
755: IF g_debug <= gme_debug.g_log_procedure THEN

Line 866: p_resource_rec IN gme_resource_txns_gtmp%ROWTYPE

862: History
863: Namit Singhi. Bug#5609683. Added parameter p_calling_mode.
864: =============================================================================================*/
865: PROCEDURE fetch_active_resources (
866: p_resource_rec IN gme_resource_txns_gtmp%ROWTYPE
867: ,p_calling_mode IN VARCHAR2 DEFAULT NULL --bug#5609683
868: ,x_resource_tbl OUT NOCOPY gme_common_pvt.resource_transactions_tab
869: ,x_return_status OUT NOCOPY VARCHAR2)
870: IS

Line 932: FOR ' SELECT * FROM GME_RESOURCE_TXNS_GTMP

928: END IF;
929:
930: IF l_cursor = 1 THEN
931: OPEN get_rsrc
932: FOR ' SELECT * FROM GME_RESOURCE_TXNS_GTMP
933: WHERE '
934: || l_where USING p_resource_rec.poc_trans_id;
935: ELSIF l_cursor = 2 THEN
936: OPEN get_rsrc

Line 937: FOR ' SELECT * FROM GME_RESOURCE_TXNS_GTMP

933: WHERE '
934: || l_where USING p_resource_rec.poc_trans_id;
935: ELSIF l_cursor = 2 THEN
936: OPEN get_rsrc
937: FOR ' SELECT * FROM GME_RESOURCE_TXNS_GTMP
938: WHERE '
939: || l_where USING p_resource_rec.line_id;
940: ELSIF l_cursor = 3 THEN
941: OPEN get_rsrc

Line 942: FOR ' SELECT * FROM GME_RESOURCE_TXNS_GTMP

938: WHERE '
939: || l_where USING p_resource_rec.line_id;
940: ELSIF l_cursor = 3 THEN
941: OPEN get_rsrc
942: FOR ' SELECT * FROM GME_RESOURCE_TXNS_GTMP
943: WHERE '
944: || l_where USING p_resource_rec.doc_id;
945: END IF;
946:

Line 1010: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;

1006: l_batch_header gme_batch_header%ROWTYPE;
1007: l_batch_step gme_batch_steps%ROWTYPE;
1008: l_step_activity gme_batch_step_activities%ROWTYPE;
1009: l_step_resources gme_batch_step_resources%ROWTYPE;
1010: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1011: l_resource_tbl gme_common_pvt.resource_transactions_tab;
1012: l_return_status VARCHAR2 (1);
1013: l_rsrc_usage NUMBER;
1014: l_rsrc_count NUMBER;

Line 1023: FROM gme_resource_txns_gtmp

1019:
1020: CURSOR cur_sum_usage (v_batchstep_resource_id NUMBER, v_completed NUMBER)
1021: IS
1022: SELECT NVL (SUM (resource_usage), 0)
1023: FROM gme_resource_txns_gtmp
1024: WHERE line_id = v_batchstep_resource_id
1025: AND completed_ind = v_completed
1026: AND (v_completed = 1 OR sequence_dependent_ind = 0);
1027:

Line 1809: FROM gme_resource_txns_gtmp

1805: /* Bug 2651477 added delete_mark condition */
1806: CURSOR cur_get_usage (v_completed_ind NUMBER)
1807: IS
1808: SELECT SUM (resource_usage)
1809: FROM gme_resource_txns_gtmp
1810: WHERE line_id = p_step_resources_rec.batchstep_resource_id
1811: AND completed_ind = v_completed_ind
1812: AND (v_completed_ind = 1 OR sequence_dependent_ind = 0)
1813: AND action_code <> 'DEL'

Line 2502: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

2498: ,p_activity IN VARCHAR2 := NULL
2499: ,p_resource IN VARCHAR2 := NULL
2500: ,p_reason_name IN VARCHAR2,
2501: p_instance_no IN NUMBER
2502: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
2503: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
2504: ,x_return_status OUT NOCOPY VARCHAR2)
2505: IS
2506: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_ACTUAL_RSRC_USAGE';

Line 2503: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

2499: ,p_resource IN VARCHAR2 := NULL
2500: ,p_reason_name IN VARCHAR2,
2501: p_instance_no IN NUMBER
2502: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
2503: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
2504: ,x_return_status OUT NOCOPY VARCHAR2)
2505: IS
2506: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_ACTUAL_RSRC_USAGE';
2507: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;

Line 2507: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;

2503: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
2504: ,x_return_status OUT NOCOPY VARCHAR2)
2505: IS
2506: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_ACTUAL_RSRC_USAGE';
2507: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
2508: l_batch_header gme_batch_header%ROWTYPE;
2509: l_step_resources gme_batch_step_resources%ROWTYPE;
2510: l_resource_tbl gme_common_pvt.resource_transactions_tab;
2511: l_line_id NUMBER;

Line 2522: l_rsrc_txn_rec gme_resource_txns_gtmp%ROWTYPE;

2518: l_resources VARCHAR2 (16);
2519: l_usage_uom VARCHAR2 (4);
2520: --Rishi Varma 02-09-2004 B3856541
2521: l_trans_date DATE;
2522: l_rsrc_txn_rec gme_resource_txns_gtmp%ROWTYPE;
2523: l_tran_rec gme_resource_txns_gtmp%ROWTYPE;
2524:
2525: CURSOR cur_fetch_resource_dtl (v_line_id NUMBER)
2526: IS

Line 2523: l_tran_rec gme_resource_txns_gtmp%ROWTYPE;

2519: l_usage_uom VARCHAR2 (4);
2520: --Rishi Varma 02-09-2004 B3856541
2521: l_trans_date DATE;
2522: l_rsrc_txn_rec gme_resource_txns_gtmp%ROWTYPE;
2523: l_tran_rec gme_resource_txns_gtmp%ROWTYPE;
2524:
2525: CURSOR cur_fetch_resource_dtl (v_line_id NUMBER)
2526: IS
2527: SELECT resources, usage_um

Line 2709: IF NOT (gme_resource_txns_gtmp_dbl.insert_row (l_rsrc_txn_rec

2705: l_rsrc_txn_rec.attribute28 := x_rsrc_txn_rec.attribute28;
2706: l_rsrc_txn_rec.attribute29 := x_rsrc_txn_rec.attribute29;
2707: l_rsrc_txn_rec.attribute30 := x_rsrc_txn_rec.attribute30;
2708: --END IF;
2709: IF NOT (gme_resource_txns_gtmp_dbl.insert_row (l_rsrc_txn_rec
2710: ,l_rsrc_txn_rec) ) THEN
2711: RAISE rsrc_txn_insert_err;
2712: END IF;
2713:

Line 2795: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

2791: ,p_activity IN VARCHAR2 := NULL
2792: ,p_resource IN VARCHAR2 := NULL
2793: ,p_reason_name IN VARCHAR2
2794: ,p_instance_no IN NUMBER
2795: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
2796: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
2797: ,x_return_status OUT NOCOPY VARCHAR2)
2798: IS
2799: l_api_name CONSTANT VARCHAR2 (30)

Line 2796: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

2792: ,p_resource IN VARCHAR2 := NULL
2793: ,p_reason_name IN VARCHAR2
2794: ,p_instance_no IN NUMBER
2795: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
2796: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
2797: ,x_return_status OUT NOCOPY VARCHAR2)
2798: IS
2799: l_api_name CONSTANT VARCHAR2 (30)
2800: := 'insert_incr_actual_rsrc_txn';

Line 2801: l_resource_txns gme_resource_txns%ROWTYPE;

2797: ,x_return_status OUT NOCOPY VARCHAR2)
2798: IS
2799: l_api_name CONSTANT VARCHAR2 (30)
2800: := 'insert_incr_actual_rsrc_txn';
2801: l_resource_txns gme_resource_txns%ROWTYPE;
2802: l_batch_header gme_batch_header%ROWTYPE;
2803: l_step_resources gme_batch_step_resources%ROWTYPE;
2804: l_resource_tbl gme_common_pvt.resource_transactions_tab;
2805: l_step_status NUMBER;

Line 2821: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

2817: l_resources VARCHAR2 (16);
2818: l_usage_uom VARCHAR2 (4);
2819: --Rishi Varma B3856541 02-09-2004
2820: l_trans_date DATE;
2821: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
2822:
2823: CURSOR cur_fetch_resource_dtl (v_line_id NUMBER)
2824: IS
2825: ----SELECT resources,usage_uom

Line 2945: IF NOT (gme_resource_txns_dbl.insert_row (l_rsrc_txn_rec

2941: END IF;
2942:
2943: l_rsrc_txn_rec.sequence_dependent_ind := 0;
2944:
2945: IF NOT (gme_resource_txns_dbl.insert_row (l_rsrc_txn_rec
2946: ,x_rsrc_txn_rec) ) THEN
2947: RAISE rsrc_txn_insert_err;
2948: END IF;
2949:

Line 3048: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

3044: ,p_activity IN VARCHAR2 := NULL
3045: ,p_resource IN VARCHAR2 := NULL
3046: ,p_reason_name IN VARCHAR2,
3047: p_instance_no IN NUMBER
3048: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
3049: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
3050: ,x_return_status OUT NOCOPY VARCHAR2)
3051: IS
3052: l_api_name CONSTANT VARCHAR2 (30)

Line 3049: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

3045: ,p_resource IN VARCHAR2 := NULL
3046: ,p_reason_name IN VARCHAR2,
3047: p_instance_no IN NUMBER
3048: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
3049: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
3050: ,x_return_status OUT NOCOPY VARCHAR2)
3051: IS
3052: l_api_name CONSTANT VARCHAR2 (30)
3053: := 'insert_timed_actual_rsrc_txn';

Line 3054: l_resource_txns gme_resource_txns%ROWTYPE;

3050: ,x_return_status OUT NOCOPY VARCHAR2)
3051: IS
3052: l_api_name CONSTANT VARCHAR2 (30)
3053: := 'insert_timed_actual_rsrc_txn';
3054: l_resource_txns gme_resource_txns%ROWTYPE;
3055: l_batch_header gme_batch_header%ROWTYPE;
3056: l_step_resources gme_batch_step_resources%ROWTYPE;
3057: l_resource_tbl gme_common_pvt.resource_transactions_tab;
3058: l_line_id NUMBER;

Line 3070: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

3066: l_instance_id NUMBER;
3067: l_reason_id NUMBER;
3068: l_usage_time NUMBER;
3069: l_hour_um sy_uoms_mst.um_code%TYPE;
3070: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
3071:
3072:
3073: --Rishi Varma B3856541 02-09-2004
3074: l_trans_date DATE;

Line 3241: IF NOT (gme_resource_txns_dbl.insert_row (l_rsrc_txn_rec

3237: END IF;
3238:
3239: l_rsrc_txn_rec.sequence_dependent_ind := 0;
3240:
3241: IF NOT (gme_resource_txns_dbl.insert_row (l_rsrc_txn_rec
3242: ,x_rsrc_txn_rec) ) THEN
3243: RAISE rsrc_txn_insert_err;
3244: END IF;
3245:

Line 3339: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

3335: ,p_activity IN VARCHAR2 := NULL
3336: ,p_resource IN VARCHAR2 := NULL
3337: ,p_reason_name IN VARCHAR2
3338: ,p_instance_no IN NUMBER
3339: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
3340: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
3341: ,x_return_status OUT NOCOPY VARCHAR2)
3342: IS
3343: l_api_name CONSTANT VARCHAR2 (30) := 'start_cmplt_actual_rsrc_txn';

Line 3340: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

3336: ,p_resource IN VARCHAR2 := NULL
3337: ,p_reason_name IN VARCHAR2
3338: ,p_instance_no IN NUMBER
3339: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
3340: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
3341: ,x_return_status OUT NOCOPY VARCHAR2)
3342: IS
3343: l_api_name CONSTANT VARCHAR2 (30) := 'start_cmplt_actual_rsrc_txn';
3344: l_resource_txns gme_resource_txns%ROWTYPE;

Line 3344: l_resource_txns gme_resource_txns%ROWTYPE;

3340: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
3341: ,x_return_status OUT NOCOPY VARCHAR2)
3342: IS
3343: l_api_name CONSTANT VARCHAR2 (30) := 'start_cmplt_actual_rsrc_txn';
3344: l_resource_txns gme_resource_txns%ROWTYPE;
3345: l_batch_header gme_batch_header%ROWTYPE;
3346: l_line_id NUMBER;
3347: l_step_status NUMBER;
3348: l_return_status VARCHAR2 (2);

Line 3354: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

3350: l_usage_uom VARCHAR2 (4);
3351: l_instance_id NUMBER;
3352: l_reason_id NUMBER;
3353:
3354: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
3355:
3356: CURSOR cur_fetch_resource_dtl (v_line_id NUMBER)
3357: IS
3358: ---SELECT resources,usage_uom

Line 3489: IF NOT (gme_resource_txns_dbl.insert_row (l_rsrc_txn_rec

3485: END IF;
3486:
3487: l_rsrc_txn_rec.sequence_dependent_ind := 0;
3488:
3489: IF NOT (gme_resource_txns_dbl.insert_row (l_rsrc_txn_rec
3490: ,x_rsrc_txn_rec) ) THEN
3491: RAISE rsrc_txn_insert_err;
3492: END IF;
3493:

Line 3542: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

3538: 14th March 2005 Punit kumar
3539: Convergence changes
3540: =============================================================================================*/
3541: PROCEDURE end_cmplt_actual_rsrc_txn (
3542: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
3543: ,p_reason_name IN VARCHAR2
3544: ,p_instance_no IN NUMBER
3545: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
3546: ,x_return_status OUT NOCOPY VARCHAR2)

Line 3545: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

3541: PROCEDURE end_cmplt_actual_rsrc_txn (
3542: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
3543: ,p_reason_name IN VARCHAR2
3544: ,p_instance_no IN NUMBER
3545: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
3546: ,x_return_status OUT NOCOPY VARCHAR2)
3547: IS
3548: l_api_name CONSTANT VARCHAR2 (30) := 'end_cmplt_actual_rsrc_txn';
3549: l_resource_txns gme_resource_txns%ROWTYPE;

Line 3549: l_resource_txns gme_resource_txns%ROWTYPE;

3545: ,x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
3546: ,x_return_status OUT NOCOPY VARCHAR2)
3547: IS
3548: l_api_name CONSTANT VARCHAR2 (30) := 'end_cmplt_actual_rsrc_txn';
3549: l_resource_txns gme_resource_txns%ROWTYPE;
3550: l_batch_header gme_batch_header%ROWTYPE;
3551: l_step_resources gme_batch_step_resources%ROWTYPE;
3552: l_resource_tbl gme_common_pvt.resource_transactions_tab;
3553: --Begin Bug# 3479669

Line 3554: l_tran_rec gme_resource_txns%ROWTYPE;

3550: l_batch_header gme_batch_header%ROWTYPE;
3551: l_step_resources gme_batch_step_resources%ROWTYPE;
3552: l_resource_tbl gme_common_pvt.resource_transactions_tab;
3553: --Begin Bug# 3479669
3554: l_tran_rec gme_resource_txns%ROWTYPE;
3555: --End Bug# 3479669
3556: l_step_status NUMBER;
3557: l_return_status VARCHAR2 (2);
3558: l_txn_usage NUMBER;

Line 3568: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;

3564: l_line_id NUMBER;
3565: l_rsrc_trans_count NUMBER;
3566: l_hour_um sy_uoms_mst.um_code%TYPE;
3567: l_trans_date DATE;
3568: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
3569:
3570: --siva added following variables
3571: x_trans_date DATE;
3572: x_reason_id NUMBER;

Line 3578: FROM gme_resource_txns

3574:
3575: CURSOR cur_validate_poc_trans_id (v_poc_trans_id NUMBER)
3576: IS
3577: SELECT 1
3578: FROM gme_resource_txns
3579: WHERE poc_trans_id = v_poc_trans_id;
3580:
3581: invalid_poc_trans_id EXCEPTION;
3582: validation_failure EXCEPTION;

Line 3635: IF NOT (gme_resource_txns_dbl.fetch_row (l_rsrc_txn_rec, l_rsrc_txn_rec) ) THEN

3631: --END IF;
3632:
3633: l_rsrc_txn_rec.poc_trans_id := p_rsrc_txn_rec.poc_trans_id;
3634:
3635: IF NOT (gme_resource_txns_dbl.fetch_row (l_rsrc_txn_rec, l_rsrc_txn_rec) ) THEN
3636: RAISE rsrc_txn_fetch_err;
3637: END IF;
3638:
3639: IF ( (l_rsrc_txn_rec.resource_usage <> 0)

Line 3815: IF NOT (gme_resource_txns_dbl.insert_row (l_rsrc_txn_rec, l_tran_rec) ) THEN

3811:
3812: IF l_rsrc_txn_rec.posted_ind = 1 THEN
3813: l_rsrc_txn_rec.posted_ind := 0;
3814:
3815: IF NOT (gme_resource_txns_dbl.insert_row (l_rsrc_txn_rec, l_tran_rec) ) THEN
3816: RAISE rsrc_txn_ins_err;
3817: END IF;
3818: x_rsrc_txn_rec := l_tran_rec ;
3819: ELSE

Line 3822: ---IF NOT (GME_RESOURCE_TXNS_DBL.update_row(l_resource_txns)) THEN

3818: x_rsrc_txn_rec := l_tran_rec ;
3819: ELSE
3820: --End Bug#3479669
3821:
3822: ---IF NOT (GME_RESOURCE_TXNS_DBL.update_row(l_resource_txns)) THEN
3823: IF NOT (gme_resource_txns_dbl.update_row (l_rsrc_txn_rec) ) THEN
3824: RAISE rsrc_txn_upd_err;
3825: END IF;
3826:

Line 3823: IF NOT (gme_resource_txns_dbl.update_row (l_rsrc_txn_rec) ) THEN

3819: ELSE
3820: --End Bug#3479669
3821:
3822: ---IF NOT (GME_RESOURCE_TXNS_DBL.update_row(l_resource_txns)) THEN
3823: IF NOT (gme_resource_txns_dbl.update_row (l_rsrc_txn_rec) ) THEN
3824: RAISE rsrc_txn_upd_err;
3825: END IF;
3826:
3827: x_rsrc_txn_rec := l_rsrc_txn_rec ;