198: x_party_hierarchy_enabled_flag := l_x_SEG_rec.party_hierarchy_enabled_flag; --Added for TCA
199:
200: -- Load display out parameters if any
201:
202: l_SEG_val_rec := QP_Seg_Util.Get_Values
203: ( p_SEG_rec => l_x_SEG_rec
204: );
205: x_prc_context := l_SEG_val_rec.prc_context;
206: x_seeded := l_SEG_val_rec.seeded;
377: );
378:
379: l_old_SEG_rec := l_SEG_rec;
380:
381: IF p_attr_id = QP_Seg_Util.G_AVAILABILITY_IN_BASIC THEN
382: l_SEG_rec.availability_in_basic := p_attr_value;
383: ELSIF p_attr_id = QP_Seg_Util.G_PRC_CONTEXT THEN
384: l_SEG_rec.prc_context_id := TO_NUMBER(p_attr_value);
385: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED THEN
379: l_old_SEG_rec := l_SEG_rec;
380:
381: IF p_attr_id = QP_Seg_Util.G_AVAILABILITY_IN_BASIC THEN
382: l_SEG_rec.availability_in_basic := p_attr_value;
383: ELSIF p_attr_id = QP_Seg_Util.G_PRC_CONTEXT THEN
384: l_SEG_rec.prc_context_id := TO_NUMBER(p_attr_value);
385: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED THEN
386: l_SEG_rec.seeded_flag := p_attr_value;
387: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_FORMAT_TYPE THEN
381: IF p_attr_id = QP_Seg_Util.G_AVAILABILITY_IN_BASIC THEN
382: l_SEG_rec.availability_in_basic := p_attr_value;
383: ELSIF p_attr_id = QP_Seg_Util.G_PRC_CONTEXT THEN
384: l_SEG_rec.prc_context_id := TO_NUMBER(p_attr_value);
385: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED THEN
386: l_SEG_rec.seeded_flag := p_attr_value;
387: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_FORMAT_TYPE THEN
388: l_SEG_rec.seeded_format_type := p_attr_value;
389: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_PRECEDENCE THEN
383: ELSIF p_attr_id = QP_Seg_Util.G_PRC_CONTEXT THEN
384: l_SEG_rec.prc_context_id := TO_NUMBER(p_attr_value);
385: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED THEN
386: l_SEG_rec.seeded_flag := p_attr_value;
387: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_FORMAT_TYPE THEN
388: l_SEG_rec.seeded_format_type := p_attr_value;
389: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_PRECEDENCE THEN
390: l_SEG_rec.seeded_precedence := TO_NUMBER(p_attr_value);
391: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_SEGMENT_NAME THEN
385: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED THEN
386: l_SEG_rec.seeded_flag := p_attr_value;
387: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_FORMAT_TYPE THEN
388: l_SEG_rec.seeded_format_type := p_attr_value;
389: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_PRECEDENCE THEN
390: l_SEG_rec.seeded_precedence := TO_NUMBER(p_attr_value);
391: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_SEGMENT_NAME THEN
392: l_SEG_rec.seeded_segment_name := p_attr_value;
393: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_VALUESET THEN
387: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_FORMAT_TYPE THEN
388: l_SEG_rec.seeded_format_type := p_attr_value;
389: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_PRECEDENCE THEN
390: l_SEG_rec.seeded_precedence := TO_NUMBER(p_attr_value);
391: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_SEGMENT_NAME THEN
392: l_SEG_rec.seeded_segment_name := p_attr_value;
393: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_VALUESET THEN
394: l_SEG_rec.seeded_valueset_id := TO_NUMBER(p_attr_value);
395: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT_code THEN
389: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_PRECEDENCE THEN
390: l_SEG_rec.seeded_precedence := TO_NUMBER(p_attr_value);
391: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_SEGMENT_NAME THEN
392: l_SEG_rec.seeded_segment_name := p_attr_value;
393: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_VALUESET THEN
394: l_SEG_rec.seeded_valueset_id := TO_NUMBER(p_attr_value);
395: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT_code THEN
396: l_SEG_rec.segment_code := p_attr_value;
397: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT THEN
391: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_SEGMENT_NAME THEN
392: l_SEG_rec.seeded_segment_name := p_attr_value;
393: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_VALUESET THEN
394: l_SEG_rec.seeded_valueset_id := TO_NUMBER(p_attr_value);
395: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT_code THEN
396: l_SEG_rec.segment_code := p_attr_value;
397: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT THEN
398: l_SEG_rec.segment_id := TO_NUMBER(p_attr_value);
399: ELSIF p_attr_id = QP_Seg_Util.G_APPLICATION_ID THEN
393: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_VALUESET THEN
394: l_SEG_rec.seeded_valueset_id := TO_NUMBER(p_attr_value);
395: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT_code THEN
396: l_SEG_rec.segment_code := p_attr_value;
397: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT THEN
398: l_SEG_rec.segment_id := TO_NUMBER(p_attr_value);
399: ELSIF p_attr_id = QP_Seg_Util.G_APPLICATION_ID THEN
400: l_SEG_rec.application_id := TO_NUMBER(p_attr_value);
401: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT_MAPPING_COLUMN THEN
395: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT_code THEN
396: l_SEG_rec.segment_code := p_attr_value;
397: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT THEN
398: l_SEG_rec.segment_id := TO_NUMBER(p_attr_value);
399: ELSIF p_attr_id = QP_Seg_Util.G_APPLICATION_ID THEN
400: l_SEG_rec.application_id := TO_NUMBER(p_attr_value);
401: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT_MAPPING_COLUMN THEN
402: l_SEG_rec.segment_mapping_column := p_attr_value;
403: ELSIF p_attr_id = QP_Seg_Util.G_USER_FORMAT_TYPE THEN
397: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT THEN
398: l_SEG_rec.segment_id := TO_NUMBER(p_attr_value);
399: ELSIF p_attr_id = QP_Seg_Util.G_APPLICATION_ID THEN
400: l_SEG_rec.application_id := TO_NUMBER(p_attr_value);
401: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT_MAPPING_COLUMN THEN
402: l_SEG_rec.segment_mapping_column := p_attr_value;
403: ELSIF p_attr_id = QP_Seg_Util.G_USER_FORMAT_TYPE THEN
404: l_SEG_rec.user_format_type := p_attr_value;
405: ELSIF p_attr_id = QP_Seg_Util.G_USER_PRECEDENCE THEN
399: ELSIF p_attr_id = QP_Seg_Util.G_APPLICATION_ID THEN
400: l_SEG_rec.application_id := TO_NUMBER(p_attr_value);
401: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT_MAPPING_COLUMN THEN
402: l_SEG_rec.segment_mapping_column := p_attr_value;
403: ELSIF p_attr_id = QP_Seg_Util.G_USER_FORMAT_TYPE THEN
404: l_SEG_rec.user_format_type := p_attr_value;
405: ELSIF p_attr_id = QP_Seg_Util.G_USER_PRECEDENCE THEN
406: l_SEG_rec.user_precedence := TO_NUMBER(p_attr_value);
407: ELSIF p_attr_id = QP_Seg_Util.G_USER_SEGMENT_NAME THEN
401: ELSIF p_attr_id = QP_Seg_Util.G_SEGMENT_MAPPING_COLUMN THEN
402: l_SEG_rec.segment_mapping_column := p_attr_value;
403: ELSIF p_attr_id = QP_Seg_Util.G_USER_FORMAT_TYPE THEN
404: l_SEG_rec.user_format_type := p_attr_value;
405: ELSIF p_attr_id = QP_Seg_Util.G_USER_PRECEDENCE THEN
406: l_SEG_rec.user_precedence := TO_NUMBER(p_attr_value);
407: ELSIF p_attr_id = QP_Seg_Util.G_USER_SEGMENT_NAME THEN
408: l_SEG_rec.user_segment_name := p_attr_value;
409: ELSIF p_attr_id = QP_Seg_Util.G_USER_VALUESET THEN
403: ELSIF p_attr_id = QP_Seg_Util.G_USER_FORMAT_TYPE THEN
404: l_SEG_rec.user_format_type := p_attr_value;
405: ELSIF p_attr_id = QP_Seg_Util.G_USER_PRECEDENCE THEN
406: l_SEG_rec.user_precedence := TO_NUMBER(p_attr_value);
407: ELSIF p_attr_id = QP_Seg_Util.G_USER_SEGMENT_NAME THEN
408: l_SEG_rec.user_segment_name := p_attr_value;
409: ELSIF p_attr_id = QP_Seg_Util.G_USER_VALUESET THEN
410: l_SEG_rec.user_valueset_id := TO_NUMBER(p_attr_value);
411: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_DESCRIPTION THEN
405: ELSIF p_attr_id = QP_Seg_Util.G_USER_PRECEDENCE THEN
406: l_SEG_rec.user_precedence := TO_NUMBER(p_attr_value);
407: ELSIF p_attr_id = QP_Seg_Util.G_USER_SEGMENT_NAME THEN
408: l_SEG_rec.user_segment_name := p_attr_value;
409: ELSIF p_attr_id = QP_Seg_Util.G_USER_VALUESET THEN
410: l_SEG_rec.user_valueset_id := TO_NUMBER(p_attr_value);
411: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_DESCRIPTION THEN
412: l_SEG_rec.seeded_description := p_attr_value;
413: ELSIF p_attr_id = QP_Seg_Util.G_USER_DESCRIPTION THEN
407: ELSIF p_attr_id = QP_Seg_Util.G_USER_SEGMENT_NAME THEN
408: l_SEG_rec.user_segment_name := p_attr_value;
409: ELSIF p_attr_id = QP_Seg_Util.G_USER_VALUESET THEN
410: l_SEG_rec.user_valueset_id := TO_NUMBER(p_attr_value);
411: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_DESCRIPTION THEN
412: l_SEG_rec.seeded_description := p_attr_value;
413: ELSIF p_attr_id = QP_Seg_Util.G_USER_DESCRIPTION THEN
414: l_SEG_rec.user_description := p_attr_value;
415: ELSIF p_attr_id = QP_Seg_Util.G_REQUIRED_FLAG THEN
409: ELSIF p_attr_id = QP_Seg_Util.G_USER_VALUESET THEN
410: l_SEG_rec.user_valueset_id := TO_NUMBER(p_attr_value);
411: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_DESCRIPTION THEN
412: l_SEG_rec.seeded_description := p_attr_value;
413: ELSIF p_attr_id = QP_Seg_Util.G_USER_DESCRIPTION THEN
414: l_SEG_rec.user_description := p_attr_value;
415: ELSIF p_attr_id = QP_Seg_Util.G_REQUIRED_FLAG THEN
416: l_SEG_rec.required_flag := NVL(p_attr_value, 'N');
417: -- Added for TCA
411: ELSIF p_attr_id = QP_Seg_Util.G_SEEDED_DESCRIPTION THEN
412: l_SEG_rec.seeded_description := p_attr_value;
413: ELSIF p_attr_id = QP_Seg_Util.G_USER_DESCRIPTION THEN
414: l_SEG_rec.user_description := p_attr_value;
415: ELSIF p_attr_id = QP_Seg_Util.G_REQUIRED_FLAG THEN
416: l_SEG_rec.required_flag := NVL(p_attr_value, 'N');
417: -- Added for TCA
418: ELSIF p_attr_id = QP_Seg_Util.G_PARTY_HIERARCHY_ENABLED_FLAG THEN
419: l_SEG_rec.party_hierarchy_enabled_flag := NVL(p_attr_value, 'N');
414: l_SEG_rec.user_description := p_attr_value;
415: ELSIF p_attr_id = QP_Seg_Util.G_REQUIRED_FLAG THEN
416: l_SEG_rec.required_flag := NVL(p_attr_value, 'N');
417: -- Added for TCA
418: ELSIF p_attr_id = QP_Seg_Util.G_PARTY_HIERARCHY_ENABLED_FLAG THEN
419: l_SEG_rec.party_hierarchy_enabled_flag := NVL(p_attr_value, 'N');
420: ELSIF p_attr_id = QP_Seg_Util.G_ATTRIBUTE1
421: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE10
422: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE11
416: l_SEG_rec.required_flag := NVL(p_attr_value, 'N');
417: -- Added for TCA
418: ELSIF p_attr_id = QP_Seg_Util.G_PARTY_HIERARCHY_ENABLED_FLAG THEN
419: l_SEG_rec.party_hierarchy_enabled_flag := NVL(p_attr_value, 'N');
420: ELSIF p_attr_id = QP_Seg_Util.G_ATTRIBUTE1
421: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE10
422: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE11
423: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE12
424: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE13
417: -- Added for TCA
418: ELSIF p_attr_id = QP_Seg_Util.G_PARTY_HIERARCHY_ENABLED_FLAG THEN
419: l_SEG_rec.party_hierarchy_enabled_flag := NVL(p_attr_value, 'N');
420: ELSIF p_attr_id = QP_Seg_Util.G_ATTRIBUTE1
421: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE10
422: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE11
423: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE12
424: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE13
425: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE14
418: ELSIF p_attr_id = QP_Seg_Util.G_PARTY_HIERARCHY_ENABLED_FLAG THEN
419: l_SEG_rec.party_hierarchy_enabled_flag := NVL(p_attr_value, 'N');
420: ELSIF p_attr_id = QP_Seg_Util.G_ATTRIBUTE1
421: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE10
422: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE11
423: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE12
424: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE13
425: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE14
426: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE15
419: l_SEG_rec.party_hierarchy_enabled_flag := NVL(p_attr_value, 'N');
420: ELSIF p_attr_id = QP_Seg_Util.G_ATTRIBUTE1
421: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE10
422: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE11
423: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE12
424: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE13
425: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE14
426: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE15
427: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE2
420: ELSIF p_attr_id = QP_Seg_Util.G_ATTRIBUTE1
421: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE10
422: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE11
423: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE12
424: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE13
425: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE14
426: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE15
427: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE2
428: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE3
421: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE10
422: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE11
423: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE12
424: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE13
425: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE14
426: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE15
427: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE2
428: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE3
429: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE4
422: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE11
423: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE12
424: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE13
425: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE14
426: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE15
427: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE2
428: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE3
429: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE4
430: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE5
423: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE12
424: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE13
425: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE14
426: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE15
427: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE2
428: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE3
429: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE4
430: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE5
431: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE6
424: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE13
425: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE14
426: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE15
427: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE2
428: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE3
429: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE4
430: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE5
431: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE6
432: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE7
425: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE14
426: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE15
427: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE2
428: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE3
429: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE4
430: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE5
431: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE6
432: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE7
433: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE8
426: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE15
427: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE2
428: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE3
429: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE4
430: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE5
431: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE6
432: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE7
433: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE8
434: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE9
427: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE2
428: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE3
429: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE4
430: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE5
431: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE6
432: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE7
433: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE8
434: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE9
435: OR p_attr_id = QP_Seg_Util.G_CONTEXT
428: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE3
429: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE4
430: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE5
431: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE6
432: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE7
433: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE8
434: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE9
435: OR p_attr_id = QP_Seg_Util.G_CONTEXT
436: THEN
429: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE4
430: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE5
431: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE6
432: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE7
433: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE8
434: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE9
435: OR p_attr_id = QP_Seg_Util.G_CONTEXT
436: THEN
437:
430: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE5
431: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE6
432: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE7
433: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE8
434: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE9
435: OR p_attr_id = QP_Seg_Util.G_CONTEXT
436: THEN
437:
438: l_SEG_rec.attribute1 := p_attribute1;
431: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE6
432: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE7
433: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE8
434: OR p_attr_id = QP_Seg_Util.G_ATTRIBUTE9
435: OR p_attr_id = QP_Seg_Util.G_CONTEXT
436: THEN
437:
438: l_SEG_rec.attribute1 := p_attribute1;
439: l_SEG_rec.attribute10 := p_attribute10;
553: x_party_hierarchy_enabled_flag := FND_API.G_MISS_CHAR; -- Added for TCA
554:
555: -- Load display out parameters if any
556:
557: l_SEG_val_rec := QP_Seg_Util.Get_Values
558: ( p_SEG_rec => l_x_SEG_rec
559: , p_old_SEG_rec => l_SEG_rec
560: );
561:
1474: THEN
1475:
1476: -- Query row from DB
1477:
1478: g_SEG_rec := QP_Seg_Util.Query_Row
1479: ( p_segment_id => p_segment_id
1480: );
1481:
1482: g_SEG_rec.db_flag := FND_API.G_TRUE;