[Home] [Help]
233: AND pol.from_header_id = mct.transaction_source_id
234: AND pol.po_header_id = mct.consumption_po_header_id
235: AND poll.po_line_id = pol.po_line_id
236: AND poll.po_header_id = pol.po_header_id
237: AND poll.shipment_type = 'STANDARD'
238: AND poll.line_location_id = pod.line_location_id
239: AND pod.po_header_id = mct.consumption_po_header_id
240:
241: /* Bug 5604129 - Start */
1170: -- COMMENT : This procedure is called from the worker. It loads
1171: -- : unprocessed summarized change of ownership transactions
1172: -- : from the consumption temp table MTL_CONSUMPTION_TXN_TEMP
1173: -- : into the PO interface tables in preperation for the
1174: -- : creation of either a consumption advice or standard PO
1175: -- : Once this is done the autocreate procedure is called
1176: -- : to process the interface tables and create the release.
1177: -- : The corresponding records are updated with the result,
1178: -- : whether success or failure. If success the last billing date
1604: l_interface_header_id
1605: , 'CONSUMPTION_ADVICE'
1606: , p_batch_id
1607: , l_document_type_code
1608: , DECODE(l_valid_flag,'Y','RELEASE','STANDARD')
1609: , DECODE(l_valid_flag,'Y',segment1,NULL)
1610: , DECODE(l_valid_flag,'G',l_vendor_id,vendor_id) --Bug 4723164
1611: , DECODE(l_valid_flag,'G',l_vendor_site_id,vendor_site_id) --Bug 4723164
1612: , agent_id
2273: l_consumption_release_id := l_document_id;
2274: l_consumption_po_header_id := NULL;
2275: l_error_msg := NULL;
2276: l_consumption_processed_flag := 'Y';
2277: ELSE -- GA, Standard PO was created
2278:
2279: l_consumption_release_id := NULL;
2280: l_consumption_po_header_id := l_document_id;
2281: l_error_msg :=NULL;
2287: l_archive_subtype := 'BLANKET';
2288: l_archive_type := 'RELEASE';
2289: ELSIF NVL(l_valid_flag,'N') = 'G'
2290: THEN
2291: l_archive_subtype := 'STANDARD';
2292: l_archive_type := 'PO';
2293: END IF;
2294:
2295: l_api_version := 1.0;