1 PACKAGE WSH_WSHRDPAK_XMLP_PKG AS
2 /* $Header: WSHRDPAKS.pls 120.2 2008/02/18 10:42:50 dwkrishn noship $ */
3 P_CONC_REQUEST_ID NUMBER;
4 P_DELIVERY_ID NUMBER;
5 P_DELIVERY_DATE_HIGH DATE;
6 P_DELIVERY_DATE_LOW DATE;
7 P_PRINT_CUST_ITEM VARCHAR2(1);
8 P_ITEM_DISPLAY VARCHAR2(1);
9 P_PRINT_MODE VARCHAR2(30);
10 P_SORT VARCHAR2(30);
11 P_FREIGHT_CODE VARCHAR2(30);
12 P_ORGANIZATION_ID NUMBER;
13 P_ITEM_FLEX VARCHAR2(999):=' ';
14 P_QUANTITY_PRECISION NUMBER;
15 P_ORDER_BY VARCHAR2(999);
16 P_DISPLAY_UNSHIPPED VARCHAR2(1);
17 P_ORGANIZATIONID VARCHAR2(40);
18 P_ORGANIZATIONID_1 VARCHAR2(40):=' ';
19 P_ENTITY_NAME_WND VARCHAR2(32767);
20 P_DOC_TYPE VARCHAR2(32767);
21 P_FUNC_NAME VARCHAR2(32767);
22 P_ENTITY_NAME_WDD VARCHAR2(32767);
23 P_ENTITY_NAME_OEH VARCHAR2(32767);
24 P_ENTITY_NAME_OED VARCHAR2(32767);
25 P_CUSTOMER_ITEM_NUMBER VARCHAR2(50):=' ';
26 P_TAX_VAT_FLAG NUMBER;
27 CP_INTERNAL_SALES_ORDER VARCHAR2(40);
28 CP_WAREHOUSE_NAME VARCHAR2(240);
29 CP_DRAFT_OR_FINAL VARCHAR2(80);
30 CP_PRINT_DATE DATE;
31 CP_RLM_PRINT_CUM_DATA VARCHAR2(3) := 'N';
32 CP_SOURCE_CODE VARCHAR2(30);
33 CP_BILL_TO_CONTACT_ID NUMBER;
34 CP_SHIP_TO_CONTACT_ID NUMBER;
35 CP_BILL_ADDRESS_LINE_1 VARCHAR2(240);
36 CP_BILL_ADDRESS_LINE_2 VARCHAR2(240);
37 CP_BILL_ADDRESS_LINE_3 VARCHAR2(240);
38 CP_BILL_TOWN_OR_CITY VARCHAR2(60);
39 CP_BILL_REGION VARCHAR2(120);
40 CP_BILL_POSTAL_CODE VARCHAR2(60);
41 CP_BILL_COUNTRY VARCHAR2(80);
42 CP_BILL_ADDRESS_LINE_4 VARCHAR2(240);
43 FUNCTION AFTERREPORT RETURN BOOLEAN;
44 FUNCTION BeforeReport RETURN BOOLEAN;
45 FUNCTION CF_ITEM_NUMFORMULA(C_ITEM_FLEX IN VARCHAR2
46 ,C_INV_ITEM_ID IN NUMBER
47 ,C_DEL_ORG_ID IN NUMBER) RETURN VARCHAR2;
48 FUNCTION CF_FREIGHT_CARRIERFORMULA(C_SHIP_METHOD IN VARCHAR2
49 ,C_DEL_ORG_ID IN NUMBER
50 ,C_Q2_DELIVERY_ID IN NUMBER) RETURN VARCHAR2;
51 FUNCTION CF_FREIGHT_TERMSFORMULA(C_FREIGHT_TERMS_CODE IN VARCHAR2) RETURN VARCHAR2;
52 FUNCTION CF_FOBFORMULA(C_FOB_CODE IN VARCHAR2) RETURN VARCHAR2;
53 FUNCTION CF_CUST_ITEM_NUMFORMULA(C_CUSTOMER_ITEM_ID IN NUMBER) RETURN VARCHAR2;
54 FUNCTION CF_FROM_CITY_STATE_ZIPFORMULA(C_FROM_CITY IN VARCHAR2
55 ,C_FROM_POSTAL_CODE IN VARCHAR2
56 ,C_FROM_REGION IN VARCHAR2) RETURN VARCHAR2;
57 FUNCTION CF_TO_CITY_STATE_ZIPFORMULA(C_TO_CITY IN VARCHAR2
58 ,C_TO_POSTAL_CODE IN VARCHAR2
59 ,C_TO_REGION IN VARCHAR2) RETURN VARCHAR2;
60 FUNCTION CF_CUM_QTYFORMULA(C_DEL_CUSTOMER_ID IN NUMBER
61 ,C_CUSTOMER_ID IN NUMBER
62 ,C_SRC_LINE_ID IN NUMBER) RETURN NUMBER;
63 FUNCTION CF_UNSHIPPED_QTYFORMULA(C_SRC_LINE_ID IN NUMBER) RETURN NUMBER;
64 FUNCTION CF_FROM_ADDR_2FORMULA(C_FROM_ADDRESS_2 IN VARCHAR2
65 ,C_FROM_ADDRESS_3 IN VARCHAR2
66 ,CF_FROM_CITY_STATE_ZIP IN VARCHAR2
67 ,C_FROM_COUNTRY IN VARCHAR2) RETURN VARCHAR2;
68 FUNCTION CF_FROM_ADDR3FORMULA(C_FROM_ADDRESS_2 IN VARCHAR2
69 ,C_FROM_ADDRESS_3 IN VARCHAR2
70 ,CF_FROM_CITY_STATE_ZIP IN VARCHAR2
71 ,C_FROM_COUNTRY IN VARCHAR2) RETURN VARCHAR2;
72 FUNCTION CF_FROM_CITYFORMULA(C_FROM_ADDRESS_2 IN VARCHAR2
73 ,C_FROM_ADDRESS_3 IN VARCHAR2
74 ,CF_FROM_CITY_STATE_ZIP IN VARCHAR2
75 ,C_FROM_COUNTRY IN VARCHAR2) RETURN CHAR;
76 FUNCTION CF_TO_ADDR_2FORMULA(C_TO_ADDRESS_2 IN VARCHAR2
77 ,C_TO_ADDRESS_3 IN VARCHAR2
78 ,C_TO_ADDRESS_4 IN VARCHAR2
79 ,CF_TO_CITY_STATE_ZIP IN VARCHAR2
80 ,C_TO_COUNTRY IN VARCHAR2) RETURN CHAR;
81 FUNCTION CF_TO_ADDR_3FORMULA(C_TO_ADDRESS_2 IN VARCHAR2
82 ,C_TO_ADDRESS_3 IN VARCHAR2
83 ,C_TO_ADDRESS_4 IN VARCHAR2
84 ,CF_TO_CITY_STATE_ZIP IN VARCHAR2
85 ,C_TO_COUNTRY IN VARCHAR2) RETURN CHAR;
86 FUNCTION CF_TO_CITYFORMULA(C_TO_ADDRESS_2 IN VARCHAR2
87 ,C_TO_ADDRESS_3 IN VARCHAR2
88 ,CF_TO_CITY_STATE_ZIP IN VARCHAR2
89 ,C_TO_COUNTRY IN VARCHAR2
90 ,C_TO_ADDRESS_4 IN VARCHAR2) RETURN CHAR;
91 FUNCTION CF_BILL_ADDR_2FORMULA(CF_BILL_CITY_STATE_ZIP IN VARCHAR2) RETURN CHAR;
92 FUNCTION CF_BILL_ADDR_3FORMULA(CF_BILL_CITY_STATE_ZIP IN VARCHAR2) RETURN CHAR;
93 FUNCTION CF_BILL_CITYFORMULA(CF_BILL_CITY_STATE_ZIP IN VARCHAR2) RETURN CHAR;
94 FUNCTION CF_UNSHIP_ITEM_NAMEFORMULA(BO_INVENTORY_ITEM_ID IN NUMBER
95 ,BO_ORGANIZATION_ID IN NUMBER) RETURN CHAR;
96 FUNCTION CF_NUM_OF_LPNSFORMULA(C_Q1_DELIVERY_ID IN NUMBER
97 ,NUM_LPN IN NUMBER) RETURN NUMBER;
98 FUNCTION CF_BILL_TO_LOC1FORMULA(CF_OE_LINE_ID IN NUMBER
99 ,F_OE_LINE_ID IN NUMBER) RETURN NUMBER;
100 FUNCTION CF_OE_LINE_ID1FORMULA RETURN NUMBER;
101 FUNCTION CF_BILL_TO_CONTACT1FORMULA RETURN CHAR;
102 FUNCTION CF_SHIP_TO_CONTACT1FORMULA RETURN CHAR;
103 FUNCTION F_BILL_TO_CUST_NAME1FORMULA(F_OE_LINE_ID IN NUMBER) RETURN CHAR;
104 FUNCTION CF_LINE_TAX_CODE1FORMULA(F_OE_LINE_ID IN NUMBER) RETURN CHAR;
105 FUNCTION F_SHIP_TO_CUST_NAME1FORMULA(F_SHIP_TO_SITE_USE_ID IN NUMBER) RETURN CHAR;
106 FUNCTION F_SHIP_TO_SITE_USE_ID1FORMULA(F_DEL_DETAIL_ID IN NUMBER) RETURN NUMBER;
107 FUNCTION F_BILL_TO_LOC_ID1FORMULA(F_OE_LINE_ID IN NUMBER) RETURN NUMBER;
108 FUNCTION F_OE_LINE_ID1FORMULA RETURN NUMBER;
109 FUNCTION F_DEL_DETAIL_ID1FORMULA RETURN NUMBER;
110 FUNCTION CF_TO_ADDR_4FORMULA(CF_TO_CITY_STATE_ZIP IN VARCHAR2
111 ,C_TO_COUNTRY IN VARCHAR2
112 ,C_TO_ADDRESS_2 IN VARCHAR2
113 ,C_TO_ADDRESS_3 IN VARCHAR2
114 ,C_TO_ADDRESS_4 IN VARCHAR2) RETURN CHAR;
115 FUNCTION CF_BILL_ADDR_4FORMULA(CF_BILL_CITY_STATE_ZIP IN VARCHAR2) RETURN CHAR;
116 FUNCTION CF_REQUESTOR_NAMEFORMULA(ATTACH_ORDER_ID IN NUMBER) RETURN CHAR;
117 FUNCTION CF_ITEM_DESCRIPTIONFORMULA(C_ITEM_DESCRIPTION IN VARCHAR2
118 ,C_INV_ITEM_ID IN NUMBER
119 ,C_ORGANIZATION_ID IN NUMBER) RETURN CHAR;
120 FUNCTION CF_ITEM_DISPLAYFORMULA RETURN CHAR;
121 FUNCTION CF_DISPLAY_UNSHIPPEDFORMULA RETURN CHAR;
122 FUNCTION CF_PRINT_CUST_ITEMFORMULA RETURN CHAR;
123 FUNCTION CF_CARRIER_ADDRFORMULA(WND_CARRIER_ID IN NUMBER
124 ,C_DEL_ORG_ID IN NUMBER
125 ,C_Q2_DELIVERY_ID IN NUMBER) RETURN CHAR;
126 FUNCTION CF_CARRIER_ADDRESS1FORMULA(TRIP_CARRIER_ID IN NUMBER
127 ,C_TRIP_DELIVERY_ID IN NUMBER) RETURN CHAR;
128 FUNCTION CF_VAT_REG_NUMFORMULA(C_Q2_DELIVERY_ID IN NUMBER
129 ,C_DEL_ORG_ID IN NUMBER) RETURN VARCHAR2;
130 FUNCTION CP_INTERNAL_SALES_ORDER_P RETURN VARCHAR2;
131 FUNCTION CP_WAREHOUSE_NAME_P RETURN VARCHAR2;
132 FUNCTION CP_DRAFT_OR_FINAL_P RETURN VARCHAR2;
133 FUNCTION CP_PRINT_DATE_P RETURN DATE;
134 FUNCTION CP_RLM_PRINT_CUM_DATA_P RETURN VARCHAR2;
135 FUNCTION CP_SOURCE_CODE_P RETURN VARCHAR2;
136 FUNCTION CP_BILL_TO_CONTACT_ID_P RETURN NUMBER;
137 FUNCTION CP_SHIP_TO_CONTACT_ID_P RETURN NUMBER;
138 FUNCTION CP_BILL_ADDRESS_LINE_1_P RETURN VARCHAR2;
139 FUNCTION CP_BILL_ADDRESS_LINE_2_P RETURN VARCHAR2;
140 FUNCTION CP_BILL_ADDRESS_LINE_3_P RETURN VARCHAR2;
141 FUNCTION CP_BILL_TOWN_OR_CITY_P RETURN VARCHAR2;
142 FUNCTION CP_BILL_REGION_P RETURN VARCHAR2;
143 FUNCTION CP_BILL_POSTAL_CODE_P RETURN VARCHAR2;
144 FUNCTION CP_BILL_COUNTRY_P RETURN VARCHAR2;
145 FUNCTION CP_BILL_ADDRESS_LINE_4_P RETURN VARCHAR2;
146 FUNCTION Address_New( cf_bill_to_loc in number) RETURN VARCHAR2;
147 FUNCTION CF_BILL_CITY_STATE_ZIPFORMULA( CP_BILL_TOWN_OR_CITY in varchar2,CP_BILL_POSTAL_CODE in varchar2,
148 CP_BILL_REGION in varchar2 ) RETURN VARCHAR2 ;
149 END WSH_WSHRDPAK_XMLP_PKG;
150