APPS.WSH_WSHRDOPN_XMLP_PKG dependencies on WSH_PICKING_BATCHES

Line 50: V_BATCH_ID WSH_PICKING_BATCHES.BATCH_ID%TYPE;

46: V_ITEM_FROM VARCHAR2(150);
47: V_ITEM_WHERE VARCHAR2(240);
48: V_ITEM_QUALIFY VARCHAR2(240);
49: V_ITEM_TOTAL VARCHAR2(720);
50: V_BATCH_ID WSH_PICKING_BATCHES.BATCH_ID%TYPE;
51: V_BTCH_NO WSH_PICKING_BATCHES.NAME%TYPE;
52: CURSOR GET_BATCH_NAME IS
53: SELECT
54: WPB.NAME

Line 51: V_BTCH_NO WSH_PICKING_BATCHES.NAME%TYPE;

47: V_ITEM_WHERE VARCHAR2(240);
48: V_ITEM_QUALIFY VARCHAR2(240);
49: V_ITEM_TOTAL VARCHAR2(720);
50: V_BATCH_ID WSH_PICKING_BATCHES.BATCH_ID%TYPE;
51: V_BTCH_NO WSH_PICKING_BATCHES.NAME%TYPE;
52: CURSOR GET_BATCH_NAME IS
53: SELECT
54: WPB.NAME
55: FROM

Line 56: WSH_PICKING_BATCHES WPB

52: CURSOR GET_BATCH_NAME IS
53: SELECT
54: WPB.NAME
55: FROM
56: WSH_PICKING_BATCHES WPB
57: WHERE WPB.BATCH_ID = V_BATCH_ID;
58: V_SORT_DISPLAY FND_LOOKUP_VALUES_VL.MEANING%TYPE;
59: CURSOR GET_SORT_DISP_MEANING IS
60: SELECT

Line 203: V_BATCH_ID WSH_PICKING_BATCHES.BATCH_ID%TYPE;

199: V_ITEM_FROM VARCHAR2(150);
200: V_ITEM_WHERE VARCHAR2(240);
201: V_ITEM_QUALIFY VARCHAR2(240);
202: V_ITEM_TOTAL VARCHAR2(720);
203: V_BATCH_ID WSH_PICKING_BATCHES.BATCH_ID%TYPE;
204: V_BTCH_NO WSH_PICKING_BATCHES.NAME%TYPE;
205: CURSOR GET_BATCH_NAME IS
206: SELECT
207: WPB.NAME

Line 204: V_BTCH_NO WSH_PICKING_BATCHES.NAME%TYPE;

200: V_ITEM_WHERE VARCHAR2(240);
201: V_ITEM_QUALIFY VARCHAR2(240);
202: V_ITEM_TOTAL VARCHAR2(720);
203: V_BATCH_ID WSH_PICKING_BATCHES.BATCH_ID%TYPE;
204: V_BTCH_NO WSH_PICKING_BATCHES.NAME%TYPE;
205: CURSOR GET_BATCH_NAME IS
206: SELECT
207: WPB.NAME
208: FROM

Line 209: WSH_PICKING_BATCHES WPB

205: CURSOR GET_BATCH_NAME IS
206: SELECT
207: WPB.NAME
208: FROM
209: WSH_PICKING_BATCHES WPB
210: WHERE WPB.BATCH_ID = V_BATCH_ID;
211: V_SORT_DISPLAY FND_LOOKUP_VALUES_VL.MEANING%TYPE;
212: CURSOR GET_SORT_DISP_MEANING IS
213: SELECT