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 AUTHID CURRENT_USER AS
2 /* $Header: WSHRDINVS.pls 120.8 2010/09/20 13:56:51 anvarshn ship $ */
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   P_STANDALONE VARCHAR2(1);  --STANDALONE CHANGES
77   FUNCTION AFTERPFORM RETURN BOOLEAN;
78 
79   FUNCTION AFTERREPORT RETURN BOOLEAN;
80 
81   FUNCTION C_ITEM_DISPFORMULA(CUSTOMER_ITEM_ID1 IN NUMBER
82                              ,INVENTORY_ITEM_ID1 IN NUMBER
83                              ,ORGANIZATION_ID1 IN NUMBER
84                              ,ITEM_DESCRIPTION IN VARCHAR2) RETURN VARCHAR2;
85 
86   FUNCTION C_NUM_BOXESFORMULA(DELIVERY_ID3 IN NUMBER
87                              ,NUM_LPN IN NUMBER) RETURN NUMBER;
88 
89   FUNCTION C_DATA_FOUNDFORMULA(DELIVERY_ID3 IN NUMBER) RETURN NUMBER;
90 
91   FUNCTION LP_STOP_IDVALIDTRIGGER RETURN BOOLEAN;
92 
93   FUNCTION C_SHIP_VIAFORMULA(DELIVERY_ID3 IN NUMBER
94                             ,SHIP_VIA IN VARCHAR2
95                             ,ORGANIZATION_ID1 IN NUMBER) RETURN CHAR;
96 
97   FUNCTION H_WAREHOUSE_NAMEVALIDTRIGGER RETURN BOOLEAN;
98 
99   FUNCTION BEFOREPFORM RETURN BOOLEAN;
100 
101   FUNCTION F_SHIP_TO_CUST_NAMEFORMULA(SHIP_TO_SITE_USE_ID IN NUMBER,CONSIGNEE_FLAG IN VARCHAR2) RETURN CHAR;
102 
103   FUNCTION CF_CONTACT_NAMEFORMULA(SHIP_TO_CONTACT_ID IN NUMBER) RETURN CHAR;
104 
105   FUNCTION CF_CUSTOMER_NAMEFORMULA RETURN CHAR;
106 
107   FUNCTION BEFOREREPORT RETURN BOOLEAN;
108 
109   FUNCTION BEFOREREPORT0008 RETURN BOOLEAN;
110 
111   FUNCTION CF_1FORMULA RETURN CHAR;
112 
113   FUNCTION CF_EINFORMULA0007 RETURN CHAR;
114 
115   FUNCTION CF_COMMODITY_CLASSFORMULA(INVENTORY_ITEM_ID1 IN NUMBER
116                                     ,ORGANIZATION_ID1 IN NUMBER) RETURN CHAR;
117 
118   FUNCTION CP_SHIP_TO_ADDR1_P RETURN VARCHAR2;
119 
120   FUNCTION CP_SHIP_TO_ADDR2_P RETURN VARCHAR2;
121 
122   FUNCTION CP_SHIP_TO_ADDR3_P RETURN VARCHAR2;
123 
124   FUNCTION CP_SHIP_TO_ADDR4_P RETURN VARCHAR2;
125 
126   FUNCTION CP_SHIP_TO_CITY_STATE_P RETURN VARCHAR2;
127 
128   FUNCTION CP_SHIP_TO_COUNTRY_P RETURN VARCHAR2;
129 
130   FUNCTION CP_ITEM_COST_P RETURN NUMBER;
131 
132   FUNCTION CP_EXTENDED_COST_P RETURN NUMBER;
133 
134   PROCEDURE PUT(NAME IN VARCHAR2
135                ,VAL IN VARCHAR2);
136 
137   FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
138 
139   PROCEDURE GET(NAME IN VARCHAR2
140                ,VAL OUT NOCOPY VARCHAR2);
141 
142   FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
143 
144   FUNCTION SAVE_USER(X_NAME IN VARCHAR2
145                     ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
146 
147   FUNCTION SAVE(X_NAME IN VARCHAR2
148                ,X_VALUE IN VARCHAR2
149                ,X_LEVEL_NAME IN VARCHAR2
150                ,X_LEVEL_VALUE IN VARCHAR2
151                ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
152 
153   PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
154                         ,USER_ID_Z IN NUMBER
155                         ,RESPONSIBILITY_ID_Z IN NUMBER
156                         ,APPLICATION_ID_Z IN NUMBER
157                         ,VAL_Z OUT NOCOPY VARCHAR2
158                         ,DEFINED_Z OUT NOCOPY BOOLEAN);
159 
160   FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
161                          ,USER_ID IN NUMBER
162                          ,RESPONSIBILITY_ID IN NUMBER
163                          ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
164 
165   PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
166                       ,RESPONSIBILITY_ID_Z IN NUMBER
167                       ,APPLICATION_ID_Z IN NUMBER
168                       ,SITE_ID_Z IN NUMBER);
169 
170   PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
171                        ,VALS IN VARCHAR2
172                        ,NUM IN NUMBER);
173 
174  function C_ext_cost_fmtFormula(p_source_code varchar2, p_source_line_id number, unit_of_measure varchar2,
175 source_uom varchar2, shipped_quantity number, inventory_item_id1 number) return VARCHAR2; -- Bug 9166141  line_id changed to source_line_id
176 
177  function C_item_cost_fmtFormula(p_source_code varchar2, p_source_line_id number, unit_of_measure varchar2,
178 source_uom varchar2, inventory_item_id1 number) return VARCHAR2; -- Bug 9166141  line_id changed to source_line_id
179 
180 END WSH_WSHRDINV_XMLP_PKG;
181