APPS.CSP_REPAIR_PO_PVT dependencies on WIP_ENTITIES

Line 550: Check for existing WIP_JOB in WIP_ENTITIES that wip job is loaded through wip mass load or through API

546: ---- End Step:5 ----
547:
548: ---- Start Step:6 ----
549: /** Loop through each IO Lines for the Internal_order created and then check QTY_RECEIVED > 0
550: Check for existing WIP_JOB in WIP_ENTITIES that wip job is loaded through wip mass load or through API
551: if WIP_JOB NOT created already then insert to interface table and do wip issue transaction
552: elseif WIP_JOB created already and it is there in WIP_ENTITIES table then do wip issue transaction
553: **/
554:

Line 552: elseif WIP_JOB created already and it is there in WIP_ENTITIES table then do wip issue transaction

548: ---- Start Step:6 ----
549: /** Loop through each IO Lines for the Internal_order created and then check QTY_RECEIVED > 0
550: Check for existing WIP_JOB in WIP_ENTITIES that wip job is loaded through wip mass load or through API
551: if WIP_JOB NOT created already then insert to interface table and do wip issue transaction
552: elseif WIP_JOB created already and it is there in WIP_ENTITIES table then do wip issue transaction
553: **/
554:
555: --SAVEPOINT RUN_REPAIR_EXECUTION_PVT;
556:

Line 598: SELECT WIP_ENTITIES_S.NEXTVAL

594: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
595: into l_WIP_BATCH_ID
596: from dual;
597:
598: SELECT WIP_ENTITIES_S.NEXTVAL
599: INTO l_WIP_ENTITY_ID
600: FROM DUAL;
601:
602: Begin

Line 696: from WIP_ENTITIES

692:
693: Begin
694: Select wip_entity_id
695: into l_wip_entity_id
696: from WIP_ENTITIES
697: Where wip_entity_id = l_WIP_ENTITY_ID;
698: --and wip_entity_name = 'REPAIR_EXECUTION'||l_WIP_ENTITY_ID;
699: Exception
700: when no_data_found then

Line 793: from WIP_ENTITIES

789:
790: Begin
791: Select wip_entity_id
792: into l_wip_entity_id
793: from WIP_ENTITIES
794: Where wip_entity_id = CSP_REPAIR_PO_HEADERS_rec.WIP_ID;
795: --and wip_entity_name = 'REPAIR_EXECUTION'||l_WIP_ENTITY_ID;
796: Exception
797: when no_data_found then

Line 1319: AND CRPH.status = 8 --> WIP_JOB created in WIP_ENTITIES table

1315: CRPL.SCRAP_QTY,
1316: CRPL.ADJUSTED_QTY
1317: FROM CSP_REPAIR_PO_HEADERS CRPH, CSP_REPAIR_PO_LINES CRPL
1318: WHERE CRPH.REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID
1319: AND CRPH.status = 8 --> WIP_JOB created in WIP_ENTITIES table
1320: AND CRPH.repair_po_header_id = CRPL.repair_po_header_id
1321: AND CRPL.inventory_item_id = L_SCRAP_ADJUST_ITEM_ID;
1322:
1323: l_api_version_number CONSTANT NUMBER := 1.0;