APPS.PO_PDOI_UTL dependencies on PO_HEADERS_INTERFACE

Line 110: -- Get the next batch id to be inserted into po_headers_interface.

106: -----------------------------------------------------------------------
107: --Start of Comments
108: --Name: get_next_batch_id
109: --Function:
110: -- Get the next batch id to be inserted into po_headers_interface.
111: -- It's done by getting max (batch_id) + 1 from po_headers_interface
112: --Parameters:
113: --IN:
114: --IN OUT:

Line 111: -- It's done by getting max (batch_id) + 1 from po_headers_interface

107: --Start of Comments
108: --Name: get_next_batch_id
109: --Function:
110: -- Get the next batch id to be inserted into po_headers_interface.
111: -- It's done by getting max (batch_id) + 1 from po_headers_interface
112: --Parameters:
113: --IN:
114: --IN OUT:
115: --OUT:

Line 126: l_batch_id PO_HEADERS_INTERFACE.batch_id%TYPE;

122: d_api_name CONSTANT VARCHAR2(30) := 'get_next_batch_id';
123: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
124: d_position NUMBER;
125:
126: l_batch_id PO_HEADERS_INTERFACE.batch_id%TYPE;
127: BEGIN
128: d_position := 0;
129:
130: IF (PO_LOG.d_proc) THEN

Line 136: FROM po_headers_interface;

132: END IF;
133:
134: SELECT NVL(MAX(batch_id), 0) + 1
135: INTO l_batch_id
136: FROM po_headers_interface;
137:
138: IF (PO_LOG.d_stmt) THEN
139: PO_LOG.stmt(d_module, d_position, 'batch_id', l_batch_id);
140: END IF;

Line 198: UPDATE po_headers_interface

194:
195: IF (p_id_param_type = PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID) THEN
196: d_position := 20;
197: FORALL i IN 1..p_id_tbl.COUNT
198: UPDATE po_headers_interface
199: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
200: processing_id = -PO_PDOI_PARAMS.g_processing_id
201: WHERE interface_header_id = p_id_tbl(i)
202: AND processing_id = PO_PDOI_PARAMS.g_processing_id;