The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT workitem_id
FROM xdp_workitems
WHERE workitem_name = lv_wi_name
AND sysdate >= valid_date
AND sysdate <= NVL(invalid_date,sysdate);
SELECT workitem_id into lv_wi_id
FROM xdp_workitems
WHERE Workitem_name = lv_wi_name
AND version = lv_wi_version
AND sysdate >= valid_date
AND sysdate <= NVL(invalid_date,sysdate + 1);
SELECT msi.inventory_item_id
FROM mtl_system_items_b msi,
bom_bill_of_materials bom,
bom_inventory_components bic
WHERE msi.organization_id = p_organization_id
AND msi.inventory_item_id = p_inventory_item_id
AND NVL(msi.start_date_active,sysdate)<= sysdate
AND NVL(msi.end_date_active,sysdate) >= sysdate
AND bom.organization_id = msi.organization_id
AND bom.assembly_item_id = msi.inventory_item_id
AND bic.bill_sequence_id = bom.bill_sequence_id
AND NVL(bic.disable_date,sysdate) >= sysdate
AND NVL(bic.effectivity_date,sysdate) <= sysdate
AND EXISTS(SELECT 'Y'
FROM mtl_system_items msib
WHERE msib.organization_id = p_organization_id
AND msib.inventory_item_id = bic.component_item_id
AND msib.comms_activation_reqd_flag = 'Y');
SELECT organization_id
INTO lv_organization_id
FROM mtl_parameters
WHERE organization_id = p_organization_id ;
SELECT organization_id
INTO lv_organization_id
FROM mtl_parameters
WHERE organization_code = p_organization_code ;
SELECT service_val_act_id
FROM xdp_service_val_acts
WHERE organization_id = p_organization_id
AND inventory_item_id = p_inventory_item_id
AND action_source = p_action_source
AND action_code = p_action_code
AND NVL(valid_date,sysdate) <= sysdate
AND NVL(invalid_date,sysdate) >= sysdate ;
SELECT bic.component_item_id,
msi.concatenated_segments item_number
FROM bom_bill_of_materials bom,
bom_inventory_components bic ,
mtl_system_items_vl msi
WHERE bom.organization_id = p_organization_id
AND bom.assembly_item_id = p_inventory_item_id
AND bic.bill_sequence_id = bom.bill_sequence_id
AND NVL(bic.disable_date,sysdate) >= sysdate
AND NVL(bic.effectivity_date,sysdate) <= sysdate
AND msi.organization_id = p_organization_id
AND msi.inventory_item_id = bic.component_item_id
AND msi.comms_activation_reqd_flag = 'Y';
SELECT count(*)
INTO l_count
FROM FND_LOOKUP_VALUES
WHERE UPPER(lookup_code) = UPPER(p_order_type)
AND lookup_type = 'XDP_HA_ORDER_TYPES';
/* Update the XDP_ORDER_HEADERS table with the User defined Workitem Item Type and Item Key */
update XDP_ORDER_HEADERS
set WF_ITEM_TYPE = lv_item_type,
WF_ITEM_KEY = lv_item_key,
LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
where ORDER_ID = p_order_header.order_id;
SELECT '1' INTO lv_cust_present
FROM HZ_CUST_ACCOUNTS_ALL CUST
WHERE CUST.CUST_ACCOUNT_ID = p_order_header.cust_account_id;
SELECT CUST.CUST_ACCOUNT_ID INTO p_order_header.cust_account_id
FROM HZ_CUST_ACCOUNTS_ALL CUST
WHERE CUST.ACCOUNT_NUMBER = p_order_header.account_number;
SELECT 1 INTO lv_site_use_id from HZ_CUST_SITE_USES_ALL SITES
WHERE SITES.SITE_USE_ID = p_service_order_line_list(lv_index).site_use_id;
SELECT inventory_item_id ,
comms_activation_reqd_flag,
concatenated_segments
INTO lv_inventory_item_id,
lv_activation_flag,
lv_item_number
FROM mtl_system_items_vl
WHERE organization_id = p_organization_id
AND inventory_item_id = p_inventory_item_id
AND NVL(start_date_active,sysdate) <= sysdate
AND NVL(end_date_active,sysdate) >= sysdate ;
SELECT inventory_item_id,
comms_activation_reqd_flag
INTO lv_inventory_item_id,
lv_activation_flag
FROM mtl_system_items_vl
WHERE organization_id = p_organization_id
AND concatenated_segments = p_item_number
AND NVL(start_date_active,sysdate) <= sysdate
AND NVL(end_date_active,sysdate) >= sysdate ;
insert into xdp_order_headers
(
order_id,
external_order_number,
status_code,
date_received,
provisioning_date,
due_date,
customer_required_date,
external_order_version,
order_source,
customer_id,
customer_name,
org_id,
telephone_number,
priority,
related_order_id,
order_type,
previous_order_id,
next_order_id,
jeopardy_enabled_flag,
order_ref_name,
order_ref_value,
cust_account_id,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
)
values
(
XDP_ORDER_HEADERS_S.NEXTVAL,
p_order_header.order_number,
'STANDBY',
sysdate,
lv_date,
p_order_header.due_date,
p_order_header.customer_required_date ,
NVL(p_order_header.order_version,'1'),
p_order_header.order_source ,
p_order_header.customer_id ,
(p_order_header.customer_name),
lv_org_id ,
p_order_header.telephone_number,
p_order_header.priority ,
p_order_header.related_order_id ,
p_order_header.order_type,
p_order_header.previous_order_id,
p_order_header.next_order_id,
p_order_header.jeopardy_enabled_flag,
p_order_header.order_ref_name,
p_order_header.order_ref_value,
p_order_header.cust_account_id,
p_order_header.ATTRIBUTE_CATEGORY,
p_order_header.ATTRIBUTE1,
p_order_header.ATTRIBUTE2,
p_order_header.ATTRIBUTE3,
p_order_header.ATTRIBUTE4,
p_order_header.ATTRIBUTE5,
p_order_header.ATTRIBUTE6,
p_order_header.ATTRIBUTE7,
p_order_header.ATTRIBUTE8,
p_order_header.ATTRIBUTE9,
p_order_header.ATTRIBUTE10,
p_order_header.ATTRIBUTE11,
p_order_header.ATTRIBUTE12,
p_order_header.ATTRIBUTE13,
p_order_header.ATTRIBUTE14,
p_order_header.ATTRIBUTE15,
p_order_header.ATTRIBUTE16,
p_order_header.ATTRIBUTE17,
p_order_header.ATTRIBUTE18,
p_order_header.ATTRIBUTE19,
p_order_header.ATTRIBUTE20,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.login_id
) RETURNING ORDER_ID INTO P_order_header.order_id;
dbg_msg := ('Successfully inserted record in Order Headers');
dbg_msg := ('Number of records to be inserted in Order Parameters: '||p_order_parameter.COUNT);
insert into xdp_order_parameters
(
order_id,
order_parameter_name,
order_parameter_value,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
)
values
(
p_order_header.order_id,
lv_name_tab(lv_temp),
lv_val_tab(lv_temp),
fnd_global.user_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.login_id
);
dbg_msg := ('Records successfully Inserted in Order Parameters');
lv_name_tab.DELETE;
lv_val_tab.DELETE;
select xdp_order_line_items_s.nextval
into l_line_item_id
from dual;
SELECT bom.assembly_item_id ,
bic.component_item_id ,
bic.component_quantity ,
bic.item_num ,
bic.operation_seq_num,
msi.concatenated_segments item_number
FROM bom_bill_of_materials bom,
bom_inventory_components bic,
mtl_system_items_vl msi
WHERE bom.organization_id = p_organization_id
AND bom.assembly_item_id = p_inventory_item_id
AND bic.bill_sequence_id = bom.bill_sequence_id
AND NVL(bic.effectivity_date,sysdate) <= sysdate
AND NVL(bic.disable_date,sysdate) >= sysdate
AND msi.organization_id = p_organization_id
AND msi.inventory_item_id = bic.component_item_id
AND msi.comms_activation_reqd_flag = 'Y' ;
SELECT XDP_ORDER_LINE_ITEMS_S.nextval
INTO l_line_item_id
FROM dual ;
dbg_msg := ('Successfully updated ib_source to: '||p_service_order_line.ib_source_id);
select xdp_order_line_items_s.nextval
into lv_det_id
from dual;
/*** declare variables for bulk inserts ***/
TYPE LV_NUMBER_TAB IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
dbg_msg := ('Number of records to be inserted in Order lines: '||lv_fnd_count);
INSERT INTO XDP_ORDER_LINE_ITEMS
(LINE_ITEM_ID ,
ORDER_ID ,
LINE_NUMBER ,
STATUS_CODE ,
LINE_ITEM_NAME ,
PROVISIONING_REQUIRED_FLAG ,
PRIORITY ,
LINE_ITEM_ACTION_CODE ,
VERSION ,
BUNDLE_ID ,
LINE_SEQUENCE ,
BUNDLE_SEQUENCE ,
PROVISIONING_DATE ,
DUE_DATE ,
CUSTOMER_REQUIRED_DATE ,
IS_PACKAGE_FLAG ,
IS_VIRTUAL_LINE_FLAG ,
WORKITEM_ID ,
JEOPARDY_ENABLED_FLAG ,
STARTING_NUMBER ,
ENDING_NUMBER ,
ORGANIZATION_ID ,
INVENTORY_ITEM_ID ,
LINE_SOURCE ,
IB_SOURCE ,
IB_SOURCE_ID ,
SITE_USE_ID ,
SEQ_IN_PACKAGE ,
ATTRIBUTE_CATEGORY ,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15 ,
ATTRIBUTE16 ,
ATTRIBUTE17 ,
ATTRIBUTE18 ,
ATTRIBUTE19 ,
ATTRIBUTE20 ,
CREATED_BY ,
CREATION_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_DATE ,
LAST_UPDATE_LOGIN
)
VALUES
(
lv_line_item_id_tab(lv_temp)
,P_ORDER_HEADER.ORDER_ID
,lv_line_num_tab(lv_temp)
,'STANDBY'
,lv_name_tab(lv_temp)
,lv_pro_req_tab(lv_temp)
,lv_priority_tab(lv_temp)
,lv_action_tab(lv_temp)
,lv_version_tab(lv_temp)
,lv_bundle_id_tab(lv_temp)
,lv_prov_seq_tab(lv_temp)
,lv_bundle_seq_tab(lv_temp)
,lv_prov_date_tab(lv_temp)
,lv_due_date_tab(lv_temp)
,lv_cust_req_date_tab(lv_temp)
,lv_pack_flag_tab(lv_temp)
,lv_virtual_flag_tab(lv_temp)
,lv_workitem_id_tab(lv_temp)
,lv_jeopardy_flag_tab(lv_temp)
,lv_starting_num_tab(lv_temp)
,lv_ending_num_tab(lv_temp)
,lv_organization_id_tab(lv_temp)
,lv_inventory_item_id_tab(lv_temp)
,lv_line_source_tab(lv_temp)
,lv_ib_source_tab(lv_temp)
,lv_ib_source_id_tab(lv_temp)
,lv_site_use_id_tab(lv_temp)
,lv_seq_in_package_tab(lv_temp)
,lv_attribute_category_tab(lv_temp)
,lv_attribute1_tab(lv_temp)
,lv_attribute2_tab(lv_temp)
,lv_attribute3_tab(lv_temp)
,lv_attribute4_tab(lv_temp)
,lv_attribute5_tab(lv_temp)
,lv_attribute6_tab(lv_temp)
,lv_attribute7_tab(lv_temp)
,lv_attribute8_tab(lv_temp)
,lv_attribute9_tab(lv_temp)
,lv_attribute10_tab(lv_temp)
,lv_attribute11_tab(lv_temp)
,lv_attribute12_tab(lv_temp)
,lv_attribute13_tab(lv_temp)
,lv_attribute14_tab(lv_temp)
,lv_attribute15_tab(lv_temp)
,lv_attribute16_tab(lv_temp)
,lv_attribute17_tab(lv_temp)
,lv_attribute18_tab(lv_temp)
,lv_attribute19_tab(lv_temp)
,lv_attribute20_tab(lv_temp)
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,sysdate
,fnd_global.login_id
);
dbg_msg := ('Successfully inserted records into Order Lines');
lv_line_id_tab.DELETE;
lv_line_num_tab.DELETE;
lv_name_tab.DELETE;
lv_pro_req_tab.DELETE;
lv_priority_tab.DELETE;
lv_action_tab.DELETE;
lv_version_tab.DELETE;
lv_bundle_id_tab.DELETE;
lv_prov_seq_tab.DELETE;
lv_bundle_seq_tab.DELETE;
lv_prov_date_tab.DELETE;
lv_due_date_tab.DELETE;
lv_cust_req_date_tab.DELETE;
lv_pack_flag_tab.DELETE;
lv_workitem_id_tab.DELETE;
lv_jeopardy_flag_tab.DELETE;
lv_starting_num_tab.DELETE;
lv_line_status_tab.DELETE;
lv_ending_num_tab.DELETE;
lv_inventory_item_id_tab.DELETE;
lv_organization_id_tab.DELETE;
lv_line_source_tab.DELETE;
lv_ib_source_tab.DELETE;
lv_ib_source_id_tab.DELETE;
lv_site_use_id_tab.DELETE;
lv_pack_flag_tab.DELETE;
dbg_msg := ('Number of records to be inserted in Order Line Relationships: '||lv_fnd_count);
insert into XDP_LINE_RELATIONSHIPS
(line_item_id
,related_line_item_id
,line_relationship
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
values
(lv_line_item_id_tab(lv_temp)
,lv_rel_line_item_id_tab(lv_temp)
,lv_relationship_tab(lv_temp)
,sysdate
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,fnd_global.login_id
);
dbg_msg := ('Successfully inserted records into Order Line Relationships');
lv_item_id_tab.DELETE;
lv_rel_item_id_tab.DELETE;
lv_relationship_tab.DELETE;
lv_line_item_id_tab.DELETE;
dbg_msg := ('Number of records to be inserted in Order Line Details: '||lv_fnd_count);
INSERT INTO XDP_ORDER_LINEITEM_DETS
(line_item_id,
line_parameter_name,
parameter_value,
parameter_reference_value,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
)
values
(lv_line_item_id_tab(lv_temp),
lv_name_tab(lv_temp),
lv_val_tab(lv_temp),
lv_ref_val_tab(lv_temp),
fnd_global.user_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.login_id
);
dbg_msg := ('Successfully inserted records into Order Line Details');
select swp.workitem_id workitem_id
,wi.workitem_name workitem_name
,NVL(swp.provision_seq, 0) provision_seq
,wi.validation_procedure
,wi.validation_enabled_flag
,wi.VERSION
,wi.FA_EXEC_MAP_PROC
,wi.USER_WF_ITEM_TYPE
,wi.USER_WF_ITEM_KEY_PREFIX
,wi.USER_WF_PROCESS_NAME
,wi.WF_EXEC_PROC
,wi.TIME_ESTIMATE
,wi.PROTECTED_FLAG
,wi.ROLE_NAME
from XDP_SERVICE_WI_MAP swp,
XDP_SERVICE_VAL_ACTS svn,
XDP_WORKITEMS wi
where swp.service_val_act_id = svn.service_val_act_id and
svn.inventory_item_id = l_inventory_item_id and
svn.organization_id = l_organization_id and
swp.workitem_id = wi.workitem_id and
svn.action_code = l_action
order by provision_seq;
SELECT Validation_Procedure ,
Validation_Enabled_Flag ,
VERSION ,
FA_EXEC_MAP_PROC ,
USER_WF_ITEM_TYPE ,
USER_WF_ITEM_KEY_PREFIX ,
USER_WF_PROCESS_NAME ,
WF_EXEC_PROC ,
TIME_ESTIMATE ,
PROTECTED_FLAG ,
ROLE_NAME
INTO lv_val_proc,
lv_val_flag,
lv_version,
lv_fa,
Lv_wf_item_type,
lv_wf_item_key,
lv_wf_process ,
lv_wf_exec,
lv_time,
lv_protected_flag,
lv_role_name
FROM XDP_WORKITEMS
WHERE Workitem_id= p_service_order_line_list(lv_index).workitem_id;
SELECT wi_mapping_proc
INTO lv_wi_map_proc
FROM xdp_service_val_acts svn
WHERE svn.inventory_item_id = p_service_order_line_list(lv_index).inventory_item_id
AND svn.organization_id = p_service_order_line_list(lv_index).organization_id
AND svn.action_code = p_service_order_line_list(lv_index).action_code;
dbg_msg := ('Number of records to be inserted in Fulfill Worklist for service: '||lv_fnd_count);
dbg_msg := ('Number of records tp be inserted into Fulfill Worklist: '||lv_fnd_count);
INSERT INTO XDP_FULFILL_WORKLIST
(WORKITEM_INSTANCE_ID,
LINE_ITEM_ID,
ORDER_ID,
LINE_NUMBER,
WORKITEM_ID,
STATUS_CODE,
PROVISIONING_DATE,
PRIORITY,
WI_SEQUENCE,
DUE_DATE,
CUSTOMER_REQUIRED_DATE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
)
VALUES
(xdp_fulfill_worklist_s.NEXTVAL,
l_line_item_id(l_index),
P_ORDER_HEADER.ORDER_ID,
l_line_number(l_index),
l_workitem_id(l_index),
'STANDBY',
l_provisioning_date(l_index),
l_priority(l_index),
l_wi_sequence(l_index),
l_due_date(l_index),
l_customer_required_date(l_index),
l_attribute_category_tab(l_index),
l_attribute1_tab(l_index),
l_attribute2_tab(l_index),
l_attribute3_tab(l_index),
l_attribute4_tab(l_index),
l_attribute5_tab(l_index),
l_attribute6_tab(l_index),
l_attribute7_tab(l_index),
l_attribute8_tab(l_index),
l_attribute9_tab(l_index),
l_attribute10_tab(l_index),
l_attribute11_tab(l_index),
l_attribute12_tab(l_index),
l_attribute13_tab(l_index),
l_attribute14_tab(l_index),
l_attribute15_tab(l_index),
l_attribute16_tab(l_index),
l_attribute17_tab(l_index),
l_attribute18_tab(l_index),
l_attribute19_tab(l_index),
l_attribute20_tab(l_index),
FND_GLOBAL.USER_ID,
SYSDATE,
FND_GLOBAL.USER_ID,
SYSDATE,
FND_GLOBAL.LOGIN_ID
) RETURNING workitem_instance_id BULK COLLECT INTO l_workitem_instance_id;
dbg_msg := ('Successfully inserted records into Fulfill Worklist');
l_workitem_instance_id.DELETE;
l_line_item_id.DELETE;
l_line_number.DELETE;
l_workitem_id.DELETE;
l_provisioning_date.DELETE;
l_priority.DELETE;
l_wi_sequence.DELETE;
l_due_date.DELETE;
l_customer_required_date.DELETE;
l_attribute_category_tab.DELETE;
l_attribute1_tab.DELETE;
l_attribute2_tab.DELETE;
l_attribute3_tab.DELETE;
l_attribute4_tab.DELETE;
l_attribute5_tab.DELETE;
l_attribute6_tab.DELETE;
l_attribute7_tab.DELETE;
l_attribute8_tab.DELETE;
l_attribute9_tab.DELETE;
l_attribute10_tab.DELETE;
l_attribute11_tab.DELETE;
l_attribute12_tab.DELETE;
l_attribute13_tab.DELETE;
l_attribute14_tab.DELETE;
l_attribute15_tab.DELETE;
l_attribute16_tab.DELETE;
l_attribute17_tab.DELETE;
l_attribute18_tab.DELETE;
l_attribute19_tab.DELETE;
l_attribute20_tab.DELETE;
SELECT
wip.parameter_name,
wip.required_flag,
wip.value_lookup_sql,
wip.validation_procedure,
wip.evaluation_mode,
wip.evaluation_seq,
wip.evaluation_procedure,
wip.default_value,
wip.display_seq,
wip.workitem_id
FROM xdp_wi_parameters wip
WHERE wip.workitem_id = l_wi_id
ORDER BY wip.evaluation_seq;
dbg_msg := ('Number of records to be inserted Worklist Details: '||lv_fnd_count);
INSERT INTO xdp_worklist_details
( workitem_instance_id,
workitem_id,
is_value_evaluated,
parameter_value,
parameter_ref_value,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
txn_attrib_detail_id,
attrib_source_table,
attrib_source_id,
modified_flag,
parameter_name
)
VALUES
( l_workitem_instance_id(l_index),
l_workitem_id(l_index),
l_is_value_evaluated(l_index),
l_parameter_value(l_index),
l_parameter_ref_value(l_index),
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.LOGIN_ID,
l_txn_attrib_detail_id(l_index),
l_attrib_source_table(l_index),
l_attrib_source_id(l_index),
l_modified_flag(l_index),
l_parameter_name(l_index)
);
dbg_msg := ('Successfully inserted records into Worklist Details');
l_workitem_instance_id.DELETE;
l_workitem_id.DELETE;
l_is_value_evaluated.DELETE;
l_parameter_value.DELETE;
l_parameter_ref_value.DELETE;
l_txn_attrib_detail_id.DELETE;
l_attrib_source_table.DELETE;
l_attrib_source_id.DELETE;
l_modified_flag.DELETE;
l_parameter_name.DELETE;
INSERT INTO XDP_WORKLIST_DETAILS
( workitem_instance_id,
workitem_id,
is_value_evaluated,
parameter_value,
parameter_ref_value,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
txn_attrib_detail_id,
attrib_source_table,
attrib_source_id,
modified_flag,
parameter_name
)
VALUES
( P_WORKITEM_EVAL_PARAM_LIST(i).workitem_instance_id,
P_WORKITEM_EVAL_PARAM_LIST(i).workitem_id,
P_WORKITEM_EVAL_PARAM_LIST(i).is_value_evaluated,
P_WORKITEM_EVAL_PARAM_LIST(i).parameter_value,
P_WORKITEM_EVAL_PARAM_LIST(i).parameter_ref_value,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.LOGIN_ID,
P_WORKITEM_EVAL_PARAM_LIST(i).txn_ext_attrib_detail_id,
P_WORKITEM_EVAL_PARAM_LIST(i).attrib_source_table,
P_WORKITEM_EVAL_PARAM_LIST(i).attrib_source_id,
P_WORKITEM_EVAL_PARAM_LIST(i).modified_flag,
P_WORKITEM_EVAL_PARAM_LIST(i).parameter_name
);