PACKAGE: APPS.WMS_WMSSCHS1_XMLP_PKG

Source

1 PACKAGE WMS_WMSSCHS1_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: WMSSCHS1S.pls 120.3 2007/12/25 07:59:47 nchinnam noship $ */
3   LP_PRIOR_RES_FLAG VARCHAR2(60):='   ';
4 
5   LP_SHIPMENT_SCHEDULE_DATE VARCHAR2(1000):='   ';
6 
7   LP_REQUEST_DATE VARCHAR2(1000):='   ';
8 
9   LP_DELIVERY_ID VARCHAR2(40):='   ';
10 
11   LP_TRIP_STOP VARCHAR2(40):='   ';
12 
13   LP_PROJECT VARCHAR2(40):='   ';
14 
15   LP_TASK VARCHAR2(40):='    ';
16 
17   P_ORG_ID NUMBER;
18 
19   P_LOC_FLEX_ALL VARCHAR2(1000);
20 
21   P_ITEM_FLEX_ALL VARCHAR2(1000);
22 
23   P_PRINT_CUS_PROD_DET NUMBER;
24 
25   P_LICENSE_PLATE_NUMBER VARCHAR2(1000);
26 
27   P_OUTERMOST_LPN VARCHAR2(1000);
28 
29   P_PROJECT VARCHAR2(1000);
30 
31   P_PROJECT_1 VARCHAR2(1000);
32 
33   P_TASK VARCHAR2(1000);
34 
35   P_TASK_1 VARCHAR2(1000);
36 
37   P_CONC_REQUEST_ID NUMBER;
38 
39   P_REQUEST_DATE VARCHAR2(25);
40 
41   P_ACTUAL_START_DATE VARCHAR2(25);
42 
43   P_SAVE_OUTPUT_FLAG VARCHAR2(32767);
44 
45   P_PRINTER VARCHAR2(32767);
46 
47   P_REPORT_NAME VARCHAR2(1000);
48 
49   P_SCHEDULE_SHIPMENT_FROM_DATE VARCHAR2(100);
50 
51   P_SCHEDULE_SHIPMENT_TO_DATE VARCHAR2(100);
52 
53   P_REQUEST_DATE_FROM VARCHAR2(40);
54 
55   P_REQUEST_DATE_TO VARCHAR2(40);
56 
57   P_TRIP_ID NUMBER;
58 
59   P_PROJECT_ID NUMBER;
60 
61   P_TASK_ID NUMBER;
62 
63   P_PRIOR_RES_FLAG NUMBER;
64 
65   P_ORG_NAME VARCHAR2(240);
66 
67   P_ORG_CODE VARCHAR2(32767);
68 
69   P_CUSTOMER_NAME VARCHAR2(50);
70 
71   P_CUSTOMER_NUMBER VARCHAR2(30);
72 
73   P_CUSTOMER_ID NUMBER;
74 
75   P_DELIVERY_ID NUMBER;
76 
77   P_SHIP_TO_LOCATION VARCHAR2(1000);
78 
79   P_RES_FLAG VARCHAR2(32767);
80 
81   P_PRINT_CUS_DETAILS VARCHAR2(32767);
82 
83   LP_SO_HEADER VARCHAR2(40):='   ';
84 
85   LP_SO_LINE VARCHAR2(40):='   ';
86 
87   P_SO_TYPE VARCHAR2(32767);
88 
89   P_ORDER_HEADER_ID NUMBER;
90 
91   P_ORDER_LINE_ID NUMBER;
92 
93   P_ORDER_TYPE VARCHAR2(50);
94 
95   P_LINE_NUMBER VARCHAR2(32767);
96 
97   P_ORDER_NUMBER NUMBER;
98 
99   FUNCTION BEFOREREPORT RETURN BOOLEAN;
100 
101   FUNCTION AFTERPFORM RETURN BOOLEAN;
102 
103   FUNCTION AFTERREPORT RETURN BOOLEAN;
104 
105   FUNCTION CF_LOC_FLEX_FIELDFORMULA RETURN CHAR;
106 
107   FUNCTION CF_LPN_NUMBERFORMULA(LPN_ID_1 IN NUMBER) RETURN CHAR;
108 
109   FUNCTION CF_OUTERMOST_LPNFORMULA(LPN_ID_1 IN NUMBER) RETURN CHAR;
110 
111   FUNCTION CF_PROJECTFORMULA(PROJECT_ID_1 IN NUMBER) RETURN CHAR;
112 
113   FUNCTION CF_TASKFORMULA(TASK_ID_1 IN NUMBER
114                          ,PROJECT_ID_1 IN NUMBER) RETURN CHAR;
115 
116   FUNCTION CF_SHIP_TO_LOCATIONFORMULA(SHIP_TO_LOCATION_ID_1 IN NUMBER) RETURN CHAR;
117 
118   FUNCTION CF_BARCODEFORMULA RETURN VARCHAR2;
119 
120   FUNCTION BEFOREPFORM RETURN BOOLEAN;
121 
122   FUNCTION BETWEENPAGE RETURN BOOLEAN;
123 
124 END WMS_WMSSCHS1_XMLP_PKG;
125