APPS.GML_PO_INTERFACE dependencies on CPG_ORAGEMS_MAPPING

Line 24: # 12/24/98 added defaults for who columns in cpg_oragems_mapping

20: # 11/10/98 T.Ricci added shipper_code_cur to retreive correct
21: # shipper_code 4 char value from op_ship_mst
22: # 11/11/98 T.Ricci added fob_code_cur to retreive correct
23: # fob_code 4 char value from op_fobc_mst
24: # 12/24/98 added defaults for who columns in cpg_oragems_mapping
25: # 05/13/99 T.Ricci removed checking of inventory_item_flag and
26: # replaced with call to check_opm_item
27: #
28: ## #######################################################################*/

Line 152: FROM CPG_ORAGEMS_MAPPING

148: p_po_line_location_id IN VARCHAR2
149: )
150: IS
151: SELECT *
152: FROM CPG_ORAGEMS_MAPPING
153: WHERE po_header_id = p_po_header_id
154: AND po_line_id = p_po_line_id
155: AND po_line_location_id = p_po_line_location_id
156: FOR UPDATE;

Line 165: FROM CPG_ORAGEMS_MAPPING

161: CURSOR c_get_old_po_no ( p_po_header_id IN VARCHAR2
162: )
163: IS
164: SELECT po_no
165: FROM CPG_ORAGEMS_MAPPING
166: WHERE po_header_id = p_po_header_id;
167:
168: /* Cursor to select buyer code */
169:

Line 648: INSERT INTO cpg_oragems_mapping

644: FETCH c_checkpll_cur
645: INTO r_checkpll_rec;
646:
647: IF c_checkpll_cur%NOTFOUND THEN
648: INSERT INTO cpg_oragems_mapping
649: ( po_header_id,
650: po_line_id,
651: po_line_location_id,
652: po_no,

Line 682: UPDATE cpg_oragems_mapping

678: sysdate
679: );
680:
681: ELSIF (v_closed_code = 'FINALLY CLOSED') THEN
682: UPDATE cpg_oragems_mapping
683: SET po_status = v_closed_code,
684: time_stamp = sysdate,
685: last_update_date = sysdate
686: WHERE CURRENT of c_checkpll_cur;

Line 689: UPDATE cpg_oragems_mapping

685: last_update_date = sysdate
686: WHERE CURRENT of c_checkpll_cur;
687:
688: ELSIF (v_cancel_flag ='Y') THEN
689: UPDATE cpg_oragems_mapping
690: SET po_status = 'CANCELLED',
691: time_stamp = sysdate,
692: last_update_date = sysdate
693: WHERE CURRENT of c_checkpll_cur;

Line 710: SET a.po_no = ( SELECT b.po_no from cpg_oragems_mapping b

706:
707: /* Uday Phadtare B2038851 following update statement commented */
708:
709: /* UPDATE cpg_purchasing_interface a
710: SET a.po_no = ( SELECT b.po_no from cpg_oragems_mapping b
711: WHERE
712: b.po_header_id = a.po_header_id AND
713: b.po_line_id = a.po_line_id AND
714: b.po_line_location_id = a.po_line_location_id ) ; */