DBA Data[Home] [Help]

APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on PO_HEADERS_INTERFACE

Line 1311: -- po_headers_interface table.

1307: -- CURSORS
1308: --=================
1309:
1310: -- Cursor to get the header info to insert into the
1311: -- po_headers_interface table.
1312:
1313: CURSOR header_csr_type IS
1314: SELECT DISTINCT
1315: transaction_source_id

Line 1535: po_headers_interface_s.NEXTVAL

1531: l_document_number := NULL;
1532: END IF;
1533:
1534: SELECT
1535: po_headers_interface_s.NEXTVAL
1536: INTO
1537: l_interface_header_id
1538: FROM
1539: DUAL;

Line 1576: INSERT INTO po_headers_interface

1572: INV_THIRD_PARTY_STOCK_UTIL.get_location(l_current_org_id);
1573:
1574: --l_location_id_OU := l_location_id ;
1575:
1576: INSERT INTO po_headers_interface
1577: ( interface_header_id
1578: , interface_source_code
1579: , batch_id
1580: , document_type_code

Line 3729: SELECT po_headers_interface_s.nextval

3725: -- Generate sequence that will become the new batch id
3726:
3727: /* Bug 11822877. Changed the sequence value from mtl_third_party_cp_s
3728: to be in synchronization with PO headers sequence */
3729: SELECT po_headers_interface_s.nextval
3730: INTO l_batch_id
3731: FROM dual;
3732:
3733: RETURN l_batch_id;