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_AUTO_IMPLEMENT_PVT dependencies on PO_HEADERS_INTERFACE

Line 12: x_org_id PO_HEADERS_INTERFACE.org_id%TYPE;

8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
10:
11:
12: x_org_id PO_HEADERS_INTERFACE.org_id%TYPE;
13:
14:
15:
16: /* -----------------------------------------------------

Line 42: x_interface_header_id PO_HEADERS_INTERFACE.interface_header_id%TYPE;

38: x_po_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
39: x_po_line_num PO_LINES_ALL.line_num%TYPE;
40:
41: -- Headers Interface
42: x_interface_header_id PO_HEADERS_INTERFACE.interface_header_id%TYPE;
43: x_document_num PO_HEADERS_INTERFACE.document_num%TYPE;
44: x_document_type PO_HEADERS_INTERFACE.document_type_code%TYPE;
45: x_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;
46: x_vendor_id PO_HEADERS_INTERFACE.vendor_id%TYPE;

Line 43: x_document_num PO_HEADERS_INTERFACE.document_num%TYPE;

39: x_po_line_num PO_LINES_ALL.line_num%TYPE;
40:
41: -- Headers Interface
42: x_interface_header_id PO_HEADERS_INTERFACE.interface_header_id%TYPE;
43: x_document_num PO_HEADERS_INTERFACE.document_num%TYPE;
44: x_document_type PO_HEADERS_INTERFACE.document_type_code%TYPE;
45: x_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;
46: x_vendor_id PO_HEADERS_INTERFACE.vendor_id%TYPE;
47: x_agent_id PO_HEADERS_INTERFACE.agent_id%TYPE;

Line 44: x_document_type PO_HEADERS_INTERFACE.document_type_code%TYPE;

40:
41: -- Headers Interface
42: x_interface_header_id PO_HEADERS_INTERFACE.interface_header_id%TYPE;
43: x_document_num PO_HEADERS_INTERFACE.document_num%TYPE;
44: x_document_type PO_HEADERS_INTERFACE.document_type_code%TYPE;
45: x_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;
46: x_vendor_id PO_HEADERS_INTERFACE.vendor_id%TYPE;
47: x_agent_id PO_HEADERS_INTERFACE.agent_id%TYPE;
48: x_vendor_site_id PO_HEADERS_INTERFACE.vendor_site_id%TYPE;

Line 45: x_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;

41: -- Headers Interface
42: x_interface_header_id PO_HEADERS_INTERFACE.interface_header_id%TYPE;
43: x_document_num PO_HEADERS_INTERFACE.document_num%TYPE;
44: x_document_type PO_HEADERS_INTERFACE.document_type_code%TYPE;
45: x_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;
46: x_vendor_id PO_HEADERS_INTERFACE.vendor_id%TYPE;
47: x_agent_id PO_HEADERS_INTERFACE.agent_id%TYPE;
48: x_vendor_site_id PO_HEADERS_INTERFACE.vendor_site_id%TYPE;
49: x_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE := null;

Line 46: x_vendor_id PO_HEADERS_INTERFACE.vendor_id%TYPE;

42: x_interface_header_id PO_HEADERS_INTERFACE.interface_header_id%TYPE;
43: x_document_num PO_HEADERS_INTERFACE.document_num%TYPE;
44: x_document_type PO_HEADERS_INTERFACE.document_type_code%TYPE;
45: x_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;
46: x_vendor_id PO_HEADERS_INTERFACE.vendor_id%TYPE;
47: x_agent_id PO_HEADERS_INTERFACE.agent_id%TYPE;
48: x_vendor_site_id PO_HEADERS_INTERFACE.vendor_site_id%TYPE;
49: x_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE := null;
50: x_rate_type PO_HEADERS_INTERFACE.rate_type_code%TYPE := null;

Line 47: x_agent_id PO_HEADERS_INTERFACE.agent_id%TYPE;

43: x_document_num PO_HEADERS_INTERFACE.document_num%TYPE;
44: x_document_type PO_HEADERS_INTERFACE.document_type_code%TYPE;
45: x_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;
46: x_vendor_id PO_HEADERS_INTERFACE.vendor_id%TYPE;
47: x_agent_id PO_HEADERS_INTERFACE.agent_id%TYPE;
48: x_vendor_site_id PO_HEADERS_INTERFACE.vendor_site_id%TYPE;
49: x_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE := null;
50: x_rate_type PO_HEADERS_INTERFACE.rate_type_code%TYPE := null;
51: x_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE := null;

Line 48: x_vendor_site_id PO_HEADERS_INTERFACE.vendor_site_id%TYPE;

44: x_document_type PO_HEADERS_INTERFACE.document_type_code%TYPE;
45: x_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;
46: x_vendor_id PO_HEADERS_INTERFACE.vendor_id%TYPE;
47: x_agent_id PO_HEADERS_INTERFACE.agent_id%TYPE;
48: x_vendor_site_id PO_HEADERS_INTERFACE.vendor_site_id%TYPE;
49: x_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE := null;
50: x_rate_type PO_HEADERS_INTERFACE.rate_type_code%TYPE := null;
51: x_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE := null;
52: x_rate PO_HEADERS_INTERFACE.rate%TYPE := null;

Line 49: x_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE := null;

45: x_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;
46: x_vendor_id PO_HEADERS_INTERFACE.vendor_id%TYPE;
47: x_agent_id PO_HEADERS_INTERFACE.agent_id%TYPE;
48: x_vendor_site_id PO_HEADERS_INTERFACE.vendor_site_id%TYPE;
49: x_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE := null;
50: x_rate_type PO_HEADERS_INTERFACE.rate_type_code%TYPE := null;
51: x_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE := null;
52: x_rate PO_HEADERS_INTERFACE.rate%TYPE := null;
53: x_style_id PO_HEADERS_INTERFACE.style_id%TYPE := null;

Line 50: x_rate_type PO_HEADERS_INTERFACE.rate_type_code%TYPE := null;

46: x_vendor_id PO_HEADERS_INTERFACE.vendor_id%TYPE;
47: x_agent_id PO_HEADERS_INTERFACE.agent_id%TYPE;
48: x_vendor_site_id PO_HEADERS_INTERFACE.vendor_site_id%TYPE;
49: x_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE := null;
50: x_rate_type PO_HEADERS_INTERFACE.rate_type_code%TYPE := null;
51: x_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE := null;
52: x_rate PO_HEADERS_INTERFACE.rate%TYPE := null;
53: x_style_id PO_HEADERS_INTERFACE.style_id%TYPE := null;
54: x_pcard_id PO_HEADERS_INTERFACE.pcard_id%TYPE := null;

Line 51: x_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE := null;

47: x_agent_id PO_HEADERS_INTERFACE.agent_id%TYPE;
48: x_vendor_site_id PO_HEADERS_INTERFACE.vendor_site_id%TYPE;
49: x_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE := null;
50: x_rate_type PO_HEADERS_INTERFACE.rate_type_code%TYPE := null;
51: x_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE := null;
52: x_rate PO_HEADERS_INTERFACE.rate%TYPE := null;
53: x_style_id PO_HEADERS_INTERFACE.style_id%TYPE := null;
54: x_pcard_id PO_HEADERS_INTERFACE.pcard_id%TYPE := null;
55:

Line 52: x_rate PO_HEADERS_INTERFACE.rate%TYPE := null;

48: x_vendor_site_id PO_HEADERS_INTERFACE.vendor_site_id%TYPE;
49: x_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE := null;
50: x_rate_type PO_HEADERS_INTERFACE.rate_type_code%TYPE := null;
51: x_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE := null;
52: x_rate PO_HEADERS_INTERFACE.rate%TYPE := null;
53: x_style_id PO_HEADERS_INTERFACE.style_id%TYPE := null;
54: x_pcard_id PO_HEADERS_INTERFACE.pcard_id%TYPE := null;
55:
56: -- Lines Interface

Line 53: x_style_id PO_HEADERS_INTERFACE.style_id%TYPE := null;

49: x_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE := null;
50: x_rate_type PO_HEADERS_INTERFACE.rate_type_code%TYPE := null;
51: x_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE := null;
52: x_rate PO_HEADERS_INTERFACE.rate%TYPE := null;
53: x_style_id PO_HEADERS_INTERFACE.style_id%TYPE := null;
54: x_pcard_id PO_HEADERS_INTERFACE.pcard_id%TYPE := null;
55:
56: -- Lines Interface
57: x_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;

Line 54: x_pcard_id PO_HEADERS_INTERFACE.pcard_id%TYPE := null;

50: x_rate_type PO_HEADERS_INTERFACE.rate_type_code%TYPE := null;
51: x_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE := null;
52: x_rate PO_HEADERS_INTERFACE.rate%TYPE := null;
53: x_style_id PO_HEADERS_INTERFACE.style_id%TYPE := null;
54: x_pcard_id PO_HEADERS_INTERFACE.pcard_id%TYPE := null;
55:
56: -- Lines Interface
57: x_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;
58: x_clm_option_exercised PO_REQUISITION_LINES_ALL.clm_option_exercised%TYPE; -- Bug 9838483

Line 105: SELECT po_headers_interface_s.nextval

101: x_document_type :='PA';
102: END IF;
103:
104: l_progress:= '020';
105: SELECT po_headers_interface_s.nextval
106: INTO PO_AUTOCREATE_PARAMS.x_interface_header_id
107: FROM dual;
108:
109: IF g_debug_stmt THEN

Line 118: INSERT INTO po_headers_interface

114:
115: l_progress:= '030';
116: BEGIN
117:
118: INSERT INTO po_headers_interface
119: (interface_header_id,
120: interface_source_code,
121: batch_id,
122: process_code, /* This used to be process_flag */

Line 193: p_message => 'After inserting records into po_headers_interface: interface_header_id : '||PO_AUTOCREATE_PARAMS.x_interface_header_id);

189: l_progress:= '040';
190: IF g_debug_stmt THEN
191: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
192: p_token => l_progress,
193: p_message => 'After inserting records into po_headers_interface: interface_header_id : '||PO_AUTOCREATE_PARAMS.x_interface_header_id);
194: END IF;
195:
196: /* Populate Header - ends here */
197: