1 PACKAGE RLM_RLMNETCH_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: RLMNETCHS.pls 120.0 2008/01/25 12:02:59 krreddy noship $ */
3 P_NEW_HEADER_ID NUMBER;
4
5 P_OLD_HEADER_ID NUMBER;
6
7 P_CUSTOMER_ID NUMBER;
8
9 P_TRADING_PARTNER NUMBER;
10
11 P_SCHEDULE_TYPE VARCHAR2(30);
12
13 P_SHIP_FROM NUMBER;
14
15 P_SHIP_TO NUMBER;
16
17 P_OTHER_DETAIL_FLAG VARCHAR2(1);
18
19 CP_ORG_ID NUMBER;
20
21 P_AUTH_QUANT_FLAG VARCHAR2(1);
22
23 P_WHERE1 VARCHAR2(400) := ' ';
24
25 P_WHERE2 VARCHAR2(400) := ' ';
26
27 P_CUST_ITEM_START VARCHAR2(32767);
28
29 P_CUST_PRODSEQ_START VARCHAR2(35);
30
31 P_CUST_PRODSEQ_END VARCHAR2(35);
32
33 P_NOCHANGE_LINES_FLAG VARCHAR2(1);
34
35 P_CHANGE NUMBER;
36
37 P_CUST_ITEM_END VARCHAR2(32767);
38
39 P_WHERE3 VARCHAR2(200) := ' ';
40
41 P_WHERE4 VARCHAR2(32767) := ' ';
42
43 P_WHERE5 VARCHAR2(200) := ' ';
44
45 P_TITLE VARCHAR2(50);
46
47 P_CONC_REQUEST_ID NUMBER;
48
49 P_LOOKUP_TYPE VARCHAR2(30);
50
51 P_ITEM_DETAIL_TYPE VARCHAR2(32767);
52
53 P_RLM_DETAIL_SUBTYPE_CODE VARCHAR2(30);
54
55 P_RLM_DETAIL_TYPE_CODE VARCHAR2(30);
56
57 P_ORG_ID NUMBER;
58
59 CP_PREV_VALUE NUMBER := 0;
60
61 CP_NEW_START DATE;
62
63 CP_NEW_END DATE;
64
65 CP_OLD_START DATE;
66
67 CP_OLD_END DATE;
68
69 CP_NEW_CUM NUMBER;
70
71 CP_OLD_CUM NUMBER;
72
73 CP_NEW_CREATION_DATE DATE;
74
75 CP_OLD_CREATION_DATE DATE;
76
77 CP_CUSTOMER_ID NUMBER;
78
79 CP_OLD_ACT NUMBER;
80
81 CP_NEW_ACT NUMBER;
82
83 CP_NEW_SUP_CUM NUMBER := 0;
84
85 CP_OLD_SUP_CUM NUMBER := 0;
86
87 CP_P_SHIP_FROM VARCHAR2(240);
88
89 CP_P_SHIP_TO VARCHAR2(240);
90
91 CP_P_CUSTOMER_NAME VARCHAR2(240);
92
93 CP_P_SCHEDULE_TYPE VARCHAR2(240);
94
95 CP_P_NEW_SCH_REF_NUM VARCHAR2(35);
96
97 CP_P_OLD_SCH_REF_NUM VARCHAR2(35);
98
99 CP_P_AUTH_QUANT_FLAG VARCHAR2(80);
100
101 CP_P_OTHER_DETAIL_FLAG VARCHAR2(80);
102
103 CP_P_NOCHANGE_LINES_FLAG VARCHAR2(80);
104
105 CP_DEFAULT_OU VARCHAR2(240);
106
107 FUNCTION C_CHANGE_CUMFORMULA(CF_NEW_CUM IN NUMBER
108 ,CF_OLD_CUM IN NUMBER) RETURN NUMBER;
109
110 FUNCTION C_NET_CHANGEFORMULA(C_ACTUAL_NEW_QTY IN NUMBER
111 ,C_ACTUAL_OLD_QTY IN NUMBER) RETURN NUMBER;
112
113 FUNCTION G_ITEM_1GROUPFILTER RETURN BOOLEAN;
114
115 FUNCTION G_CUSTOMER_ITEM_ID1GROUPFILTER RETURN BOOLEAN;
116
117 FUNCTION G_ITEM_HEADGROUPFILTER RETURN BOOLEAN;
118
119 FUNCTION G_HEADERGROUPFILTER RETURN BOOLEAN;
120
121 FUNCTION BEFOREREPORT RETURN BOOLEAN;
122
123 FUNCTION CF_PERCENTAGEFORMULA(C_SUM_OLD_QTY IN NUMBER
124 ,CF_OLD_CUM IN NUMBER
125 ,C_CHANGE_CUM IN NUMBER) RETURN NUMBER;
126
127 FUNCTION C_ACTUAL_NEW_QTYFORMULA(NEW_CODE IN VARCHAR2
128 ,ITEM_DETAIL_QUANTITY IN NUMBER
129 ,CUST_RECORD_YEAR IN VARCHAR2
130 ,INTRMD_SHIP_TO_ID IN NUMBER
131 ,CUSTOMER_ITEM_ID IN NUMBER
132 ,SHIP_FROM_ORG_ID IN NUMBER
133 ,BILL_TO_ADDRESS_ID IN NUMBER
134 ,SHIP_TO_ADDRESS_ID IN NUMBER
135 ,INVENTORY_ITEM_ID IN NUMBER
136 ,CUST_PO_NUMBER IN VARCHAR2
137 ,SHIP_TO_ORG_ID IN NUMBER) RETURN NUMBER;
138
139 FUNCTION C_ACTUAL_OLD_QTYFORMULA(OLD_CODE IN VARCHAR2
140 ,ITEM_DETAIL_QUANTITY1 IN NUMBER
141 ,CUST_RECORD_YEAR IN VARCHAR2
142 ,INTRMD_SHIP_TO_ID IN NUMBER
143 ,CUSTOMER_ITEM_ID IN NUMBER
144 ,SHIP_FROM_ORG_ID IN NUMBER
145 ,BILL_TO_ADDRESS_ID IN NUMBER
146 ,SHIP_TO_ADDRESS_ID IN NUMBER
147 ,INVENTORY_ITEM_ID IN NUMBER
148 ,CUST_PO_NUMBER IN VARCHAR2
149 ,SHIP_TO_ORG_ID IN NUMBER) RETURN NUMBER;
150
151 FUNCTION CF_1FORMULA(NEW_CODE IN VARCHAR2
152 ,ITEM_DETAIL_QUANTITY IN NUMBER
153 ,OLD_CODE IN VARCHAR2
154 ,CUST_RECORD_YEAR IN VARCHAR2
155 ,INTRMD_SHIP_TO_ID IN NUMBER
156 ,CUSTOMER_ITEM_ID IN NUMBER
157 ,SHIP_FROM_ORG_ID IN NUMBER
158 ,BILL_TO_ADDRESS_ID IN NUMBER
159 ,SHIP_TO_ADDRESS_ID IN NUMBER
160 ,INVENTORY_ITEM_ID IN NUMBER
161 ,CUST_PO_NUMBER IN VARCHAR2
162 ,SHIP_TO_ORG_ID IN NUMBER) RETURN NUMBER;
163
164 FUNCTION CF_OLD_CUMFORMULA(OLD_CODE IN VARCHAR2
165 ,ITEM_DETAIL_QUANTITY1 IN NUMBER
166 ,NEW_CODE IN VARCHAR2
167 ,CUST_RECORD_YEAR IN VARCHAR2
168 ,INTRMD_SHIP_TO_ID IN NUMBER
169 ,CUSTOMER_ITEM_ID IN NUMBER
170 ,SHIP_FROM_ORG_ID IN NUMBER
171 ,BILL_TO_ADDRESS_ID IN NUMBER
172 ,SHIP_TO_ADDRESS_ID IN NUMBER
173 ,INVENTORY_ITEM_ID IN NUMBER
174 ,CUST_PO_NUMBER IN VARCHAR2
175 ,SHIP_TO_ORG_ID IN NUMBER) RETURN NUMBER;
176
177 FUNCTION INTRMD_SHIP_TO_EXTFORMULA(ITRMD_SHIP_TO_ID IN NUMBER) RETURN CHAR;
178
179 FUNCTION CUSTOMER_ITEM_NUMBERFORMULA(CUSTOMER_ITEM_ID1 IN NUMBER) RETURN CHAR;
180
181 FUNCTION CUSTOMER_ITEM_DESCFORMULA(CUSTOMER_ITEM_ID1 IN NUMBER) RETURN CHAR;
182
183 FUNCTION ITEM_NUMBER1FORMULA(INVENTORY_ITEM_ID1 IN NUMBER
184 ,SHIP_FROM_ORG_ID1 IN NUMBER) RETURN CHAR;
185
186 FUNCTION SHIP_TO_NAME1FORMULA(SHIP_TO_ORG_ID1 IN NUMBER) RETURN CHAR;
187
188 FUNCTION ORG_NAME1FORMULA(SHIP_FROM_ORG_ID1 IN NUMBER) RETURN CHAR;
189
190 FUNCTION SHIP_FROM_NAMEFORMULA(SHIP_FROM_ORG_ID1 IN NUMBER) RETURN CHAR;
191
192 FUNCTION AFTERPFORM RETURN BOOLEAN;
193
194 FUNCTION DETAIL_TYPE_SFORMULA(ITEM_DETAIL_TYPE2 IN VARCHAR2) RETURN CHAR;
195
196 FUNCTION DETAIL_SUBTYPE_SFORMULA(ITEM_DETAIL_SUBTYPE1 IN VARCHAR2) RETURN CHAR;
197
198 FUNCTION CUMKEYCALCULATION(V_AS_OF_DATE_TIME IN DATE
199 ,V_CUM_START_DATE IN DATE
200 ,CUSTOMER_ITEM_ID IN NUMBER
201 ,SHIP_FROM_ORG_ID IN NUMBER
202 ,INTRMD_SHIP_TO_ID IN NUMBER
203 ,SHIP_TO_ADDRESS_ID IN NUMBER
204 ,BILL_TO_ADDRESS_ID IN NUMBER
205 ,CUST_PO_NUMBER IN VARCHAR2
206 ,CUST_RECORD_YEAR IN VARCHAR2
207 ,INVENTORY_ITEM_ID IN NUMBER) RETURN NUMBER;
208
209 FUNCTION CF_PLACEHOLDERFORMULA(NEW_CREATION_DATE IN DATE
210 ,OLD_CREATION_DATE IN DATE
211 ,CUSTOMER_ID IN NUMBER) RETURN NUMBER;
212
213 FUNCTION AFTERREPORT RETURN BOOLEAN;
214
215 FUNCTION GET_CUM_START_DATE(X_HEADER_ID IN NUMBER,
216 SHIP_FROM_ORG_ID1 IN NUMBER,
217 SHIP_TO_ORG_ID1 IN NUMBER,
218 CUSTOMER_ITEM_ID1 IN NUMBER,
219 INVENTORY_ITEM_ID1 IN NUMBER) RETURN DATE;
220
221 FUNCTION CP_PREV_VALUE_P RETURN NUMBER;
222
223 FUNCTION CP_NEW_START_P RETURN DATE;
224
225 FUNCTION CP_NEW_END_P RETURN DATE;
226
227 FUNCTION CP_OLD_START_P RETURN DATE;
228
229 FUNCTION CP_OLD_END_P RETURN DATE;
230
231 FUNCTION CP_NEW_CUM_P RETURN NUMBER;
232
233 FUNCTION CP_OLD_CUM_P RETURN NUMBER;
234
235 FUNCTION CP_NEW_CREATION_DATE_P RETURN DATE;
236
237 FUNCTION CP_OLD_CREATION_DATE_P RETURN DATE;
238
239 FUNCTION CP_CUSTOMER_ID_P RETURN NUMBER;
240
241 FUNCTION CP_OLD_ACT_P RETURN NUMBER;
242
243 FUNCTION CP_NEW_ACT_P RETURN NUMBER;
244
245 FUNCTION CP_NEW_SUP_CUM_P RETURN NUMBER;
246
247 FUNCTION CP_OLD_SUP_CUM_P RETURN NUMBER;
248
249 FUNCTION CP_P_SHIP_FROM_P RETURN VARCHAR2;
250
251 FUNCTION CP_P_SHIP_TO_P RETURN VARCHAR2;
252
253 FUNCTION CP_P_CUSTOMER_NAME_P RETURN VARCHAR2;
254
255 FUNCTION CP_P_SCHEDULE_TYPE_P RETURN VARCHAR2;
256
257 FUNCTION CP_P_NEW_SCH_REF_NUM_P RETURN VARCHAR2;
258
259 FUNCTION CP_P_OLD_SCH_REF_NUM_P RETURN VARCHAR2;
260
261 FUNCTION CP_P_AUTH_QUANT_FLAG_P RETURN VARCHAR2;
262
263 FUNCTION CP_P_OTHER_DETAIL_FLAG_P RETURN VARCHAR2;
264
265 FUNCTION CP_P_NOCHANGE_LINES_FLAG_P RETURN VARCHAR2;
266
267 FUNCTION CP_DEFAULT_OU_P RETURN VARCHAR2;
268
269 FUNCTION CP_ORG_ID_P RETURN NUMBER;
270
271 END RLM_RLMNETCH_XMLP_PKG;