PACKAGE: APPS.WSH_WSHRDLAB_XMLP_PKG

Source

1 PACKAGE WSH_WSHRDLAB_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHRDLABS.pls 120.3.12010000.2 2009/03/20 09:42:19 gbhargav ship $ */
3   P_NO_DATA_FOUND VARCHAR2(1);
4 
5   P_TRIP_STOP_ID NUMBER;
6 
7   CP_DEPARTURE_DATE_HIGH date;
8 
9   P_DEPARTURE_DATE_LOW DATE;
10 
11   P_DEPARTURE_DATE_HIGH DATE;
12 
13   P_FREIGHT_CODE VARCHAR2(60);
14 
15   P_DELIVERY_ID NUMBER;
16 
17   P_CONTAINER_ID VARCHAR2(60);
18 
19   P_ORGANIZATION_ID NUMBER;
20 
21   LP_CONTAINER_ID VARCHAR2(128);
22 
23   LP_MASTER_FLAG VARCHAR2(128);
24 
25   LP_DELIVERY_ID VARCHAR2(60);
26 
27   LP_FREIGHT_CODE VARCHAR2(60);
28 
29   LP_ORGANIZATION_ID VARCHAR2(60);
30 
31   LP_TRIP_STOP_ID VARCHAR2(250);
32 
33   LP_DATE_RANGE VARCHAR2(256);
34 
35   LP_TRIP_ID VARCHAR2(350);
36 
37   P_TRIP_ID NUMBER;
38 
39   P_CONC_REQUEST_ID NUMBER := 0;
40 
41   CP_CONTACT_PHONE VARCHAR2(50);
42 
43   CP_ADDRESSEE VARCHAR2(1000);
44 
45   CP_DELIVER_TO_LOCATION_ID NUMBER;
46 
47   CP_SHIP_TO_ADDRESS1 VARCHAR2(240);
48 
49   CP_SHIP_TO_ADDRESS2 VARCHAR2(240);
50 
51   CP_SHIP_TO_ADDRESS3 VARCHAR2(240);
52 
53   CP_SHIP_TO_CSZ VARCHAR2(245);
54 
55   CP_SHIP_TO_COUNTRY VARCHAR2(60);
56 
57   CP_DEL_TO_ADDRESS1 VARCHAR2(240);
58 
59   CP_DEL_TO_ADDRESS2 VARCHAR2(240);
60 
61   CP_DEL_TO_ADDRESS3 VARCHAR2(240);
62 
63   CP_DEL_TO_CSZ VARCHAR2(245);
64 
65   CP_DEL_TO_COUNTRY VARCHAR2(60);
66 
67   P_STANDALONE VARCHAR2(1); --STANDALONE CHANGES
68 
69   FUNCTION CF_ORDER_NUMBERFORMULA(DELIVERY_DETAIL_ID IN NUMBER) RETURN VARCHAR2;
70 
71   FUNCTION CP_SHIP_TO_ADDRESS1FORMULA RETURN CHAR;
72 
73   FUNCTION AFTERPFORM RETURN BOOLEAN;
74 
75   FUNCTION CF_SHIP_TO_CUST_NAMEFORMULA(C_SHIP_TO_SITE_USE_ID IN NUMBER) RETURN CHAR;
76 
77   FUNCTION CF_FREIGHT_CARRIERFORMULA(CARRIER_NAME IN VARCHAR2
78                                     ,DEL_ORGANIZATION_ID IN NUMBER
79                                     ,DELIVERY_ID1 IN NUMBER) RETURN CHAR;
80 
81   FUNCTION CF_SHIP_TO_COUNTRY_NAMEFORMULA(SHIP_TO_COUNTRY IN VARCHAR2) RETURN CHAR;
82 
83   FUNCTION CF_DEL_TO_COUNTRY_NAMEFORMULA(DEL_TO_COUNTRY IN VARCHAR2) RETURN CHAR;
84 
85   FUNCTION CF_CONTACT_NAMEFORMULA(CONTACT_NAME IN VARCHAR2
86                                  ,CONTACT_PHONE_NUMBER IN VARCHAR2
87                                  ,DELIVERY_DETAIL_ID IN NUMBER) RETURN CHAR;
88 
89   FUNCTION BEFOREREPORT RETURN BOOLEAN;
90 
91   FUNCTION AFTERREPORT RETURN BOOLEAN;
92 
93   FUNCTION CP_CONTACT_PHONE_P RETURN VARCHAR2;
94 
95   FUNCTION CP_ADDRESSEE_P RETURN VARCHAR2;
96 
97   FUNCTION CP_DELIVER_TO_LOCATION_ID_P RETURN NUMBER;
98 
99   FUNCTION CP_SHIP_TO_ADDRESS1_P RETURN VARCHAR2;
100 
101   FUNCTION CP_SHIP_TO_ADDRESS2_P RETURN VARCHAR2;
102 
103   FUNCTION CP_SHIP_TO_ADDRESS3_P RETURN VARCHAR2;
104 
105   FUNCTION CP_SHIP_TO_CSZ_P RETURN VARCHAR2;
106 
107   FUNCTION CP_SHIP_TO_COUNTRY_P RETURN VARCHAR2;
108 
109   FUNCTION CP_DEL_TO_ADDRESS1_P RETURN VARCHAR2;
110 
111   FUNCTION CP_DEL_TO_ADDRESS2_P RETURN VARCHAR2;
112 
113   FUNCTION CP_DEL_TO_ADDRESS3_P RETURN VARCHAR2;
114 
115   FUNCTION CP_DEL_TO_CSZ_P RETURN VARCHAR2;
116 
117   FUNCTION CP_DEL_TO_COUNTRY_P RETURN VARCHAR2;
118 
119 END WSH_WSHRDLAB_XMLP_PKG;
120