1049: l_old_system_status,
1050: l_old_eam_status,
1051: l_workflow_type,
1052: l_wip_entity_name
1053: from wip_discrete_jobs wdj,eam_work_order_details ewod,wip_entities we
1054: where wdj.wip_entity_id = x_wip_entity_id
1055: AND wdj.wip_entity_id = ewod.wip_entity_id(+)
1056: AND wdj.wip_entity_id = we.wip_entity_id;
1057:
1181: x_workflow_process => l_workflow_process
1182: );
1183:
1184: IF(l_approval_required) THEN
1185: UPDATE EAM_WORK_ORDER_DETAILS
1186: SET user_defined_status_id=3,
1187: pending_flag='Y',
1188: last_update_date=SYSDATE,
1189: last_update_login=FND_GLOBAL.login_id,
1710: where wip_entity_id = x_wip_entity_id and
1711: organization_id = i_org_id;
1712:
1713:
1714: --Update Eam_Work_Order_Details with user_defined_status_id
1715: UPDATE EAM_WORK_ORDER_DETAILS
1716: SET last_update_date = sysdate,
1717: last_updated_by = x_user_id,
1718: last_update_login = x_user_id,
1711: organization_id = i_org_id;
1712:
1713:
1714: --Update Eam_Work_Order_Details with user_defined_status_id
1715: UPDATE EAM_WORK_ORDER_DETAILS
1716: SET last_update_date = sysdate,
1717: last_updated_by = x_user_id,
1718: last_update_login = x_user_id,
1719: user_defined_status_id=i_status_type