The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT hsecs INTO l_Timer FROM v$timer;
g_SchedItemTab.DELETE;
UPDATE rlm_interface_lines_all
SET schedule_item_num = x_SchedItemNum
WHERE header_id = x_HeaderID AND
NVL(cust_ship_from_org_ext, k_VNULL) = NVL(g_SchedItemTab(i).ship_from_ext, k_VNULL) AND
NVL(cust_ship_to_ext, k_VNULL) = NVL(g_SchedItemTab(i).ship_to_ext, k_VNULL) AND
NVL(cust_bill_to_ext, k_VNULL) = NVL(g_SchedItemTab(i).bill_to_ext, k_VNULL) AND
NVL(customer_item_ext, k_VNULL) = NVL(g_SchedItemTab(i).cust_item_ext, k_VNULL) AND
NVL(item_description_ext, k_VNULL) = NVL(g_SchedItemTab(i).item_desc_ext, k_VNULL) AND
NVL(customer_dock_code, k_VNULL) = NVL(g_SchedItemTab(i).cust_dock_code, k_VNULL) AND
NVL(hazard_code_ext, k_VNULL) = NVL(g_SchedItemTab(i).hazrd_code_ext, k_VNULL) AND
NVL(customer_item_revision, k_VNULL) = NVL(g_SchedItemTab(i).cust_item_rev, k_VNULL) AND
NVL(item_note_text, k_VNULL) = NVL(g_SchedItemTab(i).item_note_text, k_VNULL) AND
NVL(cust_po_number, k_VNULL) = NVL(g_SchedItemTab(i).cust_po_num, k_VNULL) AND
NVL(cust_po_line_num, k_VNULL) = NVL(g_SchedItemTab(i).cust_po_linnum, k_VNULL) AND
NVL(cust_po_release_num, k_VNULL) = NVL(g_SchedItemTab(i).cust_po_relnum, k_VNULL) AND
NVL(cust_po_date, k_DNULL) = NVL(g_SchedItemTab(i).cust_po_date, k_DNULL) AND
NVL(commodity_ext, k_VNULL) = NVL(g_SchedItemTab(i).commodity_ext, k_VNULL) AND
NVL(supplier_item_ext, k_VNULL) = NVL(g_SchedItemTab(i).sup_item_ext, k_VNULL);
UPDATE rlm_interface_headers_all
SET sched_horizon_start_date = TRUNC(sched_horizon_start_date),
sched_horizon_end_date = TRUNC(sched_horizon_end_date) + 0.99999
WHERE header_id = x_HeaderID;
rlm_core_sv.dlog(C_DEBUG, '# of rows updated', SQL%ROWCOUNT);
SELECT cust_ship_from_org_ext,
cust_ship_to_ext,
cust_bill_to_ext,
customer_item_ext,
item_description_ext,
customer_dock_code,
hazard_code_ext,
customer_item_revision,
item_note_text,
cust_po_number,
cust_po_line_num,
cust_po_release_num,
cust_po_date,
commodity_ext,
supplier_item_ext
FROM rlm_interface_lines_all
WHERE header_id = x_HeaderID;
InsertItemAttribRec(c_ItemAttribsRec);
PROCEDURE InsertItemAttribRec(x_ItemAttribsRec IN t_ItemAttribsRec) IS
--
v_Index NUMBER;
rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.InsertItemAttribs');
END InsertItemAttribRec;
PROCEDURE UpdateLineNumbers(x_HeaderID IN NUMBER,
x_ErrCode IN OUT NOCOPY NUMBER,
x_ErrMsg IN OUT NOCOPY VARCHAR2) IS
--
v_linenumber NUMBER := 1;
SELECT line_id
FROM rlm_interface_lines_all
WHERE header_id = x_HeaderID
ORDER BY schedule_item_num;
rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.UpdateLineNumbers');
UPDATE rlm_interface_lines_all
SET line_number = v_linenumber
WHERE line_id = v_lineid;
x_ErrMsg := x_ErrMsg || ' Unknown error in UpdateLineNumbers';
rlm_core_sv.dlog(C_DEBUG,'RLM_ERROR', 'Unknown Error in UpdateLineNumbers');
END UpdateLineNumbers;
SELECT line_id, flex_bkt_code
FROM rlm_interface_lines_all
WHERE header_id = x_header_id
AND flex_bkt_flag is null;
SELECT line_id, flex_bkt_code, start_date_time, end_date_time
FROM rlm_interface_lines_all
WHERE header_id = x_header_id
AND flex_bkt_flag = 'Y';
UPDATE rlm_interface_lines_all
SET start_date_time = v_start_date,
end_date_time = v_end_date
WHERE line_id = v_lineID;
UPDATE rlm_interface_lines_all
SET item_detail_subtype = '3'
WHERE line_id = v_lineID;
DELETE FROM rlm_interface_lines_all
WHERE header_id = x_header_id
AND flex_bkt_flag = 'Y';
SELECT standard_id
INTO v_StdID
FROM ecx_standards_b
WHERE standard_code = p_msgStd
AND standard_type = v_stdType;
SELECT ext_process_id
INTO v_ExtProcessID
FROM ecx_ext_processes
WHERE standard_id = v_StdID
AND ext_type = p_txnType
AND ext_subtype = p_txnSubtype
AND direction = v_Direction;
SELECT party_site_id, party_id
INTO v_PartySiteID, v_party_id
FROM ecx_tp_headers
WHERE tp_header_id IN (SELECT DISTINCT tp_header_id
FROM ecx_tp_details
WHERE source_tp_location_code = v_SourceTPLocCode
AND ext_process_id = v_ExtProcessID);
SELECT cust_acct_site_id, cust_account_id
INTO v_CustacctSiteId, v_CustAccountId
FROM hz_cust_acct_sites_all
WHERE party_site_id = v_PartySiteID
AND ece_tp_location_code = v_SourceTPLocCode;