DBA Data[Home] [Help]

APPS.GML_SYNCH_BPOS dependencies on CPG_ORAGEMS_MAPPING

Line 140: FROM cpg_oragems_mapping

136: IS
137:
138: CURSOR id_cur (header NUMBER, line NUMBER, location NUMBER) IS
139: SELECT bpo_id, bpo_line_id
140: FROM cpg_oragems_mapping
141: WHERE po_header_id = v_po_header_id
142: AND po_line_id = v_po_line_id
143: AND po_line_location_id = v_po_line_location_id;
144:

Line 317: FROM cpg_oragems_mapping

313: p_po_line_id CPG_PURCHASING_INTERFACE.PO_LINE_ID%TYPE,
314: p_po_line_location_id CPG_PURCHASING_INTERFACE.PO_LINE_LOCATION_ID%TYPE
315: ) IS
316: SELECT bpo_line_id
317: FROM cpg_oragems_mapping
318: WHERE po_header_id = p_po_header_id
319: AND po_line_id = p_po_line_id
320: AND po_line_location_id = p_po_line_location_id;
321:

Line 812: UPDATE cpg_oragems_mapping

808: raise_application_error(-20001, err_msg);
809: END;
810:
811:
812: UPDATE cpg_oragems_mapping
813: SET bpo_id = v_bpo_id,
814: bpo_line_id = v_new_line_id
815: WHERE po_header_id = int_rec.po_header_id
816: AND po_line_id = int_rec.po_line_id