APPS.CLN_PO_SYNC_CAT_PKG dependencies on PO_HEADERS_INTERFACE

Line 21: -- Creates a row in PO_HEADERS_INTERFACE and updates the collaboration

17:
18: -- Name
19: -- PROCESS_HEADER
20: -- Purpose
21: -- Creates a row in PO_HEADERS_INTERFACE and updates the collaboration
22: -- based on Catalog header details
23: -- Arguments
24: -- Catalog header details
25: -- Notes

Line 210: -- Insert in to PO_HEADERS_INTERFACE

206: END IF;
207:
208: SAVEPOINT PO_UPDATE_TXN;
209:
210: -- Insert in to PO_HEADERS_INTERFACE
211: IF x_operation = 'INSERT' THEN
212: -- Create a new BPO
213: -- While creating a new po, vendor document num
214: -- needs to be filled with catalog name

Line 222: INSERT INTO po_headers_interface(interface_header_id,

218: grouping factor, we never know the action is create.
219: We will populate it in the workflow using the procedure
220: SET_ACTION_CREATE_OR_UPDATE
221: */
222: INSERT INTO po_headers_interface(interface_header_id,
223: batch_id,
224: --action,
225: document_type_code,
226: vendor_id,

Line 249: INSERT INTO po_headers_interface(interface_header_id,

245: ELSE
246: -- Update an existing BPO
247: -- Need to insert a row in this case also
248: -- Action UPDATE
249: INSERT INTO po_headers_interface(interface_header_id,
250: batch_id,
251: action,
252: document_type_code,
253: vendor_id,

Line 829: UPDATE po_headers_interface

825: -- Need to update PO interface header table with currency code.
826:
827: IF x_bpo_cur_updated = 'NO' AND p_price_currency IS NOT NULL THEN
828:
829: UPDATE po_headers_interface
830: SET currency_code = p_price_currency
831: WHERE interface_header_id = p_itf_hdr_id;
832:
833: x_bpo_cur_updated := 'YES';

Line 1377: UPDATE po_headers_interface

1373: cln_debug_pub.Add('p_vendor_id:'||p_vendor_id, 2);
1374:
1375: END IF;
1376: -- To lock the rows
1377: UPDATE po_headers_interface
1378: SET vendor_doc_num = p_catalog_name
1379: WHERE vendor_doc_num = p_catalog_name
1380: AND vendor_id = p_vendor_id
1381: AND ACTION is NULL;

Line 1407: UPDATE po_headers_interface

1403: END IF;
1404:
1405: IF (l_po_header_id > 0 ) THEN
1406: --There is an existing PO, set the action to UPDATE and retrun from this procedure
1407: UPDATE po_headers_interface
1408: SET action = 'UPDATE'
1409: WHERE batch_id = p_batch_id;
1410: x_resultout := 'Y';
1411: COMMIT;

Line 1423: FROM po_headers_interface

1419: l_interface_hdr_rec_count := 0;
1420: -- Check whether there is any row, which is in process, for the same catalog. If so, then Wait.
1421: SELECT count('x')
1422: INTO l_interface_hdr_rec_count
1423: FROM po_headers_interface
1424: WHERE vendor_doc_num = p_catalog_name
1425: AND vendor_id = p_vendor_id
1426: AND ACTION = 'ORIGINAL'
1427: AND nvl(process_code,'~') NOT IN ('ACCEPTED', 'REJECTED');

Line 1464: UPDATE po_headers_interface

1460: END IF;
1461:
1462: IF (l_po_header_id > 0 ) THEN
1463: --There is an existing PO, set the action to UPDATE and retrun from this procedure
1464: UPDATE po_headers_interface
1465: SET action = 'UPDATE'
1466: WHERE batch_id = p_batch_id;
1467: ELSE
1468: UPDATE po_headers_interface

Line 1468: UPDATE po_headers_interface

1464: UPDATE po_headers_interface
1465: SET action = 'UPDATE'
1466: WHERE batch_id = p_batch_id;
1467: ELSE
1468: UPDATE po_headers_interface
1469: SET action = 'ORIGINAL'
1470: WHERE batch_id = p_batch_id;
1471: END IF;
1472: x_resultout := 'Y';