APPS.CSP_REPAIR_PO_PVT dependencies on WIP_ENTITIES

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

585: ---- End Step:5 ----
586:
587: ---- Start Step:6 ----
588: /** Loop through each IO Lines for the Internal_order created and then check QTY_RECEIVED > 0
589: Check for existing WIP_JOB in WIP_ENTITIES that wip job is loaded through wip mass load or through API
590: if WIP_JOB NOT created already then insert to interface table and do wip issue transaction
591: elseif WIP_JOB created already and it is there in WIP_ENTITIES table then do wip issue transaction
592: **/
593:

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

587: ---- Start Step:6 ----
588: /** Loop through each IO Lines for the Internal_order created and then check QTY_RECEIVED > 0
589: Check for existing WIP_JOB in WIP_ENTITIES that wip job is loaded through wip mass load or through API
590: if WIP_JOB NOT created already then insert to interface table and do wip issue transaction
591: elseif WIP_JOB created already and it is there in WIP_ENTITIES table then do wip issue transaction
592: **/
593:
594: --SAVEPOINT RUN_REPAIR_EXECUTION_PVT;
595:

Line 739: SELECT WIP_ENTITIES_S.NEXTVAL

735: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
736: into l_WIP_BATCH_ID
737: from dual;
738:
739: SELECT WIP_ENTITIES_S.NEXTVAL
740: INTO l_WIP_ENTITY_ID
741: FROM DUAL;
742:
743: Begin

Line 839: from WIP_ENTITIES

835:
836: Begin
837: Select wip_entity_id
838: into l_wip_entity_id
839: from WIP_ENTITIES
840: Where wip_entity_id = l_WIP_ENTITY_ID;
841: --and wip_entity_name = 'REPAIR_EXECUTION'||l_WIP_ENTITY_ID;
842: Exception
843: when no_data_found then

Line 943: from WIP_ENTITIES

939:
940: Begin
941: Select wip_entity_id
942: into l_wip_entity_id
943: from WIP_ENTITIES
944: Where wip_entity_id = CSP_REPAIR_PO_HEADERS_rec.WIP_ID;
945: --and wip_entity_name = 'REPAIR_EXECUTION'||l_WIP_ENTITY_ID;
946: Exception
947: when no_data_found then

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

1577: CRPL.SCRAP_QTY,
1578: CRPL.ADJUSTED_QTY
1579: FROM CSP_REPAIR_PO_HEADERS CRPH, CSP_REPAIR_PO_LINES CRPL
1580: WHERE CRPH.REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID
1581: AND CRPH.status = 8 --> WIP_JOB created in WIP_ENTITIES table
1582: AND CRPH.repair_po_header_id = CRPL.repair_po_header_id
1583: AND CRPL.inventory_item_id = L_SCRAP_ADJUST_ITEM_ID;
1584:
1585: l_api_version_number CONSTANT NUMBER := 1.0;