1 PACKAGE WSH_WSHRDMBL_XMLP_PKG AS
2 /* $Header: WSHRDMBLS.pls 120.2 2007/12/25 07:24:40 nchinnam noship $ */
3 P_TRIP_ID NUMBER;
4
5 P_PRINT_BOLS VARCHAR2(32767);
6
7 P_CONC_REQUEST_ID NUMBER := 0;
8
9 FUNCTION CF_SHIPPER_NAMEFORMULA(STOP_ID IN NUMBER) RETURN CHAR;
10
11 FUNCTION CF_ADDRESS_TRIPS_STOPSFORMULA(ADDRESS1 IN VARCHAR2
12 ,ADDRESS2 IN VARCHAR2
13 ,ADDRESS3 IN VARCHAR2
14 ,ADDRESS4 IN VARCHAR2) RETURN CHAR;
15
16 FUNCTION CF_ADDRESS_DELIVERIES_PICKEDUP(ADDRESS1_DP IN VARCHAR2
17 ,ADDRESS2_DP IN VARCHAR2
18 ,ADDRESS3_DP IN VARCHAR2
19 ,ADDRESS4_DP IN VARCHAR2) RETURN CHAR;
20
21 FUNCTION AFTERREPORT RETURN BOOLEAN;
22
23 FUNCTION CF_NO_DATA_FOUNDFORMULA RETURN CHAR;
24
25 FUNCTION BEFOREREPORT RETURN BOOLEAN;
26
27 FUNCTION CF_ITEM_DESCRIPTION_IPFORMULA(ITEM_DESCRIPTION_IP IN VARCHAR2
28 ,INVENTORY_ITEM_ID_IP IN NUMBER
29 ,ORGANIZATION_ID_IP IN NUMBER) RETURN CHAR;
30
31 FUNCTION CF_ITEM_DESCRIPTION_DFORMULA(ITEM_DESCRIPTION_D IN VARCHAR2
32 ,INVENTORY_ITEM_ID_D IN NUMBER
33 ,ORGANIZATION_ID_D IN NUMBER) RETURN CHAR;
34
35 FUNCTION CF_MODE_MEANFORMULA(MODE_OF_TRANSPORT IN VARCHAR2) RETURN CHAR;
36
37 FUNCTION CF_SERVICE_LEVELFORMULA(SERVICE_LEVEL IN VARCHAR2) RETURN CHAR;
38
39 FUNCTION CF_TRIP_STATUSFORMULA(TRIP_STATUS IN VARCHAR2) RETURN CHAR;
40
41 FUNCTION CF_STOP_STATUSFORMULA(STOP_STATUS IN VARCHAR2) RETURN CHAR;
42
43 FUNCTION CF_WEIGHT_UOMFORMULA(WEIGHT_UOM IN VARCHAR2) RETURN CHAR;
44
45 FUNCTION CF_VOLUME_UOMFORMULA(VOLUME_UOM IN VARCHAR2) RETURN CHAR;
46
47 FUNCTION CF_DELIVERY_STATUS_DPFORMULA(DELIVERY_STATUS_DP IN VARCHAR2) RETURN CHAR;
48
49 FUNCTION CF_WEIGHT_UOM_DPFORMULA(WEIGHT_UOM_DP IN VARCHAR2) RETURN CHAR;
50
51 FUNCTION CF_VOLUME_UOM_DPFORMULA(VOLUME_UOM_DP IN VARCHAR2) RETURN CHAR;
52
53 FUNCTION CF_VOLUME_UOM_DDFORMULA(VOLUME_UOM_DD IN VARCHAR2) RETURN CHAR;
54
55 FUNCTION CF_WEIGHT_UOM_DDFORMULA(WEIGHT_UOM_DD IN VARCHAR2) RETURN CHAR;
56
57 FUNCTION CF_DELIVERY_STATUS_DDFORMULA(DELIVERY_STATUS_DD IN VARCHAR2) RETURN CHAR;
58
59 FUNCTION CF_COMMODITY_CLASS_PICKEDFORMU(INVENTORY_ITEM_ID_IP IN NUMBER
60 ,ORGANIZATION_ID_IP IN NUMBER) RETURN CHAR;
61
62 FUNCTION CF_COMMODITY_CLASS_DROPPEDFORM(INVENTORY_ITEM_ID_D IN NUMBER
63 ,ORGANIZATION_ID_D IN NUMBER) RETURN CHAR;
64
65 FUNCTION CF_PARENT_DEL_NAME_DPFORMULA(DELIVERY_LEG_ID_DP IN NUMBER) RETURN CHAR;
66
67 FUNCTION CF_PARENT_DEL_NAME_DDFORMULA(DELIVERY_LEG_ID_DD IN NUMBER) RETURN CHAR;
68
69 FUNCTION CF_FREIGHT_TERMS_DPFORMULA(FREIGHT_TERMS_CODE IN VARCHAR2) RETURN CHAR;
70
71 FUNCTION CF_FREIGHT_TERMS_DDFORMULA(FREIGHT_TERMS_DD1 IN VARCHAR2) RETURN CHAR;
72
73 END WSH_WSHRDMBL_XMLP_PKG;
74