APPS.GME_TRANS_ENGINE_UTIL dependencies on GME_RESOURCE_TXNS

Line 655: FROM gme_resource_txns_gtmp

651: IS
652: CURSOR c_get_reversal_resources
653: IS
654: SELECT *
655: FROM gme_resource_txns_gtmp
656: WHERE action_code = 'REVL'; -- Should this be indexed.
657:
658: CURSOR c_get_match_reversal_resources (v_line_id NUMBER)
659: IS

Line 661: FROM gme_resource_txns_gtmp

657:
658: CURSOR c_get_match_reversal_resources (v_line_id NUMBER)
659: IS
660: SELECT *
661: FROM gme_resource_txns_gtmp
662: WHERE action_code NOT IN ('REVL', 'REVS')
663: AND line_id = v_line_id
664: AND completed_ind = 1
665: ORDER BY trans_date DESC, poc_trans_id;

Line 670: FROM gme_resource_txns_gtmp

666:
667: CURSOR c_check_rsc_transactions (p_batch_id IN NUMBER)
668: IS
669: SELECT COUNT (1)
670: FROM gme_resource_txns_gtmp
671: WHERE doc_id = p_batch_id;
672:
673: l_api_name CONSTANT VARCHAR2 (30) := 'LOAD_RSRC_TRANS';
674: l_rsc_row_count NUMBER := 0;

Line 715: -- Now Populate The GME_RESOURCE_TXNS_GTMP table

711: CLOSE c_check_rsc_transactions;
712:
713: -- Validate That We have loaded RSC txns if POC_IND ='Y'
714: IF (NVL (p_batch_row.poc_ind, 'N') = 'Y' AND l_rsc_exists = 0) THEN
715: -- Now Populate The GME_RESOURCE_TXNS_GTMP table
716: -- Should this be in same file as other table routines */
717: INSERT INTO gme_resource_txns_gtmp
718: (poc_trans_id, orgn_code, doc_type, doc_id, line_type
719: ,line_id, resources, resource_usage, trans_um

Line 717: INSERT INTO gme_resource_txns_gtmp

713: -- Validate That We have loaded RSC txns if POC_IND ='Y'
714: IF (NVL (p_batch_row.poc_ind, 'N') = 'Y' AND l_rsc_exists = 0) THEN
715: -- Now Populate The GME_RESOURCE_TXNS_GTMP table
716: -- Should this be in same file as other table routines */
717: INSERT INTO gme_resource_txns_gtmp
718: (poc_trans_id, orgn_code, doc_type, doc_id, line_type
719: ,line_id, resources, resource_usage, trans_um
720: ,trans_date, completed_ind, posted_ind, reason_code, reason_id
721: ,start_date, end_date, text_code, transaction_no

Line 746: FROM gme_resource_txns

742: ,attribute17, attribute18, attribute19, attribute20
743: ,attribute21, attribute22, attribute23, attribute24
744: ,attribute25, attribute26, attribute27, attribute28
745: ,attribute29, attribute30, attribute_category
746: FROM gme_resource_txns
747: WHERE doc_id = p_batch_row.batch_id
748: AND doc_type = l_doc_type
749: AND delete_mark = 0
750: --Rishi Varma B3818266/3759970 10-08-2004

Line 766: UPDATE gme_resource_txns_gtmp

762: || ':'
763: || 'Use SQL to Mark reversals');
764: END IF;
765:
766: UPDATE gme_resource_txns_gtmp
767: SET action_code = 'REVL'
768: WHERE resource_usage < 0 AND completed_ind = 1;
769:
770: IF (SQL%ROWCOUNT > 0) THEN

Line 790: UPDATE gme_resource_txns_gtmp

786:
787: IF ( (resrc_revs.trans_date = mtch_resrc_revs.trans_date)
788: AND (ABS (resrc_revs.resource_usage) =
789: ABS (mtch_resrc_revs.resource_usage) ) ) THEN
790: UPDATE gme_resource_txns_gtmp
791: SET action_code = 'REVS'
792: WHERE poc_trans_id = mtch_resrc_revs.poc_trans_id;
793:
794: EXIT;