DBA Data[Home] [Help]

APPS.QP_QP_FORM_SOU1 dependencies on QP_SOU_UTIL

Line 199: l_SOU_val_rec := QP_Sou_Util.Get_Values

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;

Line 378: IF p_attr_id = QP_Sou_Util.G_ATTRIBUTE_SOURCING THEN

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

Line 380: ELSIF p_attr_id = QP_Sou_Util.G_ATTRIBUTE_SOURCING_LEVEL 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

Line 382: ELSIF p_attr_id = QP_Sou_Util.G_APPLICATION_ID 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

Line 384: ELSIF p_attr_id = QP_Sou_Util.G_ENABLED 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

Line 386: ELSIF p_attr_id = QP_Sou_Util.G_REQUEST_TYPE 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

Line 388: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED 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

Line 390: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED_SOURCING_TYPE 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

Line 392: ELSIF p_attr_id = QP_Sou_Util.G_SEEDED_VALUE_STRING 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

Line 394: ELSIF p_attr_id = QP_Sou_Util.G_SEGMENT 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

Line 396: ELSIF p_attr_id = QP_Sou_Util.G_USER_SOURCING_TYPE 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

Line 398: ELSIF p_attr_id = QP_Sou_Util.G_USER_VALUE_STRING THEN

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

Line 400: ELSIF p_attr_id = QP_Sou_Util.G_ATTRIBUTE1

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

Line 401: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE10

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

Line 402: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE11

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

Line 403: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE12

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

Line 404: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE13

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

Line 405: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE15

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

Line 406: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE2

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

Line 407: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE3

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

Line 408: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE4

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

Line 409: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE5

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

Line 410: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE6

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

Line 411: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE7

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

Line 412: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE8

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:

Line 413: OR p_attr_id = QP_Sou_Util.G_ATTRIBUTE9

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;

Line 414: OR p_attr_id = QP_Sou_Util.G_CONTEXT

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;

Line 531: l_SOU_val_rec := QP_Sou_Util.Get_Values

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:

Line 1410: g_SOU_rec := QP_Sou_Util.Query_Row

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;