APPS.WSH_PR_PICKING_OBJECTS dependencies on DUAL

Line 455: FROM DUAL;

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 (
458: x_pl_id,
459: p_component_code,

Line 600: FROM DUAL;

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 (
603: x_pl_id,
604: p_component_code,

Line 779: FROM DUAL;

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 (
782: x_pl_id,
783: p_component_code,

Line 822: FROM DUAL;

818: p_new_delivery := 0;
819: ELSE
820: SELECT SO_DELIVERIES_S.NEXTVAL
821: INTO p_new_delivery
822: FROM DUAL;
823: END IF;
824:
825: rc := Insert_Picking_Line_Details (
826: BACKORDER,

Line 867: FROM DUAL;

863: ELSIF p_backorder_line = UNRELEASED_LINE THEN
864: IF p_autodetailed_quantity > 0 THEN
865: SELECT SO_DELIVERIES_S.NEXTVAL
866: INTO p_new_delivery
867: FROM DUAL;
868:
869: -- Create a new order line detail
870: rc := Insert_Order_Line_Detail (
871: p_original_line_detail_id,

Line 903: FROM DUAL;

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 (
906: x_pl_id,
907: p_component_code,

Line 1028: FROM DUAL;

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 (
1031: x_pl_id,
1032: p_component_code,

Line 1669: FROM DUAL;

1665: WSH_UTIL.Write_Log('Inserting new order line detail');
1666:
1667: SELECT SO_LINE_DETAILS_S.NEXTVAL
1668: INTO p_new_line_detail_id
1669: FROM DUAL;
1670:
1671: INSERT INTO SO_LINE_DETAILS (
1672: LINE_DETAIL_ID,
1673: CREATION_DATE,

Line 1910: FROM DUAL;

1906: RETURN x_value;
1907: ELSE
1908: SELECT SO_PICKING_HEADERS_S.NEXTVAL
1909: INTO x_value
1910: FROM DUAL;
1911: tab_size := g_ps_table.count;
1912: g_ps_table(tab_size+1).key := key;
1913: g_ps_table(tab_size+1).value := x_value;
1914: new_flag := 'Y';

Line 1938: FROM DUAL;

1934: RETURN x_value;
1935: ELSE
1936: SELECT SO_PICKING_HEADERS_S.NEXTVAL
1937: INTO x_value
1938: FROM DUAL;
1939: tab_size := g_ph_table.count;
1940: g_ph_table(tab_size+1).key := key;
1941: g_ph_table(tab_size+1).value := x_value;
1942: new_flag := 'Y';