PACKAGE: APPS.WSH_WSHRDBOL_XMLP_PKG

Source

1 PACKAGE WSH_WSHRDBOL_XMLP_PKG AS
2 /* $Header: WSHRDBOLS.pls 120.3.12010000.1 2008/07/29 06:17:25 appldev ship $ */
3   LP_WHERE_CLAUSE VARCHAR2(100);
4 
5   P_DELIVERY_LEG_ID VARCHAR2(30);
6 
7   P_DELIVERY_DATE_HIGH DATE;
8   P_DELIVERY_DATE_HIGH_V DATE;
9 
10   P_DELIVERY_DATE_LOW DATE;
11 
12   P_FREIGHT_CODE VARCHAR2(60);
13 
14   P_DELIVERY_ID NUMBER;
15 
16   P_TRIP_ID NUMBER;
17 
18   P_ITEM_DISPLAY VARCHAR2(1);
19 
20   P_ITEM_FLEX_CODE VARCHAR2(4);
21 
22   P_ORGANIZATION_ID NUMBER;
23 
24   --LP_DELIVERY_LEG_ID VARCHAR2(128);
25   LP_DELIVERY_LEG_ID VARCHAR2(128):= ' ';
26 
27   --LP_DATE_RANGE VARCHAR2(256);
28   LP_DATE_RANGE VARCHAR2(256):=' ';
29 
30   --LP_DELIVERY_ID VARCHAR2(2000);
31   LP_DELIVERY_ID VARCHAR2(2000):=' ';
32 
33   --LP_FREIGHT_CODE VARCHAR2(128);
34   LP_FREIGHT_CODE VARCHAR2(128):= ' ';
35 
36   --LP_ORGANIZATION_ID VARCHAR2(128);
37   LP_ORGANIZATION_ID VARCHAR2(128):=' ';
38 
39   --LP_TRIP_ID VARCHAR2(200);
40   LP_TRIP_ID VARCHAR2(200):= ' ';
41 
42   P_CONC_REQUEST_ID NUMBER := 0;
43 
44   CP_CLASSIFICATION VARCHAR2(32767);
45 
46   CP_NUM_PACKAGES NUMBER;
47 
48   CP_TOP_MODEL_LINE_ID NUMBER;
49 
50   CP_SRC_LINE_ID NUMBER;
51 
52   CP_CONTAINER_CLASSIFICATION VARCHAR2(20);
53 
54   CP_HM VARCHAR2(1);
55 
56   CP_TOTAL_PREPAID_AMOUNT NUMBER;
57 
58   CP_TOTAL_PREPAID_CURRENCY VARCHAR2(20);
59 
60   CP_TOTAL_COLLECT_CURRENCY VARCHAR2(20);
61 
62   FUNCTION AFTERPFORM RETURN BOOLEAN;
63 
64   FUNCTION CF_LPNFORMULA(MASTER_CONTAINER_LPN IN VARCHAR2) RETURN CHAR;
65 
66   FUNCTION CF_CONTAINER_ITEM_DESCRIPTIONF(DELIVERY_DETAIL_ID IN NUMBER
67                                          ,ORGANIZATION_ID IN NUMBER) RETURN CHAR;
68 
69   FUNCTION CF_CONTAINER_GROSS_WTFORMULA(MASTER_CONTAINER_GROSS_WEIGHT IN NUMBER
70                                        ,MASTER_CONTAINER_WEIGHT_UOM IN VARCHAR2) RETURN CHAR;
71 
72   FUNCTION CF_1FORMULA(MASTER_CONTAINER_NET_WEIGHT IN NUMBER
73                       ,MASTER_CONTAINER_WEIGHT_UOM IN VARCHAR2) RETURN CHAR;
74 
75   FUNCTION CF_CONTAINER_TARE_WTFORMULA(MASTER_CONTAINER_TARE_WEIGHT IN NUMBER
76                                       ,MASTER_CONTAINER_WEIGHT_UOM IN VARCHAR2) RETURN CHAR;
77 
78   FUNCTION CF_CONTAINER_VOLUMEFORMULA(MASTER_CONTAINER_VOLUME IN NUMBER
79                                      ,MASTER_CONTAINER_VOLUME_UOM IN VARCHAR2) RETURN CHAR;
80 
81   FUNCTION CF_UNPACKED_ITEM_DESCFORMULA(UNPACKED_ITEM_DESCRIPTION IN VARCHAR2
82                                        ,UNPACKED_ITEM_SHIPPED_QUANTITY IN NUMBER
83                                        ,UNPACKED_ITEM_QUANTITY_UOM IN VARCHAR2
84                                        ,UNPACKED_ITEM_ORGANIZATION_ID IN NUMBER
85                                        ,UNPACKED_ITEM_INV_ITEM_ID IN NUMBER
86                                        ,UNPACKED_ITEM_QUANTITY_UOM2 IN VARCHAR2
87                                        ,UNPACKED_ITEM_SHIPPED_QTY2 IN NUMBER) RETURN CHAR;
88 
89   FUNCTION CF_UNPACKED_ITEM_WTFORMULA(UNPACKED_ITEM_NET_WEIGHT IN NUMBER
90                                      ,UNPACKED_ITEM_WEIGHT_UOM IN VARCHAR2) RETURN CHAR;
91 
92   FUNCTION CF_UNPACKED_ITEM_VOLFORMULA(UNPACKED_ITEM_VOLUME IN NUMBER
93                                       ,UNPACKED_ITEM_VOLUME_UOM IN VARCHAR2) RETURN CHAR;
94 
95   FUNCTION CF_FC_COLLECT_CURRENCYFORMULA(FC_COLLECT_CURRENCY IN VARCHAR2) RETURN NUMBER;
96 
97   FUNCTION CP_NUM_PACKAGESFORMULA RETURN NUMBER;
98 
99   FUNCTION CF_NUM_OF_LPN1FORMULA(DELIVERY_ID3 IN NUMBER) RETURN NUMBER;
100 
101   FUNCTION BEFOREREPORT RETURN BOOLEAN;
102 
103   FUNCTION AFTERREPORT RETURN BOOLEAN;
104 
105   FUNCTION LP_WHERE_CLAUSEVALIDTRIGGER RETURN BOOLEAN;
106 
107   FUNCTION CF_DOCK_CODEFORMULA(DELIVERY_ID3 IN NUMBER) RETURN CHAR;
108 
109   FUNCTION CF_CARRIER_NAMEFORMULA(SHIP_METHOD IN VARCHAR2) RETURN CHAR;
110 
111   FUNCTION CF_MBOL_NUMBERFORMULA(TRIP_ID1 IN NUMBER) RETURN CHAR;
112 
113   FUNCTION CF_CUSTOMER_NAMEFORMULA(CUSTOMER_NAME IN VARCHAR2) RETURN CHAR;
114 
115   FUNCTION CF_COMMODITY_CLASSFORMULA(UNPACKED_ITEM_INV_ITEM_ID IN NUMBER
116                                     ,UNPACKED_ITEM_ORGANIZATION_ID IN NUMBER) RETURN CHAR;
117 
118   FUNCTION CF_DETAIL_COMM_CLASSFORMULA(DELIVERY_DETAIL_ID IN NUMBER) RETURN CHAR;
119 
120   FUNCTION CF_SRC_HDR_IDFORMULA RETURN NUMBER;
121 
122   FUNCTION CP_CLASSIFICATION_P RETURN VARCHAR2;
123 
124   FUNCTION CP_NUM_PACKAGES_P RETURN NUMBER;
125 
126   FUNCTION CP_TOP_MODEL_LINE_ID_P RETURN NUMBER;
127 
128   FUNCTION CP_SRC_LINE_ID_P RETURN NUMBER;
129 
130   FUNCTION CP_CONTAINER_CLASSIFICATION_P RETURN VARCHAR2;
131 
132   FUNCTION CP_HM_P RETURN VARCHAR2;
133 
134   FUNCTION CP_TOTAL_PREPAID_AMOUNT_P RETURN NUMBER;
135 
136   FUNCTION CP_TOTAL_PREPAID_CURRENCY_P RETURN VARCHAR2;
137 
138   FUNCTION CP_TOTAL_COLLECT_CURRENCY_P RETURN VARCHAR2;
139 
140 END WSH_WSHRDBOL_XMLP_PKG;
141