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.

APPS.QP_QUALIFIERS_UTIL dependencies on QP_QUALIFIERS

Line 1: PACKAGE BODY QP_Qualifiers_Util AS

1: PACKAGE BODY QP_Qualifiers_Util AS
2: /* $Header: QPXUQPQB.pls 120.9.12010000.2 2008/10/14 12:00:34 skattama ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Qualifiers_Util';

2: /* $Header: QPXUQPQB.pls 120.9.12010000.2 2008/10/14 12:00:34 skattama ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Qualifiers_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr

Line 52: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE1;

48:
49: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,p_old_QUALIFIERS_rec.attribute1)
50: THEN
51: l_index := l_index + 1;
52: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE1;
53: END IF;
54:
55: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,p_old_QUALIFIERS_rec.attribute10)
56: THEN

Line 58: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE10;

54:
55: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,p_old_QUALIFIERS_rec.attribute10)
56: THEN
57: l_index := l_index + 1;
58: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE10;
59: END IF;
60:
61: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,p_old_QUALIFIERS_rec.attribute11)
62: THEN

Line 64: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE11;

60:
61: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,p_old_QUALIFIERS_rec.attribute11)
62: THEN
63: l_index := l_index + 1;
64: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE11;
65: END IF;
66:
67: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,p_old_QUALIFIERS_rec.attribute12)
68: THEN

Line 70: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE12;

66:
67: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,p_old_QUALIFIERS_rec.attribute12)
68: THEN
69: l_index := l_index + 1;
70: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE12;
71: END IF;
72:
73: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,p_old_QUALIFIERS_rec.attribute13)
74: THEN

Line 76: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE13;

72:
73: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,p_old_QUALIFIERS_rec.attribute13)
74: THEN
75: l_index := l_index + 1;
76: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE13;
77: END IF;
78:
79: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,p_old_QUALIFIERS_rec.attribute14)
80: THEN

Line 82: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE14;

78:
79: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,p_old_QUALIFIERS_rec.attribute14)
80: THEN
81: l_index := l_index + 1;
82: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE14;
83: END IF;
84:
85: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,p_old_QUALIFIERS_rec.attribute15)
86: THEN

Line 88: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE15;

84:
85: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,p_old_QUALIFIERS_rec.attribute15)
86: THEN
87: l_index := l_index + 1;
88: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE15;
89: END IF;
90:
91: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,p_old_QUALIFIERS_rec.attribute2)
92: THEN

Line 94: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE2;

90:
91: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,p_old_QUALIFIERS_rec.attribute2)
92: THEN
93: l_index := l_index + 1;
94: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE2;
95: END IF;
96:
97: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,p_old_QUALIFIERS_rec.attribute3)
98: THEN

Line 100: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE3;

96:
97: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,p_old_QUALIFIERS_rec.attribute3)
98: THEN
99: l_index := l_index + 1;
100: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE3;
101: END IF;
102:
103: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,p_old_QUALIFIERS_rec.attribute4)
104: THEN

Line 106: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE4;

102:
103: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,p_old_QUALIFIERS_rec.attribute4)
104: THEN
105: l_index := l_index + 1;
106: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE4;
107: END IF;
108:
109: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,p_old_QUALIFIERS_rec.attribute5)
110: THEN

Line 112: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE5;

108:
109: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,p_old_QUALIFIERS_rec.attribute5)
110: THEN
111: l_index := l_index + 1;
112: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE5;
113: END IF;
114:
115: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,p_old_QUALIFIERS_rec.attribute6)
116: THEN

Line 118: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE6;

114:
115: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,p_old_QUALIFIERS_rec.attribute6)
116: THEN
117: l_index := l_index + 1;
118: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE6;
119: END IF;
120:
121: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,p_old_QUALIFIERS_rec.attribute7)
122: THEN

Line 124: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE7;

120:
121: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,p_old_QUALIFIERS_rec.attribute7)
122: THEN
123: l_index := l_index + 1;
124: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE7;
125: END IF;
126:
127: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,p_old_QUALIFIERS_rec.attribute8)
128: THEN

Line 130: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE8;

126:
127: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,p_old_QUALIFIERS_rec.attribute8)
128: THEN
129: l_index := l_index + 1;
130: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE8;
131: END IF;
132:
133: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,p_old_QUALIFIERS_rec.attribute9)
134: THEN

Line 136: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE9;

132:
133: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,p_old_QUALIFIERS_rec.attribute9)
134: THEN
135: l_index := l_index + 1;
136: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE9;
137: END IF;
138:
139: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,p_old_QUALIFIERS_rec.comparison_operator_code)
140: THEN

Line 142: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_COMPARISON_OPERATOR;

138:
139: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,p_old_QUALIFIERS_rec.comparison_operator_code)
140: THEN
141: l_index := l_index + 1;
142: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_COMPARISON_OPERATOR;
143: END IF;
144:
145: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,p_old_QUALIFIERS_rec.context)
146: THEN

Line 148: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CONTEXT;

144:
145: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,p_old_QUALIFIERS_rec.context)
146: THEN
147: l_index := l_index + 1;
148: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CONTEXT;
149: END IF;
150:
151: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,p_old_QUALIFIERS_rec.created_by)
152: THEN

Line 154: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_BY;

150:
151: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,p_old_QUALIFIERS_rec.created_by)
152: THEN
153: l_index := l_index + 1;
154: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_BY;
155: END IF;
156:
157: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,p_old_QUALIFIERS_rec.created_from_rule_id)
158: THEN

Line 160: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_FROM_RULE;

156:
157: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,p_old_QUALIFIERS_rec.created_from_rule_id)
158: THEN
159: l_index := l_index + 1;
160: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_FROM_RULE;
161: END IF;
162:
163: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,p_old_QUALIFIERS_rec.creation_date)
164: THEN

Line 166: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATION_DATE;

162:
163: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,p_old_QUALIFIERS_rec.creation_date)
164: THEN
165: l_index := l_index + 1;
166: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATION_DATE;
167: END IF;
168:
169: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,p_old_QUALIFIERS_rec.end_date_active)
170: THEN

Line 172: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_END_DATE_ACTIVE;

168:
169: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,p_old_QUALIFIERS_rec.end_date_active)
170: THEN
171: l_index := l_index + 1;
172: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_END_DATE_ACTIVE;
173: END IF;
174:
175: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,p_old_QUALIFIERS_rec.excluder_flag)
176: THEN

Line 178: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_EXCLUDER;

174:
175: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,p_old_QUALIFIERS_rec.excluder_flag)
176: THEN
177: l_index := l_index + 1;
178: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_EXCLUDER;
179: END IF;
180:
181: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,p_old_QUALIFIERS_rec.last_updated_by)
182: THEN

Line 184: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;

180:
181: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,p_old_QUALIFIERS_rec.last_updated_by)
182: THEN
183: l_index := l_index + 1;
184: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;
185: END IF;
186:
187: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,p_old_QUALIFIERS_rec.last_update_date)
188: THEN

Line 190: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;

186:
187: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,p_old_QUALIFIERS_rec.last_update_date)
188: THEN
189: l_index := l_index + 1;
190: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;
191: END IF;
192:
193: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,p_old_QUALIFIERS_rec.last_update_login)
194: THEN

Line 196: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;

192:
193: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,p_old_QUALIFIERS_rec.last_update_login)
194: THEN
195: l_index := l_index + 1;
196: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
197: END IF;
198:
199: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,p_old_QUALIFIERS_rec.list_header_id)
200: THEN

Line 202: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_HEADER;

198:
199: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,p_old_QUALIFIERS_rec.list_header_id)
200: THEN
201: l_index := l_index + 1;
202: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_HEADER;
203: END IF;
204:
205: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,p_old_QUALIFIERS_rec.list_line_id)
206: THEN

Line 208: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_LINE;

204:
205: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,p_old_QUALIFIERS_rec.list_line_id)
206: THEN
207: l_index := l_index + 1;
208: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_LINE;
209: END IF;
210:
211: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,p_old_QUALIFIERS_rec.program_application_id)
212: THEN

Line 214: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_APPLICATION;

210:
211: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,p_old_QUALIFIERS_rec.program_application_id)
212: THEN
213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_APPLICATION;
215: END IF;
216:
217: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,p_old_QUALIFIERS_rec.program_id)
218: THEN

Line 220: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM;

216:
217: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,p_old_QUALIFIERS_rec.program_id)
218: THEN
219: l_index := l_index + 1;
220: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM;
221: END IF;
222:
223: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,p_old_QUALIFIERS_rec.program_update_date)
224: THEN

Line 226: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;

222:
223: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,p_old_QUALIFIERS_rec.program_update_date)
224: THEN
225: l_index := l_index + 1;
226: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
227: END IF;
228:
229: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,p_old_QUALIFIERS_rec.qualifier_attribute)
230: THEN

Line 232: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTRIBUTE;

228:
229: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,p_old_QUALIFIERS_rec.qualifier_attribute)
230: THEN
231: l_index := l_index + 1;
232: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTRIBUTE;
233: END IF;
234:
235: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,p_old_QUALIFIERS_rec.qualifier_attr_value)
236: THEN

Line 238: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE;

234:
235: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,p_old_QUALIFIERS_rec.qualifier_attr_value)
236: THEN
237: l_index := l_index + 1;
238: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE;
239: END IF;
240:
241:
242: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,p_old_QUALIFIERS_rec.qualifier_attr_value_to)

Line 245: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE_TO;

241:
242: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,p_old_QUALIFIERS_rec.qualifier_attr_value_to)
243: THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE_TO;
246: END IF;
247:
248:
249:

Line 255: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_CONTEXT;

251:
252: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,p_old_QUALIFIERS_rec.qualifier_context)
253: THEN
254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_CONTEXT;
256: END IF;
257:
258: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,p_old_QUALIFIERS_rec.qualifier_datatype)
259: THEN

Line 261: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATATYPE;

257:
258: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,p_old_QUALIFIERS_rec.qualifier_datatype)
259: THEN
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATATYPE;
262: END IF;
263:
264: /* IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,p_old_QUALIFIERS_rec.qualifier_date_format)
265: THEN

Line 267: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATE_FORMAT;

263:
264: /* IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,p_old_QUALIFIERS_rec.qualifier_date_format)
265: THEN
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATE_FORMAT;
268: END IF;*/
269:
270: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,p_old_QUALIFIERS_rec.qualifier_grouping_no)
271: THEN

Line 273: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_GROUPING_NO;

269:
270: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,p_old_QUALIFIERS_rec.qualifier_grouping_no)
271: THEN
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_GROUPING_NO;
274: END IF;
275:
276: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,p_old_QUALIFIERS_rec.qualifier_id)
277: THEN

Line 279: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER;

275:
276: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,p_old_QUALIFIERS_rec.qualifier_id)
277: THEN
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER;
280: END IF;
281:
282: /* IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,p_old_QUALIFIERS_rec.qualifier_number_format)
283: THEN

Line 285: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_NUMBER_FORMAT;

281:
282: /* IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,p_old_QUALIFIERS_rec.qualifier_number_format)
283: THEN
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_NUMBER_FORMAT;
286: END IF;*/
287:
288: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,p_old_QUALIFIERS_rec.qualifier_precedence)
289: THEN

Line 291: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_PRECEDENCE;

287:
288: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,p_old_QUALIFIERS_rec.qualifier_precedence)
289: THEN
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_PRECEDENCE;
292: END IF;
293:
294: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,p_old_QUALIFIERS_rec.qualifier_rule_id)
295: THEN

Line 297: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_RULE;

293:
294: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,p_old_QUALIFIERS_rec.qualifier_rule_id)
295: THEN
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_RULE;
298: END IF;
299:
300: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,p_old_QUALIFIERS_rec.request_id)
301: THEN

Line 303: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_REQUEST;

299:
300: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,p_old_QUALIFIERS_rec.request_id)
301: THEN
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_REQUEST;
304: END IF;
305:
306: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,p_old_QUALIFIERS_rec.start_date_active)
307: THEN

Line 309: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_START_DATE_ACTIVE;

305:
306: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,p_old_QUALIFIERS_rec.start_date_active)
307: THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_START_DATE_ACTIVE;
310: END IF;
311: -- Added for TCA
312: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualify_hier_descendent_flag,p_old_QUALIFIERS_rec.qualify_hier_descendent_flag)
313: THEN

Line 315: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFY_HIER_DESCENDENT_FLAG;

311: -- Added for TCA
312: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualify_hier_descendent_flag,p_old_QUALIFIERS_rec.qualify_hier_descendent_flag)
313: THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFY_HIER_DESCENDENT_FLAG;
316: END IF;
317:
318: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
319: l_index := l_index + 1;

Line 320: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE1;

316: END IF;
317:
318: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
319: l_index := l_index + 1;
320: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE1;
321: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
322: l_index := l_index + 1;
323: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE10;
324: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 323: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE10;

319: l_index := l_index + 1;
320: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE1;
321: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
322: l_index := l_index + 1;
323: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE10;
324: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
325: l_index := l_index + 1;
326: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE11;
327: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 326: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE11;

322: l_index := l_index + 1;
323: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE10;
324: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
325: l_index := l_index + 1;
326: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE11;
327: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
328: l_index := l_index + 1;
329: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE12;
330: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 329: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE12;

325: l_index := l_index + 1;
326: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE11;
327: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
328: l_index := l_index + 1;
329: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE12;
330: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
331: l_index := l_index + 1;
332: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE13;
333: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 332: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE13;

328: l_index := l_index + 1;
329: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE12;
330: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
331: l_index := l_index + 1;
332: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE13;
333: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
334: l_index := l_index + 1;
335: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE14;
336: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 335: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE14;

331: l_index := l_index + 1;
332: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE13;
333: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
334: l_index := l_index + 1;
335: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE14;
336: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
337: l_index := l_index + 1;
338: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE15;
339: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 338: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE15;

334: l_index := l_index + 1;
335: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE14;
336: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
337: l_index := l_index + 1;
338: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE15;
339: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
340: l_index := l_index + 1;
341: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE2;
342: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 341: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE2;

337: l_index := l_index + 1;
338: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE15;
339: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
340: l_index := l_index + 1;
341: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE2;
342: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
343: l_index := l_index + 1;
344: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE3;
345: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 344: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE3;

340: l_index := l_index + 1;
341: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE2;
342: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
343: l_index := l_index + 1;
344: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE3;
345: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
346: l_index := l_index + 1;
347: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE4;
348: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 347: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE4;

343: l_index := l_index + 1;
344: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE3;
345: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
346: l_index := l_index + 1;
347: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE4;
348: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
349: l_index := l_index + 1;
350: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE5;
351: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 350: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE5;

346: l_index := l_index + 1;
347: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE4;
348: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
349: l_index := l_index + 1;
350: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE5;
351: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
352: l_index := l_index + 1;
353: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE6;
354: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 353: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE6;

349: l_index := l_index + 1;
350: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE5;
351: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
352: l_index := l_index + 1;
353: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE6;
354: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
355: l_index := l_index + 1;
356: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE7;
357: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 356: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE7;

352: l_index := l_index + 1;
353: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE6;
354: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
355: l_index := l_index + 1;
356: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE7;
357: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
358: l_index := l_index + 1;
359: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE8;
360: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 359: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE8;

355: l_index := l_index + 1;
356: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE7;
357: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
358: l_index := l_index + 1;
359: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE8;
360: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
361: l_index := l_index + 1;
362: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE9;
363: ELSIF p_attr_id = G_COMPARISON_OPERATOR THEN

Line 362: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE9;

358: l_index := l_index + 1;
359: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE8;
360: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
361: l_index := l_index + 1;
362: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE9;
363: ELSIF p_attr_id = G_COMPARISON_OPERATOR THEN
364: l_index := l_index + 1;
365: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_COMPARISON_OPERATOR;
366: ELSIF p_attr_id = G_CONTEXT THEN

Line 365: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_COMPARISON_OPERATOR;

361: l_index := l_index + 1;
362: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE9;
363: ELSIF p_attr_id = G_COMPARISON_OPERATOR THEN
364: l_index := l_index + 1;
365: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_COMPARISON_OPERATOR;
366: ELSIF p_attr_id = G_CONTEXT THEN
367: l_index := l_index + 1;
368: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CONTEXT;
369: ELSIF p_attr_id = G_CREATED_BY THEN

Line 368: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CONTEXT;

364: l_index := l_index + 1;
365: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_COMPARISON_OPERATOR;
366: ELSIF p_attr_id = G_CONTEXT THEN
367: l_index := l_index + 1;
368: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CONTEXT;
369: ELSIF p_attr_id = G_CREATED_BY THEN
370: l_index := l_index + 1;
371: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_BY;
372: ELSIF p_attr_id = G_CREATED_FROM_RULE THEN

Line 371: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_BY;

367: l_index := l_index + 1;
368: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CONTEXT;
369: ELSIF p_attr_id = G_CREATED_BY THEN
370: l_index := l_index + 1;
371: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_BY;
372: ELSIF p_attr_id = G_CREATED_FROM_RULE THEN
373: l_index := l_index + 1;
374: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_FROM_RULE;
375: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 374: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_FROM_RULE;

370: l_index := l_index + 1;
371: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_BY;
372: ELSIF p_attr_id = G_CREATED_FROM_RULE THEN
373: l_index := l_index + 1;
374: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_FROM_RULE;
375: ELSIF p_attr_id = G_CREATION_DATE THEN
376: l_index := l_index + 1;
377: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATION_DATE;
378: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN

Line 377: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATION_DATE;

373: l_index := l_index + 1;
374: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_FROM_RULE;
375: ELSIF p_attr_id = G_CREATION_DATE THEN
376: l_index := l_index + 1;
377: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATION_DATE;
378: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
379: l_index := l_index + 1;
380: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_END_DATE_ACTIVE;
381: ELSIF p_attr_id = G_EXCLUDER THEN

Line 380: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_END_DATE_ACTIVE;

376: l_index := l_index + 1;
377: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATION_DATE;
378: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
379: l_index := l_index + 1;
380: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_END_DATE_ACTIVE;
381: ELSIF p_attr_id = G_EXCLUDER THEN
382: l_index := l_index + 1;
383: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_EXCLUDER;
384: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 383: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_EXCLUDER;

379: l_index := l_index + 1;
380: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_END_DATE_ACTIVE;
381: ELSIF p_attr_id = G_EXCLUDER THEN
382: l_index := l_index + 1;
383: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_EXCLUDER;
384: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
385: l_index := l_index + 1;
386: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;
387: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 386: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;

382: l_index := l_index + 1;
383: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_EXCLUDER;
384: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
385: l_index := l_index + 1;
386: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;
387: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
388: l_index := l_index + 1;
389: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;
390: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 389: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;

385: l_index := l_index + 1;
386: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;
387: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
388: l_index := l_index + 1;
389: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;
390: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
391: l_index := l_index + 1;
392: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
393: ELSIF p_attr_id = G_LIST_HEADER THEN

Line 392: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;

388: l_index := l_index + 1;
389: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;
390: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
391: l_index := l_index + 1;
392: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
393: ELSIF p_attr_id = G_LIST_HEADER THEN
394: l_index := l_index + 1;
395: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_HEADER;
396: ELSIF p_attr_id = G_LIST_LINE THEN

Line 395: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_HEADER;

391: l_index := l_index + 1;
392: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
393: ELSIF p_attr_id = G_LIST_HEADER THEN
394: l_index := l_index + 1;
395: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_HEADER;
396: ELSIF p_attr_id = G_LIST_LINE THEN
397: l_index := l_index + 1;
398: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_LINE;
399: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN

Line 398: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_LINE;

394: l_index := l_index + 1;
395: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_HEADER;
396: ELSIF p_attr_id = G_LIST_LINE THEN
397: l_index := l_index + 1;
398: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_LINE;
399: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
400: l_index := l_index + 1;
401: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_APPLICATION;
402: ELSIF p_attr_id = G_PROGRAM THEN

Line 401: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_APPLICATION;

397: l_index := l_index + 1;
398: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_LINE;
399: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
400: l_index := l_index + 1;
401: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_APPLICATION;
402: ELSIF p_attr_id = G_PROGRAM THEN
403: l_index := l_index + 1;
404: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM;
405: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN

Line 404: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM;

400: l_index := l_index + 1;
401: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_APPLICATION;
402: ELSIF p_attr_id = G_PROGRAM THEN
403: l_index := l_index + 1;
404: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM;
405: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
406: l_index := l_index + 1;
407: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
408: ELSIF p_attr_id = G_QUALIFIER_ATTRIBUTE THEN

Line 407: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;

403: l_index := l_index + 1;
404: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM;
405: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
406: l_index := l_index + 1;
407: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
408: ELSIF p_attr_id = G_QUALIFIER_ATTRIBUTE THEN
409: l_index := l_index + 1;
410: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTRIBUTE;
411: ELSIF p_attr_id = G_QUALIFIER_ATTR_VALUE THEN

Line 410: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTRIBUTE;

406: l_index := l_index + 1;
407: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
408: ELSIF p_attr_id = G_QUALIFIER_ATTRIBUTE THEN
409: l_index := l_index + 1;
410: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTRIBUTE;
411: ELSIF p_attr_id = G_QUALIFIER_ATTR_VALUE THEN
412: l_index := l_index + 1;
413: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE;
414: ELSIF p_attr_id = G_QUALIFIER_ATTR_VALUE_TO THEN

Line 413: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE;

409: l_index := l_index + 1;
410: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTRIBUTE;
411: ELSIF p_attr_id = G_QUALIFIER_ATTR_VALUE THEN
412: l_index := l_index + 1;
413: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE;
414: ELSIF p_attr_id = G_QUALIFIER_ATTR_VALUE_TO THEN
415: l_index := l_index + 1;
416: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE_TO;
417: ELSIF p_attr_id = G_QUALIFIER_CONTEXT THEN

Line 416: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE_TO;

412: l_index := l_index + 1;
413: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE;
414: ELSIF p_attr_id = G_QUALIFIER_ATTR_VALUE_TO THEN
415: l_index := l_index + 1;
416: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE_TO;
417: ELSIF p_attr_id = G_QUALIFIER_CONTEXT THEN
418: l_index := l_index + 1;
419: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_CONTEXT;
420: ELSIF p_attr_id = G_QUALIFIER_DATATYPE THEN

Line 419: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_CONTEXT;

415: l_index := l_index + 1;
416: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE_TO;
417: ELSIF p_attr_id = G_QUALIFIER_CONTEXT THEN
418: l_index := l_index + 1;
419: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_CONTEXT;
420: ELSIF p_attr_id = G_QUALIFIER_DATATYPE THEN
421: l_index := l_index + 1;
422: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATATYPE;
423: --ELSIF p_attr_id = G_QUALIFIER_DATE_FORMAT THEN

Line 422: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATATYPE;

418: l_index := l_index + 1;
419: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_CONTEXT;
420: ELSIF p_attr_id = G_QUALIFIER_DATATYPE THEN
421: l_index := l_index + 1;
422: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATATYPE;
423: --ELSIF p_attr_id = G_QUALIFIER_DATE_FORMAT THEN
424: -- l_index := l_index + 1;
425: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATE_FORMAT;
426: ELSIF p_attr_id = G_QUALIFIER_GROUPING_NO THEN

Line 425: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATE_FORMAT;

421: l_index := l_index + 1;
422: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATATYPE;
423: --ELSIF p_attr_id = G_QUALIFIER_DATE_FORMAT THEN
424: -- l_index := l_index + 1;
425: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATE_FORMAT;
426: ELSIF p_attr_id = G_QUALIFIER_GROUPING_NO THEN
427: l_index := l_index + 1;
428: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_GROUPING_NO;
429: ELSIF p_attr_id = G_QUALIFIER THEN

Line 428: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_GROUPING_NO;

424: -- l_index := l_index + 1;
425: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATE_FORMAT;
426: ELSIF p_attr_id = G_QUALIFIER_GROUPING_NO THEN
427: l_index := l_index + 1;
428: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_GROUPING_NO;
429: ELSIF p_attr_id = G_QUALIFIER THEN
430: l_index := l_index + 1;
431: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER;
432: --ELSIF p_attr_id = G_QUALIFIER_NUMBER_FORMAT THEN

Line 431: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER;

427: l_index := l_index + 1;
428: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_GROUPING_NO;
429: ELSIF p_attr_id = G_QUALIFIER THEN
430: l_index := l_index + 1;
431: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER;
432: --ELSIF p_attr_id = G_QUALIFIER_NUMBER_FORMAT THEN
433: -- l_index := l_index + 1;
434: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_NUMBER_FORMAT;
435: ELSIF p_attr_id = G_QUALIFIER_PRECEDENCE THEN

Line 434: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_NUMBER_FORMAT;

430: l_index := l_index + 1;
431: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER;
432: --ELSIF p_attr_id = G_QUALIFIER_NUMBER_FORMAT THEN
433: -- l_index := l_index + 1;
434: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_NUMBER_FORMAT;
435: ELSIF p_attr_id = G_QUALIFIER_PRECEDENCE THEN
436: l_index := l_index + 1;
437: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_PRECEDENCE;
438: ELSIF p_attr_id = G_QUALIFIER_RULE THEN

Line 437: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_PRECEDENCE;

433: -- l_index := l_index + 1;
434: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_NUMBER_FORMAT;
435: ELSIF p_attr_id = G_QUALIFIER_PRECEDENCE THEN
436: l_index := l_index + 1;
437: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_PRECEDENCE;
438: ELSIF p_attr_id = G_QUALIFIER_RULE THEN
439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_RULE;
441: ELSIF p_attr_id = G_REQUEST THEN

Line 440: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_RULE;

436: l_index := l_index + 1;
437: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_PRECEDENCE;
438: ELSIF p_attr_id = G_QUALIFIER_RULE THEN
439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_RULE;
441: ELSIF p_attr_id = G_REQUEST THEN
442: l_index := l_index + 1;
443: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_REQUEST;
444: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN

Line 443: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_REQUEST;

439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_RULE;
441: ELSIF p_attr_id = G_REQUEST THEN
442: l_index := l_index + 1;
443: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_REQUEST;
444: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
445: l_index := l_index + 1;
446: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_START_DATE_ACTIVE;
447: -- Added for TCA

Line 446: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_START_DATE_ACTIVE;

442: l_index := l_index + 1;
443: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_REQUEST;
444: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
445: l_index := l_index + 1;
446: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_START_DATE_ACTIVE;
447: -- Added for TCA
448: ELSIF p_attr_id = G_QUALIFY_HIER_DESCENDENT_FLAG THEN
449: l_index := l_index + 1;
450: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFY_HIER_DESCENDENT_FLAG;

Line 450: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFY_HIER_DESCENDENT_FLAG;

446: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_START_DATE_ACTIVE;
447: -- Added for TCA
448: ELSIF p_attr_id = G_QUALIFY_HIER_DESCENDENT_FLAG THEN
449: l_index := l_index + 1;
450: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFY_HIER_DESCENDENT_FLAG;
451: END IF;
452:
453: END Clear_Dependent_Attr;
454:

Line 1115: UPDATE QP_QUALIFIERS

1111: WHEN OTHERS THEN
1112: NULL;
1113: END;
1114:
1115: UPDATE QP_QUALIFIERS
1116: SET ATTRIBUTE1 = p_QUALIFIERS_rec.attribute1
1117: , ATTRIBUTE10 = p_QUALIFIERS_rec.attribute10
1118: , ATTRIBUTE11 = p_QUALIFIERS_rec.attribute11
1119: , ATTRIBUTE12 = p_QUALIFIERS_rec.attribute12

Line 1318: INSERT INTO QP_QUALIFIERS

1314: NULL;
1315:
1316: END;
1317:
1318: INSERT INTO QP_QUALIFIERS
1319: ( ATTRIBUTE1
1320: , ATTRIBUTE10
1321: , ATTRIBUTE11
1322: , ATTRIBUTE12

Line 1494: insert into qp_qualifiers_fwk_dummy

1490: p_transaction_id IN NUMBER) IS
1491: PRAGMA AUTONOMOUS_TRANSACTION;
1492: BEGIN
1493:
1494: insert into qp_qualifiers_fwk_dummy
1495: ( ATTRIBUTE1
1496: , ATTRIBUTE10
1497: , ATTRIBUTE11
1498: , ATTRIBUTE12

Line 1611: from qp_qualifiers qual

1607: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1608: ,to_char(qualifier_id)
1609: ,nvl(ORIG_SYS_LINE_REF,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id))
1610: ,nvl(ORIG_SYS_HEADER_REF,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id))
1611: from qp_qualifiers qual
1612: where list_header_id = p_list_header_id
1613: and list_line_id = p_list_line_id
1614: and ((p_qual_grp_no = -1
1615: and qualifier_grouping_no = p_qual_grp_no)

Line 1622: and not exists (select 'Y' from qp_qualifiers_fwk_dummy dummy

1618: or qualifier_grouping_no = p_qual_grp_no)))
1619: and ((qual.list_type_code = 'PRL'
1620: and not (qual.qualifier_context = 'MODLIST' and qual.qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'))
1621: or (qual.list_type_code <> 'PRL'))
1622: and not exists (select 'Y' from qp_qualifiers_fwk_dummy dummy
1623: where dummy.qualifier_id = qual.qualifier_id
1624: and dummy.transaction_id = p_transaction_id);
1625:
1626: --AUTONOMOUS commit

Line 1638: delete from qp_qualifiers_fwk_dummy where transaction_id = p_transaction_id

1634: --to delete rows from dummy table
1635: Procedure Delete_Dummy_Rows(p_transaction_id IN NUMBER) IS
1636: PRAGMA AUTONOMOUS_TRANSACTION;
1637: BEGIN
1638: delete from qp_qualifiers_fwk_dummy where transaction_id = p_transaction_id
1639: or last_update_date < sysdate-5;
1640: -- where list_header_id = p_list_header_id
1641: -- and list_line_id = p_list_line_id;
1642:

Line 1656: update qp_qualifiers_fwk_dummy set header_quals_exist_flag = decode(p_mode, 'HGRID', 'X', 'D'),

1652: ,p_mode IN VARCHAR2
1653: ,p_transaction_id IN NUMBER) IS
1654: PRAGMA AUTONOMOUS_TRANSACTION;
1655: BEGIN
1656: update qp_qualifiers_fwk_dummy set header_quals_exist_flag = decode(p_mode, 'HGRID', 'X', 'D'),
1657: last_update_date = sysdate
1658: where qualifier_id = p_qual_id
1659: and transaction_id = p_transaction_id;
1660:

Line 1662: insert into qp_qualifiers_fwk_dummy

1658: where qualifier_id = p_qual_id
1659: and transaction_id = p_transaction_id;
1660:
1661: IF SQL%ROWCOUNT < 1 THEN
1662: insert into qp_qualifiers_fwk_dummy
1663: ( ATTRIBUTE1
1664: , ATTRIBUTE10
1665: , ATTRIBUTE11
1666: , ATTRIBUTE12

Line 1779: from qp_qualifiers qual

1775: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1776: ,to_char(qual.qualifier_id)
1777: ,nvl(qual.ORIG_SYS_LINE_REF,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=qual.list_line_id))
1778: ,nvl(qual.ORIG_SYS_HEADER_REF,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=qual.list_header_id))
1779: from qp_qualifiers qual
1780: where qualifier_id = p_qual_id;
1781: END IF;--SQL%ROWCOUNT
1782: --AUTONOMOUS commit
1783: commit;

Line 1796: update qp_qualifiers_fwk_dummy set header_quals_exist_flag = 'X'

1792: p_list_line_id IN NUMBER,
1793: p_transaction_id IN NUMBER) IS
1794: PRAGMA AUTONOMOUS_TRANSACTION;
1795: BEGIN
1796: update qp_qualifiers_fwk_dummy set header_quals_exist_flag = 'X'
1797: ,last_update_date = sysdate
1798: where qualifier_grouping_no = p_qual_grp_no
1799: and list_header_id = p_list_header_id
1800: and list_line_id = p_list_line_id

Line 1807: insert into qp_qualifiers_fwk_dummy

1803: or (list_type_code <> 'PRL'))
1804: and transaction_id = p_transaction_id;
1805:
1806: IF SQL%ROWCOUNT < 1 THEN
1807: insert into qp_qualifiers_fwk_dummy
1808: ( ATTRIBUTE1
1809: , ATTRIBUTE10
1810: , ATTRIBUTE11
1811: , ATTRIBUTE12

Line 1924: from qp_qualifiers qual

1920: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1921: ,to_char(qualifier_id)
1922: ,nvl(ORIG_SYS_LINE_REF,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id))
1923: ,nvl(ORIG_SYS_HEADER_REF,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id))
1924: from qp_qualifiers qual
1925: where list_header_id = p_list_header_id
1926: and list_line_id = p_list_line_id
1927: and qualifier_grouping_no = p_qual_grp_no
1928: and ((qual.list_type_code = 'PRL'

Line 1947: delete from qp_qualifiers_fwk_dummy

1943: p_transaction_id IN NUMBER) IS
1944: PRAGMA AUTONOMOUS_TRANSACTION;
1945: BEGIN
1946: IF p_action_type = 'CANCEL' THEN
1947: delete from qp_qualifiers_fwk_dummy
1948: where list_header_id = p_list_header_id
1949: and list_line_id = p_list_line_id
1950: and transaction_id = p_transaction_id
1951: and nvl(header_quals_exist_flag, 'N') in ('Q');--, 'D', 'U', 'N');

Line 1953: delete from qp_qualifiers_fwk_dummy

1949: and list_line_id = p_list_line_id
1950: and transaction_id = p_transaction_id
1951: and nvl(header_quals_exist_flag, 'N') in ('Q');--, 'D', 'U', 'N');
1952: ELSIF p_action_type = 'APPLY' THEN
1953: delete from qp_qualifiers_fwk_dummy
1954: where list_header_id = p_list_header_id
1955: and list_line_id = p_list_line_id
1956: and transaction_id = p_transaction_id
1957: and nvl(header_quals_exist_flag, 'N') = 'Q';

Line 1981: DELETE FROM QP_QUALIFIERS

1977: -- l_qualifiers_rec:=Query_Row(p_qualifier_id);
1978: IF p_qualifier_rule_id <> FND_API.G_MISS_NUM
1979: THEN
1980:
1981: DELETE FROM QP_QUALIFIERS
1982: WHERE QUALIFIER_RULE_ID = p_qualifier_rule_id ;
1983: ELSE
1984:
1985: DELETE FROM QP_QUALIFIERS

Line 1985: DELETE FROM QP_QUALIFIERS

1981: DELETE FROM QP_QUALIFIERS
1982: WHERE QUALIFIER_RULE_ID = p_qualifier_rule_id ;
1983: ELSE
1984:
1985: DELETE FROM QP_QUALIFIERS
1986: WHERE QUALIFIER_ID = p_qualifier_id ;
1987:
1988: END IF;
1989:

Line 2037: delete from qp_qualifiers_fwk_dummy

2033: IS
2034: PRAGMA AUTONOMOUS_TRANSACTION;
2035: BEGIN
2036:
2037: delete from qp_qualifiers_fwk_dummy
2038: where transaction_id = p_transaction_id
2039: or last_update_date < sysdate - 5;
2040: --where qualifier_grouping_no = p_qual_grp_no
2041: --and list_header_id = p_list_header_id

Line 2132: FROM QP_QUALIFIERS

2128: , QUALIFIER_GROUP_CNT
2129: , HEADER_QUALS_EXIST_FLAG
2130: , DISTINCT_ROW_COUNT
2131: , QUALIFY_HIER_DESCENDENTS_FLAG -- Added for TCA
2132: FROM QP_QUALIFIERS
2133: WHERE ( QUALIFIER_ID = p_qualifier_id
2134: )
2135: OR ( QUALIFIER_RULE_ID = p_qualifier_rule_id
2136: );

Line 2367: FROM QP_QUALIFIERS

2363: , l_QUALIFIERS_rec.qualifier_rule_id
2364: , l_QUALIFIERS_rec.request_id
2365: , l_QUALIFIERS_rec.start_date_active
2366: , l_QUALIFIERS_rec.qualify_hier_descendent_flag -- Added for TCA
2367: FROM QP_QUALIFIERS
2368: WHERE QUALIFIER_ID = p_QUALIFIERS_rec.qualifier_id
2369: FOR UPDATE NOWAIT;
2370:
2371: -- Row locked. Compare IN attributes to DB attributes.

Line 3087: FROM qp_qualifiers

3083: /*SELECT 1
3084: INTO l_hlq_count
3085: FROM DUAL
3086: WHERE EXISTS (SELECT 'X'
3087: FROM qp_qualifiers
3088: WHERE list_header_id = p_QUALIFIERS_rec.list_header_id
3089: AND list_line_id = -1
3090: AND NOT (qualifier_context = 'MODLIST' AND
3091: qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'));*/

Line 3096: FROM qp_qualifiers

3092:
3093: /* changed the sql query from where exists to 'and rownum=1'*/
3094:
3095: SELECT 1 into l_hlq_count
3096: FROM qp_qualifiers
3097: WHERE list_header_id = p_QUALIFIERS_rec.list_header_id
3098: AND list_line_id = -1
3099: AND NOT (qualifier_context = 'MODLIST' AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE4')
3100: and rownum=1;

Line 3114: FROM qp_qualifiers

3110: /*SELECT 1
3111: INTO l_hlq_count
3112: FROM DUAL
3113: WHERE EXISTS (SELECT 'X'
3114: FROM qp_qualifiers
3115: WHERE list_header_id = p_QUALIFIERS_rec.list_header_id
3116: AND list_line_id = -1); */
3117:
3118: /* changed the sql query from where exists to 'and rownum=1'*/

Line 3120: FROM qp_qualifiers

3116: AND list_line_id = -1); */
3117:
3118: /* changed the sql query from where exists to 'and rownum=1'*/
3119: SELECT 1 into l_hlq_count
3120: FROM qp_qualifiers
3121: WHERE list_header_id = p_QUALIFIERS_rec.list_header_id
3122: AND list_line_id = -1
3123: and rownum = 1;
3124: EXCEPTION

Line 3137: FROM qp_qualifiers

3133: BEGIN
3134: /* SELECT 1 INTO l_llq_count
3135: FROM DUAL
3136: WHERE EXISTS ( SELECT 'X'
3137: FROM qp_qualifiers
3138: WHERE list_line_id = p_QUALIFIERS_rec.list_line_id);*/
3139:
3140: /* changed the sql query from where exists to 'and rownum=1'*/
3141: SELECT 1 into l_llq_count

Line 3142: FROM qp_qualifiers

3138: WHERE list_line_id = p_QUALIFIERS_rec.list_line_id);*/
3139:
3140: /* changed the sql query from where exists to 'and rownum=1'*/
3141: SELECT 1 into l_llq_count
3142: FROM qp_qualifiers
3143: WHERE list_line_id = p_QUALIFIERS_rec.list_line_id
3144: and rownum=1;
3145: EXCEPTION
3146: WHEN NO_DATA_FOUND THEN

Line 3340: from qp_qualifiers

3336: and p_qualifiers_rec.operation = QP_GLOBALS.G_OPR_UPDATE then
3337: declare
3338: cursor c_qual_grp is
3339: select distinct qualifier_grouping_no qualifier_grouping_no
3340: from qp_qualifiers
3341: where list_header_id = p_qualifiers_rec.list_header_id
3342: and list_line_id = p_qualifiers_rec.list_line_id
3343: and qualifier_grouping_no <> -1;
3344: begin

Line 3634: END QP_Qualifiers_Util;

3630: END IF;
3631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3632: END Pre_Write_Process;
3633:
3634: END QP_Qualifiers_Util;