195: x_user_value_string := l_x_SOU_rec.user_value_string;
196:
197: -- Load display out parameters if any
198:
199: l_SOU_val_rec := QP_Sou_Util.Get_Values
200: ( p_SOU_rec => l_x_SOU_rec
201: );
202: x_attribute_sourcing := l_SOU_val_rec.attribute_sourcing;
203: x_enabled := l_SOU_val_rec.enabled;
374: );
375:
376: l_old_SOU_rec := l_SOU_rec;
377:
378: IF p_attr_id = QP_Sou_Util.G_ATTRIBUTE_SOURCING THEN
379: l_SOU_rec.attribute_sourcing_id := TO_NUMBER(p_attr_value);
380: ELSIF p_attr_id = QP_Sou_Util.G_ATTRIBUTE_SOURCING_LEVEL THEN
381: l_SOU_rec.attribute_sourcing_level := p_attr_value;
382: ELSIF p_attr_id = QP_Sou_Util.G_APPLICATION_ID THEN
376: l_old_SOU_rec := l_SOU_rec;
377:
378: IF p_attr_id = QP_Sou_Util.G_ATTRIBUTE_SOURCING THEN
379: l_SOU_rec.attribute_sourcing_id := TO_NUMBER(p_attr_value);
380: ELSIF p_attr_id = QP_Sou_Util.G_ATTRIBUTE_SOURCING_LEVEL THEN
381: l_SOU_rec.attribute_sourcing_level := p_attr_value;
382: ELSIF p_attr_id = QP_Sou_Util.G_APPLICATION_ID THEN
383: l_SOU_rec.application_id := p_attr_value;
384: ELSIF p_attr_id = QP_Sou_Util.G_ENABLED THEN
378: IF p_attr_id = QP_Sou_Util.G_ATTRIBUTE_SOURCING THEN
379: l_SOU_rec.attribute_sourcing_id := TO_NUMBER(p_attr_value);
380: ELSIF p_attr_id = QP_Sou_Util.G_ATTRIBUTE_SOURCING_LEVEL THEN
381: l_SOU_rec.attribute_sourcing_level := p_attr_value;
382: ELSIF p_attr_id = QP_Sou_Util.G_APPLICATION_ID THEN
383: l_SOU_rec.application_id := p_attr_value;
384: ELSIF p_attr_id = QP_Sou_Util.G_ENABLED THEN
385: l_SOU_rec.enabled_flag := p_attr_value;
386: ELSIF p_attr_id = QP_Sou_Util.G_REQUEST_TYPE THEN
380: ELSIF p_attr_id = QP_Sou_Util.G_ATTRIBUTE_SOURCING_LEVEL THEN
381: l_SOU_rec.attribute_sourcing_level := p_attr_value;
382: ELSIF p_attr_id = QP_Sou_Util.G_APPLICATION_ID THEN
383: l_SOU_rec.application_id := p_attr_value;
384: ELSIF p_attr_id = QP_Sou_Util.G_ENABLED THEN
385: l_SOU_rec.enabled_flag := p_attr_value;
386: ELSIF p_attr_id = QP_Sou_Util.G_REQUEST_TYPE THEN
387: l_SOU_rec.request_type_code := p_attr_value;
388: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED THEN
382: ELSIF p_attr_id = QP_Sou_Util.G_APPLICATION_ID THEN
383: l_SOU_rec.application_id := p_attr_value;
384: ELSIF p_attr_id = QP_Sou_Util.G_ENABLED THEN
385: l_SOU_rec.enabled_flag := p_attr_value;
386: ELSIF p_attr_id = QP_Sou_Util.G_REQUEST_TYPE THEN
387: l_SOU_rec.request_type_code := p_attr_value;
388: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED THEN
389: l_SOU_rec.seeded_flag := p_attr_value;
390: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED_SOURCING_TYPE THEN
384: ELSIF p_attr_id = QP_Sou_Util.G_ENABLED THEN
385: l_SOU_rec.enabled_flag := p_attr_value;
386: ELSIF p_attr_id = QP_Sou_Util.G_REQUEST_TYPE THEN
387: l_SOU_rec.request_type_code := p_attr_value;
388: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED THEN
389: l_SOU_rec.seeded_flag := p_attr_value;
390: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED_SOURCING_TYPE THEN
391: l_SOU_rec.seeded_sourcing_type := p_attr_value;
392: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED_VALUE_STRING THEN
386: ELSIF p_attr_id = QP_Sou_Util.G_REQUEST_TYPE THEN
387: l_SOU_rec.request_type_code := p_attr_value;
388: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED THEN
389: l_SOU_rec.seeded_flag := p_attr_value;
390: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED_SOURCING_TYPE THEN
391: l_SOU_rec.seeded_sourcing_type := p_attr_value;
392: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED_VALUE_STRING THEN
393: l_SOU_rec.seeded_value_string := p_attr_value;
394: ELSIF p_attr_id = QP_Sou_Util.G_SEGMENT THEN
388: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED THEN
389: l_SOU_rec.seeded_flag := p_attr_value;
390: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED_SOURCING_TYPE THEN
391: l_SOU_rec.seeded_sourcing_type := p_attr_value;
392: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED_VALUE_STRING THEN
393: l_SOU_rec.seeded_value_string := p_attr_value;
394: ELSIF p_attr_id = QP_Sou_Util.G_SEGMENT THEN
395: l_SOU_rec.segment_id := TO_NUMBER(p_attr_value);
396: ELSIF p_attr_id = QP_Sou_Util.G_USER_SOURCING_TYPE THEN
390: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED_SOURCING_TYPE THEN
391: l_SOU_rec.seeded_sourcing_type := p_attr_value;
392: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED_VALUE_STRING THEN
393: l_SOU_rec.seeded_value_string := p_attr_value;
394: ELSIF p_attr_id = QP_Sou_Util.G_SEGMENT THEN
395: l_SOU_rec.segment_id := TO_NUMBER(p_attr_value);
396: ELSIF p_attr_id = QP_Sou_Util.G_USER_SOURCING_TYPE THEN
397: l_SOU_rec.user_sourcing_type := p_attr_value;
398: ELSIF p_attr_id = QP_Sou_Util.G_USER_VALUE_STRING THEN
392: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED_VALUE_STRING THEN
393: l_SOU_rec.seeded_value_string := p_attr_value;
394: ELSIF p_attr_id = QP_Sou_Util.G_SEGMENT THEN
395: l_SOU_rec.segment_id := TO_NUMBER(p_attr_value);
396: ELSIF p_attr_id = QP_Sou_Util.G_USER_SOURCING_TYPE THEN
397: l_SOU_rec.user_sourcing_type := p_attr_value;
398: ELSIF p_attr_id = QP_Sou_Util.G_USER_VALUE_STRING THEN
399: l_SOU_rec.user_value_string := p_attr_value;
400: ELSIF p_attr_id = QP_Sou_Util.G_ATTRIBUTE1
394: ELSIF p_attr_id = QP_Sou_Util.G_SEGMENT THEN
395: l_SOU_rec.segment_id := TO_NUMBER(p_attr_value);
396: ELSIF p_attr_id = QP_Sou_Util.G_USER_SOURCING_TYPE THEN
397: l_SOU_rec.user_sourcing_type := p_attr_value;
398: ELSIF p_attr_id = QP_Sou_Util.G_USER_VALUE_STRING THEN
399: l_SOU_rec.user_value_string := p_attr_value;
400: ELSIF p_attr_id = QP_Sou_Util.G_ATTRIBUTE1
401: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE10
402: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE11
396: ELSIF p_attr_id = QP_Sou_Util.G_USER_SOURCING_TYPE THEN
397: l_SOU_rec.user_sourcing_type := p_attr_value;
398: ELSIF p_attr_id = QP_Sou_Util.G_USER_VALUE_STRING THEN
399: l_SOU_rec.user_value_string := p_attr_value;
400: ELSIF p_attr_id = QP_Sou_Util.G_ATTRIBUTE1
401: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE10
402: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE11
403: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE12
404: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE13
397: l_SOU_rec.user_sourcing_type := p_attr_value;
398: ELSIF p_attr_id = QP_Sou_Util.G_USER_VALUE_STRING THEN
399: l_SOU_rec.user_value_string := p_attr_value;
400: ELSIF p_attr_id = QP_Sou_Util.G_ATTRIBUTE1
401: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE10
402: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE11
403: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE12
404: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE13
405: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE15
398: ELSIF p_attr_id = QP_Sou_Util.G_USER_VALUE_STRING THEN
399: l_SOU_rec.user_value_string := p_attr_value;
400: ELSIF p_attr_id = QP_Sou_Util.G_ATTRIBUTE1
401: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE10
402: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE11
403: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE12
404: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE13
405: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE15
406: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE2
399: l_SOU_rec.user_value_string := p_attr_value;
400: ELSIF p_attr_id = QP_Sou_Util.G_ATTRIBUTE1
401: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE10
402: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE11
403: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE12
404: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE13
405: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE15
406: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE2
407: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE3
400: ELSIF p_attr_id = QP_Sou_Util.G_ATTRIBUTE1
401: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE10
402: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE11
403: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE12
404: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE13
405: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE15
406: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE2
407: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE3
408: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE4
401: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE10
402: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE11
403: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE12
404: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE13
405: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE15
406: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE2
407: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE3
408: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE4
409: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE5
402: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE11
403: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE12
404: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE13
405: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE15
406: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE2
407: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE3
408: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE4
409: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE5
410: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE6
403: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE12
404: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE13
405: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE15
406: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE2
407: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE3
408: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE4
409: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE5
410: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE6
411: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE7
404: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE13
405: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE15
406: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE2
407: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE3
408: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE4
409: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE5
410: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE6
411: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE7
412: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE8
405: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE15
406: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE2
407: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE3
408: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE4
409: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE5
410: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE6
411: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE7
412: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE8
413: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE9
406: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE2
407: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE3
408: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE4
409: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE5
410: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE6
411: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE7
412: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE8
413: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE9
414: OR p_attr_id = QP_Sou_Util.G_CONTEXT
407: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE3
408: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE4
409: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE5
410: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE6
411: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE7
412: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE8
413: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE9
414: OR p_attr_id = QP_Sou_Util.G_CONTEXT
415: THEN
408: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE4
409: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE5
410: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE6
411: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE7
412: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE8
413: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE9
414: OR p_attr_id = QP_Sou_Util.G_CONTEXT
415: THEN
416:
409: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE5
410: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE6
411: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE7
412: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE8
413: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE9
414: OR p_attr_id = QP_Sou_Util.G_CONTEXT
415: THEN
416:
417: l_SOU_rec.attribute1 := p_attribute1;
410: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE6
411: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE7
412: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE8
413: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE9
414: OR p_attr_id = QP_Sou_Util.G_CONTEXT
415: THEN
416:
417: l_SOU_rec.attribute1 := p_attribute1;
418: l_SOU_rec.attribute10 := p_attribute10;
527: x_segment := FND_API.G_MISS_CHAR;
528:
529: -- Load display out parameters if any
530:
531: l_SOU_val_rec := QP_Sou_Util.Get_Values
532: ( p_SOU_rec => l_x_SOU_rec
533: , p_old_SOU_rec => l_SOU_rec
534: );
535:
1406: THEN
1407:
1408: -- Query row from DB
1409:
1410: g_SOU_rec := QP_Sou_Util.Query_Row
1411: ( p_attribute_sourcing_id => p_attribute_sourcing_id
1412: );
1413:
1414: g_SOU_rec.db_flag := FND_API.G_TRUE;