[Home] [Help]
731: If nvl(IO_QTY_RECEIVED_CHECK_REC.QUANTITY_RECEIVED,0) > 0 and
732: CSP_REPAIR_PO_HEADERS_rec.WIP_ID IS NULL THEN
733: /** Create a WIB_JOB if there is no WIB_JOB created for this INTERNAL_ORDER so far **/
734:
735: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
736: into l_WIP_BATCH_ID
737: from dual;
738:
739: SELECT WIP_ENTITIES_S.NEXTVAL
761: g_retcode := 1;
762: End if;
763:
764: Begin
765: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(
766: LAST_UPDATE_DATE,
767: LAST_UPDATED_BY,
768: CREATION_DATE,
769: CREATED_BY,
907: AND ORGANIZATION_ID = IO_QTY_RECEIVED_CHECK_REC.DESTINATION_ORGANIZATION_ID
908: AND WIP_ENTITY_ID = l_WIP_ENTITY_ID ;
909:
910: Else
911: /* STATUS = 7 => Inserted into 'WIP_JOB_SCHEDULE_INTERFACE' */
912: UPDATE CSP_REPAIR_PO_HEADERS
913: SET WIP_ID = l_WIP_ENTITY_ID_INTERFACE, STATUS = 7
914: -- WHERE CURRENT OF CSP_REPAIR_PO_HEADERS;
915: WHERE ROWID = CSP_REPAIR_PO_HEADERS_rec.ROWID;
1292:
1293: --------------------- Start comment on Nov-29-2005 -----------------
1294: /*
1295:
1296: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
1297: into l_WIP_BATCH_ID
1298: from dual;
1299:
1300: Begin
1297: into l_WIP_BATCH_ID
1298: from dual;
1299:
1300: Begin
1301: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(
1302: LAST_UPDATE_DATE,
1303: LAST_UPDATED_BY,
1304: CREATION_DATE,
1305: CREATED_BY,
1451: This transaction is for WIP job qty scrap
1452: Do "Return Components from WIP" (43) transaction and wip job qty is returned from WIP JOB to Repair Supplier Org's Defect subinv
1453:
1454: Passing 'Y' for FINAL_COMPLETION_FLAG is not completing the WIP JOB automatically,
1455: So we need to insert record to WIP_JOB_SCHEDULE_INTERFACE with status_type as 'COMPLETE' VALUE 4.
1456: Then run the WIP_MASS_LOAD Concurrent program to change the JOB status to "COMPLETE".
1457:
1458: Do Miscellaneous transaction or SCRAP/ADJUSTMENT transaction from defective subinv
1459:
1670: WIP_JOB qty is returned from WIP JOB to Repair Supplier Org's Defect subinv
1671: by doing material transaction of type "Return Components from WIP" (43)
1672:
1673: Passing 'Y' for FINAL_COMPLETION_FLAG is not completing the WIP JOB automatically,
1674: So we need to insert record to WIP_JOB_SCHEDULE_INTERFACE with status_type as 'COMPLETE' VALUE 4.
1675: Then run the WIP_MASS_LOAD Concurrent program to change the JOB status to "COMPLETE".
1676:
1677: Do Miscellaneous issue transaction or SCRAP/ADJUSTMENT transaction from
1678: Repair Supplier Org's defective subinv for the scrap qty
1878: 3.If possible try to update quantity_scrapped column with l_scrap_quanity value instead of updating QUANTITY_COMPLETED column.
1879: **/
1880: ---------------End comment on NOV-29-2005 --------
1881: /*
1882: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
1883: into l_WIP_BATCH_ID
1884: from dual;
1885:
1886: Begin
1883: into l_WIP_BATCH_ID
1884: from dual;
1885:
1886: Begin
1887: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE
1888: (
1889: LAST_UPDATE_DATE,
1890: LAST_UPDATED_BY,
1891: CREATION_DATE,