DBA Data[Home] [Help]

APPS.WSH_PR_PICKING_OBJECTS dependencies on SO_PICKING_LINES_S

Line 453: SELECT SO_PICKING_LINES_S.NEXTVAL

449: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
450: RETURN FAILURE;
451: END IF;
452:
453: SELECT SO_PICKING_LINES_S.NEXTVAL
454: INTO x_pl_id
455: FROM DUAL;
456:
457: rc := Insert_Picking_Line (

Line 598: SELECT SO_PICKING_LINES_S.NEXTVAL

594: WSH_UTIL.Write_Log('Transactable and Reservable');
595:
596: IF p_autodetailed_quantity > 0 THEN
597: -- Insert picking line
598: SELECT SO_PICKING_LINES_S.NEXTVAL
599: INTO x_pl_id
600: FROM DUAL;
601:
602: rc := Insert_Picking_Line (

Line 777: SELECT SO_PICKING_LINES_S.NEXTVAL

773:
774: IF p_backorder_line = BACKORDER_LINE THEN
775: -- Create a picking line for the remaining quantity with
776: -- picking header id = 0
777: SELECT SO_PICKING_LINES_S.NEXTVAL
778: INTO x_pl_id
779: FROM DUAL;
780:
781: rc := Insert_Picking_Line (

Line 901: SELECT SO_PICKING_LINES_S.NEXTVAL

897:
898: WSH_UTIL.Write_Log('Transactable, Not Reservable');
899:
900: -- Insert picking line
901: SELECT SO_PICKING_LINES_S.NEXTVAL
902: INTO x_pl_id
903: FROM DUAL;
904:
905: rc := Insert_Picking_Line (

Line 1026: SELECT SO_PICKING_LINES_S.NEXTVAL

1022: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
1023: RETURN FAILURE;
1024: END IF;
1025:
1026: SELECT SO_PICKING_LINES_S.NEXTVAL
1027: INTO x_pl_id
1028: FROM DUAL;
1029:
1030: rc := Insert_Picking_Line (