1 PACKAGE JA_JAINPRPOL_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAINPRPOLS.pls 120.1 2007/12/25 16:25:21 dwkrishn noship $ */
3 P_REPORT_TYPE VARCHAR2(40);
4
5 P_AGENT_ID VARCHAR2(40);
6
7 P_PO_NUM_FROM VARCHAR2(40);
8
9 P_PO_NUM_TO VARCHAR2(40);
10
11 P_RELEASE_NUM_FROM VARCHAR2(40);
12
13 P_RELEASE_NUM_TO VARCHAR2(40);
14
15 P_DATE_FROM DATE;
16
17 P_DATE_TO DATE;
18
19 P_SORTBY VARCHAR2(40);
20
21 P_FLEX_ITEM VARCHAR2(800);
22
23 P_CONC_REQUEST_ID NUMBER := 0;
24
25 P_TEST_FLAG VARCHAR2(40);
26
27 P_APPROVED_FLAG VARCHAR2(40);
28
29 P_QTY_PRECISION NUMBER;
30
31 P_USER_ID NUMBER;
32
33 P_EC_STATUS VARCHAR2(1);
34
35 MLS_FLAG VARCHAR2(1);
36
37 P_LANGUAGE_WHERE VARCHAR2(400) := 'and 1=1';
38
39 TEMP_COL_NAME VARCHAR2(40);
40
41 P_DESCRIPTION VARCHAR2(256) := 'pol.item_description';
42
43 P_UOM_COL_NAME VARCHAR2(60) := 'pol.unit_of_measure';
44
45 P_JOIN_UOM VARCHAR2(200);
46
47 P_PRINT_RELEASES VARCHAR2(4);
48
49 P_FAX_ENABLE VARCHAR2(1);
50
51 P_FAX_NUM VARCHAR2(30);
52
53 P_SINGLE_PO_PRINT NUMBER := 0;
54
55 ORG_ID VARCHAR2(40);
56
57 P_CANCEL_LINE VARCHAR2(1);
58
59 P_BLANKET_LINES VARCHAR2(1);
60
61 WHERE_PERFORMANCE VARCHAR2(2000) := 'and 1 = 2';
62
63 P_PO_NUM_TYPE VARCHAR2(32767);
64
65 POH_SHIP_ADDRESS_LINE2 VARCHAR2(240);
66
67 POH_BILL_COUNTRY VARCHAR2(60);
68
69 POH_BILL_ADR_INFO VARCHAR2(400);
70
71 POH_BILL_ADDRESS_LINE3 VARCHAR2(240);
72
73 POH_BILL_ADDRESS_LINE2 VARCHAR2(240);
74
75 POH_BILL_ADDRESS_LINE1 VARCHAR2(240);
76
77 POH_SHIP_COUNTRY VARCHAR2(60);
78
79 POH_SHIP_ADR_INFO VARCHAR2(400);
80
81 POH_SHIP_ADDRESS_LINE3 VARCHAR2(240);
82
83 POH_SHIP_ADDRESS_LINE1 VARCHAR2(240);
84
85 PLL_SHIP_COUNTRY VARCHAR2(60);
86
87 PLL_SHIP_ADR_INFO VARCHAR2(400);
88
89 PLL_SHIP_ADDRESS_LINE3 VARCHAR2(240);
90
91 PLL_SHIP_ADDRESS_LINE2 VARCHAR2(240);
92
93 PLL_SHIP_ADDRESS_LINE1 VARCHAR2(240);
94
95 C_ARCHIVE_SUCCEED NUMBER := 1;
96
97 C_RUNNING_TOTAL NUMBER := 0;
98
99 C_CONTINUED VARCHAR2(93);
100
101 C_ADDRESS_AT_TOP VARCHAR2(93);
102
103 FUNCTION WHERE_CLAUSEFORMULA RETURN VARCHAR2;
104
105 FUNCTION BEFOREREPORT RETURN BOOLEAN;
106
107 FUNCTION AFTERREPORT RETURN BOOLEAN;
108
109 FUNCTION SHIPMENT_TOTAL(C_PLL_NET_QUANTITY IN NUMBER
110 ,PLL_RELEASE_PRICE IN NUMBER
111 ,PLL_CANCEL_FLAG IN VARCHAR2
112 ,POL_LINE_TYPE IN VARCHAR2
113 ,C_PLL_NET_AMOUNT IN NUMBER) RETURN NUMBER;
114
115 FUNCTION C_TOTALFORMULA(C_PAGE_TOTAL IN VARCHAR2
116 ,C_LINE_TOTAL_1 IN VARCHAR2) RETURN VARCHAR2;
117
118 --PROCEDURE UPDATE_PRINT_DATE_COUNT;
119 PROCEDURE UPDATE_PRINT_DATE_COUNT(POH_PO_HEADER_ID IN NUMBER
120 ,POH_PO_RELEASE_ID IN NUMBER
121 ,POH_RELEASE_TYPE IN VARCHAR2
122 ,POH_PO_TYPE IN VARCHAR2);
123
124 FUNCTION DUMMY1(POH_PO_HEADER_ID IN NUMBER
125 ,POH_PO_RELEASE_ID IN NUMBER
126 ,POH_RELEASE_TYPE IN VARCHAR2
127 ,POH_PO_TYPE IN VARCHAR2
128 ,SECURITY_POR_PO_NUM IN NUMBER
129 ,SECURITY_POH_PO_NUM IN VARCHAR2) RETURN NUMBER;
130
131 FUNCTION C_SHIPTO_ADDRESSFORMULA RETURN VARCHAR2;
132
133 FUNCTION C_CONTINUED_OR_TOTALFORMULA(POH_NO_OF_LINES IN NUMBER
134 ,C_LAST_SUM IN NUMBER
135 ,C_AMOUNT_POL_TOTAL_DISP IN VARCHAR2) RETURN VARCHAR2;
136
137 FUNCTION CHECK_SECURITY(POH_PO_TYPE IN VARCHAR2
138 ,SECURITY_POH_PO_NUM IN VARCHAR2
139 ,SECURITY_POR_PO_NUM IN NUMBER
140 ,POH_PO_HEADER_ID IN NUMBER) RETURN BOOLEAN;
141
142 FUNCTION G_HEADERSGROUPFILTER(PO_NUM_TYPE IN VARCHAR2
143 ,SECURITY_POH_PO_NUM IN VARCHAR2
144 ,SECURITY_POR_PO_NUM IN NUMBER
145 ,POH_PO_HEADER_ID IN NUMBER
146 ,POH_PO_TYPE IN VARCHAR2) RETURN BOOLEAN;
147
148 FUNCTION ROUND_POL_AMT(C_AMOUNT_POL IN NUMBER
149 ,C_CURRENCY_PRECISION IN NUMBER) RETURN NUMBER;
150
151 FUNCTION ROUND_POH_AMT_AGREED(POH_AMOUNT_AGREED IN NUMBER
152 ,C_CURRENCY_PRECISION IN NUMBER) RETURN NUMBER;
153
154 FUNCTION ROUND_POL_TOTAL(C_AMOUNT_POL_TOTAL IN VARCHAR2,C_CURRENCY_PRECISION IN NUMBER) RETURN NUMBER;
155
156 FUNCTION ROUND_REL_TOTAL_POL_AMT(C_AMOUNT_POL_RELEASE_TOTAL IN NUMBER
157 ,C_CURRENCY_PRECISION IN NUMBER) RETURN NUMBER;
158
159 FUNCTION ROUND_PLL_AMOUNT(C_AMOUNT_PLL IN NUMBER
160 ,C_CURRENCY_PRECISION IN NUMBER) RETURN NUMBER;
161
162 FUNCTION C_ORIGINAL_BUYERFORMULA(POH_REVISED_DATE IN DATE
163 ,POH_BUYER IN VARCHAR2
164 ,POH_ARCHIVE_BUYER IN VARCHAR2) RETURN VARCHAR2;
165
166 FUNCTION C_EC_WHERE RETURN VARCHAR2;
167
168 FUNCTION MLS_INSTALLED RETURN BOOLEAN;
169
170 PROCEDURE POPULATE_MLS_LEXICALS;
171
172 FUNCTION NET_QUANTITY(PLL_QUANTITY_ORDERED IN NUMBER
173 ,PLL_QUANTITY_CANCELLED IN NUMBER
174 ,PLL_CANCEL_FLAG IN VARCHAR2) RETURN NUMBER;
175
176 FUNCTION C_FAX_HEADERFORMULA(CS_POH_RELEASE_TYPE IN VARCHAR2) RETURN CHAR;
177
178 FUNCTION C_FAX_TRAILERFORMULA(POH_NO_OF_LINES IN NUMBER
179 ,C_LAST_SUM IN NUMBER
180 ,CS_POH_VENDOR_NAME IN VARCHAR2
181 ,CS_POH_PO_NUM IN VARCHAR2
182 ,CS_POH_BUYER IN VARCHAR2
183 ,CS_POH_AGENT_ID IN VARCHAR2) RETURN CHAR;
184
185 FUNCTION C_ITEM_DESCFORMULA(POL_PO_ITEM_ID IN NUMBER
186 ,POL_ITEM_DESCRIPTION IN VARCHAR2
187 ,C_MSI_DESC IN VARCHAR2
188 ,C_MSIT_DESC IN VARCHAR2) RETURN CHAR;
189
190 FUNCTION HEADER_NOTEFORMULA(HEADER_NOTE_DATATYPE_ID IN NUMBER
191 ,HEADER_NOTE_MEDIA_ID IN NUMBER) RETURN CHAR;
192
193 FUNCTION RELEASE_HEADER_NOTEFORMULA(RELEASE_NOTE_DATATYPE_ID IN NUMBER
194 ,RELEASE_NOTE_MEDIA_ID IN NUMBER) RETURN CHAR;
195
196 FUNCTION SHIPMENT_NOTEFORMULA(SHIPMENT_NOTE_DATATYPE_ID IN NUMBER
197 ,SHIPMENT_NOTE_MEDIA_ID IN NUMBER) RETURN CHAR;
198
199 FUNCTION CANCEL_WHERE_CLAUSEFORMULA RETURN CHAR;
200
201 FUNCTION AFTERPFORM RETURN BOOLEAN;
202
203 FUNCTION HEADER_ADDRESSFORMULA(POH_SHIP_TO_LOCATION IN NUMBER
204 ,POH_BILL_TO_LOCATION IN NUMBER) RETURN CHAR;
205
206 FUNCTION SHIPMENT_ADDRESSFORMULA(PLL_SHIP_TO_LOCATION IN NUMBER
207 ,POH_SHIP_TO_LOCATION IN NUMBER
208 ,POH_BILL_TO_LOCATION IN NUMBER) RETURN CHAR;
209
210 FUNCTION C_SRC_BTEXTFORMULA(POL_SRC_GA_FLAG IN VARCHAR2) RETURN CHAR;
211
212 FUNCTION NET_AMOUNT(PLL_AMOUNT IN NUMBER
213 ,PLL_AMOUNT_CANCELLED IN NUMBER
214 ,PLL_CANCEL_FLAG IN VARCHAR2) RETURN NUMBER;
215
216 FUNCTION ITEM_NOTEFORMULA(ITEM_NOTE_DATATYPE_ID IN NUMBER
217 ,ITEM_NOTE_MEDIA_ID IN NUMBER) RETURN CHAR;
218
219 FUNCTION LINE_NOTEFORMULA(LINE_NOTE_DATATYPE_ID IN NUMBER
220 ,LINE_NOTE_MEDIA_ID IN NUMBER) RETURN CHAR;
221
222 FUNCTION C_TOTAL_TAX_AMOUNTFORMULA(PLL_PO_LINE_ID IN NUMBER
223 ,PLL_LINE_LOCATION_ID IN NUMBER) RETURN NUMBER;
224
225 FUNCTION POH_SHIP_ADDRESS_LINE2_P RETURN VARCHAR2;
226
227 FUNCTION POH_BILL_COUNTRY_P RETURN VARCHAR2;
228
229 FUNCTION POH_BILL_ADR_INFO_P RETURN VARCHAR2;
230
231 FUNCTION POH_BILL_ADDRESS_LINE3_P RETURN VARCHAR2;
232
233 FUNCTION POH_BILL_ADDRESS_LINE2_P RETURN VARCHAR2;
234
235 FUNCTION POH_BILL_ADDRESS_LINE1_P RETURN VARCHAR2;
236
237 FUNCTION POH_SHIP_COUNTRY_P RETURN VARCHAR2;
238
239 FUNCTION POH_SHIP_ADR_INFO_P RETURN VARCHAR2;
240
241 FUNCTION POH_SHIP_ADDRESS_LINE3_P RETURN VARCHAR2;
242
243 FUNCTION POH_SHIP_ADDRESS_LINE1_P RETURN VARCHAR2;
244
245 FUNCTION PLL_SHIP_COUNTRY_P RETURN VARCHAR2;
246
247 FUNCTION PLL_SHIP_ADR_INFO_P RETURN VARCHAR2;
248
249 FUNCTION PLL_SHIP_ADDRESS_LINE3_P RETURN VARCHAR2;
250
251 FUNCTION PLL_SHIP_ADDRESS_LINE2_P RETURN VARCHAR2;
252
253 FUNCTION PLL_SHIP_ADDRESS_LINE1_P RETURN VARCHAR2;
254
255 FUNCTION C_ARCHIVE_SUCCEED_P RETURN NUMBER;
256
257 FUNCTION C_RUNNING_TOTAL_P RETURN NUMBER;
258
259 FUNCTION C_CONTINUED_P RETURN VARCHAR2;
260
261 FUNCTION C_ADDRESS_AT_TOP_P RETURN VARCHAR2;
262
263 END JA_JAINPRPOL_XMLP_PKG;
264
265