eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_EXT_FWK_PUB dependencies on FND_FLEX_VALUES

Line 571: -- FND_FLEX_VALUES and FND_FLEX_VALUES_TL

567: -- Requirement: bug: 3542670
568: --
569: -- Function: To process value set values.
570: -- Given all the parameters, the data is inserted into
571: -- FND_FLEX_VALUES and FND_FLEX_VALUES_TL
572: --
573: -- Parameters:
574: -- IN
575: -- p_transaction_type : CREATE, UPDATE

Line 603: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;

599: ,x_return_status OUT NOCOPY VARCHAR2
600: ) IS
601:
602: l_api_name VARCHAR2(30);
603: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
604: l_value_set_id FND_FLEX_VALUES.flex_value_set_id%TYPE;
605: l_Sysdate DATE;
606: l_rowid VARCHAR2(100);
607:

Line 604: l_value_set_id FND_FLEX_VALUES.flex_value_set_id%TYPE;

600: ) IS
601:
602: l_api_name VARCHAR2(30);
603: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
604: l_value_set_id FND_FLEX_VALUES.flex_value_set_id%TYPE;
605: l_Sysdate DATE;
606: l_rowid VARCHAR2(100);
607:
608: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

Line 614: l_rec_fnd_flex_values FND_FLEX_VALUES%ROWTYPE;

610: l_msg_count NUMBER;
611: l_msg_data VARCHAR2(32767);
612: l_owner NUMBER;
613: --bug 13629961
614: l_rec_fnd_flex_values FND_FLEX_VALUES%ROWTYPE;
615:
616: BEGIN
617:
618: l_api_name := 'PVT_Process_Value_Set_Val';

Line 651: SELECT fnd_flex_values_s.NEXTVAL

647: WHERE flex_value_set_name = p_value_set_name;
648:
649: IF p_transaction_type = 'CREATE' THEN
650: -- create an translatable independent value set
651: SELECT fnd_flex_values_s.NEXTVAL
652: INTO l_flex_value_id
653: FROM dual;
654: FND_FLEX_VALUES_PKG.INSERT_ROW
655: (x_rowid => l_rowid

Line 654: FND_FLEX_VALUES_PKG.INSERT_ROW

650: -- create an translatable independent value set
651: SELECT fnd_flex_values_s.NEXTVAL
652: INTO l_flex_value_id
653: FROM dual;
654: FND_FLEX_VALUES_PKG.INSERT_ROW
655: (x_rowid => l_rowid
656: ,x_flex_value_id => l_flex_value_id
657: ,x_attribute_sort_order => NULL
658: ,x_flex_value_set_id => l_value_set_id

Line 732: INTO l_rec_fnd_flex_values

728: ELSIF p_transaction_type = 'UPDATE' THEN
729: --bug 13629961
730: --When some Attribute has value, it is overridden with NULL value,hence getting the value from table and resetting
731: SELECT *
732: INTO l_rec_fnd_flex_values
733: FROM fnd_flex_values
734: WHERE flex_value_set_id = l_value_set_id
735: AND flex_value = p_internal_name;
736:

Line 733: FROM fnd_flex_values

729: --bug 13629961
730: --When some Attribute has value, it is overridden with NULL value,hence getting the value from table and resetting
731: SELECT *
732: INTO l_rec_fnd_flex_values
733: FROM fnd_flex_values
734: WHERE flex_value_set_id = l_value_set_id
735: AND flex_value = p_internal_name;
736:
737: FND_FLEX_VALUES_PKG.UPDATE_ROW

Line 737: FND_FLEX_VALUES_PKG.UPDATE_ROW

733: FROM fnd_flex_values
734: WHERE flex_value_set_id = l_value_set_id
735: AND flex_value = p_internal_name;
736:
737: FND_FLEX_VALUES_PKG.UPDATE_ROW
738: (x_flex_value_id =>l_rec_fnd_flex_values.FLEX_VALUE_ID
739: ,x_attribute_sort_order => NULL
740: ,x_flex_value_set_id => l_value_set_id
741: ,x_flex_value => p_internal_name

Line 738: (x_flex_value_id =>l_rec_fnd_flex_values.FLEX_VALUE_ID

734: WHERE flex_value_set_id = l_value_set_id
735: AND flex_value = p_internal_name;
736:
737: FND_FLEX_VALUES_PKG.UPDATE_ROW
738: (x_flex_value_id =>l_rec_fnd_flex_values.FLEX_VALUE_ID
739: ,x_attribute_sort_order => NULL
740: ,x_flex_value_set_id => l_value_set_id
741: ,x_flex_value => p_internal_name
742: ,x_enabled_flag => p_enabled

Line 746: ,x_parent_flex_value_low =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_LOW

742: ,x_enabled_flag => p_enabled
743: ,x_summary_flag => 'N'
744: ,x_start_date_active => p_start_date
745: ,x_end_date_active => p_end_date
746: ,x_parent_flex_value_low =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_LOW
747: ,x_parent_flex_value_high =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_HIGH
748: ,x_structured_hierarchy_level =>l_rec_fnd_flex_values.STRUCTURED_HIERARCHY_LEVEL
749: ,x_hierarchy_level => l_rec_fnd_flex_values.HIERARCHY_LEVEL
750: ,x_compiled_value_attributes =>l_rec_fnd_flex_values.COMPILED_VALUE_ATTRIBUTES

Line 747: ,x_parent_flex_value_high =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_HIGH

743: ,x_summary_flag => 'N'
744: ,x_start_date_active => p_start_date
745: ,x_end_date_active => p_end_date
746: ,x_parent_flex_value_low =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_LOW
747: ,x_parent_flex_value_high =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_HIGH
748: ,x_structured_hierarchy_level =>l_rec_fnd_flex_values.STRUCTURED_HIERARCHY_LEVEL
749: ,x_hierarchy_level => l_rec_fnd_flex_values.HIERARCHY_LEVEL
750: ,x_compiled_value_attributes =>l_rec_fnd_flex_values.COMPILED_VALUE_ATTRIBUTES
751: ,x_value_category => l_rec_fnd_flex_values.VALUE_CATEGORY

Line 748: ,x_structured_hierarchy_level =>l_rec_fnd_flex_values.STRUCTURED_HIERARCHY_LEVEL

744: ,x_start_date_active => p_start_date
745: ,x_end_date_active => p_end_date
746: ,x_parent_flex_value_low =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_LOW
747: ,x_parent_flex_value_high =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_HIGH
748: ,x_structured_hierarchy_level =>l_rec_fnd_flex_values.STRUCTURED_HIERARCHY_LEVEL
749: ,x_hierarchy_level => l_rec_fnd_flex_values.HIERARCHY_LEVEL
750: ,x_compiled_value_attributes =>l_rec_fnd_flex_values.COMPILED_VALUE_ATTRIBUTES
751: ,x_value_category => l_rec_fnd_flex_values.VALUE_CATEGORY
752: ,x_attribute1 => l_rec_fnd_flex_values.ATTRIBUTE1

Line 749: ,x_hierarchy_level => l_rec_fnd_flex_values.HIERARCHY_LEVEL

745: ,x_end_date_active => p_end_date
746: ,x_parent_flex_value_low =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_LOW
747: ,x_parent_flex_value_high =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_HIGH
748: ,x_structured_hierarchy_level =>l_rec_fnd_flex_values.STRUCTURED_HIERARCHY_LEVEL
749: ,x_hierarchy_level => l_rec_fnd_flex_values.HIERARCHY_LEVEL
750: ,x_compiled_value_attributes =>l_rec_fnd_flex_values.COMPILED_VALUE_ATTRIBUTES
751: ,x_value_category => l_rec_fnd_flex_values.VALUE_CATEGORY
752: ,x_attribute1 => l_rec_fnd_flex_values.ATTRIBUTE1
753: ,x_attribute2 => l_rec_fnd_flex_values.ATTRIBUTE2

Line 750: ,x_compiled_value_attributes =>l_rec_fnd_flex_values.COMPILED_VALUE_ATTRIBUTES

746: ,x_parent_flex_value_low =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_LOW
747: ,x_parent_flex_value_high =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_HIGH
748: ,x_structured_hierarchy_level =>l_rec_fnd_flex_values.STRUCTURED_HIERARCHY_LEVEL
749: ,x_hierarchy_level => l_rec_fnd_flex_values.HIERARCHY_LEVEL
750: ,x_compiled_value_attributes =>l_rec_fnd_flex_values.COMPILED_VALUE_ATTRIBUTES
751: ,x_value_category => l_rec_fnd_flex_values.VALUE_CATEGORY
752: ,x_attribute1 => l_rec_fnd_flex_values.ATTRIBUTE1
753: ,x_attribute2 => l_rec_fnd_flex_values.ATTRIBUTE2
754: ,x_attribute3 => l_rec_fnd_flex_values.ATTRIBUTE3

Line 751: ,x_value_category => l_rec_fnd_flex_values.VALUE_CATEGORY

747: ,x_parent_flex_value_high =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_HIGH
748: ,x_structured_hierarchy_level =>l_rec_fnd_flex_values.STRUCTURED_HIERARCHY_LEVEL
749: ,x_hierarchy_level => l_rec_fnd_flex_values.HIERARCHY_LEVEL
750: ,x_compiled_value_attributes =>l_rec_fnd_flex_values.COMPILED_VALUE_ATTRIBUTES
751: ,x_value_category => l_rec_fnd_flex_values.VALUE_CATEGORY
752: ,x_attribute1 => l_rec_fnd_flex_values.ATTRIBUTE1
753: ,x_attribute2 => l_rec_fnd_flex_values.ATTRIBUTE2
754: ,x_attribute3 => l_rec_fnd_flex_values.ATTRIBUTE3
755: ,x_attribute4 => l_rec_fnd_flex_values.ATTRIBUTE4

Line 752: ,x_attribute1 => l_rec_fnd_flex_values.ATTRIBUTE1

748: ,x_structured_hierarchy_level =>l_rec_fnd_flex_values.STRUCTURED_HIERARCHY_LEVEL
749: ,x_hierarchy_level => l_rec_fnd_flex_values.HIERARCHY_LEVEL
750: ,x_compiled_value_attributes =>l_rec_fnd_flex_values.COMPILED_VALUE_ATTRIBUTES
751: ,x_value_category => l_rec_fnd_flex_values.VALUE_CATEGORY
752: ,x_attribute1 => l_rec_fnd_flex_values.ATTRIBUTE1
753: ,x_attribute2 => l_rec_fnd_flex_values.ATTRIBUTE2
754: ,x_attribute3 => l_rec_fnd_flex_values.ATTRIBUTE3
755: ,x_attribute4 => l_rec_fnd_flex_values.ATTRIBUTE4
756: ,x_attribute5 => l_rec_fnd_flex_values.ATTRIBUTE5

Line 753: ,x_attribute2 => l_rec_fnd_flex_values.ATTRIBUTE2

749: ,x_hierarchy_level => l_rec_fnd_flex_values.HIERARCHY_LEVEL
750: ,x_compiled_value_attributes =>l_rec_fnd_flex_values.COMPILED_VALUE_ATTRIBUTES
751: ,x_value_category => l_rec_fnd_flex_values.VALUE_CATEGORY
752: ,x_attribute1 => l_rec_fnd_flex_values.ATTRIBUTE1
753: ,x_attribute2 => l_rec_fnd_flex_values.ATTRIBUTE2
754: ,x_attribute3 => l_rec_fnd_flex_values.ATTRIBUTE3
755: ,x_attribute4 => l_rec_fnd_flex_values.ATTRIBUTE4
756: ,x_attribute5 => l_rec_fnd_flex_values.ATTRIBUTE5
757: ,x_attribute6 => l_rec_fnd_flex_values.ATTRIBUTE6

Line 754: ,x_attribute3 => l_rec_fnd_flex_values.ATTRIBUTE3

750: ,x_compiled_value_attributes =>l_rec_fnd_flex_values.COMPILED_VALUE_ATTRIBUTES
751: ,x_value_category => l_rec_fnd_flex_values.VALUE_CATEGORY
752: ,x_attribute1 => l_rec_fnd_flex_values.ATTRIBUTE1
753: ,x_attribute2 => l_rec_fnd_flex_values.ATTRIBUTE2
754: ,x_attribute3 => l_rec_fnd_flex_values.ATTRIBUTE3
755: ,x_attribute4 => l_rec_fnd_flex_values.ATTRIBUTE4
756: ,x_attribute5 => l_rec_fnd_flex_values.ATTRIBUTE5
757: ,x_attribute6 => l_rec_fnd_flex_values.ATTRIBUTE6
758: ,x_attribute7 => l_rec_fnd_flex_values.ATTRIBUTE7

Line 755: ,x_attribute4 => l_rec_fnd_flex_values.ATTRIBUTE4

751: ,x_value_category => l_rec_fnd_flex_values.VALUE_CATEGORY
752: ,x_attribute1 => l_rec_fnd_flex_values.ATTRIBUTE1
753: ,x_attribute2 => l_rec_fnd_flex_values.ATTRIBUTE2
754: ,x_attribute3 => l_rec_fnd_flex_values.ATTRIBUTE3
755: ,x_attribute4 => l_rec_fnd_flex_values.ATTRIBUTE4
756: ,x_attribute5 => l_rec_fnd_flex_values.ATTRIBUTE5
757: ,x_attribute6 => l_rec_fnd_flex_values.ATTRIBUTE6
758: ,x_attribute7 => l_rec_fnd_flex_values.ATTRIBUTE7
759: ,x_attribute8 => l_rec_fnd_flex_values.ATTRIBUTE8

Line 756: ,x_attribute5 => l_rec_fnd_flex_values.ATTRIBUTE5

752: ,x_attribute1 => l_rec_fnd_flex_values.ATTRIBUTE1
753: ,x_attribute2 => l_rec_fnd_flex_values.ATTRIBUTE2
754: ,x_attribute3 => l_rec_fnd_flex_values.ATTRIBUTE3
755: ,x_attribute4 => l_rec_fnd_flex_values.ATTRIBUTE4
756: ,x_attribute5 => l_rec_fnd_flex_values.ATTRIBUTE5
757: ,x_attribute6 => l_rec_fnd_flex_values.ATTRIBUTE6
758: ,x_attribute7 => l_rec_fnd_flex_values.ATTRIBUTE7
759: ,x_attribute8 => l_rec_fnd_flex_values.ATTRIBUTE8
760: ,x_attribute9 => l_rec_fnd_flex_values.ATTRIBUTE9

Line 757: ,x_attribute6 => l_rec_fnd_flex_values.ATTRIBUTE6

753: ,x_attribute2 => l_rec_fnd_flex_values.ATTRIBUTE2
754: ,x_attribute3 => l_rec_fnd_flex_values.ATTRIBUTE3
755: ,x_attribute4 => l_rec_fnd_flex_values.ATTRIBUTE4
756: ,x_attribute5 => l_rec_fnd_flex_values.ATTRIBUTE5
757: ,x_attribute6 => l_rec_fnd_flex_values.ATTRIBUTE6
758: ,x_attribute7 => l_rec_fnd_flex_values.ATTRIBUTE7
759: ,x_attribute8 => l_rec_fnd_flex_values.ATTRIBUTE8
760: ,x_attribute9 => l_rec_fnd_flex_values.ATTRIBUTE9
761: ,x_attribute10 => l_rec_fnd_flex_values.ATTRIBUTE10

Line 758: ,x_attribute7 => l_rec_fnd_flex_values.ATTRIBUTE7

754: ,x_attribute3 => l_rec_fnd_flex_values.ATTRIBUTE3
755: ,x_attribute4 => l_rec_fnd_flex_values.ATTRIBUTE4
756: ,x_attribute5 => l_rec_fnd_flex_values.ATTRIBUTE5
757: ,x_attribute6 => l_rec_fnd_flex_values.ATTRIBUTE6
758: ,x_attribute7 => l_rec_fnd_flex_values.ATTRIBUTE7
759: ,x_attribute8 => l_rec_fnd_flex_values.ATTRIBUTE8
760: ,x_attribute9 => l_rec_fnd_flex_values.ATTRIBUTE9
761: ,x_attribute10 => l_rec_fnd_flex_values.ATTRIBUTE10
762: ,x_attribute11 => l_rec_fnd_flex_values.ATTRIBUTE11

Line 759: ,x_attribute8 => l_rec_fnd_flex_values.ATTRIBUTE8

755: ,x_attribute4 => l_rec_fnd_flex_values.ATTRIBUTE4
756: ,x_attribute5 => l_rec_fnd_flex_values.ATTRIBUTE5
757: ,x_attribute6 => l_rec_fnd_flex_values.ATTRIBUTE6
758: ,x_attribute7 => l_rec_fnd_flex_values.ATTRIBUTE7
759: ,x_attribute8 => l_rec_fnd_flex_values.ATTRIBUTE8
760: ,x_attribute9 => l_rec_fnd_flex_values.ATTRIBUTE9
761: ,x_attribute10 => l_rec_fnd_flex_values.ATTRIBUTE10
762: ,x_attribute11 => l_rec_fnd_flex_values.ATTRIBUTE11
763: ,x_attribute12 => l_rec_fnd_flex_values.ATTRIBUTE12

Line 760: ,x_attribute9 => l_rec_fnd_flex_values.ATTRIBUTE9

756: ,x_attribute5 => l_rec_fnd_flex_values.ATTRIBUTE5
757: ,x_attribute6 => l_rec_fnd_flex_values.ATTRIBUTE6
758: ,x_attribute7 => l_rec_fnd_flex_values.ATTRIBUTE7
759: ,x_attribute8 => l_rec_fnd_flex_values.ATTRIBUTE8
760: ,x_attribute9 => l_rec_fnd_flex_values.ATTRIBUTE9
761: ,x_attribute10 => l_rec_fnd_flex_values.ATTRIBUTE10
762: ,x_attribute11 => l_rec_fnd_flex_values.ATTRIBUTE11
763: ,x_attribute12 => l_rec_fnd_flex_values.ATTRIBUTE12
764: ,x_attribute13 => l_rec_fnd_flex_values.ATTRIBUTE13

Line 761: ,x_attribute10 => l_rec_fnd_flex_values.ATTRIBUTE10

757: ,x_attribute6 => l_rec_fnd_flex_values.ATTRIBUTE6
758: ,x_attribute7 => l_rec_fnd_flex_values.ATTRIBUTE7
759: ,x_attribute8 => l_rec_fnd_flex_values.ATTRIBUTE8
760: ,x_attribute9 => l_rec_fnd_flex_values.ATTRIBUTE9
761: ,x_attribute10 => l_rec_fnd_flex_values.ATTRIBUTE10
762: ,x_attribute11 => l_rec_fnd_flex_values.ATTRIBUTE11
763: ,x_attribute12 => l_rec_fnd_flex_values.ATTRIBUTE12
764: ,x_attribute13 => l_rec_fnd_flex_values.ATTRIBUTE13
765: ,x_attribute14 => l_rec_fnd_flex_values.ATTRIBUTE14

Line 762: ,x_attribute11 => l_rec_fnd_flex_values.ATTRIBUTE11

758: ,x_attribute7 => l_rec_fnd_flex_values.ATTRIBUTE7
759: ,x_attribute8 => l_rec_fnd_flex_values.ATTRIBUTE8
760: ,x_attribute9 => l_rec_fnd_flex_values.ATTRIBUTE9
761: ,x_attribute10 => l_rec_fnd_flex_values.ATTRIBUTE10
762: ,x_attribute11 => l_rec_fnd_flex_values.ATTRIBUTE11
763: ,x_attribute12 => l_rec_fnd_flex_values.ATTRIBUTE12
764: ,x_attribute13 => l_rec_fnd_flex_values.ATTRIBUTE13
765: ,x_attribute14 => l_rec_fnd_flex_values.ATTRIBUTE14
766: ,x_attribute15 => l_rec_fnd_flex_values.ATTRIBUTE15

Line 763: ,x_attribute12 => l_rec_fnd_flex_values.ATTRIBUTE12

759: ,x_attribute8 => l_rec_fnd_flex_values.ATTRIBUTE8
760: ,x_attribute9 => l_rec_fnd_flex_values.ATTRIBUTE9
761: ,x_attribute10 => l_rec_fnd_flex_values.ATTRIBUTE10
762: ,x_attribute11 => l_rec_fnd_flex_values.ATTRIBUTE11
763: ,x_attribute12 => l_rec_fnd_flex_values.ATTRIBUTE12
764: ,x_attribute13 => l_rec_fnd_flex_values.ATTRIBUTE13
765: ,x_attribute14 => l_rec_fnd_flex_values.ATTRIBUTE14
766: ,x_attribute15 => l_rec_fnd_flex_values.ATTRIBUTE15
767: ,x_attribute16 => l_rec_fnd_flex_values.ATTRIBUTE16

Line 764: ,x_attribute13 => l_rec_fnd_flex_values.ATTRIBUTE13

760: ,x_attribute9 => l_rec_fnd_flex_values.ATTRIBUTE9
761: ,x_attribute10 => l_rec_fnd_flex_values.ATTRIBUTE10
762: ,x_attribute11 => l_rec_fnd_flex_values.ATTRIBUTE11
763: ,x_attribute12 => l_rec_fnd_flex_values.ATTRIBUTE12
764: ,x_attribute13 => l_rec_fnd_flex_values.ATTRIBUTE13
765: ,x_attribute14 => l_rec_fnd_flex_values.ATTRIBUTE14
766: ,x_attribute15 => l_rec_fnd_flex_values.ATTRIBUTE15
767: ,x_attribute16 => l_rec_fnd_flex_values.ATTRIBUTE16
768: ,x_attribute17 => l_rec_fnd_flex_values.ATTRIBUTE17

Line 765: ,x_attribute14 => l_rec_fnd_flex_values.ATTRIBUTE14

761: ,x_attribute10 => l_rec_fnd_flex_values.ATTRIBUTE10
762: ,x_attribute11 => l_rec_fnd_flex_values.ATTRIBUTE11
763: ,x_attribute12 => l_rec_fnd_flex_values.ATTRIBUTE12
764: ,x_attribute13 => l_rec_fnd_flex_values.ATTRIBUTE13
765: ,x_attribute14 => l_rec_fnd_flex_values.ATTRIBUTE14
766: ,x_attribute15 => l_rec_fnd_flex_values.ATTRIBUTE15
767: ,x_attribute16 => l_rec_fnd_flex_values.ATTRIBUTE16
768: ,x_attribute17 => l_rec_fnd_flex_values.ATTRIBUTE17
769: ,x_attribute18 => l_rec_fnd_flex_values.ATTRIBUTE18

Line 766: ,x_attribute15 => l_rec_fnd_flex_values.ATTRIBUTE15

762: ,x_attribute11 => l_rec_fnd_flex_values.ATTRIBUTE11
763: ,x_attribute12 => l_rec_fnd_flex_values.ATTRIBUTE12
764: ,x_attribute13 => l_rec_fnd_flex_values.ATTRIBUTE13
765: ,x_attribute14 => l_rec_fnd_flex_values.ATTRIBUTE14
766: ,x_attribute15 => l_rec_fnd_flex_values.ATTRIBUTE15
767: ,x_attribute16 => l_rec_fnd_flex_values.ATTRIBUTE16
768: ,x_attribute17 => l_rec_fnd_flex_values.ATTRIBUTE17
769: ,x_attribute18 => l_rec_fnd_flex_values.ATTRIBUTE18
770: ,x_attribute19 => l_rec_fnd_flex_values.ATTRIBUTE19

Line 767: ,x_attribute16 => l_rec_fnd_flex_values.ATTRIBUTE16

763: ,x_attribute12 => l_rec_fnd_flex_values.ATTRIBUTE12
764: ,x_attribute13 => l_rec_fnd_flex_values.ATTRIBUTE13
765: ,x_attribute14 => l_rec_fnd_flex_values.ATTRIBUTE14
766: ,x_attribute15 => l_rec_fnd_flex_values.ATTRIBUTE15
767: ,x_attribute16 => l_rec_fnd_flex_values.ATTRIBUTE16
768: ,x_attribute17 => l_rec_fnd_flex_values.ATTRIBUTE17
769: ,x_attribute18 => l_rec_fnd_flex_values.ATTRIBUTE18
770: ,x_attribute19 => l_rec_fnd_flex_values.ATTRIBUTE19
771: ,x_attribute20 => l_rec_fnd_flex_values.ATTRIBUTE20

Line 768: ,x_attribute17 => l_rec_fnd_flex_values.ATTRIBUTE17

764: ,x_attribute13 => l_rec_fnd_flex_values.ATTRIBUTE13
765: ,x_attribute14 => l_rec_fnd_flex_values.ATTRIBUTE14
766: ,x_attribute15 => l_rec_fnd_flex_values.ATTRIBUTE15
767: ,x_attribute16 => l_rec_fnd_flex_values.ATTRIBUTE16
768: ,x_attribute17 => l_rec_fnd_flex_values.ATTRIBUTE17
769: ,x_attribute18 => l_rec_fnd_flex_values.ATTRIBUTE18
770: ,x_attribute19 => l_rec_fnd_flex_values.ATTRIBUTE19
771: ,x_attribute20 => l_rec_fnd_flex_values.ATTRIBUTE20
772: ,x_attribute21 => l_rec_fnd_flex_values.ATTRIBUTE21

Line 769: ,x_attribute18 => l_rec_fnd_flex_values.ATTRIBUTE18

765: ,x_attribute14 => l_rec_fnd_flex_values.ATTRIBUTE14
766: ,x_attribute15 => l_rec_fnd_flex_values.ATTRIBUTE15
767: ,x_attribute16 => l_rec_fnd_flex_values.ATTRIBUTE16
768: ,x_attribute17 => l_rec_fnd_flex_values.ATTRIBUTE17
769: ,x_attribute18 => l_rec_fnd_flex_values.ATTRIBUTE18
770: ,x_attribute19 => l_rec_fnd_flex_values.ATTRIBUTE19
771: ,x_attribute20 => l_rec_fnd_flex_values.ATTRIBUTE20
772: ,x_attribute21 => l_rec_fnd_flex_values.ATTRIBUTE21
773: ,x_attribute22 => l_rec_fnd_flex_values.ATTRIBUTE22

Line 770: ,x_attribute19 => l_rec_fnd_flex_values.ATTRIBUTE19

766: ,x_attribute15 => l_rec_fnd_flex_values.ATTRIBUTE15
767: ,x_attribute16 => l_rec_fnd_flex_values.ATTRIBUTE16
768: ,x_attribute17 => l_rec_fnd_flex_values.ATTRIBUTE17
769: ,x_attribute18 => l_rec_fnd_flex_values.ATTRIBUTE18
770: ,x_attribute19 => l_rec_fnd_flex_values.ATTRIBUTE19
771: ,x_attribute20 => l_rec_fnd_flex_values.ATTRIBUTE20
772: ,x_attribute21 => l_rec_fnd_flex_values.ATTRIBUTE21
773: ,x_attribute22 => l_rec_fnd_flex_values.ATTRIBUTE22
774: ,x_attribute23 => l_rec_fnd_flex_values.ATTRIBUTE23

Line 771: ,x_attribute20 => l_rec_fnd_flex_values.ATTRIBUTE20

767: ,x_attribute16 => l_rec_fnd_flex_values.ATTRIBUTE16
768: ,x_attribute17 => l_rec_fnd_flex_values.ATTRIBUTE17
769: ,x_attribute18 => l_rec_fnd_flex_values.ATTRIBUTE18
770: ,x_attribute19 => l_rec_fnd_flex_values.ATTRIBUTE19
771: ,x_attribute20 => l_rec_fnd_flex_values.ATTRIBUTE20
772: ,x_attribute21 => l_rec_fnd_flex_values.ATTRIBUTE21
773: ,x_attribute22 => l_rec_fnd_flex_values.ATTRIBUTE22
774: ,x_attribute23 => l_rec_fnd_flex_values.ATTRIBUTE23
775: ,x_attribute24 => l_rec_fnd_flex_values.ATTRIBUTE24

Line 772: ,x_attribute21 => l_rec_fnd_flex_values.ATTRIBUTE21

768: ,x_attribute17 => l_rec_fnd_flex_values.ATTRIBUTE17
769: ,x_attribute18 => l_rec_fnd_flex_values.ATTRIBUTE18
770: ,x_attribute19 => l_rec_fnd_flex_values.ATTRIBUTE19
771: ,x_attribute20 => l_rec_fnd_flex_values.ATTRIBUTE20
772: ,x_attribute21 => l_rec_fnd_flex_values.ATTRIBUTE21
773: ,x_attribute22 => l_rec_fnd_flex_values.ATTRIBUTE22
774: ,x_attribute23 => l_rec_fnd_flex_values.ATTRIBUTE23
775: ,x_attribute24 => l_rec_fnd_flex_values.ATTRIBUTE24
776: ,x_attribute25 => l_rec_fnd_flex_values.ATTRIBUTE25

Line 773: ,x_attribute22 => l_rec_fnd_flex_values.ATTRIBUTE22

769: ,x_attribute18 => l_rec_fnd_flex_values.ATTRIBUTE18
770: ,x_attribute19 => l_rec_fnd_flex_values.ATTRIBUTE19
771: ,x_attribute20 => l_rec_fnd_flex_values.ATTRIBUTE20
772: ,x_attribute21 => l_rec_fnd_flex_values.ATTRIBUTE21
773: ,x_attribute22 => l_rec_fnd_flex_values.ATTRIBUTE22
774: ,x_attribute23 => l_rec_fnd_flex_values.ATTRIBUTE23
775: ,x_attribute24 => l_rec_fnd_flex_values.ATTRIBUTE24
776: ,x_attribute25 => l_rec_fnd_flex_values.ATTRIBUTE25
777: ,x_attribute26 => l_rec_fnd_flex_values.ATTRIBUTE26

Line 774: ,x_attribute23 => l_rec_fnd_flex_values.ATTRIBUTE23

770: ,x_attribute19 => l_rec_fnd_flex_values.ATTRIBUTE19
771: ,x_attribute20 => l_rec_fnd_flex_values.ATTRIBUTE20
772: ,x_attribute21 => l_rec_fnd_flex_values.ATTRIBUTE21
773: ,x_attribute22 => l_rec_fnd_flex_values.ATTRIBUTE22
774: ,x_attribute23 => l_rec_fnd_flex_values.ATTRIBUTE23
775: ,x_attribute24 => l_rec_fnd_flex_values.ATTRIBUTE24
776: ,x_attribute25 => l_rec_fnd_flex_values.ATTRIBUTE25
777: ,x_attribute26 => l_rec_fnd_flex_values.ATTRIBUTE26
778: ,x_attribute27 => l_rec_fnd_flex_values.ATTRIBUTE27

Line 775: ,x_attribute24 => l_rec_fnd_flex_values.ATTRIBUTE24

771: ,x_attribute20 => l_rec_fnd_flex_values.ATTRIBUTE20
772: ,x_attribute21 => l_rec_fnd_flex_values.ATTRIBUTE21
773: ,x_attribute22 => l_rec_fnd_flex_values.ATTRIBUTE22
774: ,x_attribute23 => l_rec_fnd_flex_values.ATTRIBUTE23
775: ,x_attribute24 => l_rec_fnd_flex_values.ATTRIBUTE24
776: ,x_attribute25 => l_rec_fnd_flex_values.ATTRIBUTE25
777: ,x_attribute26 => l_rec_fnd_flex_values.ATTRIBUTE26
778: ,x_attribute27 => l_rec_fnd_flex_values.ATTRIBUTE27
779: ,x_attribute28 => l_rec_fnd_flex_values.ATTRIBUTE28

Line 776: ,x_attribute25 => l_rec_fnd_flex_values.ATTRIBUTE25

772: ,x_attribute21 => l_rec_fnd_flex_values.ATTRIBUTE21
773: ,x_attribute22 => l_rec_fnd_flex_values.ATTRIBUTE22
774: ,x_attribute23 => l_rec_fnd_flex_values.ATTRIBUTE23
775: ,x_attribute24 => l_rec_fnd_flex_values.ATTRIBUTE24
776: ,x_attribute25 => l_rec_fnd_flex_values.ATTRIBUTE25
777: ,x_attribute26 => l_rec_fnd_flex_values.ATTRIBUTE26
778: ,x_attribute27 => l_rec_fnd_flex_values.ATTRIBUTE27
779: ,x_attribute28 => l_rec_fnd_flex_values.ATTRIBUTE28
780: ,x_attribute29 => l_rec_fnd_flex_values.ATTRIBUTE29

Line 777: ,x_attribute26 => l_rec_fnd_flex_values.ATTRIBUTE26

773: ,x_attribute22 => l_rec_fnd_flex_values.ATTRIBUTE22
774: ,x_attribute23 => l_rec_fnd_flex_values.ATTRIBUTE23
775: ,x_attribute24 => l_rec_fnd_flex_values.ATTRIBUTE24
776: ,x_attribute25 => l_rec_fnd_flex_values.ATTRIBUTE25
777: ,x_attribute26 => l_rec_fnd_flex_values.ATTRIBUTE26
778: ,x_attribute27 => l_rec_fnd_flex_values.ATTRIBUTE27
779: ,x_attribute28 => l_rec_fnd_flex_values.ATTRIBUTE28
780: ,x_attribute29 => l_rec_fnd_flex_values.ATTRIBUTE29
781: ,x_attribute30 => l_rec_fnd_flex_values.ATTRIBUTE30

Line 778: ,x_attribute27 => l_rec_fnd_flex_values.ATTRIBUTE27

774: ,x_attribute23 => l_rec_fnd_flex_values.ATTRIBUTE23
775: ,x_attribute24 => l_rec_fnd_flex_values.ATTRIBUTE24
776: ,x_attribute25 => l_rec_fnd_flex_values.ATTRIBUTE25
777: ,x_attribute26 => l_rec_fnd_flex_values.ATTRIBUTE26
778: ,x_attribute27 => l_rec_fnd_flex_values.ATTRIBUTE27
779: ,x_attribute28 => l_rec_fnd_flex_values.ATTRIBUTE28
780: ,x_attribute29 => l_rec_fnd_flex_values.ATTRIBUTE29
781: ,x_attribute30 => l_rec_fnd_flex_values.ATTRIBUTE30
782: ,x_attribute31 => l_rec_fnd_flex_values.ATTRIBUTE31

Line 779: ,x_attribute28 => l_rec_fnd_flex_values.ATTRIBUTE28

775: ,x_attribute24 => l_rec_fnd_flex_values.ATTRIBUTE24
776: ,x_attribute25 => l_rec_fnd_flex_values.ATTRIBUTE25
777: ,x_attribute26 => l_rec_fnd_flex_values.ATTRIBUTE26
778: ,x_attribute27 => l_rec_fnd_flex_values.ATTRIBUTE27
779: ,x_attribute28 => l_rec_fnd_flex_values.ATTRIBUTE28
780: ,x_attribute29 => l_rec_fnd_flex_values.ATTRIBUTE29
781: ,x_attribute30 => l_rec_fnd_flex_values.ATTRIBUTE30
782: ,x_attribute31 => l_rec_fnd_flex_values.ATTRIBUTE31
783: ,x_attribute32 => l_rec_fnd_flex_values.ATTRIBUTE32

Line 780: ,x_attribute29 => l_rec_fnd_flex_values.ATTRIBUTE29

776: ,x_attribute25 => l_rec_fnd_flex_values.ATTRIBUTE25
777: ,x_attribute26 => l_rec_fnd_flex_values.ATTRIBUTE26
778: ,x_attribute27 => l_rec_fnd_flex_values.ATTRIBUTE27
779: ,x_attribute28 => l_rec_fnd_flex_values.ATTRIBUTE28
780: ,x_attribute29 => l_rec_fnd_flex_values.ATTRIBUTE29
781: ,x_attribute30 => l_rec_fnd_flex_values.ATTRIBUTE30
782: ,x_attribute31 => l_rec_fnd_flex_values.ATTRIBUTE31
783: ,x_attribute32 => l_rec_fnd_flex_values.ATTRIBUTE32
784: ,x_attribute33 => l_rec_fnd_flex_values.ATTRIBUTE33

Line 781: ,x_attribute30 => l_rec_fnd_flex_values.ATTRIBUTE30

777: ,x_attribute26 => l_rec_fnd_flex_values.ATTRIBUTE26
778: ,x_attribute27 => l_rec_fnd_flex_values.ATTRIBUTE27
779: ,x_attribute28 => l_rec_fnd_flex_values.ATTRIBUTE28
780: ,x_attribute29 => l_rec_fnd_flex_values.ATTRIBUTE29
781: ,x_attribute30 => l_rec_fnd_flex_values.ATTRIBUTE30
782: ,x_attribute31 => l_rec_fnd_flex_values.ATTRIBUTE31
783: ,x_attribute32 => l_rec_fnd_flex_values.ATTRIBUTE32
784: ,x_attribute33 => l_rec_fnd_flex_values.ATTRIBUTE33
785: ,x_attribute34 => l_rec_fnd_flex_values.ATTRIBUTE34

Line 782: ,x_attribute31 => l_rec_fnd_flex_values.ATTRIBUTE31

778: ,x_attribute27 => l_rec_fnd_flex_values.ATTRIBUTE27
779: ,x_attribute28 => l_rec_fnd_flex_values.ATTRIBUTE28
780: ,x_attribute29 => l_rec_fnd_flex_values.ATTRIBUTE29
781: ,x_attribute30 => l_rec_fnd_flex_values.ATTRIBUTE30
782: ,x_attribute31 => l_rec_fnd_flex_values.ATTRIBUTE31
783: ,x_attribute32 => l_rec_fnd_flex_values.ATTRIBUTE32
784: ,x_attribute33 => l_rec_fnd_flex_values.ATTRIBUTE33
785: ,x_attribute34 => l_rec_fnd_flex_values.ATTRIBUTE34
786: ,x_attribute35 => l_rec_fnd_flex_values.ATTRIBUTE35

Line 783: ,x_attribute32 => l_rec_fnd_flex_values.ATTRIBUTE32

779: ,x_attribute28 => l_rec_fnd_flex_values.ATTRIBUTE28
780: ,x_attribute29 => l_rec_fnd_flex_values.ATTRIBUTE29
781: ,x_attribute30 => l_rec_fnd_flex_values.ATTRIBUTE30
782: ,x_attribute31 => l_rec_fnd_flex_values.ATTRIBUTE31
783: ,x_attribute32 => l_rec_fnd_flex_values.ATTRIBUTE32
784: ,x_attribute33 => l_rec_fnd_flex_values.ATTRIBUTE33
785: ,x_attribute34 => l_rec_fnd_flex_values.ATTRIBUTE34
786: ,x_attribute35 => l_rec_fnd_flex_values.ATTRIBUTE35
787: ,x_attribute36 => l_rec_fnd_flex_values.ATTRIBUTE36

Line 784: ,x_attribute33 => l_rec_fnd_flex_values.ATTRIBUTE33

780: ,x_attribute29 => l_rec_fnd_flex_values.ATTRIBUTE29
781: ,x_attribute30 => l_rec_fnd_flex_values.ATTRIBUTE30
782: ,x_attribute31 => l_rec_fnd_flex_values.ATTRIBUTE31
783: ,x_attribute32 => l_rec_fnd_flex_values.ATTRIBUTE32
784: ,x_attribute33 => l_rec_fnd_flex_values.ATTRIBUTE33
785: ,x_attribute34 => l_rec_fnd_flex_values.ATTRIBUTE34
786: ,x_attribute35 => l_rec_fnd_flex_values.ATTRIBUTE35
787: ,x_attribute36 => l_rec_fnd_flex_values.ATTRIBUTE36
788: ,x_attribute37 => l_rec_fnd_flex_values.ATTRIBUTE37

Line 785: ,x_attribute34 => l_rec_fnd_flex_values.ATTRIBUTE34

781: ,x_attribute30 => l_rec_fnd_flex_values.ATTRIBUTE30
782: ,x_attribute31 => l_rec_fnd_flex_values.ATTRIBUTE31
783: ,x_attribute32 => l_rec_fnd_flex_values.ATTRIBUTE32
784: ,x_attribute33 => l_rec_fnd_flex_values.ATTRIBUTE33
785: ,x_attribute34 => l_rec_fnd_flex_values.ATTRIBUTE34
786: ,x_attribute35 => l_rec_fnd_flex_values.ATTRIBUTE35
787: ,x_attribute36 => l_rec_fnd_flex_values.ATTRIBUTE36
788: ,x_attribute37 => l_rec_fnd_flex_values.ATTRIBUTE37
789: ,x_attribute38 => l_rec_fnd_flex_values.ATTRIBUTE38

Line 786: ,x_attribute35 => l_rec_fnd_flex_values.ATTRIBUTE35

782: ,x_attribute31 => l_rec_fnd_flex_values.ATTRIBUTE31
783: ,x_attribute32 => l_rec_fnd_flex_values.ATTRIBUTE32
784: ,x_attribute33 => l_rec_fnd_flex_values.ATTRIBUTE33
785: ,x_attribute34 => l_rec_fnd_flex_values.ATTRIBUTE34
786: ,x_attribute35 => l_rec_fnd_flex_values.ATTRIBUTE35
787: ,x_attribute36 => l_rec_fnd_flex_values.ATTRIBUTE36
788: ,x_attribute37 => l_rec_fnd_flex_values.ATTRIBUTE37
789: ,x_attribute38 => l_rec_fnd_flex_values.ATTRIBUTE38
790: ,x_attribute39 => l_rec_fnd_flex_values.ATTRIBUTE39

Line 787: ,x_attribute36 => l_rec_fnd_flex_values.ATTRIBUTE36

783: ,x_attribute32 => l_rec_fnd_flex_values.ATTRIBUTE32
784: ,x_attribute33 => l_rec_fnd_flex_values.ATTRIBUTE33
785: ,x_attribute34 => l_rec_fnd_flex_values.ATTRIBUTE34
786: ,x_attribute35 => l_rec_fnd_flex_values.ATTRIBUTE35
787: ,x_attribute36 => l_rec_fnd_flex_values.ATTRIBUTE36
788: ,x_attribute37 => l_rec_fnd_flex_values.ATTRIBUTE37
789: ,x_attribute38 => l_rec_fnd_flex_values.ATTRIBUTE38
790: ,x_attribute39 => l_rec_fnd_flex_values.ATTRIBUTE39
791: ,x_attribute40 => l_rec_fnd_flex_values.ATTRIBUTE40

Line 788: ,x_attribute37 => l_rec_fnd_flex_values.ATTRIBUTE37

784: ,x_attribute33 => l_rec_fnd_flex_values.ATTRIBUTE33
785: ,x_attribute34 => l_rec_fnd_flex_values.ATTRIBUTE34
786: ,x_attribute35 => l_rec_fnd_flex_values.ATTRIBUTE35
787: ,x_attribute36 => l_rec_fnd_flex_values.ATTRIBUTE36
788: ,x_attribute37 => l_rec_fnd_flex_values.ATTRIBUTE37
789: ,x_attribute38 => l_rec_fnd_flex_values.ATTRIBUTE38
790: ,x_attribute39 => l_rec_fnd_flex_values.ATTRIBUTE39
791: ,x_attribute40 => l_rec_fnd_flex_values.ATTRIBUTE40
792: ,x_attribute41 => l_rec_fnd_flex_values.ATTRIBUTE41

Line 789: ,x_attribute38 => l_rec_fnd_flex_values.ATTRIBUTE38

785: ,x_attribute34 => l_rec_fnd_flex_values.ATTRIBUTE34
786: ,x_attribute35 => l_rec_fnd_flex_values.ATTRIBUTE35
787: ,x_attribute36 => l_rec_fnd_flex_values.ATTRIBUTE36
788: ,x_attribute37 => l_rec_fnd_flex_values.ATTRIBUTE37
789: ,x_attribute38 => l_rec_fnd_flex_values.ATTRIBUTE38
790: ,x_attribute39 => l_rec_fnd_flex_values.ATTRIBUTE39
791: ,x_attribute40 => l_rec_fnd_flex_values.ATTRIBUTE40
792: ,x_attribute41 => l_rec_fnd_flex_values.ATTRIBUTE41
793: ,x_attribute42 => l_rec_fnd_flex_values.ATTRIBUTE42

Line 790: ,x_attribute39 => l_rec_fnd_flex_values.ATTRIBUTE39

786: ,x_attribute35 => l_rec_fnd_flex_values.ATTRIBUTE35
787: ,x_attribute36 => l_rec_fnd_flex_values.ATTRIBUTE36
788: ,x_attribute37 => l_rec_fnd_flex_values.ATTRIBUTE37
789: ,x_attribute38 => l_rec_fnd_flex_values.ATTRIBUTE38
790: ,x_attribute39 => l_rec_fnd_flex_values.ATTRIBUTE39
791: ,x_attribute40 => l_rec_fnd_flex_values.ATTRIBUTE40
792: ,x_attribute41 => l_rec_fnd_flex_values.ATTRIBUTE41
793: ,x_attribute42 => l_rec_fnd_flex_values.ATTRIBUTE42
794: ,x_attribute43 => l_rec_fnd_flex_values.ATTRIBUTE43

Line 791: ,x_attribute40 => l_rec_fnd_flex_values.ATTRIBUTE40

787: ,x_attribute36 => l_rec_fnd_flex_values.ATTRIBUTE36
788: ,x_attribute37 => l_rec_fnd_flex_values.ATTRIBUTE37
789: ,x_attribute38 => l_rec_fnd_flex_values.ATTRIBUTE38
790: ,x_attribute39 => l_rec_fnd_flex_values.ATTRIBUTE39
791: ,x_attribute40 => l_rec_fnd_flex_values.ATTRIBUTE40
792: ,x_attribute41 => l_rec_fnd_flex_values.ATTRIBUTE41
793: ,x_attribute42 => l_rec_fnd_flex_values.ATTRIBUTE42
794: ,x_attribute43 => l_rec_fnd_flex_values.ATTRIBUTE43
795: ,x_attribute44 => l_rec_fnd_flex_values.ATTRIBUTE44

Line 792: ,x_attribute41 => l_rec_fnd_flex_values.ATTRIBUTE41

788: ,x_attribute37 => l_rec_fnd_flex_values.ATTRIBUTE37
789: ,x_attribute38 => l_rec_fnd_flex_values.ATTRIBUTE38
790: ,x_attribute39 => l_rec_fnd_flex_values.ATTRIBUTE39
791: ,x_attribute40 => l_rec_fnd_flex_values.ATTRIBUTE40
792: ,x_attribute41 => l_rec_fnd_flex_values.ATTRIBUTE41
793: ,x_attribute42 => l_rec_fnd_flex_values.ATTRIBUTE42
794: ,x_attribute43 => l_rec_fnd_flex_values.ATTRIBUTE43
795: ,x_attribute44 => l_rec_fnd_flex_values.ATTRIBUTE44
796: ,x_attribute45 => l_rec_fnd_flex_values.ATTRIBUTE45

Line 793: ,x_attribute42 => l_rec_fnd_flex_values.ATTRIBUTE42

789: ,x_attribute38 => l_rec_fnd_flex_values.ATTRIBUTE38
790: ,x_attribute39 => l_rec_fnd_flex_values.ATTRIBUTE39
791: ,x_attribute40 => l_rec_fnd_flex_values.ATTRIBUTE40
792: ,x_attribute41 => l_rec_fnd_flex_values.ATTRIBUTE41
793: ,x_attribute42 => l_rec_fnd_flex_values.ATTRIBUTE42
794: ,x_attribute43 => l_rec_fnd_flex_values.ATTRIBUTE43
795: ,x_attribute44 => l_rec_fnd_flex_values.ATTRIBUTE44
796: ,x_attribute45 => l_rec_fnd_flex_values.ATTRIBUTE45
797: ,x_attribute46 => l_rec_fnd_flex_values.ATTRIBUTE46

Line 794: ,x_attribute43 => l_rec_fnd_flex_values.ATTRIBUTE43

790: ,x_attribute39 => l_rec_fnd_flex_values.ATTRIBUTE39
791: ,x_attribute40 => l_rec_fnd_flex_values.ATTRIBUTE40
792: ,x_attribute41 => l_rec_fnd_flex_values.ATTRIBUTE41
793: ,x_attribute42 => l_rec_fnd_flex_values.ATTRIBUTE42
794: ,x_attribute43 => l_rec_fnd_flex_values.ATTRIBUTE43
795: ,x_attribute44 => l_rec_fnd_flex_values.ATTRIBUTE44
796: ,x_attribute45 => l_rec_fnd_flex_values.ATTRIBUTE45
797: ,x_attribute46 => l_rec_fnd_flex_values.ATTRIBUTE46
798: ,x_attribute47 => l_rec_fnd_flex_values.ATTRIBUTE47

Line 795: ,x_attribute44 => l_rec_fnd_flex_values.ATTRIBUTE44

791: ,x_attribute40 => l_rec_fnd_flex_values.ATTRIBUTE40
792: ,x_attribute41 => l_rec_fnd_flex_values.ATTRIBUTE41
793: ,x_attribute42 => l_rec_fnd_flex_values.ATTRIBUTE42
794: ,x_attribute43 => l_rec_fnd_flex_values.ATTRIBUTE43
795: ,x_attribute44 => l_rec_fnd_flex_values.ATTRIBUTE44
796: ,x_attribute45 => l_rec_fnd_flex_values.ATTRIBUTE45
797: ,x_attribute46 => l_rec_fnd_flex_values.ATTRIBUTE46
798: ,x_attribute47 => l_rec_fnd_flex_values.ATTRIBUTE47
799: ,x_attribute48 => l_rec_fnd_flex_values.ATTRIBUTE48

Line 796: ,x_attribute45 => l_rec_fnd_flex_values.ATTRIBUTE45

792: ,x_attribute41 => l_rec_fnd_flex_values.ATTRIBUTE41
793: ,x_attribute42 => l_rec_fnd_flex_values.ATTRIBUTE42
794: ,x_attribute43 => l_rec_fnd_flex_values.ATTRIBUTE43
795: ,x_attribute44 => l_rec_fnd_flex_values.ATTRIBUTE44
796: ,x_attribute45 => l_rec_fnd_flex_values.ATTRIBUTE45
797: ,x_attribute46 => l_rec_fnd_flex_values.ATTRIBUTE46
798: ,x_attribute47 => l_rec_fnd_flex_values.ATTRIBUTE47
799: ,x_attribute48 => l_rec_fnd_flex_values.ATTRIBUTE48
800: ,x_attribute49 => l_rec_fnd_flex_values.ATTRIBUTE49

Line 797: ,x_attribute46 => l_rec_fnd_flex_values.ATTRIBUTE46

793: ,x_attribute42 => l_rec_fnd_flex_values.ATTRIBUTE42
794: ,x_attribute43 => l_rec_fnd_flex_values.ATTRIBUTE43
795: ,x_attribute44 => l_rec_fnd_flex_values.ATTRIBUTE44
796: ,x_attribute45 => l_rec_fnd_flex_values.ATTRIBUTE45
797: ,x_attribute46 => l_rec_fnd_flex_values.ATTRIBUTE46
798: ,x_attribute47 => l_rec_fnd_flex_values.ATTRIBUTE47
799: ,x_attribute48 => l_rec_fnd_flex_values.ATTRIBUTE48
800: ,x_attribute49 => l_rec_fnd_flex_values.ATTRIBUTE49
801: ,x_attribute50 => l_rec_fnd_flex_values.ATTRIBUTE50

Line 798: ,x_attribute47 => l_rec_fnd_flex_values.ATTRIBUTE47

794: ,x_attribute43 => l_rec_fnd_flex_values.ATTRIBUTE43
795: ,x_attribute44 => l_rec_fnd_flex_values.ATTRIBUTE44
796: ,x_attribute45 => l_rec_fnd_flex_values.ATTRIBUTE45
797: ,x_attribute46 => l_rec_fnd_flex_values.ATTRIBUTE46
798: ,x_attribute47 => l_rec_fnd_flex_values.ATTRIBUTE47
799: ,x_attribute48 => l_rec_fnd_flex_values.ATTRIBUTE48
800: ,x_attribute49 => l_rec_fnd_flex_values.ATTRIBUTE49
801: ,x_attribute50 => l_rec_fnd_flex_values.ATTRIBUTE50
802: ,x_flex_value_meaning => p_display_name

Line 799: ,x_attribute48 => l_rec_fnd_flex_values.ATTRIBUTE48

795: ,x_attribute44 => l_rec_fnd_flex_values.ATTRIBUTE44
796: ,x_attribute45 => l_rec_fnd_flex_values.ATTRIBUTE45
797: ,x_attribute46 => l_rec_fnd_flex_values.ATTRIBUTE46
798: ,x_attribute47 => l_rec_fnd_flex_values.ATTRIBUTE47
799: ,x_attribute48 => l_rec_fnd_flex_values.ATTRIBUTE48
800: ,x_attribute49 => l_rec_fnd_flex_values.ATTRIBUTE49
801: ,x_attribute50 => l_rec_fnd_flex_values.ATTRIBUTE50
802: ,x_flex_value_meaning => p_display_name
803: ,x_description => p_description

Line 800: ,x_attribute49 => l_rec_fnd_flex_values.ATTRIBUTE49

796: ,x_attribute45 => l_rec_fnd_flex_values.ATTRIBUTE45
797: ,x_attribute46 => l_rec_fnd_flex_values.ATTRIBUTE46
798: ,x_attribute47 => l_rec_fnd_flex_values.ATTRIBUTE47
799: ,x_attribute48 => l_rec_fnd_flex_values.ATTRIBUTE48
800: ,x_attribute49 => l_rec_fnd_flex_values.ATTRIBUTE49
801: ,x_attribute50 => l_rec_fnd_flex_values.ATTRIBUTE50
802: ,x_flex_value_meaning => p_display_name
803: ,x_description => p_description
804: ,x_last_update_date => l_sysdate

Line 801: ,x_attribute50 => l_rec_fnd_flex_values.ATTRIBUTE50

797: ,x_attribute46 => l_rec_fnd_flex_values.ATTRIBUTE46
798: ,x_attribute47 => l_rec_fnd_flex_values.ATTRIBUTE47
799: ,x_attribute48 => l_rec_fnd_flex_values.ATTRIBUTE48
800: ,x_attribute49 => l_rec_fnd_flex_values.ATTRIBUTE49
801: ,x_attribute50 => l_rec_fnd_flex_values.ATTRIBUTE50
802: ,x_flex_value_meaning => p_display_name
803: ,x_description => p_description
804: ,x_last_update_date => l_sysdate
805: ,x_last_updated_by => l_owner

Line 6813: --Clearing out the start date and end of values in fnd_flex_values because we are considering all the

6809: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6810: VALUES
6811: (EGO_OBJECT_LOCK_S.NEXTVAL,'EGO_VALUE_SET',P_VALUE_SET_ID,FND_GLOBAL.PARTY_ID,'L',
6812: FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID) ;
6813: --Clearing out the start date and end of values in fnd_flex_values because we are considering all the
6814: -- enabled values for this value set.
6815: UPDATE FND_FLEX_VALUES SET START_DATE_ACTIVE = NULL ,END_DATE_ACTIVE= NULL
6816: WHERE FLEX_VALUE_SET_ID= P_VALUE_SET_ID AND ENABLED_FLAG='Y';
6817: --Creating the record for values in EGO_FLEX_VALUE_VERSION_B table

Line 6815: UPDATE FND_FLEX_VALUES SET START_DATE_ACTIVE = NULL ,END_DATE_ACTIVE= NULL

6811: (EGO_OBJECT_LOCK_S.NEXTVAL,'EGO_VALUE_SET',P_VALUE_SET_ID,FND_GLOBAL.PARTY_ID,'L',
6812: FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID) ;
6813: --Clearing out the start date and end of values in fnd_flex_values because we are considering all the
6814: -- enabled values for this value set.
6815: UPDATE FND_FLEX_VALUES SET START_DATE_ACTIVE = NULL ,END_DATE_ACTIVE= NULL
6816: WHERE FLEX_VALUE_SET_ID= P_VALUE_SET_ID AND ENABLED_FLAG='Y';
6817: --Creating the record for values in EGO_FLEX_VALUE_VERSION_B table
6818: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID, FLEX_VALUE_ID,SEQUENCE,
6819: VERSION_SEQ_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)

Line 6822: FROM FND_FLEX_VALUES A, EGO_VS_VALUES_DISP_ORDER B

6818: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID, FLEX_VALUE_ID,SEQUENCE,
6819: VERSION_SEQ_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6820: SELECT P_VALUE_SET_ID, A.FLEX_VALUE_ID, B.DISP_SEQUENCE,0,A.CREATED_BY,SYSDATE,
6821: FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID
6822: FROM FND_FLEX_VALUES A, EGO_VS_VALUES_DISP_ORDER B
6823: WHERE
6824: A.FLEX_VALUE_SET_ID = P_VALUE_SET_ID
6825: AND A.ENABLED_FLAG='Y'
6826: AND B.VALUE_SET_VALUE_ID = A.FLEX_VALUE_ID ;

Line 6833: FND_FLEX_VALUES_TL B

6829: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,DESCRIPTION,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6830: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG
6831: ) SELECT A.FLEX_VALUE_ID,B.DESCRIPTION ,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,FND_GLOBAL.LOGIN_ID,
6832: B.FLEX_VALUE_MEANING,B.LANGUAGE,USERENV('LANG') FROM EGO_FLEX_VALUE_VERSION_B A,
6833: FND_FLEX_VALUES_TL B
6834: WHERE A.FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND
6835: A.VERSION_SEQ_ID = 0 AND A.FLEX_VALUE_ID = B.FLEX_VALUE_ID;
6836: x_return_status := 'S';
6837: COMMIT;

Line 8317: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;

8313: --if we change optional parameters, version goes from x.n to x.(n+1)
8314: l_api_version NUMBER;
8315: l_storage_value VARCHAR2(32767);
8316:
8317: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
8318: -- l_Sysdate DATE;
8319: l_rowid VARCHAR2(100);
8320: l_owner NUMBER;
8321: x_flex_Value_Set_Id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE ;

Line 8330: SELECT COUNT(*) INTO L_VALUE_EXIST FROM FND_FLEX_VALUES WHERE FLEX_VALUE_SET_ID = X_FLEX_VALUE_SET_ID

8326: BEGIN
8327: SELECT FLEX_VALUE_SET_ID INTO
8328: X_FLEX_VALUE_SET_ID FROM FND_FLEX_VALUE_SETS WHERE FLEX_VALUE_SET_NAME = P_VALUE_SET_NAME ;
8329:
8330: SELECT COUNT(*) INTO L_VALUE_EXIST FROM FND_FLEX_VALUES WHERE FLEX_VALUE_SET_ID = X_FLEX_VALUE_SET_ID
8331: AND FLEX_VALUE = P_INTERNAL_NAME ;
8332:
8333: IF(L_VALUE_EXIST < 1 ) THEN
8334:

Line 8372: SELECT FLEX_VALUE_ID INTO l_flex_value_id FROM FND_FLEX_VALUES

8368: IF VersionedValueSet >= 1 THEN
8369:
8370:
8371:
8372: SELECT FLEX_VALUE_ID INTO l_flex_value_id FROM FND_FLEX_VALUES
8373: WHERE FLEX_VALUE_SET_ID = x_flex_Value_Set_Id AND FLEX_VALUE like p_internal_name ;
8374:
8375:
8376: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID, FLEX_VALUE_ID, VERSION_SEQ_ID,

Line 8425: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;

8421: --if we change optional parameters, version goes from x.n to x.(n+1)
8422: l_api_version NUMBER;
8423: l_storage_value VARCHAR2(32767);
8424:
8425: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
8426: -- l_Sysdate DATE;
8427: l_rowid VARCHAR2(100);
8428: l_owner NUMBER;
8429: flex_Value_Set_Id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE ;

Line 8628: l_flex_value_id fnd_flex_values.flex_value_id%type;

8624: l_api_version NUMBER;
8625: l_owner NUMBER;
8626: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE ;
8627: l_values_count NUMBER;
8628: l_flex_value_id fnd_flex_values.flex_value_id%type;
8629: BEGIN
8630:
8631: l_api_name := 'Update_Value_Set_Val';
8632: l_api_version := 1.0;

Line 8679: SELECT flex_value_id INTO l_flex_value_id FROM fnd_flex_values

8675: ***/
8676: SELECT flex_value_set_id INTO l_value_set_id FROM fnd_flex_value_sets
8677: WHERE flex_value_set_name = p_value_set_name;
8678:
8679: SELECT flex_value_id INTO l_flex_value_id FROM fnd_flex_values
8680: WHERE flex_value_set_id = l_value_set_id AND flex_value = p_internal_name;
8681:
8682:
8683: Process_Value_Set_Val (

Line 8774: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;

8770: ,x_return_status OUT NOCOPY VARCHAR2
8771: ,x_msg_count OUT NOCOPY NUMBER
8772: ,x_msg_data OUT NOCOPY VARCHAR2
8773: ) IS
8774: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
8775: l_value_set_id fnd_flex_values.flex_value_set_id%TYPE;
8776: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
8777:
8778: l_vsv_row fnd_flex_values%ROWTYPE;

Line 8775: l_value_set_id fnd_flex_values.flex_value_set_id%TYPE;

8771: ,x_msg_count OUT NOCOPY NUMBER
8772: ,x_msg_data OUT NOCOPY VARCHAR2
8773: ) IS
8774: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
8775: l_value_set_id fnd_flex_values.flex_value_set_id%TYPE;
8776: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
8777:
8778: l_vsv_row fnd_flex_values%ROWTYPE;
8779: l_vsvtl_row fnd_flex_values_tl%ROWTYPE;

Line 8778: l_vsv_row fnd_flex_values%ROWTYPE;

8774: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
8775: l_value_set_id fnd_flex_values.flex_value_set_id%TYPE;
8776: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
8777:
8778: l_vsv_row fnd_flex_values%ROWTYPE;
8779: l_vsvtl_row fnd_flex_values_tl%ROWTYPE;
8780:
8781: CURSOR c_get_vs_details (cp_value_set_id IN NUMBER) IS
8782: SELECT vsvtl.last_updated_by, vsvtl.last_update_date

Line 8779: l_vsvtl_row fnd_flex_values_tl%ROWTYPE;

8775: l_value_set_id fnd_flex_values.flex_value_set_id%TYPE;
8776: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
8777:
8778: l_vsv_row fnd_flex_values%ROWTYPE;
8779: l_vsvtl_row fnd_flex_values_tl%ROWTYPE;
8780:
8781: CURSOR c_get_vs_details (cp_value_set_id IN NUMBER) IS
8782: SELECT vsvtl.last_updated_by, vsvtl.last_update_date
8783: FROM FND_FLEX_VALUES vsv, FND_FLEX_VALUES_TL vsvtl

Line 8783: FROM FND_FLEX_VALUES vsv, FND_FLEX_VALUES_TL vsvtl

8779: l_vsvtl_row fnd_flex_values_tl%ROWTYPE;
8780:
8781: CURSOR c_get_vs_details (cp_value_set_id IN NUMBER) IS
8782: SELECT vsvtl.last_updated_by, vsvtl.last_update_date
8783: FROM FND_FLEX_VALUES vsv, FND_FLEX_VALUES_TL vsvtl
8784: WHERE vsv.flex_value_set_id = cp_value_set_id
8785: AND vsv.flex_value = p_internal_name
8786: AND vsv.flex_value_id = vsvtl.flex_value_id
8787: AND USERENV('LANG') IN (language, source_lang);

Line 8790: l_last_update_login fnd_flex_values.last_update_login%TYPE;

8786: AND vsv.flex_value_id = vsvtl.flex_value_id
8787: AND USERENV('LANG') IN (language, source_lang);
8788:
8789:
8790: l_last_update_login fnd_flex_values.last_update_login%TYPE;
8791: l_last_update_date fnd_flex_values.last_update_date%TYPE;
8792: l_last_updated_by fnd_flex_values.last_updated_by%TYPE;
8793:
8794: BEGIN

Line 8791: l_last_update_date fnd_flex_values.last_update_date%TYPE;

8787: AND USERENV('LANG') IN (language, source_lang);
8788:
8789:
8790: l_last_update_login fnd_flex_values.last_update_login%TYPE;
8791: l_last_update_date fnd_flex_values.last_update_date%TYPE;
8792: l_last_updated_by fnd_flex_values.last_updated_by%TYPE;
8793:
8794: BEGIN
8795: SELECT vs.flex_value_set_id, vs.validation_type

Line 8792: l_last_updated_by fnd_flex_values.last_updated_by%TYPE;

8788:
8789:
8790: l_last_update_login fnd_flex_values.last_update_login%TYPE;
8791: l_last_update_date fnd_flex_values.last_update_date%TYPE;
8792: l_last_updated_by fnd_flex_values.last_updated_by%TYPE;
8793:
8794: BEGIN
8795: SELECT vs.flex_value_set_id, vs.validation_type
8796: INTO l_value_set_id, l_validation_type

Line 8815: FROM FND_FLEX_VALUES vsv

8811: ,l_last_update_date
8812: ,NULL)) THEN
8813: SELECT vsv.*
8814: INTO l_vsv_row
8815: FROM FND_FLEX_VALUES vsv
8816: WHERE vsv.flex_value_set_id = l_value_set_id
8817: AND vsv.flex_value = p_internal_name;
8818:
8819: FND_FLEX_VALUES_PKG.UPDATE_ROW

Line 8819: FND_FLEX_VALUES_PKG.UPDATE_ROW

8815: FROM FND_FLEX_VALUES vsv
8816: WHERE vsv.flex_value_set_id = l_value_set_id
8817: AND vsv.flex_value = p_internal_name;
8818:
8819: FND_FLEX_VALUES_PKG.UPDATE_ROW
8820: (x_flex_value_id => l_vsv_row.flex_value_id
8821: ,x_attribute_sort_order => l_vsv_row.attribute_sort_order
8822: ,x_flex_value_set_id => l_value_set_id
8823: ,x_flex_value => p_internal_name

Line 8985: l_vsv_created_by fnd_flex_values.created_by%TYPE;

8981: -- T is VS Value is editable
8982: -- F if VS Value is not editable.
8983: l_return_status VARCHAR2(1);
8984:
8985: l_vsv_created_by fnd_flex_values.created_by%TYPE;
8986: l_vs_created_by fnd_flex_values.created_by%TYPE;
8987: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8988: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8989: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

Line 8986: l_vs_created_by fnd_flex_values.created_by%TYPE;

8982: -- F if VS Value is not editable.
8983: l_return_status VARCHAR2(1);
8984:
8985: l_vsv_created_by fnd_flex_values.created_by%TYPE;
8986: l_vs_created_by fnd_flex_values.created_by%TYPE;
8987: l_vs_format_type fnd_flex_value_sets.format_type%TYPE;
8988: l_vs_validation_type fnd_flex_value_sets.validation_type%TYPE;
8989: l_vs_alpha_numeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
8990: l_vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%TYPE;

Line 9003: FROM fnd_flex_values a, fnd_flex_value_sets b

8999: b.numeric_mode_enabled_flag, b.security_enabled_flag, b.created_by
9000: INTO l_vsv_created_by, l_vs_format_type, l_vs_validation_type,
9001: l_vs_alpha_numeric_allowed, l_vs_uppercase_only,
9002: l_vs_numeric_mode_enabled, l_vs_security_enabled, l_vs_created_by
9003: FROM fnd_flex_values a, fnd_flex_value_sets b
9004: WHERE a.flex_value_id = cp_vs_value_id
9005: AND a.flex_value_set_id = b.flex_value_set_id;
9006:
9007: IF l_vsv_created_by IN (1,2)

Line 9074: l_value_set_value_id fnd_flex_values.flex_value_id%TYPE;

9070: ) IS
9071:
9072: l_api_name VARCHAR2(30);
9073: l_api_version NUMBER;
9074: l_value_set_value_id fnd_flex_values.flex_value_id%TYPE;
9075: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
9076: l_sequence EGO_VS_VALUES_DISP_ORDER.disp_sequence%TYPE;
9077: l_invalid_params BOOLEAN;
9078: l_create_sequence BOOLEAN;

Line 9136: FROM fnd_flex_values

9132: IF p_value_set_value_id IS NOT NULL THEN
9133: BEGIN
9134: SELECT flex_value_id, flex_value_set_id
9135: INTO l_value_set_value_id, l_value_set_id
9136: FROM fnd_flex_values
9137: WHERE flex_value_id = p_value_set_value_id;
9138: EXCEPTION
9139: WHEN OTHERS THEN
9140: l_invalid_params := TRUE;

Line 9146: FROM fnd_flex_values a, fnd_flex_value_sets b

9142: ELSE
9143: BEGIN
9144: SELECT a.flex_value_id, a.flex_value_set_id
9145: INTO l_value_set_value_id, l_value_set_id
9146: FROM fnd_flex_values a, fnd_flex_value_sets b
9147: WHERE a.flex_value_set_id = b.flex_value_set_id
9148: AND a.flex_value = p_value_set_value
9149: AND (b.flex_value_set_id = p_value_set_id OR b.flex_value_set_name = p_value_set_name);
9150: EXCEPTION

Line 15475: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;

15471: ,x_return_status OUT NOCOPY VARCHAR2
15472: ) IS
15473:
15474: l_value_set_name FND_FLEX_VALUE_SETS.flex_value_set_name%TYPE;
15475: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
15476: l_internal_name FND_FLEX_VALUES.FLEX_VALUE%TYPE;
15477: l_display_name FND_FLEX_VALUES_TL.flex_value_meaning%TYPE;
15478: l_description FND_FLEX_VALUES_TL.description%TYPE;
15479: l_start_date DATE;

Line 15476: l_internal_name FND_FLEX_VALUES.FLEX_VALUE%TYPE;

15472: ) IS
15473:
15474: l_value_set_name FND_FLEX_VALUE_SETS.flex_value_set_name%TYPE;
15475: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
15476: l_internal_name FND_FLEX_VALUES.FLEX_VALUE%TYPE;
15477: l_display_name FND_FLEX_VALUES_TL.flex_value_meaning%TYPE;
15478: l_description FND_FLEX_VALUES_TL.description%TYPE;
15479: l_start_date DATE;
15480: l_end_date DATE;

Line 15477: l_display_name FND_FLEX_VALUES_TL.flex_value_meaning%TYPE;

15473:
15474: l_value_set_name FND_FLEX_VALUE_SETS.flex_value_set_name%TYPE;
15475: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
15476: l_internal_name FND_FLEX_VALUES.FLEX_VALUE%TYPE;
15477: l_display_name FND_FLEX_VALUES_TL.flex_value_meaning%TYPE;
15478: l_description FND_FLEX_VALUES_TL.description%TYPE;
15479: l_start_date DATE;
15480: l_end_date DATE;
15481: l_enabled FND_FLEX_VALUES.ENABLED_FLAG%TYPE;

Line 15478: l_description FND_FLEX_VALUES_TL.description%TYPE;

15474: l_value_set_name FND_FLEX_VALUE_SETS.flex_value_set_name%TYPE;
15475: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
15476: l_internal_name FND_FLEX_VALUES.FLEX_VALUE%TYPE;
15477: l_display_name FND_FLEX_VALUES_TL.flex_value_meaning%TYPE;
15478: l_description FND_FLEX_VALUES_TL.description%TYPE;
15479: l_start_date DATE;
15480: l_end_date DATE;
15481: l_enabled FND_FLEX_VALUES.ENABLED_FLAG%TYPE;
15482:

Line 15481: l_enabled FND_FLEX_VALUES.ENABLED_FLAG%TYPE;

15477: l_display_name FND_FLEX_VALUES_TL.flex_value_meaning%TYPE;
15478: l_description FND_FLEX_VALUES_TL.description%TYPE;
15479: l_start_date DATE;
15480: l_end_date DATE;
15481: l_enabled FND_FLEX_VALUES.ENABLED_FLAG%TYPE;
15482:
15483: BEGIN
15484: SELECT FLEX_VALUE_SET_NAME INTO L_VALUE_SET_NAME FROM FND_FLEX_VALUE_SETS
15485: WHERE FLEX_VALUE_SET_ID = p_value_set_id ;

Line 15488: FROM FND_FLEX_VALUES,FND_FLEX_VALUES_TL WHERE

15484: SELECT FLEX_VALUE_SET_NAME INTO L_VALUE_SET_NAME FROM FND_FLEX_VALUE_SETS
15485: WHERE FLEX_VALUE_SET_ID = p_value_set_id ;
15486: SELECT FLEX_VALUE,FLEX_VALUE_MEANING,DESCRIPTION, START_DATE_ACTIVE,
15487: ENABLED_FLAG INTO l_internal_name,l_display_name,l_description,l_start_date,l_enabled
15488: FROM FND_FLEX_VALUES,FND_FLEX_VALUES_TL WHERE
15489: LANGUAGE = userenv('LANG') AND FND_FLEX_VALUES.FLEX_VALUE_ID = p_value_id
15490: AND FND_FLEX_VALUES_TL.FLEX_VALUE_ID = p_value_id AND ROWNUM=1;
15491: FND_FLEX_VALUES_PKG.UPDATE_ROW
15492: (x_flex_value_id => p_value_id

Line 15489: LANGUAGE = userenv('LANG') AND FND_FLEX_VALUES.FLEX_VALUE_ID = p_value_id

15485: WHERE FLEX_VALUE_SET_ID = p_value_set_id ;
15486: SELECT FLEX_VALUE,FLEX_VALUE_MEANING,DESCRIPTION, START_DATE_ACTIVE,
15487: ENABLED_FLAG INTO l_internal_name,l_display_name,l_description,l_start_date,l_enabled
15488: FROM FND_FLEX_VALUES,FND_FLEX_VALUES_TL WHERE
15489: LANGUAGE = userenv('LANG') AND FND_FLEX_VALUES.FLEX_VALUE_ID = p_value_id
15490: AND FND_FLEX_VALUES_TL.FLEX_VALUE_ID = p_value_id AND ROWNUM=1;
15491: FND_FLEX_VALUES_PKG.UPDATE_ROW
15492: (x_flex_value_id => p_value_id
15493: ,x_attribute_sort_order => NULL

Line 15490: AND FND_FLEX_VALUES_TL.FLEX_VALUE_ID = p_value_id AND ROWNUM=1;

15486: SELECT FLEX_VALUE,FLEX_VALUE_MEANING,DESCRIPTION, START_DATE_ACTIVE,
15487: ENABLED_FLAG INTO l_internal_name,l_display_name,l_description,l_start_date,l_enabled
15488: FROM FND_FLEX_VALUES,FND_FLEX_VALUES_TL WHERE
15489: LANGUAGE = userenv('LANG') AND FND_FLEX_VALUES.FLEX_VALUE_ID = p_value_id
15490: AND FND_FLEX_VALUES_TL.FLEX_VALUE_ID = p_value_id AND ROWNUM=1;
15491: FND_FLEX_VALUES_PKG.UPDATE_ROW
15492: (x_flex_value_id => p_value_id
15493: ,x_attribute_sort_order => NULL
15494: ,x_flex_value_set_id => p_value_set_id

Line 15491: FND_FLEX_VALUES_PKG.UPDATE_ROW

15487: ENABLED_FLAG INTO l_internal_name,l_display_name,l_description,l_start_date,l_enabled
15488: FROM FND_FLEX_VALUES,FND_FLEX_VALUES_TL WHERE
15489: LANGUAGE = userenv('LANG') AND FND_FLEX_VALUES.FLEX_VALUE_ID = p_value_id
15490: AND FND_FLEX_VALUES_TL.FLEX_VALUE_ID = p_value_id AND ROWNUM=1;
15491: FND_FLEX_VALUES_PKG.UPDATE_ROW
15492: (x_flex_value_id => p_value_id
15493: ,x_attribute_sort_order => NULL
15494: ,x_flex_value_set_id => p_value_set_id
15495: ,x_flex_value => l_internal_name