[Home] [Help]
108: -- have not been received by INV need to be modified so they
109: -- don't get picked by the next run of the RMA inferface program.
110: -- For those record found in the interface set the quantity to 0
111: -- and set the closed_flag to 'Y'.
112: -- Need to insert a record into so_order_cancellations indicating
113: -- the order level cancellation. We also need to detele the
114: -- corresponding so_line_details for the order just cancelled,
115: -- excluding any line details that have been released. Also
116: -- need to cleanup the so_line_service_details if there were any
298: END LOOP;
299: end;
300: END IF;
301:
302: INSERT INTO SO_ORDER_CANCELLATIONS
303: (HEADER_ID, CANCEL_CODE,
304: CANCELLED_BY, CANCEL_DATE,
305: LAST_UPDATED_BY, LAST_UPDATE_DATE,
306: LAST_UPDATE_LOGIN, CREATION_DATE,
875: -- once we cancel, we need to disassociate it from it's
876: -- source since we've changed the configuration.
877: -- Update the cancelled_quantity in so_lines adjusted by any
878: -- ratio differences if were have a model.
879: -- Insert a record into so_order_cancellations
880: -- Update the open_flag in so_lines, if ordered_quantity less
881: -- the cancelled_quantity is 0 then set the open_flag = ''
882: -- Set the S9 (Cancel Line) column based on the open flag.
883: -- If open_flag is null then set the S9 to 11 (Complete) otherwise
1005: - GREATEST (NVL(SHIPPED_QUANTITY,0),
1006: NVL(INVOICED_QUANTITY,0))
1007: WHERE SOL.LINE_ID = full1rec.LINE_ID;
1008:
1009: INSERT INTO SO_ORDER_CANCELLATIONS
1010: (LINE_ID, HEADER_ID, CANCEL_CODE, CANCELLED_BY,
1011: CANCEL_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
1012: CANCEL_COMMENT, CANCELLED_QUANTITY, STATUS,
1013: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN )
1089: WHERE L.LINE_ID = not_full_rec.LINE_ID;
1090: END LOOP;
1091: END;
1092:
1093: INSERT INTO SO_ORDER_CANCELLATIONS
1094: ( LINE_ID, HEADER_ID,
1095: CANCEL_CODE, CANCELLED_BY,
1096: CANCEL_DATE, LAST_UPDATED_BY,
1097: LAST_UPDATE_DATE, CANCEL_COMMENT,
1104: SYSDATE, V_CANCEL_COMMENT,
1105: NVL(L.CANCELLED_QUANTITY,0) - NVL(SUM (SOC.CANCELLED_QUANTITY),0),
1106: V_STATUS, SYSDATE, v_current_user,
1107: V_LAST_UPDATE_LOGIN
1108: FROM SO_LINES L, SO_ORDER_CANCELLATIONS SOC
1109: WHERE L.LINE_ID IN
1110: (SELECT LINE_ID
1111: FROM SO_LINES
1112: WHERE PARENT_LINE_ID = V_REAL_PARENT_LINE_ID
1270: -- open_flag to '' if ordered_quantity equals cancelled_quantity.
1271: -- If no backordered picking lines exist where the original requested
1272: -- quantity is greater than the cancelled quantity then set S3
1273: -- (Backorder Release) to 8 (Not Applicable) if it was 18 (Eligible).
1274: -- Insert a record into so_order_cancellations.
1275: --
1276: -- RETURNS
1277: -- 1 -> success
1278: ------------------------------------------------------------------------
1440: S30_DATE=DECODE(OPEN_FLAG,'' ,
1441: DECODE(S30,8,SYSDATE,S30_DATE),S30_DATE)
1442: WHERE LINE_ID = V_LINE_ID;
1443:
1444: INSERT INTO SO_ORDER_CANCELLATIONS
1445: ( LINE_ID, HEADER_ID,
1446: CANCEL_CODE, CANCELLED_BY,
1447: CANCEL_DATE, LAST_UPDATED_BY,
1448: LAST_UPDATE_DATE, CANCEL_COMMENT,