1 PACKAGE WSH_WSHRDPAK_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHRDPAKS.pls 120.5 2011/03/15 09:20:03 ashimalh ship $ */
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 --STANDALONE CHANGES
44 P_STANDALONE VARCHAR2(1);
45 FUNCTION AFTERPFORM RETURN BOOLEAN;
46
47 FUNCTION AFTERREPORT RETURN BOOLEAN;
48 FUNCTION BeforeReport RETURN BOOLEAN;
49 FUNCTION CF_ITEM_NUMFORMULA(C_ITEM_FLEX IN VARCHAR2
50 ,C_INV_ITEM_ID IN NUMBER
51 ,C_DEL_ORG_ID IN NUMBER) RETURN VARCHAR2;
52 FUNCTION CF_FREIGHT_CARRIERFORMULA(C_SHIP_METHOD IN VARCHAR2
53 ,C_DEL_ORG_ID IN NUMBER
54 ,C_Q2_DELIVERY_ID IN NUMBER) RETURN VARCHAR2;
55 FUNCTION CF_FREIGHT_TERMSFORMULA(C_FREIGHT_TERMS_CODE IN VARCHAR2) RETURN VARCHAR2;
56 FUNCTION CF_FOBFORMULA(C_FOB_CODE IN VARCHAR2) RETURN VARCHAR2;
57 FUNCTION CF_CUST_ITEM_NUMFORMULA(C_CUSTOMER_ITEM_ID IN NUMBER) RETURN VARCHAR2;
58 FUNCTION CF_FROM_CITY_STATE_ZIPFORMULA(C_FROM_CITY IN VARCHAR2
59 ,C_FROM_POSTAL_CODE IN VARCHAR2
60 ,C_FROM_REGION IN VARCHAR2) RETURN VARCHAR2;
61 FUNCTION CF_TO_CITY_STATE_ZIPFORMULA(C_TO_CITY IN VARCHAR2
62 ,C_TO_POSTAL_CODE IN VARCHAR2
63 ,C_TO_REGION IN VARCHAR2) RETURN VARCHAR2;
64 FUNCTION CF_CUM_QTYFORMULA(C_DEL_CUSTOMER_ID IN NUMBER
65 ,C_CUSTOMER_ID IN NUMBER
66 ,C_SRC_LINE_ID IN NUMBER) RETURN NUMBER;
67 FUNCTION CF_UNSHIPPED_QTYFORMULA(C_SRC_LINE_ID IN NUMBER) RETURN NUMBER;
68 FUNCTION CF_FROM_ADDR_2FORMULA(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_ADDR3FORMULA(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 VARCHAR2;
76 FUNCTION CF_FROM_CITYFORMULA(C_FROM_ADDRESS_2 IN VARCHAR2
77 ,C_FROM_ADDRESS_3 IN VARCHAR2
78 ,CF_FROM_CITY_STATE_ZIP IN VARCHAR2
79 ,C_FROM_COUNTRY IN VARCHAR2) RETURN CHAR;
80 FUNCTION CF_TO_ADDR_2FORMULA(C_TO_ADDRESS_2 IN VARCHAR2
81 ,C_TO_ADDRESS_3 IN VARCHAR2
82 ,C_TO_ADDRESS_4 IN VARCHAR2
83 ,CF_TO_CITY_STATE_ZIP IN VARCHAR2
84 ,C_TO_COUNTRY IN VARCHAR2) RETURN CHAR;
85 FUNCTION CF_TO_ADDR_3FORMULA(C_TO_ADDRESS_2 IN VARCHAR2
86 ,C_TO_ADDRESS_3 IN VARCHAR2
87 ,C_TO_ADDRESS_4 IN VARCHAR2
88 ,CF_TO_CITY_STATE_ZIP IN VARCHAR2
89 ,C_TO_COUNTRY IN VARCHAR2) RETURN CHAR;
90 FUNCTION CF_TO_CITYFORMULA(C_TO_ADDRESS_2 IN VARCHAR2
91 ,C_TO_ADDRESS_3 IN VARCHAR2
92 ,CF_TO_CITY_STATE_ZIP IN VARCHAR2
93 ,C_TO_COUNTRY IN VARCHAR2
94 ,C_TO_ADDRESS_4 IN VARCHAR2) RETURN CHAR;
95 FUNCTION CF_BILL_ADDR_2FORMULA(CF_BILL_CITY_STATE_ZIP IN VARCHAR2) RETURN CHAR;
96 FUNCTION CF_BILL_ADDR_3FORMULA(CF_BILL_CITY_STATE_ZIP IN VARCHAR2) RETURN CHAR;
97 FUNCTION CF_BILL_CITYFORMULA(CF_BILL_CITY_STATE_ZIP IN VARCHAR2) RETURN CHAR;
98 FUNCTION CF_UNSHIP_ITEM_NAMEFORMULA(BO_INVENTORY_ITEM_ID IN NUMBER
99 ,BO_ORGANIZATION_ID IN NUMBER) RETURN CHAR;
100 FUNCTION CF_NUM_OF_LPNSFORMULA(C_Q1_DELIVERY_ID IN NUMBER
101 ,NUM_LPN IN NUMBER) RETURN NUMBER;
102 FUNCTION CF_BILL_TO_LOC1FORMULA(CF_OE_LINE_ID IN NUMBER
103 ,F_OE_LINE_ID IN NUMBER) RETURN NUMBER;
104 FUNCTION CF_OE_LINE_ID1FORMULA RETURN NUMBER;
105 FUNCTION CF_BILL_TO_CONTACT1FORMULA RETURN CHAR;
106 FUNCTION CF_SHIP_TO_CONTACT1FORMULA RETURN CHAR;
107 FUNCTION F_BILL_TO_CUST_NAME1FORMULA(F_OE_LINE_ID IN NUMBER) RETURN CHAR;
108 FUNCTION CF_LINE_TAX_CODE1FORMULA(F_OE_LINE_ID IN NUMBER) RETURN CHAR;
109 --RTV changes
110 FUNCTION F_SHIP_TO_CUST_NAME1FORMULA(F_DEL_DETAIL_ID IN NUMBER) RETURN CHAR;
111 FUNCTION F_SHIP_TO_SITE_USE_ID1FORMULA(F_DEL_DETAIL_ID IN NUMBER) RETURN NUMBER;
112 FUNCTION F_BILL_TO_LOC_ID1FORMULA(F_OE_LINE_ID IN NUMBER) RETURN NUMBER;
113 FUNCTION F_OE_LINE_ID1FORMULA RETURN NUMBER;
114 FUNCTION F_DEL_DETAIL_ID1FORMULA RETURN NUMBER;
115 FUNCTION CF_TO_ADDR_4FORMULA(CF_TO_CITY_STATE_ZIP IN VARCHAR2
116 ,C_TO_COUNTRY IN VARCHAR2
117 ,C_TO_ADDRESS_2 IN VARCHAR2
118 ,C_TO_ADDRESS_3 IN VARCHAR2
119 ,C_TO_ADDRESS_4 IN VARCHAR2) RETURN CHAR;
120 FUNCTION CF_BILL_ADDR_4FORMULA(CF_BILL_CITY_STATE_ZIP IN VARCHAR2) RETURN CHAR;
121 FUNCTION CF_REQUESTOR_NAMEFORMULA(ATTACH_LINE_ID IN NUMBER) RETURN CHAR;
122 FUNCTION CF_ITEM_DESCRIPTIONFORMULA(C_ITEM_DESCRIPTION IN VARCHAR2
123 ,C_INV_ITEM_ID IN NUMBER
124 ,C_ORGANIZATION_ID IN NUMBER) RETURN CHAR;
125 FUNCTION CF_ITEM_DISPLAYFORMULA RETURN CHAR;
126 FUNCTION CF_DISPLAY_UNSHIPPEDFORMULA RETURN CHAR;
127 FUNCTION CF_PRINT_CUST_ITEMFORMULA RETURN CHAR;
128 FUNCTION CF_CARRIER_ADDRFORMULA(WND_CARRIER_ID IN NUMBER
129 ,C_DEL_ORG_ID IN NUMBER
130 ,C_Q2_DELIVERY_ID IN NUMBER) RETURN CHAR;
131 FUNCTION CF_CARRIER_ADDRESS1FORMULA(TRIP_CARRIER_ID IN NUMBER
132 ,C_TRIP_DELIVERY_ID IN NUMBER) RETURN CHAR;
133 FUNCTION CF_VAT_REG_NUMFORMULA(C_Q2_DELIVERY_ID IN NUMBER
134 ,C_DEL_ORG_ID IN NUMBER) RETURN VARCHAR2;
135 FUNCTION CP_INTERNAL_SALES_ORDER_P RETURN VARCHAR2;
136 FUNCTION CP_WAREHOUSE_NAME_P RETURN VARCHAR2;
137 FUNCTION CP_DRAFT_OR_FINAL_P RETURN VARCHAR2;
138 FUNCTION CP_PRINT_DATE_P RETURN DATE;
139 FUNCTION CP_RLM_PRINT_CUM_DATA_P RETURN VARCHAR2;
140 FUNCTION CP_SOURCE_CODE_P RETURN VARCHAR2;
141 FUNCTION CP_BILL_TO_CONTACT_ID_P RETURN NUMBER;
142 FUNCTION CP_SHIP_TO_CONTACT_ID_P RETURN NUMBER;
143 FUNCTION CP_BILL_ADDRESS_LINE_1_P RETURN VARCHAR2;
144 FUNCTION CP_BILL_ADDRESS_LINE_2_P RETURN VARCHAR2;
145 FUNCTION CP_BILL_ADDRESS_LINE_3_P RETURN VARCHAR2;
146 FUNCTION CP_BILL_TOWN_OR_CITY_P RETURN VARCHAR2;
147 FUNCTION CP_BILL_REGION_P RETURN VARCHAR2;
148 FUNCTION CP_BILL_POSTAL_CODE_P RETURN VARCHAR2;
149 FUNCTION CP_BILL_COUNTRY_P RETURN VARCHAR2;
150 FUNCTION CP_BILL_ADDRESS_LINE_4_P RETURN VARCHAR2;
151 FUNCTION Address_New( cf_bill_to_loc in number) RETURN VARCHAR2;
152 FUNCTION CF_BILL_CITY_STATE_ZIPFORMULA( CP_BILL_TOWN_OR_CITY in varchar2,CP_BILL_REGION in varchar2,
153 CP_BILL_POSTAL_CODE in varchar2 ) RETURN VARCHAR2 ;
154 END WSH_WSHRDPAK_XMLP_PKG;
155