[Home] [Help]
916:
917:
918: -------------------------------------------------------------------------------
919: -- Creating easy work order
920: -- insert row into wip_discrete_jobs, wip_entities
921: -- create a default operation 10 for the new work order
922: -- release the work order and call wip_change_status.release
923:
924: --anjgupta Changes for IB and Transactable Assets Project in R12
1011: l_asset_class VARCHAR2(10);
1012: l_auto_firm VARCHAR2(10);
1013:
1014: l_row wip_discrete_jobs%ROWTYPE;
1015: l_entity wip_entities%ROWTYPE;
1016: l_op wip_operations%ROWTYPE;
1017:
1018: l_rowid VARCHAR2(250);
1019: l_we_rowid VARCHAR2(250);
1248: begin
1249:
1250: select wdj.status_type
1251: into l_orig_wo_status
1252: from wip_discrete_jobs wdj,wip_entities we
1253: where we.wip_entity_id=wdj.wip_entity_id
1254: and we.organization_id=p_organization_id
1255: and wdj.organization_id=p_organization_id
1256: and we.wip_entity_name=p_wip_entity_name;
1413: if(p_parent_work_order is not null) then
1414: begin
1415: SELECT wip_entity_id
1416: INTO l_parent_wip_entity_id
1417: FROM WIP_ENTITIES
1418: WHERE wip_entity_name=p_parent_work_order
1419: AND organization_id=p_organization_id;
1420: exception
1421: when others then
1680:
1681: /* select we.wip_entity_id, nvl(wdj.date_released,sysdate),wdj.parent_wip_entity_id,wdj.manual_rebuild_flag */
1682: select we.wip_entity_id,wdj.date_released,wdj.parent_wip_entity_id,wdj.manual_rebuild_flag
1683: into l_wip_entity_updt, l_date_released,l_old_rebuild_source,manual_rebuild_flag
1684: from wip_entities we, wip_discrete_jobs wdj
1685: where we.wip_entity_name = l_wip_entity_name
1686: and we.organization_id = p_organization_id
1687: and we.organization_id = wdj.organization_id
1688: and we.wip_entity_id = wdj.wip_entity_id;