DBA Data[Home] [Help]

APPS.PO_AUTO_IMPLEMENT_PVT dependencies on PO_AUTOCREATE_PARAMS

Line 106: INTO PO_AUTOCREATE_PARAMS.x_interface_header_id

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
110: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 112: p_message => 'After getting interface header id :'||PO_AUTOCREATE_PARAMS.x_interface_header_id);

108:
109: IF g_debug_stmt THEN
110: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
111: p_token => l_progress,
112: p_message => 'After getting interface header id :'||PO_AUTOCREATE_PARAMS.x_interface_header_id);
113: END IF;
114:
115: l_progress:= '030';
116: BEGIN

Line 149: VALUES (PO_AUTOCREATE_PARAMS.x_interface_header_id,

145: last_update_date,
146: last_updated_by,
147: org_id, --
148: style_id) --
149: VALUES (PO_AUTOCREATE_PARAMS.x_interface_header_id,
150: 'PO',
151: PO_AUTOCREATE_PARAMS.x_interface_header_id,
152: 'ADD',
153: 'ADD',

Line 151: PO_AUTOCREATE_PARAMS.x_interface_header_id,

147: org_id, --
148: style_id) --
149: VALUES (PO_AUTOCREATE_PARAMS.x_interface_header_id,
150: 'PO',
151: PO_AUTOCREATE_PARAMS.x_interface_header_id,
152: 'ADD',
153: 'ADD',
154: x_document_type,
155: x_document_subtype,

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:

Line 310: VALUES(PO_AUTOCREATE_PARAMS.x_interface_header_id,

306: creation_date,
307: created_by,
308: last_update_date,
309: last_updated_by)
310: VALUES(PO_AUTOCREATE_PARAMS.x_interface_header_id,
311: x_interface_line_id,
312: NULL,
313: x_po_line_num,
314: x_po_shipment_num,

Line 342: VALUES(PO_AUTOCREATE_PARAMS.x_interface_header_id,

338: creation_date,
339: created_by,
340: last_update_date,
341: last_updated_by)
342: VALUES(PO_AUTOCREATE_PARAMS.x_interface_header_id,
343: x_interface_line_id,
344: NULL,
345: x_req_line_id,
346: sysdate,

Line 376: VALUES(PO_AUTOCREATE_PARAMS.x_interface_header_id,

372: last_update_date,
373: last_updated_by,
374: clm_exercised_flag, -- Bug 9838483
375: clm_exercised_date) -- Bug 11890703
376: VALUES(PO_AUTOCREATE_PARAMS.x_interface_header_id,
377: x_interface_line_id,
378: NULL,
379: x_po_line_num,
380: x_po_shipment_num,

Line 538: PO_AUTOCREATE_PARAMS.g_is_clm_po := 'Y';

534: p_message => 'After populating the interface tables');
535: END IF;
536:
537: -- Call the AutoCreate API to add the new Info Line or Distribution
538: PO_AUTOCREATE_PARAMS.g_is_clm_po := 'Y';
539: PO_AUTOCREATE_PVT.create_po(PO_AUTOCREATE_PARAMS.x_interface_header_id
540: ,x_po_header_id
541: ,NULL
542: ,'N'

Line 539: PO_AUTOCREATE_PVT.create_po(PO_AUTOCREATE_PARAMS.x_interface_header_id

535: END IF;
536:
537: -- Call the AutoCreate API to add the new Info Line or Distribution
538: PO_AUTOCREATE_PARAMS.g_is_clm_po := 'Y';
539: PO_AUTOCREATE_PVT.create_po(PO_AUTOCREATE_PARAMS.x_interface_header_id
540: ,x_po_header_id
541: ,NULL
542: ,'N'
543: ,'AUTOCREATE'