APPS.WSH_SC_PLD_PKG dependencies on SO_PICKING_LINE_DETAILS

Line 44: FROM so_picking_line_details

40: --get the picking line details for this Delivery
41: CURSOR picking_line_details_cursor IS
42: SELECT picking_line_detail_id, requested_quantity, shipped_quantity,
43: serial_number
44: FROM so_picking_line_details
45: WHERE delivery_id = X_Delivery_Id
46: AND transaction_temp_id IS NOT NULL;
47:
48: -- to check if the item is under serial number control

Line 53: so_picking_line_details pld

49: CURSOR check_serial(X_Pk_Line_Detail_Id NUMBER) is
50: SELECT msi.serial_number_control_code
51: FROM mtl_system_items msi,
52: so_picking_lines_all pl,
53: so_picking_line_details pld
54: WHERE pl.inventory_item_id = msi.inventory_item_id
55: AND pl.warehouse_id = msi.organization_id
56: AND msi.serial_number_control_code in (2,5,6)
57: AND pl.picking_line_id = pld.picking_line_id

Line 135: UPDATE SO_PICKING_LINE_DETAILS PLD

131: X_Shipped_Qty IN NUMBER,
132: X_Serial IN VARCHAR2) IS
133: BEGIN
134:
135: UPDATE SO_PICKING_LINE_DETAILS PLD
136: SET
137: (LAST_UPDATE_DATE,
138: LAST_UPDATED_BY,
139: LAST_UPDATE_LOGIN,

Line 181: SELECT SO_PICKING_LINE_DETAILS_S.NEXTVAL

177: X_detail_type_code IN VARCHAR2)
178: RETURN NUMBER IS
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,

Line 228: SELECT SO_PICKING_LINE_DETAILS_S.NEXTVAL

224: BEGIN
225:
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:

Line 233: INSERT INTO SO_PICKING_LINE_DETAILS (

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
235: ,LAST_UPDATE_DATE
236: ,LAST_UPDATED_BY
237: ,CREATED_BY

Line 405: FROM SO_PICKING_LINE_DETAILS WHERE

401: ,decode(X_Mode,'REMAINDER', NULL,TRANSACTION_TEMP_ID)
402: ,PICK_SLIP_NUMBER
403: ,decode(X_Mode,'REMAINDER', NULL,CONTAINER_ID)
404: ,MVT_STAT_STATUS
405: FROM SO_PICKING_LINE_DETAILS WHERE
406: PICKING_LINE_DETAIL_ID = X_Parent_Detail_Id ;
407:
408: EXCEPTION
409: WHEN NO_DATA_FOUND THEN

Line 444: -- insert the remainder detail in so_picking_line_details

440: PROCEDURE Create_Remainders(X_Picking_Line_Detail_Id NUMBER,
441: X_New_Requested NUMBER ) IS
442: BEGIN
443:
444: -- insert the remainder detail in so_picking_line_details
445: -- shipped quantity will be 0 since this remainder detail
446: -- is for the unshipped quantity
447: Insert_Details( NULL,
448: X_Picking_Line_Detail_Id,

Line 455: UPDATE so_picking_line_details pld

451: NULL ,
452: 'REMAINDER') ;
453:
454: --now update the requested quantity on the original picking_line_detail
455: UPDATE so_picking_line_details pld
456: SET pld.requested_quantity = pld.shipped_quantity
457: WHERE pld.picking_line_detail_id = X_Picking_Line_Detail_Id;
458:
459: EXCEPTION

Line 484: -- there is one line in SO_PICKING_LINE_DETAILS

480: -- control and hence must do the explosion
481: --
482: -- Notes
483: -- Assumptions: The package assumes that it will be called when
484: -- there is one line in SO_PICKING_LINE_DETAILS
485: -- for every line in MTL_SERIAL_NUMBERS_TEMP.
486: --
487:
488:

Line 502: so_picking_line_details pld

498: msnt.fm_serial_number,
499: msnt.to_serial_number,
500: msnt.serial_prefix
501: FROM mtl_serial_numbers_temp msnt,
502: so_picking_line_details pld
503: WHERE pld.picking_line_detail_id = pk_line_detail_id
504: AND pld.transaction_temp_id = msnt.transaction_temp_id(+)
505: ORDER BY msnt.transaction_temp_id;
506:

Line 655: FROM so_picking_line_details

651:
652: DELETE FROM mtl_serial_numbers_temp
653: WHERE transaction_temp_id in
654: (SELECT transaction_temp_id
655: FROM so_picking_line_details
656: WHERE delivery_id = X_Delivery_Id );
657:
658: EXCEPTION
659: WHEN NO_DATA_FOUND THEN