The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT substr( service_parameters, instr(service_parameters, 'XDP_DQ_INIT_NUM_THREADS', 1)) service_parameters,
nvl(max_processes,-1) max_processes
FROM fnd_concurrent_queues
WHERE concurrent_queue_name = 'XDP_Q_EVENT_SVC'
AND application_id = 535;
SELECT org_id,
header_id, --Added for MACD Enhancement
inventory_item_id,
line_category_code,
ordered_item,
item_type_code,
fulfilled_quantity,
shipped_quantity,
shippable_flag,
config_header_id, --Added for MACD Enhancement
config_rev_nbr, --Added for MACD Enhancement
configuration_id, --Added for MACD Enhancement
ato_line_id
INTO l_org_id,
l_order_id, --Added for MACD Enhancement
l_inventory_item_id,
l_line_category_code,
l_ordered_item,
l_item_type_code,
l_fulfilled_qty,
l_shipped_qty,
l_shippable_flag,
l_config_header_id,--Added for MACD Enhancement
l_config_rev_nbr, --Added for MACD Enhancement
l_configuration_id,--Added for MACD Enhancement
l_ato_line_id
FROM oe_order_lines_all
WHERE line_id = p_order_line_id;
SELECT nvl(mtl_transactions_enabled_flag,'N')
INTO l_transactable_flag
FROM mtl_system_items
WHERE inventory_item_id = l_inventory_item_id
AND organization_id = l_vld_organization_id;
SELECT nvl(shippable_item_flag,'N')
INTO l_shippable_flag
FROM mtl_system_items
WHERE inventory_item_id = l_inventory_item_id
AND organization_id = l_vld_organization_id;
insert into CSI_BATCH_TXN_LINES
(
BATCH_ID,
PROCESSED_FLAG,
ORDER_HEADER_ID,
ORDER_LINE_ID,
--ORGANIZATION_ID,
--INVENTORY_ITEM_ID,
TRANSACTION_TYPE,
TRANSACTION_TYPE_ID,
TRANSACTION_ID
--INSTANCE_ID,
--SERIAL_NUMBER
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
)
VALUES
(
-1,
0,
L_ORDER_ID,
P_ORDER_LINE_ID,
--NULL,
--l_inventory_item_id,
l_txn_type,
l_txn_type_id,
NULL
--NULL,
--NULL
,sysdate
,fnd_global.user_id
,sysdate
,fnd_global.user_id
);