[Home] [Help]
146: FND_GLOBAL.USER_ID,
147: X_Requested_Qty,
148: X_Shipped_Qty,
149: X_Serial
150: FROM DUAL)
151: WHERE PICKING_LINE_DETAIL_ID = X_Trx_Src_Line_Id;
152:
153: EXCEPTION
154: WHEN NO_DATA_FOUND THEN
179: X_new_detail_id NUMBER;
180: BEGIN
181: SELECT SO_PICKING_LINE_DETAILS_S.NEXTVAL
182: INTO X_new_detail_id
183: FROM DUAL;
184:
185: Insert_Details( x_new_detail_id,
186: X_Parent_Detail_Id,
187: NULL,
226:
227: IF (X_New_Detail_Id is NULL) THEN
228: SELECT SO_PICKING_LINE_DETAILS_S.NEXTVAL
229: INTO X_Created_Detail_Id
230: FROM DUAL;
231: END IF;
232:
233: INSERT INTO SO_PICKING_LINE_DETAILS (
234: PICKING_LINE_DETAIL_ID
471: --
472: -- Name
473: -- Explode_Lines
474: -- Purpose
475: -- Takes individual lines from MTL_SERIAL_NUMBERS_TEMP that
476: -- are under serial number control and explodes them into multiple
477: -- lines based on the serial numbers entered.
478: -- Arguments
479: -- X_Picking_Line_Detail_Id for which is under Serial number
626: select s_prefix || lpad('000000000000000000000000000000',
627: s_num_length - length(to_char(s_num_current + 1)))
628: || to_char(s_num_current + 1)
629: into X_new_serial
630: from dual;
631:
632: return(X_new_serial);
633:
634: END Next_Serial;