[Home] [Help]
936:
937:
938: -------------------------------------------------------------------------------
939: -- Creating easy work order
940: -- insert row into wip_discrete_jobs, wip_entities
941: -- create a default operation 10 for the new work order
942: -- release the work order and call wip_change_status.release
943:
944: --anjgupta Changes for IB and Transactable Assets Project in R12
1032: l_asset_class VARCHAR2(10);
1033: l_auto_firm VARCHAR2(10);
1034:
1035: l_row wip_discrete_jobs%ROWTYPE;
1036: l_entity wip_entities%ROWTYPE;
1037: l_op wip_operations%ROWTYPE;
1038:
1039: l_rowid VARCHAR2(250);
1040: l_we_rowid VARCHAR2(250);
1279: begin
1280:
1281: select wdj.status_type
1282: into l_orig_wo_status
1283: from wip_discrete_jobs wdj,wip_entities we
1284: where we.wip_entity_id=wdj.wip_entity_id
1285: and we.organization_id=p_organization_id
1286: and wdj.organization_id=p_organization_id
1287: and we.wip_entity_name=p_wip_entity_name;
1444: if(p_parent_work_order is not null) then
1445: begin
1446: SELECT wip_entity_id
1447: INTO l_parent_wip_entity_id
1448: FROM WIP_ENTITIES
1449: WHERE wip_entity_name=p_parent_work_order
1450: AND organization_id=p_organization_id;
1451: exception
1452: when others then
1711:
1712: /* select we.wip_entity_id, nvl(wdj.date_released,sysdate),wdj.parent_wip_entity_id,wdj.manual_rebuild_flag */
1713: select we.wip_entity_id,wdj.date_released,wdj.parent_wip_entity_id,wdj.manual_rebuild_flag
1714: into l_wip_entity_updt, l_date_released,l_old_rebuild_source,manual_rebuild_flag
1715: from wip_entities we, wip_discrete_jobs wdj
1716: where we.wip_entity_name = l_wip_entity_name
1717: and we.organization_id = p_organization_id
1718: and we.organization_id = wdj.organization_id
1719: and we.wip_entity_id = wdj.wip_entity_id;