eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.WSH_WSHRDINV_XMLP_PKG

Source


1 PACKAGE WSH_WSHRDINV_XMLP_PKG AS
2 /* $Header: WSHRDINVS.pls 120.3 2008/02/18 06:26:25 dwkrishn noship $ */
3   P_DELIVERY_ID NUMBER;
4 
5   P_TRIP_STOP_ID NUMBER;
6 
7   P_DEPARTURE_DATE_HIGH DATE;
8   LP_DEPARTURE_DATE_HIGH DATE;
9 
10   P_DEPARTURE_DATE_LOW DATE;
11 
12   P_FREIGHT_CODE VARCHAR2(30);
13 
14   P_ITEM_DISPLAY VARCHAR2(1);
15 
16   P_ITEM_FLEX_CODE VARCHAR2(32767);
17 
18   LP_STRUCTURE_NUM VARCHAR2(128);
19 
20   P_ORGANIZATION_ID NUMBER;
21 
22   H_REPORT_ID NUMBER;
23 
24   H_WAREHOUSE_NAME VARCHAR2(240);
25 
26   RP_DATA_FOUND NUMBER;
27 
28   P_PRINT_CUST_ITEM VARCHAR2(1);
29 
30   H_EIN VARCHAR2(150);
31 
32   LP_TRIP_STOP_ID VARCHAR2(250) := ' ';
33 
34   LP_DELIVERY_ID VARCHAR2(128) := ' ';
35 
36   LP_DEPARTURE_DATE VARCHAR2(250) := ' ';
37 
38   P_CURRENCY_CODE VARCHAR2(15);
39 
40   LP_FREIGHT_CODE VARCHAR2(128) := ' ';
41 
42   LP_ORGANIZATION_ID VARCHAR2(128) := ' ';
43 
44   P_ITEM_COST NUMBER;
45 
46   P_EXTENDED_COST NUMBER;
47 
48   P_EXPORT_TXT VARCHAR2(300);
49 
50   P_MODULE_NAME VARCHAR2(32767);
51 
52   P_HEADER_NAME VARCHAR2(32767);
53 
54   P_LINE_NAME VARCHAR2(32767);
55 
56   P_CONC_REQUEST_ID NUMBER := 0;
57 
58   C_DELIVERY_DETAIL_ID VARCHAR2(40);
59 
60   CP_SHIP_TO_ADDR1 VARCHAR2(240);
61 
62   CP_SHIP_TO_ADDR2 VARCHAR2(240);
63 
64   CP_SHIP_TO_ADDR3 VARCHAR2(240);
65 
66   CP_SHIP_TO_ADDR4 VARCHAR2(240);
67 
68   CP_SHIP_TO_CITY_STATE VARCHAR2(185);
69 
70   CP_SHIP_TO_COUNTRY VARCHAR2(120);
71 
72   CP_ITEM_COST NUMBER;
73 
74   CP_EXTENDED_COST NUMBER;
75 
76   FUNCTION AFTERPFORM RETURN BOOLEAN;
77 
78   FUNCTION AFTERREPORT RETURN BOOLEAN;
79 
80   FUNCTION C_ITEM_DISPFORMULA(CUSTOMER_ITEM_ID1 IN NUMBER
81                              ,INVENTORY_ITEM_ID1 IN NUMBER
82                              ,ORGANIZATION_ID1 IN NUMBER
83                              ,ITEM_DESCRIPTION IN VARCHAR2) RETURN VARCHAR2;
84 
85   FUNCTION C_NUM_BOXESFORMULA(DELIVERY_ID3 IN NUMBER
86                              ,NUM_LPN IN NUMBER) RETURN NUMBER;
87 
88   FUNCTION C_DATA_FOUNDFORMULA(DELIVERY_ID3 IN NUMBER) RETURN NUMBER;
89 
90   FUNCTION LP_STOP_IDVALIDTRIGGER RETURN BOOLEAN;
91 
92   FUNCTION C_SHIP_VIAFORMULA(DELIVERY_ID3 IN NUMBER
93                             ,SHIP_VIA IN VARCHAR2
94                             ,ORGANIZATION_ID1 IN NUMBER) RETURN CHAR;
95 
96   FUNCTION H_WAREHOUSE_NAMEVALIDTRIGGER RETURN BOOLEAN;
97 
98   FUNCTION BEFOREPFORM RETURN BOOLEAN;
99 
100   FUNCTION F_SHIP_TO_CUST_NAMEFORMULA(SHIP_TO_SITE_USE_ID IN NUMBER) RETURN CHAR;
101 
102   FUNCTION CF_CONTACT_NAMEFORMULA(SHIP_TO_CONTACT_ID IN NUMBER) RETURN CHAR;
103 
104   FUNCTION CF_CUSTOMER_NAMEFORMULA RETURN CHAR;
105 
106   FUNCTION BEFOREREPORT RETURN BOOLEAN;
107 
108   FUNCTION BEFOREREPORT0008 RETURN BOOLEAN;
109 
110   FUNCTION CF_1FORMULA RETURN CHAR;
111 
112   FUNCTION CF_EINFORMULA0007 RETURN CHAR;
113 
114   FUNCTION CF_COMMODITY_CLASSFORMULA(INVENTORY_ITEM_ID1 IN NUMBER
115                                     ,ORGANIZATION_ID1 IN NUMBER) RETURN CHAR;
116 
117   FUNCTION CP_SHIP_TO_ADDR1_P RETURN VARCHAR2;
118 
119   FUNCTION CP_SHIP_TO_ADDR2_P RETURN VARCHAR2;
120 
121   FUNCTION CP_SHIP_TO_ADDR3_P RETURN VARCHAR2;
122 
123   FUNCTION CP_SHIP_TO_ADDR4_P RETURN VARCHAR2;
124 
125   FUNCTION CP_SHIP_TO_CITY_STATE_P RETURN VARCHAR2;
126 
127   FUNCTION CP_SHIP_TO_COUNTRY_P RETURN VARCHAR2;
128 
129   FUNCTION CP_ITEM_COST_P RETURN NUMBER;
130 
131   FUNCTION CP_EXTENDED_COST_P RETURN NUMBER;
132 
133   PROCEDURE PUT(NAME IN VARCHAR2
134                ,VAL IN VARCHAR2);
135 
136   FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
137 
138   PROCEDURE GET(NAME IN VARCHAR2
139                ,VAL OUT NOCOPY VARCHAR2);
140 
141   FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
142 
143   FUNCTION SAVE_USER(X_NAME IN VARCHAR2
144                     ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
145 
146   FUNCTION SAVE(X_NAME IN VARCHAR2
147                ,X_VALUE IN VARCHAR2
148                ,X_LEVEL_NAME IN VARCHAR2
149                ,X_LEVEL_VALUE IN VARCHAR2
150                ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
151 
152   PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
153                         ,USER_ID_Z IN NUMBER
154                         ,RESPONSIBILITY_ID_Z IN NUMBER
155                         ,APPLICATION_ID_Z IN NUMBER
156                         ,VAL_Z OUT NOCOPY VARCHAR2
157                         ,DEFINED_Z OUT NOCOPY BOOLEAN);
158 
159   FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
160                          ,USER_ID IN NUMBER
161                          ,RESPONSIBILITY_ID IN NUMBER
162                          ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
163 
164   PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
165                       ,RESPONSIBILITY_ID_Z IN NUMBER
166                       ,APPLICATION_ID_Z IN NUMBER
167                       ,SITE_ID_Z IN NUMBER);
168 
169   PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
170                        ,VALS IN VARCHAR2
171                        ,NUM IN NUMBER);
172 
173  function C_ext_cost_fmtFormula(source_code varchar2, line_id number, unit_of_measure varchar2,
174 source_uom varchar2, shipped_quantity number, inventory_item_id1 number) return VARCHAR2;
175 
176  function C_item_cost_fmtFormula(source_code varchar2, line_id number, unit_of_measure varchar2,
177 source_uom varchar2, inventory_item_id1 number) return VARCHAR2;
178 
179 END WSH_WSHRDINV_XMLP_PKG;
180