The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pha.type_lookup_code,
pha.segment1,
pha.agent_id,
pha.vendor_id,
pha.vendor_site_id,
pha.currency_code,
pha.rate_type,
pha.rate_date,
pha.rate,
pha.org_id,
pha.style_id,
pha.pcard_id
INTO x_document_subtype,
x_document_num,
x_agent_id,
x_vendor_id,
x_vendor_site_id,
x_currency_code,
x_rate_type,
x_rate_date,
x_rate,
x_org_id,
x_style_id,
x_pcard_id
FROM po_headers_all pha
WHERE pha.po_header_id = po_doc_id;
SELECT po_headers_interface_s.nextval
INTO PO_AUTOCREATE_PARAMS.x_interface_header_id
FROM dual;
INSERT INTO po_headers_interface
(interface_header_id,
interface_source_code,
batch_id,
process_code, /* This used to be process_flag */
action, /* This used to be action_type_code */
document_type_code,
document_subtype,
document_num,
group_code,
vendor_id,
vendor_site_id,
release_num,
release_date,
agent_id,
currency_code,
rate_type_code, /* This used to be rate_type */
rate_date,
rate,
vendor_list_header_id,
-- quote_type_lookup_code, <-- no longer in headers_interface
-- quotation_class_code, <-- no longer in headers_interface
--DPCARD{
pcard_id,
--DPCARD}
creation_date,
created_by,
last_update_date,
last_updated_by,
org_id, --
style_id) --
VALUES (PO_AUTOCREATE_PARAMS.x_interface_header_id,
'PO',
PO_AUTOCREATE_PARAMS.x_interface_header_id,
'ADD',
'ADD',
x_document_type,
x_document_subtype,
x_document_num,
'REQUISITION',
x_vendor_id,
x_vendor_site_id,
NULL,
NULL,
x_agent_id,
x_currency_code,
x_rate_type,
x_rate_date,
x_rate,
NULL,
--DPCARD{
x_pcard_id,
--DPCARD}
sysdate,
FND_GLOBAL.user_id,
sysdate,
FND_GLOBAL.user_id,
x_org_id,
x_style_id);
p_message => 'After inserting records into po_headers_interface: interface_header_id : '||PO_AUTOCREATE_PARAMS.x_interface_header_id);
SELECT group_line_id,
clm_info_flag
INTO x_group_line_id,
x_info_slin_falg
FROM po_requisition_lines_all prl
WHERE prl.requisition_line_id=x_req_line_id
AND prl.group_line_id IS NOT NULL;
SELECT clm_option_exercised
INTO x_clm_option_exercised
FROM po_requisition_lines_all prl
WHERE prl.requisition_line_id=x_req_line_id;
SELECT line_location_id
INTO x_po_line_location_id
FROM po_requisition_lines_all prl
WHERE prl.requisition_line_id = x_req_line_id;
SELECT line_location_id
INTO x_po_line_location_id
FROM po_requisition_lines_all prl
WHERE prl.requisition_line_id = x_group_line_id;
SELECT pla.line_num,
pll.shipment_num
INTO x_po_line_num,
x_po_shipment_num
FROM po_line_locations_all pll,
po_lines_all pla
WHERE pla.po_line_id = pll.po_line_id
AND pll.line_location_id = x_po_line_location_id;
SELECT po_lines_interface_s.nextval
INTO x_interface_line_id
FROM dual;
INSERT INTO po_lines_interface
(interface_header_id,
interface_line_id,
action,
line_num,
shipment_num,
requisition_line_id,
quantity,
amount,
creation_date,
created_by,
last_update_date,
last_updated_by)
VALUES(PO_AUTOCREATE_PARAMS.x_interface_header_id,
x_interface_line_id,
NULL,
x_po_line_num,
x_po_shipment_num,
x_group_line_id,
0,
0,
sysdate,
FND_GLOBAL.user_id,
sysdate,
FND_GLOBAL.user_id);
SELECT po_lines_interface_s.nextval
INTO x_interface_line_id
FROM dual;
INSERT INTO po_lines_interface
(interface_header_id,
interface_line_id,
action,
requisition_line_id,
creation_date,
created_by,
last_update_date,
last_updated_by)
VALUES(PO_AUTOCREATE_PARAMS.x_interface_header_id,
x_interface_line_id,
NULL,
x_req_line_id,
sysdate,
FND_GLOBAL.user_id,
sysdate,
FND_GLOBAL.user_id);
SELECT po_lines_interface_s.nextval
INTO x_interface_line_id
FROM dual;
INSERT INTO po_lines_interface
(interface_header_id,
interface_line_id,
action,
line_num,
shipment_num,
requisition_line_id,
quantity,
amount,
creation_date,
created_by,
last_update_date,
last_updated_by,
clm_exercised_flag, -- Bug 9838483
clm_exercised_date) -- Bug 11890703
VALUES(PO_AUTOCREATE_PARAMS.x_interface_header_id,
x_interface_line_id,
NULL,
x_po_line_num,
x_po_shipment_num,
x_req_line_id,
0,
0,
sysdate,
FND_GLOBAL.user_id,
sysdate,
FND_GLOBAL.user_id,
x_clm_option_exercised, -- Bug 9838483
Decode(x_clm_option_exercised, 'Y', SYSDATE, NULL)); -- Bug 11890703
SELECT group_line_id,
clm_info_flag,
org_id
INTO x_group_line_id,
x_info_slin_falg,
x_req_operating_unit_id
FROM po_requisition_lines_all prl
WHERE prl.requisition_line_id=x_req_line_id
AND prl.group_line_id IS NOT NULL;
SELECT line_location_id
INTO x_po_line_location_id
FROM po_requisition_lines_all prl
WHERE prl.requisition_line_id = x_req_line_id;
SELECT line_location_id
INTO x_po_line_location_id
FROM po_requisition_lines_all prl
WHERE prl.requisition_line_id = x_group_line_id;
SELECT pha.po_header_id
INTO x_po_header_id
FROM po_line_locations_all pll,
po_headers_all pha
WHERE pha.po_header_id = pll.po_header_id
AND pll.line_location_id = x_po_line_location_id;