PACKAGE: APPS.WSH_WSHRDXCP_XMLP_PKG

Source

1 PACKAGE WSH_WSHRDXCP_XMLP_PKG AS
2 /* $Header: WSHRDXCPS.pls 120.4 2008/02/12 13:06:24 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_ORG_ID NUMBER;
6 
7   P_LOCATOR_STRUC_NUM NUMBER;
8 
9   CP_CREATION_DATE_FROM  varchar2(20);
10   CP_CREATION_DATE_TO varchar2(20);
11   CP_LAST_UPDATE_DATE_FROM varchar2(20);
12   CP_LAST_UPDATE_DATE_TO varchar2(20);
13 
14   P_LOCATOR_FLEXSQL VARCHAR2(1000);
15 
16   P_DELIVERY_ID_HIGH NUMBER;
17 
18   P_CREATION_DATE_TO DATE;
19 
20   P_CREATION_DATE_FROM DATE;
21 
22   P_ITEM_FLEXSQL VARCHAR2(1000);
23 
24   P_ITEM_FLEXNUM NUMBER;
25 
26   P_TRIP_ID_LOW NUMBER;
27 
28   P_TRACE_FLAG NUMBER;
29 
30   P_CBO_FLAG NUMBER;
31 
32   P_DELIVERY_ID_LOW NUMBER;
33 
34   P_TRIP_ID_HIGH NUMBER;
35 
36   P_REQUEST_ID NUMBER;
37 
38   P_EXCEPTION_LOCATION_ID NUMBER;
39 
40   P_LOGGED_LOCATION_ID NUMBER;
41 
42   P_SEVERITY VARCHAR2(10);
43 
44   P_STATUS VARCHAR2(30);
45 
46   P_SORT_BY NUMBER;
47 
48   P_WHERE_CLAUSE VARCHAR2(4000);
49 
50   P_LAST_UPDATE_DATE_FROM DATE;
51 
52   P_LAST_UPDATE_DATE_TO DATE;
53 
54   P_EXCEPTION_NAME VARCHAR2(100);
55 
56   P_LOGGING_ENTITY VARCHAR2(30);
57 
58   P_ORDER_BY VARCHAR2(100) := 'order by exception_name';
59 
60   P_MOVE_ORDER_LOW VARCHAR2(30);
61 
62   P_MOVE_ORDER_HIGH VARCHAR2(30);
63 
64   P_BATCHES VARCHAR2(120);
65 
66   P_DEL_LINES_CONT VARCHAR2(5000):=' ';
67 
68   P_WSH_PICKING_BATCHES_TABLE VARCHAR2(40);
69 
70   P_REQUEST VARCHAR2(100);
71 
72   P_EXCEPTION VARCHAR2(100);
73 
74   P_LOGGING_ENTITY_LOCATION VARCHAR2(200);
75 
76   P_TRIP VARCHAR2(200);
77 
78   P_DELIVERY VARCHAR2(200);
79 
80   P_SEVERITY_STATUS VARCHAR2(150);
81 
82   P_WE_WPB_OUTER_JOIN VARCHAR2(100);
83 
84   P_CREATION_UPDATE_DATE VARCHAR2(350);
85 
86   P_HINT_1 VARCHAR2(200);
87 
88   CP_DELIVERY_DETAIL_ID NUMBER;
89 
90   CP_EXCEPTION_LOCATION_NAME VARCHAR2(100);
91 
92   CP_SHIP_FROM_LOCATION_NAME VARCHAR2(100);
93 
94   CP_WAREHOUSE_NAME VARCHAR2(100);
95 
96   FUNCTION BEFOREREPORT RETURN BOOLEAN;
97 
98   FUNCTION AFTERREPORT RETURN BOOLEAN;
99 
100   FUNCTION AFTERPFORM RETURN BOOLEAN;
101 
102   FUNCTION C_LOGGED_LOCATIONFORMULA(LOGGED_AT_LOCATION_ID IN NUMBER) RETURN CHAR;
103 
104   FUNCTION C_EXCEPTION_LOCATIONFORMULA(EXCEPTION_LOCATION_ID IN NUMBER) RETURN CHAR;
105 
106   FUNCTION CF_CONTAINER_NAMEFORMULA(CONTAINER_NAME IN VARCHAR2
107                                    ,DELIVERY_DETAIL_ID IN NUMBER) RETURN VARCHAR2;
108 
109   FUNCTION CF_DELIVERY_NAMEFORMULA(DELIVERY_DETAIL_ID IN NUMBER
110                                   ,DEL_NAME IN VARCHAR2) RETURN CHAR;
111 
112   FUNCTION CP_DELIVERY_DETAIL_ID_P RETURN NUMBER;
113 
114   FUNCTION CP_EXCEPTION_LOCATION_NAME_P RETURN VARCHAR2;
115 
116   FUNCTION CP_SHIP_FROM_LOCATION_NAME_P RETURN VARCHAR2;
117 
118   FUNCTION CP_WAREHOUSE_NAME_P RETURN VARCHAR2;
119 
120 END WSH_WSHRDXCP_XMLP_PKG;
121