APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_HEADERS_INTERFACE

Line 178: l_process_code PO_HEADERS_INTERFACE.process_code%TYPE;

174: l_transfer_flag VARCHAR2(1);
175: l_submit_for_buyer_acc_flag VARCHAR2(1);
176:
177: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;
178: l_process_code PO_HEADERS_INTERFACE.process_code%TYPE;
179:
180: x_process_code VARCHAR2(1) := ''; -- bug 7277317
181: l_remove_draft VARCHAR2(1); -- bug5129752
182: BEGIN

Line 398: UPDATE po_headers_interface

394: IF (x_process_code = 'I' ) THEN
395: l_process_code := 'INCOMPLETE';
396: END IF;
397:
398: UPDATE po_headers_interface
399: SET process_code = l_process_code
400: WHERE interface_header_id = l_doc_rec.interface_header_id;
401:
402: IF (PO_LOG.d_stmt) THEN

Line 624: FROM po_headers_interface PHI

620: INTO l_intf_header_id_tbl,
621: l_action_tbl,
622: l_dft_id_tbl,
623: l_po_header_id_tbl
624: FROM po_headers_interface PHI
625: WHERE processing_id = -PO_PDOI_PARAMS.g_processing_id
626: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num;
627:
628: d_position := 10;

Line 803: p_table_name => 'PO_HEADERS_INTERFACE',

799:
800: PO_PDOI_ERR_UTL.add_fatal_error
801: ( p_interface_header_id => p_doc_rec.interface_header_id,
802: p_error_message_name => 'PO_PDOI_INVALID_NUM_OF_LINES',
803: p_table_name => 'PO_HEADERS_INTERFACE',
804: p_column_name => 'PO_HEADER_ID',
805: p_column_value => p_doc_rec.po_header_id,
806: p_token1_name => 'COLUMN_NAME',
807: p_token1_value => 'PO_HEADER_ID'

Line 1215: UPDATE po_headers_interface

1211: END IF;
1212:
1213: IF (l_doc_info.has_lines_to_notify = FND_API.G_TRUE) THEN
1214: -- set header level process code to NOTIFIED
1215: UPDATE po_headers_interface
1216: SET process_code = 'NOTIFIED'
1217: WHERE interface_header_id = p_doc_rec.interface_header_id;
1218:
1219: IF (PO_LOG.d_stmt) THEN

Line 1508: UPDATE po_headers_interface

1504: IF (l_doc_info.has_lines_to_notify = FND_API.G_TRUE) THEN
1505: d_position := 10;
1506:
1507: -- set header level process code to NOTIFIED
1508: UPDATE po_headers_interface
1509: SET process_code = 'NOTIFIED'
1510: WHERE interface_header_id = p_doc_rec.interface_header_id;
1511:
1512: IF (PO_LOG.d_stmt) THEN

Line 2207: FROM po_headers_interface PHI,

2203: x_lines.interface_line_id_tbl,
2204: x_lines.sourcing_rule_name_tbl,
2205: x_lines.effective_date_tbl,
2206: x_lines.expiration_date_tbl
2207: FROM po_headers_interface PHI,
2208: po_lines_interface PLI,
2209: po_lines_draft_all PLD
2210: WHERE PHI.interface_header_id = p_doc_rec.interface_header_id
2211: AND PHI.interface_header_id = PLI.interface_header_id

Line 2453: l_intended_approval_status PO_HEADERS_INTERFACE.approval_status%TYPE;

2449: d_api_name CONSTANT VARCHAR2(30) := 'get_approval_method';
2450: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2451: d_position NUMBER;
2452:
2453: l_intended_approval_status PO_HEADERS_INTERFACE.approval_status%TYPE;
2454: BEGIN
2455: d_position := 0;
2456: IF (PO_LOG.d_proc) THEN
2457: PO_LOG.proc_begin(d_module);

Line 3207: p_table_name => 'PO_HEADERS_INTERFACE',

3203: d_position := 10;
3204: PO_PDOI_ERR_UTL.add_fatal_error
3205: ( p_interface_header_id => p_doc_rec.interface_header_id,
3206: p_error_message_name => 'PO_PDOI_UNABLE_CLOSE_PO',
3207: p_table_name => 'PO_HEADERS_INTERFACE',
3208: p_column_name => 'CLOSED_CODE',
3209: p_column_value => ''
3210: );
3211:

Line 3329: p_table_name => 'PO_HEADERS_INTERFACE',

3325: PO_PDOI_ERR_UTL.add_warning
3326: (
3327: p_interface_header_id => p_doc_rec.interface_header_id,
3328: p_error_message_name => 'PO_PDOI_TAX_CALCULATION_ERR',
3329: p_table_name => 'PO_HEADERS_INTERFACE',
3330: p_column_name => NULL
3331: );
3332: END IF;
3333: