[Home] [Help]
590: If nvl(IO_QTY_RECEIVED_CHECK_REC.QUANTITY_RECEIVED,0) > 0 and
591: CSP_REPAIR_PO_HEADERS_rec.WIP_ID IS NULL THEN
592: /** Create a WIB_JOB if there is no WIB_JOB created for this INTERNAL_ORDER so far **/
593:
594: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
595: into l_WIP_BATCH_ID
596: from dual;
597:
598: SELECT WIP_ENTITIES_S.NEXTVAL
620: g_retcode := 1;
621: End if;
622:
623: Begin
624: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(
625: LAST_UPDATE_DATE,
626: LAST_UPDATED_BY,
627: CREATION_DATE,
628: CREATED_BY,
757: SET WIP_ID = l_WIP_ENTITY_ID, STATUS = 8
758: -- WHERE CURRENT OF CSP_REPAIR_PO_HEADERS;
759: WHERE ROWID = CSP_REPAIR_PO_HEADERS_rec.ROWID;
760: Else
761: /* STATUS = 7 => Inserted into 'WIP_JOB_SCHEDULE_INTERFACE' */
762: UPDATE CSP_REPAIR_PO_HEADERS
763: SET WIP_ID = l_WIP_ENTITY_ID_INTERFACE, STATUS = 7
764: -- WHERE CURRENT OF CSP_REPAIR_PO_HEADERS;
765: WHERE ROWID = CSP_REPAIR_PO_HEADERS_rec.ROWID;
1035:
1036: --------------------- Start comment on Nov-29-2005 -----------------
1037: /*
1038:
1039: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
1040: into l_WIP_BATCH_ID
1041: from dual;
1042:
1043: Begin
1040: into l_WIP_BATCH_ID
1041: from dual;
1042:
1043: Begin
1044: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(
1045: LAST_UPDATE_DATE,
1046: LAST_UPDATED_BY,
1047: CREATION_DATE,
1048: CREATED_BY,
1193: This transaction is for WIP job qty scrap
1194: Do "Return Components from WIP" (43) transaction and wip job qty is returned from WIP JOB to Repair Supplier Org's Defect subinv
1195:
1196: Passing 'Y' for FINAL_COMPLETION_FLAG is not completing the WIP JOB automatically,
1197: So we need to insert record to WIP_JOB_SCHEDULE_INTERFACE with status_type as 'COMPLETE' VALUE 4.
1198: Then run the WIP_MASS_LOAD Concurrent program to change the JOB status to "COMPLETE".
1199:
1200: Do Miscellaneous transaction or SCRAP/ADJUSTMENT transaction from defective subinv
1201:
1372: WIP_JOB qty is returned from WIP JOB to Repair Supplier Org's Defect subinv
1373: by doing material transaction of type "Return Components from WIP" (43)
1374:
1375: Passing 'Y' for FINAL_COMPLETION_FLAG is not completing the WIP JOB automatically,
1376: So we need to insert record to WIP_JOB_SCHEDULE_INTERFACE with status_type as 'COMPLETE' VALUE 4.
1377: Then run the WIP_MASS_LOAD Concurrent program to change the JOB status to "COMPLETE".
1378:
1379: Do Miscellaneous issue transaction or SCRAP/ADJUSTMENT transaction from
1380: Repair Supplier Org's defective subinv for the scrap qty
1573: 3.If possible try to update quantity_scrapped column with l_scrap_quanity value instead of updating QUANTITY_COMPLETED column.
1574: **/
1575: ---------------End comment on NOV-29-2005 --------
1576: /*
1577: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
1578: into l_WIP_BATCH_ID
1579: from dual;
1580:
1581: Begin
1578: into l_WIP_BATCH_ID
1579: from dual;
1580:
1581: Begin
1582: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE
1583: (
1584: LAST_UPDATE_DATE,
1585: LAST_UPDATED_BY,
1586: CREATION_DATE,