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_DBL

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 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 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 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 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 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 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 ;