APPS.GML_PO_SYNCH dependencies on CPG_ORAGEMS_MAPPING

Line 241: FROM cpg_oragems_mapping

237: IS
238:
239: CURSOR id_cur(header NUMBER, line NUMBER, location NUMBER) IS
240: SELECT po_id, line_id
241: FROM cpg_oragems_mapping
242: WHERE po_header_id = header
243: AND po_line_id = line
244: AND po_line_location_id = location;
245:

Line 1182: From cpg_oragems_mapping

1178: IS
1179:
1180: cursor total_lines_cur IS
1181: Select count(*)
1182: From cpg_oragems_mapping
1183: Where po_id = p_po_id;
1184:
1185: Cursor get_line_status IS
1186: Select po_status

Line 1563: FROM cpg_oragems_mapping

1559: v_source_shipment_id CPG_PURCHASING_INTERFACE.SOURCE_SHIPMENT_ID%TYPE
1560: )
1561: IS
1562: SELECT bpo_id, bpo_line_id
1563: FROM cpg_oragems_mapping
1564: WHERE po_header_id = v_po_header_id
1565: AND po_line_id = v_po_line_id
1566: AND po_line_location_id = v_source_shipment_id;
1567:

Line 1592: FROM cpg_oragems_mapping

1588:
1589: CURSOR line_id_cur(v_po_header_id NUMBER, v_po_line_id NUMBER,
1590: v_po_line_location_id NUMBER) IS
1591: SELECT line_id
1592: FROM cpg_oragems_mapping
1593: WHERE po_header_id = v_po_header_id
1594: AND po_line_id = v_po_line_id
1595: AND po_line_location_id = v_po_line_location_id;
1596:

Line 2714: UPDATE cpg_oragems_mapping

2710: raise_application_error(-20001, err_msg);
2711: END;
2712:
2713: BEGIN
2714: UPDATE cpg_oragems_mapping
2715: SET po_id = v_po_id,
2716: line_id = v_new_line_id
2717: WHERE po_header_id = int_rec.po_header_id
2718: AND po_line_id = int_rec.po_line_id

Line 2723: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating cpg_oragems_mapping

2719: AND po_line_location_id = int_rec.po_line_location_id;
2720: EXCEPTION
2721: WHEN OTHERS THEN
2722: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2723: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating cpg_oragems_mapping
2724: ');
2725: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2726: err_num := SQLCODE;
2727: err_msg := SUBSTRB (SQLERRM, 1, 100);