APPS.GML_RECV_TRANS_PKG dependencies on GML_RECV_TRANS_MAP

Line 93: FROM gml_recv_trans_map

89: line_location_id = vc_apps_po_line_location_id;
90:
91: CURSOR check_map_table IS
92: SELECT group_id,rcv_receipt_num
93: FROM gml_recv_trans_map
94: WHERE recv_id = v_recv_id
95: AND organization_id = v_ship_to_organization_id
96: AND rcv_receipt_num is not null;
97:

Line 297: FROM gml_recv_trans_map

293: X_progress VARCHAR2(4);
294:
295: CURSOR get_trans_id_cur(vc_recv_id NUMBER, vc_line_id NUMBER) IS
296: SELECT interface_transaction_id
297: FROM gml_recv_trans_map
298: WHERE recv_id = vc_recv_id AND
299: line_id = vc_line_id;
300:
301: CURSOR RCV_TRANS_DELIVER_CUR(v_transaction_id NUMBER,

Line 646: FROM gml_recv_trans_map

642: error_rec adjust_error_cur%ROWTYPE;
643:
644: CURSOR get_trans_id_cur(vc_recv_id NUMBER, vc_line_id NUMBER) IS
645: SELECT interface_transaction_id
646: FROM gml_recv_trans_map
647: WHERE recv_id = vc_recv_id AND
648: line_id = vc_line_id;
649:
650: CURSOR get_recv_dtl_cur(vc_recv_id NUMBER, vc_line_id NUMBER) IS

Line 731: gml_recv_trans_map tables

727: gml_new_recv_trans_insert()
728: DESCRIPTION The procedure inserts data into the
729: RCV_HEADERS_INTERFACE ,
730: RCV_TRANSACTIONS_INTERFACE and
731: gml_recv_trans_map tables
732:
733: PARAMETERS p_recv_id recv_id
734: ....
735: p_transaction_type Transaction_type could be 'DELIVER',

Line 1388: INSERT INTO gml_recv_trans_map

1384: insert a row in the mapping table.
1385: */
1386: IF (p_header_interface_id <> 0 AND p_header_flag = 0 ) THEN
1387:
1388: INSERT INTO gml_recv_trans_map
1389: (recv_id, line_id, interface_transaction_id,group_id,
1390: creation_date,created_by,last_update_date,last_updated_by,
1391: last_update_login,organization_id,rcv_receipt_num)
1392: VALUES