DBA Data[Home] [Help]

APPS.QP_DEFAULT_PSG dependencies on FND_API

Line 112: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR THEN

108: BEGIN
109:
110: -- In the future call Flex APIs for defaults
111:
112: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
113: g_PSG_rec.attribute1 := NULL;
114: END IF;
115:
116: IF g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 116: IF g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR THEN

112: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
113: g_PSG_rec.attribute1 := NULL;
114: END IF;
115:
116: IF g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR THEN
117: g_PSG_rec.attribute10 := NULL;
118: END IF;
119:
120: IF g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 120: IF g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR THEN

116: IF g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR THEN
117: g_PSG_rec.attribute10 := NULL;
118: END IF;
119:
120: IF g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR THEN
121: g_PSG_rec.attribute11 := NULL;
122: END IF;
123:
124: IF g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 124: IF g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR THEN

120: IF g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR THEN
121: g_PSG_rec.attribute11 := NULL;
122: END IF;
123:
124: IF g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR THEN
125: g_PSG_rec.attribute12 := NULL;
126: END IF;
127:
128: IF g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 128: IF g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR THEN

124: IF g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR THEN
125: g_PSG_rec.attribute12 := NULL;
126: END IF;
127:
128: IF g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR THEN
129: g_PSG_rec.attribute13 := NULL;
130: END IF;
131:
132: IF g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 132: IF g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR THEN

128: IF g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR THEN
129: g_PSG_rec.attribute13 := NULL;
130: END IF;
131:
132: IF g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR THEN
133: g_PSG_rec.attribute14 := NULL;
134: END IF;
135:
136: IF g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 136: IF g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR THEN

132: IF g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR THEN
133: g_PSG_rec.attribute14 := NULL;
134: END IF;
135:
136: IF g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR THEN
137: g_PSG_rec.attribute15 := NULL;
138: END IF;
139:
140: IF g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 140: IF g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR THEN

136: IF g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR THEN
137: g_PSG_rec.attribute15 := NULL;
138: END IF;
139:
140: IF g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR THEN
141: g_PSG_rec.attribute2 := NULL;
142: END IF;
143:
144: IF g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 144: IF g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR THEN

140: IF g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR THEN
141: g_PSG_rec.attribute2 := NULL;
142: END IF;
143:
144: IF g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR THEN
145: g_PSG_rec.attribute3 := NULL;
146: END IF;
147:
148: IF g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 148: IF g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR THEN

144: IF g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR THEN
145: g_PSG_rec.attribute3 := NULL;
146: END IF;
147:
148: IF g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR THEN
149: g_PSG_rec.attribute4 := NULL;
150: END IF;
151:
152: IF g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 152: IF g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR THEN

148: IF g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR THEN
149: g_PSG_rec.attribute4 := NULL;
150: END IF;
151:
152: IF g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR THEN
153: g_PSG_rec.attribute5 := NULL;
154: END IF;
155:
156: IF g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 156: IF g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR THEN

152: IF g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR THEN
153: g_PSG_rec.attribute5 := NULL;
154: END IF;
155:
156: IF g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR THEN
157: g_PSG_rec.attribute6 := NULL;
158: END IF;
159:
160: IF g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 160: IF g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR THEN

156: IF g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR THEN
157: g_PSG_rec.attribute6 := NULL;
158: END IF;
159:
160: IF g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR THEN
161: g_PSG_rec.attribute7 := NULL;
162: END IF;
163:
164: IF g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 164: IF g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR THEN

160: IF g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR THEN
161: g_PSG_rec.attribute7 := NULL;
162: END IF;
163:
164: IF g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR THEN
165: g_PSG_rec.attribute8 := NULL;
166: END IF;
167:
168: IF g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 168: IF g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR THEN

164: IF g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR THEN
165: g_PSG_rec.attribute8 := NULL;
166: END IF;
167:
168: IF g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR THEN
169: g_PSG_rec.attribute9 := NULL;
170: END IF;
171:
172: IF g_PSG_rec.context = FND_API.G_MISS_CHAR THEN

Line 172: IF g_PSG_rec.context = FND_API.G_MISS_CHAR THEN

168: IF g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR THEN
169: g_PSG_rec.attribute9 := NULL;
170: END IF;
171:
172: IF g_PSG_rec.context = FND_API.G_MISS_CHAR THEN
173: g_PSG_rec.context := NULL;
174: END IF;
175:
176: END Get_Flex_Psg;

Line 202: RAISE FND_API.G_EXC_ERROR;

198: OE_MSG_PUB.Add;
199:
200: END IF;
201:
202: RAISE FND_API.G_EXC_ERROR;
203:
204: END IF;
205:
206: -- Initialize g_PSG_rec

Line 212: IF g_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR THEN

208: g_PSG_rec := p_PSG_rec;
209:
210: -- Default missing attributes.
211:
212: IF g_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR THEN
213:
214: g_PSG_rec.limits_enabled := Get_Limits_Enabled;
215:
216: IF g_PSG_rec.limits_enabled IS NOT NULL THEN

Line 234: IF g_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR THEN

230: END IF;
231:
232: END IF;
233:
234: IF g_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR THEN
235:
236: g_PSG_rec.lov_enabled := Get_Lov_Enabled;
237:
238: IF g_PSG_rec.lov_enabled IS NOT NULL THEN

Line 256: IF g_PSG_rec.pte_code = FND_API.G_MISS_CHAR THEN

252: END IF;
253:
254: END IF;
255:
256: IF g_PSG_rec.pte_code = FND_API.G_MISS_CHAR THEN
257:
258: g_PSG_rec.pte_code := Get_Pte;
259:
260: IF g_PSG_rec.pte_code IS NOT NULL THEN

Line 278: IF g_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR THEN

274: END IF;
275:
276: END IF;
277:
278: IF g_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR THEN
279:
280: g_PSG_rec.seeded_sourcing_method := Get_Seeded_Sourcing_Method;
281:
282: IF g_PSG_rec.seeded_sourcing_method IS NOT NULL THEN

Line 300: IF g_PSG_rec.segment_id = FND_API.G_MISS_NUM THEN

296: END IF;
297:
298: END IF;
299:
300: IF g_PSG_rec.segment_id = FND_API.G_MISS_NUM THEN
301:
302: g_PSG_rec.segment_id := Get_Segment;
303:
304: IF g_PSG_rec.segment_id IS NOT NULL THEN

Line 322: IF g_PSG_rec.segment_level = FND_API.G_MISS_CHAR THEN

318: END IF;
319:
320: END IF;
321:
322: IF g_PSG_rec.segment_level = FND_API.G_MISS_CHAR THEN
323:
324: g_PSG_rec.segment_level := Get_Segment_Level;
325:
326: IF g_PSG_rec.segment_level IS NOT NULL THEN

Line 344: IF g_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM THEN

340: END IF;
341:
342: END IF;
343:
344: IF g_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM THEN
345:
346: g_PSG_rec.segment_pte_id := Get_Segment_Pte;
347:
348: IF g_PSG_rec.segment_pte_id IS NOT NULL THEN

Line 366: IF g_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR THEN

362: END IF;
363:
364: END IF;
365:
366: IF g_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR THEN
367:
368: g_PSG_rec.sourcing_enabled := Get_Sourcing_Enabled;
369:
370: IF g_PSG_rec.sourcing_enabled IS NOT NULL THEN

Line 388: IF g_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR THEN

384: END IF;
385:
386: END IF;
387:
388: IF g_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR THEN
389:
390: g_PSG_rec.sourcing_status := Get_Sourcing_Status;
391:
392: IF g_PSG_rec.sourcing_status IS NOT NULL THEN

Line 410: IF g_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR THEN

406: END IF;
407:
408: END IF;
409:
410: IF g_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR THEN
411:
412: g_PSG_rec.user_sourcing_method := Get_User_Sourcing_Method;
413:
414: IF g_PSG_rec.user_sourcing_method IS NOT NULL THEN

Line 432: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR

428: END IF;
429:
430: END IF;
431:
432: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR
433: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR
434: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
435: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
436: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR

Line 433: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR

429:
430: END IF;
431:
432: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR
433: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR
434: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
435: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
436: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
437: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR

Line 434: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR

430: END IF;
431:
432: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR
433: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR
434: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
435: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
436: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
437: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
438: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR

Line 435: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR

431:
432: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR
433: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR
434: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
435: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
436: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
437: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
438: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
439: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR

Line 436: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR

432: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR
433: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR
434: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
435: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
436: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
437: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
438: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
439: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
440: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR

Line 437: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR

433: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR
434: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
435: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
436: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
437: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
438: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
439: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
440: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
441: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR

Line 438: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR

434: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
435: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
436: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
437: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
438: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
439: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
440: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
441: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
442: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR

Line 439: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR

435: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
436: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
437: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
438: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
439: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
440: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
441: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
442: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
443: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR

Line 440: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR

436: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
437: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
438: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
439: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
440: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
441: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
442: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
443: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
444: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR

Line 441: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR

437: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
438: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
439: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
440: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
441: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
442: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
443: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
444: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
445: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR

Line 442: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR

438: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
439: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
440: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
441: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
442: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
443: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
444: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
445: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
446: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR

Line 443: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR

439: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
440: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
441: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
442: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
443: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
444: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
445: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
446: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR
447: OR g_PSG_rec.context = FND_API.G_MISS_CHAR

Line 444: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR

440: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
441: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
442: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
443: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
444: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
445: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
446: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR
447: OR g_PSG_rec.context = FND_API.G_MISS_CHAR
448: THEN

Line 445: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR

441: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
442: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
443: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
444: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
445: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
446: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR
447: OR g_PSG_rec.context = FND_API.G_MISS_CHAR
448: THEN
449:

Line 446: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR

442: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
443: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
444: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
445: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
446: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR
447: OR g_PSG_rec.context = FND_API.G_MISS_CHAR
448: THEN
449:
450: Get_Flex_Psg;

Line 447: OR g_PSG_rec.context = FND_API.G_MISS_CHAR

443: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
444: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
445: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
446: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR
447: OR g_PSG_rec.context = FND_API.G_MISS_CHAR
448: THEN
449:
450: Get_Flex_Psg;
451:

Line 454: IF g_PSG_rec.created_by = FND_API.G_MISS_NUM THEN

450: Get_Flex_Psg;
451:
452: END IF;
453:
454: IF g_PSG_rec.created_by = FND_API.G_MISS_NUM THEN
455:
456: g_PSG_rec.created_by := NULL;
457:
458: END IF;

Line 460: IF g_PSG_rec.creation_date = FND_API.G_MISS_DATE THEN

456: g_PSG_rec.created_by := NULL;
457:
458: END IF;
459:
460: IF g_PSG_rec.creation_date = FND_API.G_MISS_DATE THEN
461:
462: g_PSG_rec.creation_date := NULL;
463:
464: END IF;

Line 466: IF g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM THEN

462: g_PSG_rec.creation_date := NULL;
463:
464: END IF;
465:
466: IF g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM THEN
467:
468: g_PSG_rec.last_updated_by := NULL;
469:
470: END IF;

Line 472: IF g_PSG_rec.last_update_date = FND_API.G_MISS_DATE THEN

468: g_PSG_rec.last_updated_by := NULL;
469:
470: END IF;
471:
472: IF g_PSG_rec.last_update_date = FND_API.G_MISS_DATE THEN
473:
474: g_PSG_rec.last_update_date := NULL;
475:
476: END IF;

Line 478: IF g_PSG_rec.last_update_login = FND_API.G_MISS_NUM THEN

474: g_PSG_rec.last_update_date := NULL;
475:
476: END IF;
477:
478: IF g_PSG_rec.last_update_login = FND_API.G_MISS_NUM THEN
479:
480: g_PSG_rec.last_update_login := NULL;
481:
482: END IF;

Line 484: IF g_PSG_rec.program_application_id = FND_API.G_MISS_NUM THEN

480: g_PSG_rec.last_update_login := NULL;
481:
482: END IF;
483:
484: IF g_PSG_rec.program_application_id = FND_API.G_MISS_NUM THEN
485:
486: g_PSG_rec.program_application_id := NULL;
487:
488: END IF;

Line 490: IF g_PSG_rec.program_id = FND_API.G_MISS_NUM THEN

486: g_PSG_rec.program_application_id := NULL;
487:
488: END IF;
489:
490: IF g_PSG_rec.program_id = FND_API.G_MISS_NUM THEN
491:
492: g_PSG_rec.program_id := NULL;
493:
494: END IF;

Line 496: IF g_PSG_rec.program_update_date = FND_API.G_MISS_DATE THEN

492: g_PSG_rec.program_id := NULL;
493:
494: END IF;
495:
496: IF g_PSG_rec.program_update_date = FND_API.G_MISS_DATE THEN
497:
498: g_PSG_rec.program_update_date := NULL;
499:
500: END IF;

Line 504: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR

500: END IF;
501:
502: -- Redefault if there are any missing attributes.
503:
504: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR
505: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR
506: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
507: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
508: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR

Line 505: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR

501:
502: -- Redefault if there are any missing attributes.
503:
504: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR
505: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR
506: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
507: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
508: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
509: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR

Line 506: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR

502: -- Redefault if there are any missing attributes.
503:
504: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR
505: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR
506: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
507: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
508: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
509: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
510: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR

Line 507: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR

503:
504: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR
505: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR
506: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
507: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
508: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
509: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
510: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
511: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR

Line 508: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR

504: IF g_PSG_rec.attribute1 = FND_API.G_MISS_CHAR
505: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR
506: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
507: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
508: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
509: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
510: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
511: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
512: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR

Line 509: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR

505: OR g_PSG_rec.attribute10 = FND_API.G_MISS_CHAR
506: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
507: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
508: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
509: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
510: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
511: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
512: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
513: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR

Line 510: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR

506: OR g_PSG_rec.attribute11 = FND_API.G_MISS_CHAR
507: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
508: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
509: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
510: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
511: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
512: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
513: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
514: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR

Line 511: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR

507: OR g_PSG_rec.attribute12 = FND_API.G_MISS_CHAR
508: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
509: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
510: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
511: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
512: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
513: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
514: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
515: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR

Line 512: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR

508: OR g_PSG_rec.attribute13 = FND_API.G_MISS_CHAR
509: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
510: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
511: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
512: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
513: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
514: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
515: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
516: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR

Line 513: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR

509: OR g_PSG_rec.attribute14 = FND_API.G_MISS_CHAR
510: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
511: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
512: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
513: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
514: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
515: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
516: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
517: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR

Line 514: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR

510: OR g_PSG_rec.attribute15 = FND_API.G_MISS_CHAR
511: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
512: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
513: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
514: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
515: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
516: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
517: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
518: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR

Line 515: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR

511: OR g_PSG_rec.attribute2 = FND_API.G_MISS_CHAR
512: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
513: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
514: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
515: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
516: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
517: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
518: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR
519: OR g_PSG_rec.context = FND_API.G_MISS_CHAR

Line 516: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR

512: OR g_PSG_rec.attribute3 = FND_API.G_MISS_CHAR
513: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
514: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
515: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
516: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
517: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
518: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR
519: OR g_PSG_rec.context = FND_API.G_MISS_CHAR
520: OR g_PSG_rec.created_by = FND_API.G_MISS_NUM

Line 517: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR

513: OR g_PSG_rec.attribute4 = FND_API.G_MISS_CHAR
514: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
515: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
516: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
517: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
518: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR
519: OR g_PSG_rec.context = FND_API.G_MISS_CHAR
520: OR g_PSG_rec.created_by = FND_API.G_MISS_NUM
521: OR g_PSG_rec.creation_date = FND_API.G_MISS_DATE

Line 518: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR

514: OR g_PSG_rec.attribute5 = FND_API.G_MISS_CHAR
515: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
516: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
517: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
518: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR
519: OR g_PSG_rec.context = FND_API.G_MISS_CHAR
520: OR g_PSG_rec.created_by = FND_API.G_MISS_NUM
521: OR g_PSG_rec.creation_date = FND_API.G_MISS_DATE
522: OR g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM

Line 519: OR g_PSG_rec.context = FND_API.G_MISS_CHAR

515: OR g_PSG_rec.attribute6 = FND_API.G_MISS_CHAR
516: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
517: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
518: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR
519: OR g_PSG_rec.context = FND_API.G_MISS_CHAR
520: OR g_PSG_rec.created_by = FND_API.G_MISS_NUM
521: OR g_PSG_rec.creation_date = FND_API.G_MISS_DATE
522: OR g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM
523: OR g_PSG_rec.last_update_date = FND_API.G_MISS_DATE

Line 520: OR g_PSG_rec.created_by = FND_API.G_MISS_NUM

516: OR g_PSG_rec.attribute7 = FND_API.G_MISS_CHAR
517: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
518: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR
519: OR g_PSG_rec.context = FND_API.G_MISS_CHAR
520: OR g_PSG_rec.created_by = FND_API.G_MISS_NUM
521: OR g_PSG_rec.creation_date = FND_API.G_MISS_DATE
522: OR g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM
523: OR g_PSG_rec.last_update_date = FND_API.G_MISS_DATE
524: OR g_PSG_rec.last_update_login = FND_API.G_MISS_NUM

Line 521: OR g_PSG_rec.creation_date = FND_API.G_MISS_DATE

517: OR g_PSG_rec.attribute8 = FND_API.G_MISS_CHAR
518: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR
519: OR g_PSG_rec.context = FND_API.G_MISS_CHAR
520: OR g_PSG_rec.created_by = FND_API.G_MISS_NUM
521: OR g_PSG_rec.creation_date = FND_API.G_MISS_DATE
522: OR g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM
523: OR g_PSG_rec.last_update_date = FND_API.G_MISS_DATE
524: OR g_PSG_rec.last_update_login = FND_API.G_MISS_NUM
525: OR g_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR

Line 522: OR g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM

518: OR g_PSG_rec.attribute9 = FND_API.G_MISS_CHAR
519: OR g_PSG_rec.context = FND_API.G_MISS_CHAR
520: OR g_PSG_rec.created_by = FND_API.G_MISS_NUM
521: OR g_PSG_rec.creation_date = FND_API.G_MISS_DATE
522: OR g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM
523: OR g_PSG_rec.last_update_date = FND_API.G_MISS_DATE
524: OR g_PSG_rec.last_update_login = FND_API.G_MISS_NUM
525: OR g_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR
526: OR g_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR

Line 523: OR g_PSG_rec.last_update_date = FND_API.G_MISS_DATE

519: OR g_PSG_rec.context = FND_API.G_MISS_CHAR
520: OR g_PSG_rec.created_by = FND_API.G_MISS_NUM
521: OR g_PSG_rec.creation_date = FND_API.G_MISS_DATE
522: OR g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM
523: OR g_PSG_rec.last_update_date = FND_API.G_MISS_DATE
524: OR g_PSG_rec.last_update_login = FND_API.G_MISS_NUM
525: OR g_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR
526: OR g_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR
527: OR g_PSG_rec.program_application_id = FND_API.G_MISS_NUM

Line 524: OR g_PSG_rec.last_update_login = FND_API.G_MISS_NUM

520: OR g_PSG_rec.created_by = FND_API.G_MISS_NUM
521: OR g_PSG_rec.creation_date = FND_API.G_MISS_DATE
522: OR g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM
523: OR g_PSG_rec.last_update_date = FND_API.G_MISS_DATE
524: OR g_PSG_rec.last_update_login = FND_API.G_MISS_NUM
525: OR g_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR
526: OR g_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR
527: OR g_PSG_rec.program_application_id = FND_API.G_MISS_NUM
528: OR g_PSG_rec.program_id = FND_API.G_MISS_NUM

Line 525: OR g_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR

521: OR g_PSG_rec.creation_date = FND_API.G_MISS_DATE
522: OR g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM
523: OR g_PSG_rec.last_update_date = FND_API.G_MISS_DATE
524: OR g_PSG_rec.last_update_login = FND_API.G_MISS_NUM
525: OR g_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR
526: OR g_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR
527: OR g_PSG_rec.program_application_id = FND_API.G_MISS_NUM
528: OR g_PSG_rec.program_id = FND_API.G_MISS_NUM
529: OR g_PSG_rec.program_update_date = FND_API.G_MISS_DATE

Line 526: OR g_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR

522: OR g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM
523: OR g_PSG_rec.last_update_date = FND_API.G_MISS_DATE
524: OR g_PSG_rec.last_update_login = FND_API.G_MISS_NUM
525: OR g_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR
526: OR g_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR
527: OR g_PSG_rec.program_application_id = FND_API.G_MISS_NUM
528: OR g_PSG_rec.program_id = FND_API.G_MISS_NUM
529: OR g_PSG_rec.program_update_date = FND_API.G_MISS_DATE
530: OR g_PSG_rec.pte_code = FND_API.G_MISS_CHAR

Line 527: OR g_PSG_rec.program_application_id = FND_API.G_MISS_NUM

523: OR g_PSG_rec.last_update_date = FND_API.G_MISS_DATE
524: OR g_PSG_rec.last_update_login = FND_API.G_MISS_NUM
525: OR g_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR
526: OR g_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR
527: OR g_PSG_rec.program_application_id = FND_API.G_MISS_NUM
528: OR g_PSG_rec.program_id = FND_API.G_MISS_NUM
529: OR g_PSG_rec.program_update_date = FND_API.G_MISS_DATE
530: OR g_PSG_rec.pte_code = FND_API.G_MISS_CHAR
531: OR g_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR

Line 528: OR g_PSG_rec.program_id = FND_API.G_MISS_NUM

524: OR g_PSG_rec.last_update_login = FND_API.G_MISS_NUM
525: OR g_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR
526: OR g_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR
527: OR g_PSG_rec.program_application_id = FND_API.G_MISS_NUM
528: OR g_PSG_rec.program_id = FND_API.G_MISS_NUM
529: OR g_PSG_rec.program_update_date = FND_API.G_MISS_DATE
530: OR g_PSG_rec.pte_code = FND_API.G_MISS_CHAR
531: OR g_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR
532: OR g_PSG_rec.segment_id = FND_API.G_MISS_NUM

Line 529: OR g_PSG_rec.program_update_date = FND_API.G_MISS_DATE

525: OR g_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR
526: OR g_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR
527: OR g_PSG_rec.program_application_id = FND_API.G_MISS_NUM
528: OR g_PSG_rec.program_id = FND_API.G_MISS_NUM
529: OR g_PSG_rec.program_update_date = FND_API.G_MISS_DATE
530: OR g_PSG_rec.pte_code = FND_API.G_MISS_CHAR
531: OR g_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR
532: OR g_PSG_rec.segment_id = FND_API.G_MISS_NUM
533: OR g_PSG_rec.segment_level = FND_API.G_MISS_CHAR

Line 530: OR g_PSG_rec.pte_code = FND_API.G_MISS_CHAR

526: OR g_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR
527: OR g_PSG_rec.program_application_id = FND_API.G_MISS_NUM
528: OR g_PSG_rec.program_id = FND_API.G_MISS_NUM
529: OR g_PSG_rec.program_update_date = FND_API.G_MISS_DATE
530: OR g_PSG_rec.pte_code = FND_API.G_MISS_CHAR
531: OR g_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR
532: OR g_PSG_rec.segment_id = FND_API.G_MISS_NUM
533: OR g_PSG_rec.segment_level = FND_API.G_MISS_CHAR
534: OR g_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM

Line 531: OR g_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR

527: OR g_PSG_rec.program_application_id = FND_API.G_MISS_NUM
528: OR g_PSG_rec.program_id = FND_API.G_MISS_NUM
529: OR g_PSG_rec.program_update_date = FND_API.G_MISS_DATE
530: OR g_PSG_rec.pte_code = FND_API.G_MISS_CHAR
531: OR g_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR
532: OR g_PSG_rec.segment_id = FND_API.G_MISS_NUM
533: OR g_PSG_rec.segment_level = FND_API.G_MISS_CHAR
534: OR g_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM
535: OR g_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR

Line 532: OR g_PSG_rec.segment_id = FND_API.G_MISS_NUM

528: OR g_PSG_rec.program_id = FND_API.G_MISS_NUM
529: OR g_PSG_rec.program_update_date = FND_API.G_MISS_DATE
530: OR g_PSG_rec.pte_code = FND_API.G_MISS_CHAR
531: OR g_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR
532: OR g_PSG_rec.segment_id = FND_API.G_MISS_NUM
533: OR g_PSG_rec.segment_level = FND_API.G_MISS_CHAR
534: OR g_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM
535: OR g_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR
536: OR g_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR

Line 533: OR g_PSG_rec.segment_level = FND_API.G_MISS_CHAR

529: OR g_PSG_rec.program_update_date = FND_API.G_MISS_DATE
530: OR g_PSG_rec.pte_code = FND_API.G_MISS_CHAR
531: OR g_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR
532: OR g_PSG_rec.segment_id = FND_API.G_MISS_NUM
533: OR g_PSG_rec.segment_level = FND_API.G_MISS_CHAR
534: OR g_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM
535: OR g_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR
536: OR g_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR
537: OR g_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR

Line 534: OR g_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM

530: OR g_PSG_rec.pte_code = FND_API.G_MISS_CHAR
531: OR g_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR
532: OR g_PSG_rec.segment_id = FND_API.G_MISS_NUM
533: OR g_PSG_rec.segment_level = FND_API.G_MISS_CHAR
534: OR g_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM
535: OR g_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR
536: OR g_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR
537: OR g_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR
538: THEN

Line 535: OR g_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR

531: OR g_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR
532: OR g_PSG_rec.segment_id = FND_API.G_MISS_NUM
533: OR g_PSG_rec.segment_level = FND_API.G_MISS_CHAR
534: OR g_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM
535: OR g_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR
536: OR g_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR
537: OR g_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR
538: THEN
539:

Line 536: OR g_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR

532: OR g_PSG_rec.segment_id = FND_API.G_MISS_NUM
533: OR g_PSG_rec.segment_level = FND_API.G_MISS_CHAR
534: OR g_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM
535: OR g_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR
536: OR g_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR
537: OR g_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR
538: THEN
539:
540: QP_Default_Psg.Attributes

Line 537: OR g_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR

533: OR g_PSG_rec.segment_level = FND_API.G_MISS_CHAR
534: OR g_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM
535: OR g_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR
536: OR g_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR
537: OR g_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR
538: THEN
539:
540: QP_Default_Psg.Attributes
541: ( p_PSG_rec => g_PSG_rec