128: p_eam_op_comp_rec.vendor_site_id,
129: p_eam_op_comp_rec.vendor_contact_id,
130: p_eam_op_comp_rec.reason_id,
131: p_eam_op_comp_rec.reference, -- transaction_reference
132: FND_GLOBAL.user_id,
133: sysdate,
134: FND_GLOBAL.user_id,
135: sysdate,
136: FND_GLOBAL.login_id,
130: p_eam_op_comp_rec.reason_id,
131: p_eam_op_comp_rec.reference, -- transaction_reference
132: FND_GLOBAL.user_id,
133: sysdate,
134: FND_GLOBAL.user_id,
135: sysdate,
136: FND_GLOBAL.login_id,
137: p_eam_op_comp_rec.attribute_category,
138: p_eam_op_comp_rec.attribute1,
132: FND_GLOBAL.user_id,
133: sysdate,
134: FND_GLOBAL.user_id,
135: sysdate,
136: FND_GLOBAL.login_id,
137: p_eam_op_comp_rec.attribute_category,
138: p_eam_op_comp_rec.attribute1,
139: p_eam_op_comp_rec.attribute2,
140: p_eam_op_comp_rec.attribute3,
223: p_eam_op_comp_rec.shutdown_start_date,
224: p_eam_op_comp_rec.shutdown_end_date,
225: p_eam_op_comp_rec.wip_entity_id,
226: p_eam_op_comp_rec.operation_seq_num,
227: FND_GLOBAL.user_id,
228: SYSDATE,
229: FND_GLOBAL.user_id,
230: SYSDATE,
231: FND_GLOBAL.login_id,
225: p_eam_op_comp_rec.wip_entity_id,
226: p_eam_op_comp_rec.operation_seq_num,
227: FND_GLOBAL.user_id,
228: SYSDATE,
229: FND_GLOBAL.user_id,
230: SYSDATE,
231: FND_GLOBAL.login_id,
232: p_eam_op_comp_rec.attribute_category,
233: p_eam_op_comp_rec.attribute1,
227: FND_GLOBAL.user_id,
228: SYSDATE,
229: FND_GLOBAL.user_id,
230: SYSDATE,
231: FND_GLOBAL.login_id,
232: p_eam_op_comp_rec.attribute_category,
233: p_eam_op_comp_rec.attribute1,
234: p_eam_op_comp_rec.attribute2,
235: p_eam_op_comp_rec.attribute3,
296: IF NVL(to_number(l_shutdown_type),1) = 2 THEN
297: UPDATE eam_asset_status_history
298: SET enable_flag = 'N'
299: , last_update_date = SYSDATE
300: , last_updated_by = FND_GLOBAL.user_id
301: , last_update_login = FND_GLOBAL.login_id
302: WHERE organization_id = p_eam_op_comp_rec.organization_id
303: AND wip_entity_id = p_eam_op_comp_rec.wip_entity_id
304: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num
297: UPDATE eam_asset_status_history
298: SET enable_flag = 'N'
299: , last_update_date = SYSDATE
300: , last_updated_by = FND_GLOBAL.user_id
301: , last_update_login = FND_GLOBAL.login_id
302: WHERE organization_id = p_eam_op_comp_rec.organization_id
303: AND wip_entity_id = p_eam_op_comp_rec.wip_entity_id
304: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num
305: AND enable_flag = 'Y' OR enable_flag IS NULL;
308: UPDATE wip_operations
309: SET
310: operation_completed = decode(p_eam_op_comp_rec.transaction_type,EAM_PROCESS_WO_PVT.G_OPR_COMPLETE,'Y',EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE,'N'),
311: quantity_completed = 1,
312: last_updated_by = FND_GLOBAL.user_id,
313: last_update_date = sysdate,
314: last_update_login = FND_GLOBAL.login_id
315: WHERE
316: wip_entity_id = p_eam_op_comp_rec.wip_entity_id
310: operation_completed = decode(p_eam_op_comp_rec.transaction_type,EAM_PROCESS_WO_PVT.G_OPR_COMPLETE,'Y',EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE,'N'),
311: quantity_completed = 1,
312: last_updated_by = FND_GLOBAL.user_id,
313: last_update_date = sysdate,
314: last_update_login = FND_GLOBAL.login_id
315: WHERE
316: wip_entity_id = p_eam_op_comp_rec.wip_entity_id
317: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num;
318: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exiting Package EAM_OP_COMP_UTILITY_PVT.update_row procedure'); END IF;