190: x_user_sourcing_method := l_x_PSG_rec.user_sourcing_method;
191:
192: -- Load display out parameters if any
193:
194: l_PSG_val_rec := QP_Psg_Util.Get_Values
195: ( p_PSG_rec => l_x_PSG_rec
196: );
197: x_pte := l_PSG_val_rec.pte;
198: x_segment := l_PSG_val_rec.segment;
364: );
365:
366: l_old_PSG_rec := l_PSG_rec;
367:
368: IF p_attr_id = QP_Psg_Util.G_LIMITS_ENABLED THEN
369: l_PSG_rec.limits_enabled := p_attr_value;
370: ELSIF p_attr_id = QP_Psg_Util.G_LOV_ENABLED THEN
371: l_PSG_rec.lov_enabled := p_attr_value;
372: ELSIF p_attr_id = QP_Psg_Util.G_PTE THEN
366: l_old_PSG_rec := l_PSG_rec;
367:
368: IF p_attr_id = QP_Psg_Util.G_LIMITS_ENABLED THEN
369: l_PSG_rec.limits_enabled := p_attr_value;
370: ELSIF p_attr_id = QP_Psg_Util.G_LOV_ENABLED THEN
371: l_PSG_rec.lov_enabled := p_attr_value;
372: ELSIF p_attr_id = QP_Psg_Util.G_PTE THEN
373: l_PSG_rec.pte_code := p_attr_value;
374: ELSIF p_attr_id = QP_Psg_Util.G_SEEDED_SOURCING_METHOD THEN
368: IF p_attr_id = QP_Psg_Util.G_LIMITS_ENABLED THEN
369: l_PSG_rec.limits_enabled := p_attr_value;
370: ELSIF p_attr_id = QP_Psg_Util.G_LOV_ENABLED THEN
371: l_PSG_rec.lov_enabled := p_attr_value;
372: ELSIF p_attr_id = QP_Psg_Util.G_PTE THEN
373: l_PSG_rec.pte_code := p_attr_value;
374: ELSIF p_attr_id = QP_Psg_Util.G_SEEDED_SOURCING_METHOD THEN
375: l_PSG_rec.seeded_sourcing_method := p_attr_value;
376: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT THEN
370: ELSIF p_attr_id = QP_Psg_Util.G_LOV_ENABLED THEN
371: l_PSG_rec.lov_enabled := p_attr_value;
372: ELSIF p_attr_id = QP_Psg_Util.G_PTE THEN
373: l_PSG_rec.pte_code := p_attr_value;
374: ELSIF p_attr_id = QP_Psg_Util.G_SEEDED_SOURCING_METHOD THEN
375: l_PSG_rec.seeded_sourcing_method := p_attr_value;
376: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT THEN
377: l_PSG_rec.segment_id := TO_NUMBER(p_attr_value);
378: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT_LEVEL THEN
372: ELSIF p_attr_id = QP_Psg_Util.G_PTE THEN
373: l_PSG_rec.pte_code := p_attr_value;
374: ELSIF p_attr_id = QP_Psg_Util.G_SEEDED_SOURCING_METHOD THEN
375: l_PSG_rec.seeded_sourcing_method := p_attr_value;
376: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT THEN
377: l_PSG_rec.segment_id := TO_NUMBER(p_attr_value);
378: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT_LEVEL THEN
379: l_PSG_rec.segment_level := p_attr_value;
380: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT_PTE THEN
374: ELSIF p_attr_id = QP_Psg_Util.G_SEEDED_SOURCING_METHOD THEN
375: l_PSG_rec.seeded_sourcing_method := p_attr_value;
376: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT THEN
377: l_PSG_rec.segment_id := TO_NUMBER(p_attr_value);
378: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT_LEVEL THEN
379: l_PSG_rec.segment_level := p_attr_value;
380: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT_PTE THEN
381: l_PSG_rec.segment_pte_id := TO_NUMBER(p_attr_value);
382: ELSIF p_attr_id = QP_Psg_Util.G_SOURCING_ENABLED THEN
376: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT THEN
377: l_PSG_rec.segment_id := TO_NUMBER(p_attr_value);
378: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT_LEVEL THEN
379: l_PSG_rec.segment_level := p_attr_value;
380: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT_PTE THEN
381: l_PSG_rec.segment_pte_id := TO_NUMBER(p_attr_value);
382: ELSIF p_attr_id = QP_Psg_Util.G_SOURCING_ENABLED THEN
383: l_PSG_rec.sourcing_enabled := p_attr_value;
384: ELSIF p_attr_id = QP_Psg_Util.G_SOURCING_STATUS THEN
378: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT_LEVEL THEN
379: l_PSG_rec.segment_level := p_attr_value;
380: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT_PTE THEN
381: l_PSG_rec.segment_pte_id := TO_NUMBER(p_attr_value);
382: ELSIF p_attr_id = QP_Psg_Util.G_SOURCING_ENABLED THEN
383: l_PSG_rec.sourcing_enabled := p_attr_value;
384: ELSIF p_attr_id = QP_Psg_Util.G_SOURCING_STATUS THEN
385: l_PSG_rec.sourcing_status := p_attr_value;
386: ELSIF p_attr_id = QP_Psg_Util.G_USER_SOURCING_METHOD THEN
380: ELSIF p_attr_id = QP_Psg_Util.G_SEGMENT_PTE THEN
381: l_PSG_rec.segment_pte_id := TO_NUMBER(p_attr_value);
382: ELSIF p_attr_id = QP_Psg_Util.G_SOURCING_ENABLED THEN
383: l_PSG_rec.sourcing_enabled := p_attr_value;
384: ELSIF p_attr_id = QP_Psg_Util.G_SOURCING_STATUS THEN
385: l_PSG_rec.sourcing_status := p_attr_value;
386: ELSIF p_attr_id = QP_Psg_Util.G_USER_SOURCING_METHOD THEN
387: l_PSG_rec.user_sourcing_method := p_attr_value;
388: ELSIF p_attr_id = QP_Psg_Util.G_ATTRIBUTE1
382: ELSIF p_attr_id = QP_Psg_Util.G_SOURCING_ENABLED THEN
383: l_PSG_rec.sourcing_enabled := p_attr_value;
384: ELSIF p_attr_id = QP_Psg_Util.G_SOURCING_STATUS THEN
385: l_PSG_rec.sourcing_status := p_attr_value;
386: ELSIF p_attr_id = QP_Psg_Util.G_USER_SOURCING_METHOD THEN
387: l_PSG_rec.user_sourcing_method := p_attr_value;
388: ELSIF p_attr_id = QP_Psg_Util.G_ATTRIBUTE1
389: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE10
390: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE11
384: ELSIF p_attr_id = QP_Psg_Util.G_SOURCING_STATUS THEN
385: l_PSG_rec.sourcing_status := p_attr_value;
386: ELSIF p_attr_id = QP_Psg_Util.G_USER_SOURCING_METHOD THEN
387: l_PSG_rec.user_sourcing_method := p_attr_value;
388: ELSIF p_attr_id = QP_Psg_Util.G_ATTRIBUTE1
389: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE10
390: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE11
391: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE12
392: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE13
385: l_PSG_rec.sourcing_status := p_attr_value;
386: ELSIF p_attr_id = QP_Psg_Util.G_USER_SOURCING_METHOD THEN
387: l_PSG_rec.user_sourcing_method := p_attr_value;
388: ELSIF p_attr_id = QP_Psg_Util.G_ATTRIBUTE1
389: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE10
390: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE11
391: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE12
392: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE13
393: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE14
386: ELSIF p_attr_id = QP_Psg_Util.G_USER_SOURCING_METHOD THEN
387: l_PSG_rec.user_sourcing_method := p_attr_value;
388: ELSIF p_attr_id = QP_Psg_Util.G_ATTRIBUTE1
389: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE10
390: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE11
391: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE12
392: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE13
393: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE14
394: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE15
387: l_PSG_rec.user_sourcing_method := p_attr_value;
388: ELSIF p_attr_id = QP_Psg_Util.G_ATTRIBUTE1
389: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE10
390: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE11
391: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE12
392: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE13
393: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE14
394: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE15
395: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE2
388: ELSIF p_attr_id = QP_Psg_Util.G_ATTRIBUTE1
389: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE10
390: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE11
391: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE12
392: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE13
393: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE14
394: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE15
395: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE2
396: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE3
389: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE10
390: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE11
391: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE12
392: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE13
393: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE14
394: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE15
395: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE2
396: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE3
397: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE4
390: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE11
391: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE12
392: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE13
393: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE14
394: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE15
395: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE2
396: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE3
397: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE4
398: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE5
391: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE12
392: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE13
393: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE14
394: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE15
395: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE2
396: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE3
397: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE4
398: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE5
399: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE6
392: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE13
393: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE14
394: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE15
395: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE2
396: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE3
397: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE4
398: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE5
399: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE6
400: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE7
393: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE14
394: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE15
395: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE2
396: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE3
397: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE4
398: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE5
399: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE6
400: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE7
401: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE8
394: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE15
395: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE2
396: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE3
397: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE4
398: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE5
399: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE6
400: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE7
401: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE8
402: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE9
395: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE2
396: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE3
397: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE4
398: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE5
399: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE6
400: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE7
401: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE8
402: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE9
403: OR p_attr_id = QP_Psg_Util.G_CONTEXT
396: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE3
397: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE4
398: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE5
399: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE6
400: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE7
401: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE8
402: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE9
403: OR p_attr_id = QP_Psg_Util.G_CONTEXT
404: THEN
397: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE4
398: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE5
399: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE6
400: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE7
401: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE8
402: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE9
403: OR p_attr_id = QP_Psg_Util.G_CONTEXT
404: THEN
405:
398: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE5
399: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE6
400: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE7
401: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE8
402: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE9
403: OR p_attr_id = QP_Psg_Util.G_CONTEXT
404: THEN
405:
406: l_PSG_rec.attribute1 := p_attribute1;
399: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE6
400: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE7
401: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE8
402: OR p_attr_id = QP_Psg_Util.G_ATTRIBUTE9
403: OR p_attr_id = QP_Psg_Util.G_CONTEXT
404: THEN
405:
406: l_PSG_rec.attribute1 := p_attribute1;
407: l_PSG_rec.attribute10 := p_attribute10;
514: x_segment_pte := FND_API.G_MISS_CHAR;
515:
516: -- Load display out parameters if any
517:
518: l_PSG_val_rec := QP_Psg_Util.Get_Values
519: ( p_PSG_rec => l_x_PSG_rec
520: , p_old_PSG_rec => l_PSG_rec
521: );
522:
1383: THEN
1384:
1385: -- Query row from DB
1386:
1387: g_PSG_rec := QP_Psg_Util.Query_Row
1388: ( p_segment_pte_id => p_segment_pte_id
1389: );
1390:
1391: g_PSG_rec.db_flag := FND_API.G_TRUE;