APPS.WSH_WSHRDOPN_XMLP_PKG dependencies on WSH_PICKING_BATCHES

Line 58: V_BATCH_ID WSH_PICKING_BATCHES.BATCH_ID%TYPE;

54: V_ITEM_FROM VARCHAR2(150);
55: V_ITEM_WHERE VARCHAR2(240);
56: V_ITEM_QUALIFY VARCHAR2(240);
57: V_ITEM_TOTAL VARCHAR2(720);
58: V_BATCH_ID WSH_PICKING_BATCHES.BATCH_ID%TYPE;
59: V_BTCH_NO WSH_PICKING_BATCHES.NAME%TYPE;
60: CURSOR GET_BATCH_NAME IS
61: SELECT
62: WPB.NAME

Line 59: V_BTCH_NO WSH_PICKING_BATCHES.NAME%TYPE;

55: V_ITEM_WHERE VARCHAR2(240);
56: V_ITEM_QUALIFY VARCHAR2(240);
57: V_ITEM_TOTAL VARCHAR2(720);
58: V_BATCH_ID WSH_PICKING_BATCHES.BATCH_ID%TYPE;
59: V_BTCH_NO WSH_PICKING_BATCHES.NAME%TYPE;
60: CURSOR GET_BATCH_NAME IS
61: SELECT
62: WPB.NAME
63: FROM

Line 64: WSH_PICKING_BATCHES WPB

60: CURSOR GET_BATCH_NAME IS
61: SELECT
62: WPB.NAME
63: FROM
64: WSH_PICKING_BATCHES WPB
65: WHERE WPB.BATCH_ID = V_BATCH_ID;
66: V_SORT_DISPLAY FND_LOOKUP_VALUES_VL.MEANING%TYPE;
67: CURSOR GET_SORT_DISP_MEANING IS
68: SELECT

Line 230: V_BATCH_ID WSH_PICKING_BATCHES.BATCH_ID%TYPE;

226: V_ITEM_FROM VARCHAR2(150);
227: V_ITEM_WHERE VARCHAR2(240);
228: V_ITEM_QUALIFY VARCHAR2(240);
229: V_ITEM_TOTAL VARCHAR2(720);
230: V_BATCH_ID WSH_PICKING_BATCHES.BATCH_ID%TYPE;
231: V_BTCH_NO WSH_PICKING_BATCHES.NAME%TYPE;
232: CURSOR GET_BATCH_NAME IS
233: SELECT
234: WPB.NAME

Line 231: V_BTCH_NO WSH_PICKING_BATCHES.NAME%TYPE;

227: V_ITEM_WHERE VARCHAR2(240);
228: V_ITEM_QUALIFY VARCHAR2(240);
229: V_ITEM_TOTAL VARCHAR2(720);
230: V_BATCH_ID WSH_PICKING_BATCHES.BATCH_ID%TYPE;
231: V_BTCH_NO WSH_PICKING_BATCHES.NAME%TYPE;
232: CURSOR GET_BATCH_NAME IS
233: SELECT
234: WPB.NAME
235: FROM

Line 236: WSH_PICKING_BATCHES WPB

232: CURSOR GET_BATCH_NAME IS
233: SELECT
234: WPB.NAME
235: FROM
236: WSH_PICKING_BATCHES WPB
237: WHERE WPB.BATCH_ID = V_BATCH_ID;
238: V_SORT_DISPLAY FND_LOOKUP_VALUES_VL.MEANING%TYPE;
239: CURSOR GET_SORT_DISP_MEANING IS
240: SELECT