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.QP_DATA_COMPARE_PVT

Source


1 PACKAGE QP_Data_Compare_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPXVDATS.pls 120.0 2005/06/02 01:35:00 appldev noship $ */
3 
4 G_LIST_HEADER_TBL  CONSTANT VARCHAR2(30) := 'QP_LIST_HEADERS';
5 G_LIST_LINE_TBL    CONSTANT VARCHAR2(30) := 'QP_LIST_LINES';
6 
7 TYPE LIST_HEADER_REC_TYPE IS RECORD
8 (
9 LIST_HEADER_ID                      NUMBER,
10 REQUEST_ID                          NUMBER ,
11 LIST_TYPE_CODE                      VARCHAR2(30),
12 START_DATE_ACTIVE                   DATE,
13 END_DATE_ACTIVE                     DATE,
14 AUTOMATIC_FLAG                      VARCHAR2(1),
15 CURRENCY_CODE                       VARCHAR2(30),
16 ROUNDING_FACTOR                     NUMBER ,
17 SHIP_METHOD_CODE                    VARCHAR2(30),
18 FREIGHT_TERMS_CODE                  VARCHAR2(30),
19 TERMS_ID                            NUMBER,
20 COMMENTS                            VARCHAR2(100),
21 DISCOUNT_LINES_FLAG                 VARCHAR2(30),
22 GSA_INDICATOR                       VARCHAR2(1),
23 PRORATE_FLAG                        VARCHAR2(30),
24 SOURCE_SYSTEM_CODE                  VARCHAR2(30),
25 ASK_FOR_FLAG                        VARCHAR2(1),
26 ACTIVE_FLAG                         VARCHAR2(1),
27 PARENT_LIST_HEADER_ID               NUMBER,
28 START_DATE_ACTIVE_FIRST             DATE,
29 END_DATE_ACTIVE_FIRST               DATE,
30 ACTIVE_DATE_FIRST_TYPE              VARCHAR2(30),
31 START_DATE_ACTIVE_SECOND            DATE,
32 END_DATE_ACTIVE_SECOND              DATE,
33 ACTIVE_DATE_SECOND_TYPE             VARCHAR2(30),
34 LIMIT_EXISTS_FLAG                   VARCHAR2(1),
35 MOBILE_DOWNLOAD                     VARCHAR2(1),
36 CURRENCY_HEADER_ID                  NUMBER,
37 PTE_CODE                            VARCHAR2(30),
38 LIST_SOURCE_CODE                    VARCHAR2(30),
39 ORIG_SYSTEM_HEADER_REF              VARCHAR2(30),
40 ORIG_ORG_ID                         NUMBER,
41 GLOBAL_FLAG                         VARCHAR2(1),
42 SOLD_TO_ORG_ID                      NUMBER,
43 SHAREABLE_FLAG                      VARCHAR2(1),
44 LOCKED_FROM_LIST_HEADER_ID          NUMBER,
45 LANGUAGE                            VARCHAR2(4),
46 SOURCE_LANG                         VARCHAR2(4),
47 NAME                                VARCHAR2(240),
48 DESCRIPTION                         VARCHAR2(2000),
49 VERSION_NO                          VARCHAR2(30));
50 
51 TYPE QUALIFIER_REC_TYPE IS RECORD
52 (
53 QUALIFIER_ID                  NUMBER,
54 QUALIFIER_GROUPING_NO         NUMBER,
55 QUALIFIER_CONTEXT             VARCHAR2(30),
56 QUALIFIER_ATTRIBUTE           VARCHAR2(30),
57 QUALIFIER_ATTR_VALUE          VARCHAR2(240),
58 COMPARISON_OPERATOR_CODE      VARCHAR2(30),
59 EXCLUDER_FLAG                 VARCHAR2(1),
60 QUALIFIER_RULE_ID             NUMBER,
61 START_DATE_ACTIVE             DATE,
62 END_DATE_ACTIVE               DATE,
63 CREATED_FROM_RULE_ID          NUMBER,
64 QUALIFIER_PRECEDENCE          NUMBER,
65 LIST_HEADER_ID                NUMBER,
66 LIST_LINE_ID                  NUMBER,
67 QUALIFIER_DATATYPE            VARCHAR2(10),
68 QUALIFIER_ATTR_VALUE_TO       VARCHAR2(240),
69 ACTIVE_FLAG                   VARCHAR2(1),
70 LIST_TYPE_CODE                VARCHAR2(30),
71 QUAL_ATTR_VALUE_FROM_NUMBER   NUMBER,
72 QUAL_ATTR_VALUE_TO_NUMBER     NUMBER,
73 SEARCH_IND                    NUMBER,
74 QUALIFIER_GROUP_CNT           NUMBER,
75 HEADER_QUALS_EXIST_FLAG       VARCHAR2(1),
76 DISTINCT_ROW_COUNT            NUMBER,
77 OTHERS_GROUP_CNT              NUMBER,
78 ORIG_SYS_QUALIFIER_REF        VARCHAR2(50),
79 ORIG_SYS_HEADER_REF           VARCHAR2(50),
80 ORIG_SYS_LINE_REF             VARCHAR2(50),
81 SEGMENT_ID                    NUMBER);
82 
83 TYPE LIST_LINE_REC_TYPE IS RECORD
84 (
85 LIST_LINE_ID                  NUMBER,
86 LIST_HEADER_ID                NUMBER,
87 LIST_LINE_TYPE_CODE           VARCHAR2(30),
88 START_DATE_ACTIVE             DATE,
89 END_DATE_ACTIVE               DATE,
90 AUTOMATIC_FLAG                VARCHAR2(1),
91 MODIFIER_LEVEL_CODE           VARCHAR2(30),
92 PRICE_BY_FORMULA_ID           NUMBER,
93 PRIMARY_UOM_FLAG              VARCHAR2(1),
94 PRICE_BREAK_TYPE_CODE         VARCHAR2(30),
95 ARITHMETIC_OPERATOR           VARCHAR2(30),
96 OPERAND                       NUMBER,
97 OVERRIDE_FLAG                 VARCHAR2(1),
98 ACCRUAL_QTY                   NUMBER,
99 ACCRUAL_UOM_CODE              VARCHAR2(30),
100 ESTIM_ACCRUAL_RATE            NUMBER,
101 GENERATE_USING_FORMULA_ID     NUMBER,
102 LIST_LINE_NO                  VARCHAR2(30),
103 ESTIM_GL_VALUE                NUMBER,
104 BENEFIT_PRICE_LIST_LINE_ID    NUMBER,
105 EXPIRATION_PERIOD_START_DATE  DATE,
106 NUMBER_EXPIRATION_PERIODS     NUMBER,
107 EXPIRATION_PERIOD_UOM         VARCHAR2(30),
108 EXPIRATION_DATE               DATE,
109 ACCRUAL_FLAG                  VARCHAR2(1),
110 PRICING_PHASE_ID              NUMBER,
111 PRICING_GROUP_SEQUENCE        NUMBER,
112 INCOMPATIBILITY_GRP_CODE      VARCHAR2(30),
113 PRODUCT_PRECEDENCE            NUMBER,
114 PRORATION_TYPE_CODE           VARCHAR2(30),
115 ACCRUAL_CONVERSION_RATE       NUMBER,
116 BENEFIT_QTY                   NUMBER,
117 BENEFIT_UOM_CODE              VARCHAR2(30),
118 QUALIFICATION_IND             NUMBER,
119 LIMIT_EXISTS_FLAG             VARCHAR2(1),
120 GROUP_COUNT                   NUMBER,
121 NET_AMOUNT_FLAG               VARCHAR2(1),
122 RECURRING_VALUE               NUMBER,
123 ACCUM_CONTEXT                 VARCHAR2(30),
124 ACCUM_ATTRIBUTE               VARCHAR2(30),
125 ACCUM_ATTR_RUN_SRC_FLAG       VARCHAR2(1),
126 BREAK_UOM_CODE                VARCHAR2(30),
127 BREAK_UOM_CONTEXT             VARCHAR2(30),
128 BREAK_UOM_ATTRIBUTE           VARCHAR2(30),
129 PATTERN_ID                    NUMBER,
130 PRODUCT_UOM_CODE              VARCHAR2(30),
131 PRICING_ATTRIBUTE_COUNT       NUMBER,
132 HASH_KEY                      VARCHAR2(30),
133 CACHE_KEY                     VARCHAR2(30));
134 
135 TYPE PRICING_ATTRIBUTE_REC_TYPE IS RECORD
136 (
137 PRICING_ATTRIBUTE_ID           NUMBER,
138 LIST_LINE_ID                   NUMBER,
139 EXCLUDER_FLAG                  VARCHAR2(1),
140 ACCUMULATE_FLAG                VARCHAR2(1),
141 PRODUCT_ATTRIBUTE_CONTEXT      VARCHAR2(30),
142 PRODUCT_ATTRIBUTE              VARCHAR2(30),
143 PRODUCT_ATTR_VALUE             VARCHAR2(30),
144 PRODUCT_UOM_CODE               VARCHAR2(30),
145 PRICING_ATTRIBUTE_CONTEXT      VARCHAR2(30),
146 PRICING_ATTRIBUTE              VARCHAR2(30),
147 PRICING_ATTR_VALUE_FROM        VARCHAR2(240),
148 PRICING_ATTR_VALUE_TO          VARCHAR2(240),
149 ATTRIBUTE_GROUPING_NO          NUMBER,
150 PRODUCT_ATTRIBUTE_DATATYPE     VARCHAR2(1),
151 PRICING_ATTRIBUTE_DATATYPE     VARCHAR2(1),
152 COMPARISON_OPERATOR_CODE       VARCHAR2(30),
153 LIST_HEADER_ID                 NUMBER,
154 PRICING_PHASE_ID               NUMBER,
155 QUALIFICATION_IND              NUMBER,
156 PRICING_ATTR_VALUE_FROM_NUMBER NUMBER,
157 PRICING_ATTR_VALUE_TO_NUMBER   NUMBER,
158 DISTINCT_ROW_COUNT             NUMBER,
159 SEARCH_IND                     NUMBER,
160 PATTERN_VALUE_FROM_POSITIVE    VARCHAR2(240),
161 PATTERN_VALUE_TO_POSITIVE      VARCHAR2(240),
162 PATTERN_VALUE_FROM_NEGATIVE    VARCHAR2(240),
163 PATTERN_VALUE_TO_NEGATIVE      VARCHAR2(240),
164 PRODUCT_SEGMENT_ID             NUMBER,
165 PRICING_SEGMENT_ID             NUMBER);
166 
167 TYPE RLTD_MODIFIER_REC_TYPE IS RECORD
168 (
169 RLTD_MODIFIER_ID          NUMBER,
170 RLTD_MODIFIER_GRP_NO      NUMBER,
171 FROM_RLTD_MODIFIER_ID     NUMBER,
172 TO_RLTD_MODIFIER_ID       NUMBER,
173 RLTD_MODIFIER_GRP_TYPE    VARCHAR2(30));
174 
175 TYPE LIST_HEADER_PHASES_REC_TYPE IS RECORD
176 (
177 LIST_HEADER_ID            NUMBER,
178 PRICING_PHASE_ID          NUMBER,
179 QUALIFIER_FLAG            VARCHAR2(1));
180 
181 TYPE PRICING_PHASES_REC_TYPE IS RECORD
182 (
183 MODIFIER_LEVEL_CODE       VARCHAR2(30),
184 PHASE_SEQUENCE            NUMBER,
185 PRICING_PHASE_ID          NUMBER,
186 INCOMPAT_RESOLVE_CODE     VARCHAR2(30),
187 NAME                      VARCHAR2(30),
188 SEEDED_FLAG               VARCHAR2(1),
189 FREEZE_OVERRIDE_FLAG      VARCHAR2(1),
190 USER_FREEZE_OVERRIDE_FLAG VARCHAR2(1),
191 USER_INCOMPAT_RESOLVE_CODE  VARCHAR2(30),
192 LINE_GROUP_EXISTS         VARCHAR2(1),
193 OID_EXISTS                VARCHAR2(1),
194 RLTD_EXISTS               VARCHAR2(1),
195 FREIGHT_EXISTS            VARCHAR2(1),
196 MANUAL_MODIFIER_FLAG      VARCHAR2(1));
197 
198 TYPE ADV_MOD_PRODUCTS_REC_TYPE IS RECORD
199 ( PRICING_PHASE_ID        NUMBER,
200 PRODUCT_ATTRIBUTE         VARCHAR2(30),
201 PRODUCT_ATTR_VALUE        VARCHAR2(240));
202 
203 TYPE ATTRIBUTE_GROUPS_REC_TYPE IS RECORD
204 (
205 LIST_HEADER_ID            NUMBER,
206 LIST_LINE_ID              NUMBER,
207 ACTIVE_FLAG               VARCHAR2(1),
208 LIST_TYPE_CODE            VARCHAR2(30),
209 START_DATE_ACTIVE_Q       DATE,
210 END_DATE_ACTIVE_Q         DATE,
211 PATTERN_ID                NUMBER,
212 CURRENCY_CODE             VARCHAR2(30),
213 ASK_FOR_FLAG              VARCHAR2(1),
214 LIMIT_EXISTS              VARCHAR2(1),
215 SOURCE_SYSTEM_CODE        VARCHAR2(30),
216 EFFECTIVE_PRECEDENCE      NUMBER,
217 GROUPING_NO               NUMBER,
218 PRICING_PHASE_ID          NUMBER,
219 MODIFIER_LEVEL_CODE       VARCHAR2(30),
220 HASH_KEY                  VARCHAR2(2000),
221 CACHE_KEY                 VARCHAR2(240));
222 
223 TYPE PATTERNS_REC_TYPE IS RECORD
224 (
225 PATTERN_ID                NUMBER,
226 SEGMENT_ID                NUMBER,
227 PATTERN_TYPE              VARCHAR2(30),
228 PATTERN_STRING            VARCHAR2(2000));
229 
230 TYPE PATTERN_PHASES_REC_TYPE IS RECORD
231 (
232 LIST_HEADER_ID            NUMBER,
233 PATTERN_ID                NUMBER,
234 PRICING_PHASE_ID          NUMBER);
235 
236 
237 PROCEDURE List_Header_Data(p_html_list_line_id NUMBER,
238                            p_forms_list_line_id NUMBER,
239                            p_file_dir VARCHAR2,
240                            x_return_status OUT NOCOPY VARCHAR2);
241 
242 PROCEDURE Qualifier_Data(p_html_list_line_id NUMBER,
243                          p_forms_list_line_id NUMBER,
244                          p_file_dir VARCHAR2,
245                          x_return_status OUT NOCOPY VARCHAR2);
246 
247 PROCEDURE List_Line_Data(p_html_list_line_id NUMBER,
248                          p_forms_list_line_id NUMBER,
249                          p_file_dir VARCHAR2,
250                          x_return_status OUT NOCOPY VARCHAR2);
251 
252 PROCEDURE Pricing_Attribute_Data(p_html_list_line_id NUMBER,
253                                  p_forms_list_line_id NUMBER,
254                                  p_file_dir VARCHAR2,
255                                  x_return_status OUT NOCOPY VARCHAR2);
256 
257 PROCEDURE Rltd_Modifier_Data(p_html_list_line_id NUMBER,
258                              p_forms_list_line_id NUMBER,
259                              p_file_dir VARCHAR2,
260                              x_return_status OUT NOCOPY VARCHAR2);
261 
262 PROCEDURE Attribute_Groups_Data(p_html_list_line_id NUMBER,
263                                 p_forms_list_line_id NUMBER,
264                                 p_file_dir VARCHAR2,
265                                 x_return_status OUT NOCOPY VARCHAR2);
266 
267 PROCEDURE List_Header_Phases_Data(p_html_list_line_id NUMBER,
268                                   p_forms_list_line_id NUMBER,
269                                   p_file_dir VARCHAR2,
270                                   x_return_status OUT NOCOPY VARCHAR2);
271 
272 PROCEDURE Pricing_Phases_Data(p_data_creation_method VARCHAR2,
273                               p_file_dir VARCHAR2,
274                               x_return_status OUT NOCOPY VARCHAR2);
275 
276 PROCEDURE Adv_Mod_Products_Data(p_list_line_id NUMBER,
277                                 p_data_creation_method VARCHAR2,
278                                 p_file_dir VARCHAR2,
279                                 x_return_status OUT NOCOPY VARCHAR2);
280 
281 PROCEDURE Patterns_Data(p_html_list_line_id NUMBER,
282                         p_forms_list_line_id NUMBER,
283                         p_pattern_type VARCHAR2,
284                         p_file_dir VARCHAR2,
285                         x_return_status OUT NOCOPY VARCHAR2);
286 
287 PROCEDURE Pattern_Phases_Data(p_html_list_line_id NUMBER,
288                               p_forms_list_line_id NUMBER,
289                               p_pattern_type VARCHAR2,
290                               p_file_dir VARCHAR2,
291                               x_return_status OUT NOCOPY VARCHAR2);
292 
293 PROCEDURE Profiles_Data(p_list_line_id NUMBER,
294                         p_data_creation_method VARCHAR2,
295                         p_file_dir VARCHAR2,
296                         x_return_status OUT NOCOPY VARCHAR2);
297 END QP_Data_Compare_PVT;