eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_HEADERS_INTERFACE

Line 206: l_process_code PO_HEADERS_INTERFACE.process_code%TYPE;

202: l_transfer_flag VARCHAR2(1);
203: l_submit_for_buyer_acc_flag VARCHAR2(1);
204:
205: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;
206: l_process_code PO_HEADERS_INTERFACE.process_code%TYPE;
207:
208: x_process_code VARCHAR2(1) := ''; -- bug 7277317
209: l_remove_draft VARCHAR2(1); -- bug5129752
210:

Line 229: FROM po_headers_interface phi,

225: --Cursor to collect all uda_intf data for each header
226: Cursor c_uda_intf(p_interface_header_id number) IS
227:
228: SELECT pui.interface_line_id
229: FROM po_headers_interface phi,
230: po_uda_interface pui
231: WHERE phi.interface_header_id = p_interface_header_id
232: AND phi.interface_header_id = pui.interface_reference_id
233: AND pui.attr_group_type = 'PO_HEADER_EXT_ATTRS'

Line 236: FROM po_headers_interface phi,

232: AND phi.interface_header_id = pui.interface_reference_id
233: AND pui.attr_group_type = 'PO_HEADER_EXT_ATTRS'
234: UNION
235: SELECT pui.interface_line_id
236: FROM po_headers_interface phi,
237: po_lines_interface pli,
238: po_uda_interface pui
239: WHERE phi.interface_header_id = p_interface_header_id
240: AND pli.interface_header_id = phi.interface_header_id

Line 245: FROM po_headers_interface phi,

241: AND pli.interface_line_id = pui.interface_reference_id
242: AND pui.attr_group_type = 'PO_LINE_EXT_ATTRS'
243: UNION
244: SELECT pui.interface_line_id
245: FROM po_headers_interface phi,
246: po_lines_interface pli,
247: po_line_locations_interface pll,
248: po_uda_interface pui
249: WHERE phi.interface_header_id = p_interface_header_id

Line 339: FROM po_headers_interface

335: --LINE_LOCATION_ID in case of shipment level attr
336: forall i in 1..l_uda_lines_tbl.count
337: UPDATE PO_UDA_INTERFACE
338: SET pk1_value = Decode(attr_group_type, 'PO_HEADER_EXT_ATTRS', (SELECT po_header_id
339: FROM po_headers_interface
340: WHERE interface_header_id = interface_reference_id ),
341: 'PO_LINE_EXT_ATTRS' , (SELECT PO_LINE_ID
342: FROM po_lines_interface
343: WHERE interface_line_id = interface_reference_id),

Line 527: UPDATE po_headers_interface

523: not as INCOMPLETE */
524: l_process_code := PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED;
525: END IF;
526:
527: UPDATE po_headers_interface
528: SET process_code = l_process_code
529: WHERE interface_header_id = l_doc_rec.interface_header_id;
530:
531: --removing the document_numbering for clm docs and moving it to a separate api assign_clm_document_number

Line 755: FROM po_headers_interface PHI

751: INTO l_intf_header_id_tbl,
752: l_action_tbl,
753: l_dft_id_tbl,
754: l_po_header_id_tbl
755: FROM po_headers_interface PHI
756: WHERE processing_id = -PO_PDOI_PARAMS.g_processing_id
757: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num;
758:
759: d_position := 10;

Line 934: p_table_name => 'PO_HEADERS_INTERFACE',

930:
931: PO_PDOI_ERR_UTL.add_fatal_error
932: ( p_interface_header_id => p_doc_rec.interface_header_id,
933: p_error_message_name => 'PO_PDOI_INVALID_NUM_OF_LINES',
934: p_table_name => 'PO_HEADERS_INTERFACE',
935: p_column_name => 'PO_HEADER_ID',
936: p_column_value => p_doc_rec.po_header_id,
937: p_token1_name => 'COLUMN_NAME',
938: p_token1_value => 'PO_HEADER_ID'

Line 1377: UPDATE po_headers_interface

1373: END IF;
1374:
1375: IF (l_doc_info.has_lines_to_notify = FND_API.G_TRUE) THEN
1376: -- set header level process code to NOTIFIED
1377: UPDATE po_headers_interface
1378: SET process_code = 'NOTIFIED'
1379: WHERE interface_header_id = p_doc_rec.interface_header_id;
1380:
1381: IF (PO_LOG.d_stmt) THEN

Line 1692: UPDATE po_headers_interface

1688: IF (l_doc_info.has_lines_to_notify = FND_API.G_TRUE) THEN
1689: d_position := 10;
1690:
1691: -- set header level process code to NOTIFIED
1692: UPDATE po_headers_interface
1693: SET process_code = 'NOTIFIED'
1694: WHERE interface_header_id = p_doc_rec.interface_header_id;
1695:
1696: IF (PO_LOG.d_stmt) THEN

Line 1927: FROM po_headers_interface

1923: END IF;
1924:
1925: SELECT interface_header_id
1926: INTO l_int_header_id
1927: FROM po_headers_interface
1928: WHERE po_header_id = p_doc_rec.PHI_PO_HEADER_ID;
1929:
1930:
1931: -- The following is just a warning message.

Line 1942: p_table_name => 'PO_HEADERS_INTERFACE',

1938:
1939: PO_PDOI_ERR_UTL.process_val_type_errors
1940: (
1941: x_results => l_results,
1942: p_table_name => 'PO_HEADERS_INTERFACE',
1943: p_headers => l_headers
1944: );
1945: END LOOP;
1946: END IF; -- End l_return_status='S'

Line 2031: FROM po_headers_interface

2027: END IF;
2028:
2029: SELECT interface_header_id
2030: INTO l_int_header_id
2031: FROM po_headers_interface
2032: WHERE po_header_id = p_doc_rec.PHI_PO_HEADER_ID;
2033:
2034: -- The following is just a warning message.
2035: l_results.add_result(p_entity_type => c_entity_type_header,

Line 2044: p_table_name => 'PO_HEADERS_INTERFACE',

2040:
2041: PO_PDOI_ERR_UTL.process_val_type_errors
2042: (
2043: x_results => l_results,
2044: p_table_name => 'PO_HEADERS_INTERFACE',
2045: p_headers => l_headers
2046: );
2047:
2048: -- If Total Order Value is less than the funded value, do not launch Approval Workflow

Line 2358: FROM po_headers_interface

2354: END IF;
2355:
2356: SELECT Max(interface_header_id)
2357: INTO l_int_header_id
2358: FROM po_headers_interface
2359: WHERE po_header_id = p_doc_rec.PHI_PO_HEADER_ID;
2360:
2361: -- The following is just a warning message.
2362: FOR i IN 1..l_RETURN_MESSAGE.Count LOOP

Line 2371: p_table_name => 'PO_HEADERS_INTERFACE',

2367:
2368: PO_PDOI_ERR_UTL.process_val_type_errors
2369: (
2370: x_results => l_results,
2371: p_table_name => 'PO_HEADERS_INTERFACE',
2372: p_headers => l_headers
2373: );
2374: END LOOP;
2375: END IF; -- End l_return_status='S'

Line 2785: FROM po_headers_interface PHI,

2781: x_lines.interface_line_id_tbl,
2782: x_lines.sourcing_rule_name_tbl,
2783: x_lines.effective_date_tbl,
2784: x_lines.expiration_date_tbl
2785: FROM po_headers_interface PHI,
2786: po_lines_interface PLI,
2787: po_lines_draft_all PLD
2788: WHERE PHI.interface_header_id = p_doc_rec.interface_header_id
2789: AND PHI.interface_header_id = PLI.interface_header_id

Line 3031: l_intended_approval_status PO_HEADERS_INTERFACE.approval_status%TYPE;

3027: d_api_name CONSTANT VARCHAR2(30) := 'get_approval_method';
3028: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3029: d_position NUMBER;
3030:
3031: l_intended_approval_status PO_HEADERS_INTERFACE.approval_status%TYPE;
3032: BEGIN
3033: d_position := 0;
3034: IF (PO_LOG.d_proc) THEN
3035: PO_LOG.proc_begin(d_module);

Line 3848: p_table_name => 'PO_HEADERS_INTERFACE',

3844: d_position := 10;
3845: PO_PDOI_ERR_UTL.add_fatal_error
3846: ( p_interface_header_id => p_doc_rec.interface_header_id,
3847: p_error_message_name => 'PO_PDOI_UNABLE_CLOSE_PO',
3848: p_table_name => 'PO_HEADERS_INTERFACE',
3849: p_column_name => 'CLOSED_CODE',
3850: p_column_value => ''
3851: );
3852:

Line 3982: p_table_name => 'PO_HEADERS_INTERFACE',

3978: PO_PDOI_ERR_UTL.add_warning
3979: (
3980: p_interface_header_id => p_doc_rec.interface_header_id,
3981: p_error_message_name => 'PO_PDOI_TAX_CALCULATION_ERR',
3982: p_table_name => 'PO_HEADERS_INTERFACE',
3983: p_column_name => NULL
3984: );
3985: END IF;
3986: