47: BEGIN
48:
49: -- In the future call Flex APIs for defaults
50:
51: IF g_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
52: g_QUALIFIER_RULES_rec.attribute1 := NULL;
53: END IF;
54:
55: IF g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
51: IF g_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
52: g_QUALIFIER_RULES_rec.attribute1 := NULL;
53: END IF;
54:
55: IF g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
56: g_QUALIFIER_RULES_rec.attribute10 := NULL;
57: END IF;
58:
59: IF g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
55: IF g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
56: g_QUALIFIER_RULES_rec.attribute10 := NULL;
57: END IF;
58:
59: IF g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
60: g_QUALIFIER_RULES_rec.attribute11 := NULL;
61: END IF;
62:
63: IF g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
59: IF g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
60: g_QUALIFIER_RULES_rec.attribute11 := NULL;
61: END IF;
62:
63: IF g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
64: g_QUALIFIER_RULES_rec.attribute12 := NULL;
65: END IF;
66:
67: IF g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
63: IF g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
64: g_QUALIFIER_RULES_rec.attribute12 := NULL;
65: END IF;
66:
67: IF g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
68: g_QUALIFIER_RULES_rec.attribute13 := NULL;
69: END IF;
70:
71: IF g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
67: IF g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
68: g_QUALIFIER_RULES_rec.attribute13 := NULL;
69: END IF;
70:
71: IF g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
72: g_QUALIFIER_RULES_rec.attribute14 := NULL;
73: END IF;
74:
75: IF g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
71: IF g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
72: g_QUALIFIER_RULES_rec.attribute14 := NULL;
73: END IF;
74:
75: IF g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
76: g_QUALIFIER_RULES_rec.attribute15 := NULL;
77: END IF;
78:
79: IF g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
75: IF g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
76: g_QUALIFIER_RULES_rec.attribute15 := NULL;
77: END IF;
78:
79: IF g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
80: g_QUALIFIER_RULES_rec.attribute2 := NULL;
81: END IF;
82:
83: IF g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
79: IF g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
80: g_QUALIFIER_RULES_rec.attribute2 := NULL;
81: END IF;
82:
83: IF g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
84: g_QUALIFIER_RULES_rec.attribute3 := NULL;
85: END IF;
86:
87: IF g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
83: IF g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
84: g_QUALIFIER_RULES_rec.attribute3 := NULL;
85: END IF;
86:
87: IF g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
88: g_QUALIFIER_RULES_rec.attribute4 := NULL;
89: END IF;
90:
91: IF g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
87: IF g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
88: g_QUALIFIER_RULES_rec.attribute4 := NULL;
89: END IF;
90:
91: IF g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
92: g_QUALIFIER_RULES_rec.attribute5 := NULL;
93: END IF;
94:
95: IF g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
91: IF g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
92: g_QUALIFIER_RULES_rec.attribute5 := NULL;
93: END IF;
94:
95: IF g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
96: g_QUALIFIER_RULES_rec.attribute6 := NULL;
97: END IF;
98:
99: IF g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
95: IF g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
96: g_QUALIFIER_RULES_rec.attribute6 := NULL;
97: END IF;
98:
99: IF g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
100: g_QUALIFIER_RULES_rec.attribute7 := NULL;
101: END IF;
102:
103: IF g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
99: IF g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
100: g_QUALIFIER_RULES_rec.attribute7 := NULL;
101: END IF;
102:
103: IF g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
104: g_QUALIFIER_RULES_rec.attribute8 := NULL;
105: END IF;
106:
107: IF g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
103: IF g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
104: g_QUALIFIER_RULES_rec.attribute8 := NULL;
105: END IF;
106:
107: IF g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
108: g_QUALIFIER_RULES_rec.attribute9 := NULL;
109: END IF;
110:
111: IF g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR THEN
107: IF g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
108: g_QUALIFIER_RULES_rec.attribute9 := NULL;
109: END IF;
110:
111: IF g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR THEN
112: g_QUALIFIER_RULES_rec.context := NULL;
113: END IF;
114:
115: END Get_Flex_Qualifier_Rules;
136: OE_MSG_PUB.Add;
137:
138: END IF;
139:
140: RAISE FND_API.G_EXC_ERROR;
141:
142: END IF;
143:
144: -- Initialize g_QUALIFIER_RULES_rec
146: g_QUALIFIER_RULES_rec := p_QUALIFIER_RULES_rec;
147:
148: -- Default missing attributes.
149:
150: IF g_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR THEN
151:
152: g_QUALIFIER_RULES_rec.description := Get_Description;
153:
154: IF g_QUALIFIER_RULES_rec.description IS NOT NULL THEN
168: END IF;
169:
170: END IF;
171:
172: IF g_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR THEN
173:
174: g_QUALIFIER_RULES_rec.name := Get_Name;
175:
176: IF g_QUALIFIER_RULES_rec.name IS NOT NULL THEN
190: END IF;
191:
192: END IF;
193:
194: IF g_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
195:
196: --dbms_output.put_line('calling get_qualifierrule id to generate rule id');
197: oe_debug_pub.add('calling get_qualifierrule id to generate rule id');
198:
220: END IF;
221:
222: END IF;
223:
224: IF g_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR
225: OR g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR
226: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
227: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
228: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
221:
222: END IF;
223:
224: IF g_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR
225: OR g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR
226: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
227: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
228: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
229: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
222: END IF;
223:
224: IF g_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR
225: OR g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR
226: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
227: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
228: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
229: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
230: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
223:
224: IF g_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR
225: OR g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR
226: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
227: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
228: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
229: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
230: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
231: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
224: IF g_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR
225: OR g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR
226: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
227: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
228: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
229: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
230: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
231: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
232: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
225: OR g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR
226: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
227: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
228: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
229: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
230: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
231: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
232: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
233: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
226: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
227: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
228: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
229: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
230: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
231: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
232: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
233: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
234: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
227: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
228: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
229: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
230: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
231: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
232: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
233: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
234: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
235: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
228: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
229: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
230: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
231: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
232: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
233: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
234: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
235: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
236: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
229: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
230: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
231: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
232: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
233: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
234: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
235: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
236: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
237: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
230: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
231: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
232: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
233: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
234: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
235: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
236: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
237: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
238: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
231: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
232: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
233: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
234: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
235: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
236: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
237: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
238: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
239: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
232: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
233: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
234: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
235: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
236: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
237: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
238: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
239: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
240: THEN
233: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
234: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
235: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
236: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
237: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
238: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
239: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
240: THEN
241:
234: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
235: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
236: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
237: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
238: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
239: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
240: THEN
241:
242: Get_Flex_Qualifier_Rules;
235: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
236: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
237: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
238: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
239: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
240: THEN
241:
242: Get_Flex_Qualifier_Rules;
243:
242: Get_Flex_Qualifier_Rules;
243:
244: END IF;
245:
246: IF g_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM THEN
247:
248: g_QUALIFIER_RULES_rec.created_by := NULL;
249:
250: END IF;
248: g_QUALIFIER_RULES_rec.created_by := NULL;
249:
250: END IF;
251:
252: IF g_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE THEN
253:
254: g_QUALIFIER_RULES_rec.creation_date := NULL;
255:
256: END IF;
254: g_QUALIFIER_RULES_rec.creation_date := NULL;
255:
256: END IF;
257:
258: IF g_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
259:
260: g_QUALIFIER_RULES_rec.last_updated_by := NULL;
261:
262: END IF;
260: g_QUALIFIER_RULES_rec.last_updated_by := NULL;
261:
262: END IF;
263:
264: IF g_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE THEN
265:
266: g_QUALIFIER_RULES_rec.last_update_date := NULL;
267:
268: END IF;
266: g_QUALIFIER_RULES_rec.last_update_date := NULL;
267:
268: END IF;
269:
270: IF g_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM THEN
271:
272: g_QUALIFIER_RULES_rec.last_update_login := NULL;
273:
274: END IF;
272: g_QUALIFIER_RULES_rec.last_update_login := NULL;
273:
274: END IF;
275:
276: IF g_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM THEN
277:
278: g_QUALIFIER_RULES_rec.program_application_id := NULL;
279:
280: END IF;
278: g_QUALIFIER_RULES_rec.program_application_id := NULL;
279:
280: END IF;
281:
282: IF g_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM THEN
283:
284: g_QUALIFIER_RULES_rec.program_id := NULL;
285:
286: END IF;
284: g_QUALIFIER_RULES_rec.program_id := NULL;
285:
286: END IF;
287:
288: IF g_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE THEN
289:
290: g_QUALIFIER_RULES_rec.program_update_date := NULL;
291:
292: END IF;
290: g_QUALIFIER_RULES_rec.program_update_date := NULL;
291:
292: END IF;
293:
294: IF g_QUALIFIER_RULES_rec.request_id = FND_API.G_MISS_NUM THEN
295:
296: g_QUALIFIER_RULES_rec.request_id := NULL;
297:
298: END IF;
298: END IF;
299:
300: -- Redefault if there are any missing attributes.
301:
302: IF g_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR
303: OR g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR
304: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
305: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
306: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
299:
300: -- Redefault if there are any missing attributes.
301:
302: IF g_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR
303: OR g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR
304: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
305: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
306: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
307: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
300: -- Redefault if there are any missing attributes.
301:
302: IF g_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR
303: OR g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR
304: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
305: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
306: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
307: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
308: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
301:
302: IF g_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR
303: OR g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR
304: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
305: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
306: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
307: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
308: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
309: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
302: IF g_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR
303: OR g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR
304: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
305: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
306: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
307: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
308: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
309: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
310: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
303: OR g_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR
304: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
305: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
306: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
307: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
308: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
309: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
310: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
311: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
304: OR g_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR
305: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
306: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
307: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
308: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
309: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
310: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
311: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
312: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
305: OR g_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR
306: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
307: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
308: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
309: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
310: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
311: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
312: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
313: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
306: OR g_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR
307: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
308: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
309: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
310: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
311: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
312: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
313: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
314: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
307: OR g_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR
308: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
309: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
310: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
311: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
312: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
313: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
314: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
315: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
308: OR g_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR
309: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
310: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
311: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
312: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
313: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
314: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
315: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
316: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
309: OR g_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR
310: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
311: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
312: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
313: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
314: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
315: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
316: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
317: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
310: OR g_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR
311: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
312: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
313: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
314: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
315: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
316: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
317: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
318: OR g_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM
311: OR g_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR
312: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
313: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
314: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
315: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
316: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
317: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
318: OR g_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM
319: OR g_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE
312: OR g_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR
313: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
314: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
315: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
316: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
317: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
318: OR g_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM
319: OR g_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE
320: OR g_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR
313: OR g_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR
314: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
315: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
316: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
317: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
318: OR g_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM
319: OR g_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE
320: OR g_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR
321: OR g_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM
314: OR g_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR
315: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
316: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
317: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
318: OR g_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM
319: OR g_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE
320: OR g_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR
321: OR g_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM
322: OR g_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE
315: OR g_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR
316: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
317: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
318: OR g_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM
319: OR g_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE
320: OR g_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR
321: OR g_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM
322: OR g_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE
323: OR g_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM
316: OR g_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR
317: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
318: OR g_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM
319: OR g_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE
320: OR g_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR
321: OR g_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM
322: OR g_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE
323: OR g_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM
324: OR g_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR
317: OR g_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR
318: OR g_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM
319: OR g_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE
320: OR g_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR
321: OR g_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM
322: OR g_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE
323: OR g_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM
324: OR g_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR
325: OR g_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM
318: OR g_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM
319: OR g_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE
320: OR g_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR
321: OR g_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM
322: OR g_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE
323: OR g_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM
324: OR g_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR
325: OR g_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM
326: OR g_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM
319: OR g_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE
320: OR g_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR
321: OR g_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM
322: OR g_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE
323: OR g_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM
324: OR g_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR
325: OR g_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM
326: OR g_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM
327: OR g_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE
320: OR g_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR
321: OR g_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM
322: OR g_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE
323: OR g_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM
324: OR g_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR
325: OR g_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM
326: OR g_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM
327: OR g_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE
328: OR g_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM
321: OR g_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM
322: OR g_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE
323: OR g_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM
324: OR g_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR
325: OR g_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM
326: OR g_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM
327: OR g_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE
328: OR g_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM
329: OR g_QUALIFIER_RULES_rec.request_id = FND_API.G_MISS_NUM
322: OR g_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE
323: OR g_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM
324: OR g_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR
325: OR g_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM
326: OR g_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM
327: OR g_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE
328: OR g_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM
329: OR g_QUALIFIER_RULES_rec.request_id = FND_API.G_MISS_NUM
330: THEN
323: OR g_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM
324: OR g_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR
325: OR g_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM
326: OR g_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM
327: OR g_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE
328: OR g_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM
329: OR g_QUALIFIER_RULES_rec.request_id = FND_API.G_MISS_NUM
330: THEN
331:
324: OR g_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR
325: OR g_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM
326: OR g_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM
327: OR g_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE
328: OR g_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM
329: OR g_QUALIFIER_RULES_rec.request_id = FND_API.G_MISS_NUM
330: THEN
331:
332: QP_Default_Qualifier_Rules.Attributes
325: OR g_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM
326: OR g_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM
327: OR g_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE
328: OR g_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM
329: OR g_QUALIFIER_RULES_rec.request_id = FND_API.G_MISS_NUM
330: THEN
331:
332: QP_Default_Qualifier_Rules.Attributes
333: ( p_QUALIFIER_RULES_rec => g_QUALIFIER_RULES_rec