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.XLE_ASSOCIATION_PKG dependencies on FND_API

Line 83: ,DECODE(p_association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id)

79: ,last_update_login
80: )
81: VALUES (
82: xle_associations_s.NEXTVAL
83: ,DECODE(p_association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id)
84: ,DECODE(p_subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id)
85: ,DECODE(p_subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id)
86: ,DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
87: ,DECODE(p_association_type_id,10006,SYSDATE,DECODE(p_effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from))

Line 84: ,DECODE(p_subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id)

80: )
81: VALUES (
82: xle_associations_s.NEXTVAL
83: ,DECODE(p_association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id)
84: ,DECODE(p_subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id)
85: ,DECODE(p_subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id)
86: ,DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
87: ,DECODE(p_association_type_id,10006,SYSDATE,DECODE(p_effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from))
88: ,DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)

Line 85: ,DECODE(p_subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id)

81: VALUES (
82: xle_associations_s.NEXTVAL
83: ,DECODE(p_association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id)
84: ,DECODE(p_subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id)
85: ,DECODE(p_subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id)
86: ,DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
87: ,DECODE(p_association_type_id,10006,SYSDATE,DECODE(p_effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from))
88: ,DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)
89: ,DECODE(p_assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context)

Line 86: ,DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)

82: xle_associations_s.NEXTVAL
83: ,DECODE(p_association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id)
84: ,DECODE(p_subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id)
85: ,DECODE(p_subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id)
86: ,DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
87: ,DECODE(p_association_type_id,10006,SYSDATE,DECODE(p_effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from))
88: ,DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)
89: ,DECODE(p_assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context)
90: ,DECODE(p_assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1)

Line 87: ,DECODE(p_association_type_id,10006,SYSDATE,DECODE(p_effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from))

83: ,DECODE(p_association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id)
84: ,DECODE(p_subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id)
85: ,DECODE(p_subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id)
86: ,DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
87: ,DECODE(p_association_type_id,10006,SYSDATE,DECODE(p_effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from))
88: ,DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)
89: ,DECODE(p_assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context)
90: ,DECODE(p_assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1)
91: ,DECODE(p_assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2)

Line 88: ,DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)

84: ,DECODE(p_subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id)
85: ,DECODE(p_subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id)
86: ,DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
87: ,DECODE(p_association_type_id,10006,SYSDATE,DECODE(p_effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from))
88: ,DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)
89: ,DECODE(p_assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context)
90: ,DECODE(p_assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1)
91: ,DECODE(p_assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2)
92: ,DECODE(p_assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3)

Line 89: ,DECODE(p_assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context)

85: ,DECODE(p_subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id)
86: ,DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
87: ,DECODE(p_association_type_id,10006,SYSDATE,DECODE(p_effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from))
88: ,DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)
89: ,DECODE(p_assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context)
90: ,DECODE(p_assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1)
91: ,DECODE(p_assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2)
92: ,DECODE(p_assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3)
93: ,DECODE(p_assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4)

Line 90: ,DECODE(p_assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1)

86: ,DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
87: ,DECODE(p_association_type_id,10006,SYSDATE,DECODE(p_effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from))
88: ,DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)
89: ,DECODE(p_assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context)
90: ,DECODE(p_assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1)
91: ,DECODE(p_assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2)
92: ,DECODE(p_assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3)
93: ,DECODE(p_assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4)
94: ,DECODE(p_assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5)

Line 91: ,DECODE(p_assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2)

87: ,DECODE(p_association_type_id,10006,SYSDATE,DECODE(p_effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from))
88: ,DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)
89: ,DECODE(p_assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context)
90: ,DECODE(p_assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1)
91: ,DECODE(p_assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2)
92: ,DECODE(p_assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3)
93: ,DECODE(p_assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4)
94: ,DECODE(p_assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5)
95: ,DECODE(p_assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6)

Line 92: ,DECODE(p_assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3)

88: ,DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)
89: ,DECODE(p_assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context)
90: ,DECODE(p_assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1)
91: ,DECODE(p_assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2)
92: ,DECODE(p_assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3)
93: ,DECODE(p_assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4)
94: ,DECODE(p_assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5)
95: ,DECODE(p_assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6)
96: ,DECODE(p_assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7)

Line 93: ,DECODE(p_assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4)

89: ,DECODE(p_assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context)
90: ,DECODE(p_assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1)
91: ,DECODE(p_assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2)
92: ,DECODE(p_assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3)
93: ,DECODE(p_assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4)
94: ,DECODE(p_assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5)
95: ,DECODE(p_assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6)
96: ,DECODE(p_assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7)
97: ,DECODE(p_assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8)

Line 94: ,DECODE(p_assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5)

90: ,DECODE(p_assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1)
91: ,DECODE(p_assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2)
92: ,DECODE(p_assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3)
93: ,DECODE(p_assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4)
94: ,DECODE(p_assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5)
95: ,DECODE(p_assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6)
96: ,DECODE(p_assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7)
97: ,DECODE(p_assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8)
98: ,DECODE(p_assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9)

Line 95: ,DECODE(p_assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6)

91: ,DECODE(p_assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2)
92: ,DECODE(p_assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3)
93: ,DECODE(p_assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4)
94: ,DECODE(p_assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5)
95: ,DECODE(p_assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6)
96: ,DECODE(p_assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7)
97: ,DECODE(p_assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8)
98: ,DECODE(p_assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9)
99: ,DECODE(p_assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10)

Line 96: ,DECODE(p_assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7)

92: ,DECODE(p_assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3)
93: ,DECODE(p_assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4)
94: ,DECODE(p_assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5)
95: ,DECODE(p_assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6)
96: ,DECODE(p_assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7)
97: ,DECODE(p_assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8)
98: ,DECODE(p_assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9)
99: ,DECODE(p_assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10)
100: ,DECODE(p_assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11)

Line 97: ,DECODE(p_assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8)

93: ,DECODE(p_assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4)
94: ,DECODE(p_assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5)
95: ,DECODE(p_assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6)
96: ,DECODE(p_assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7)
97: ,DECODE(p_assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8)
98: ,DECODE(p_assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9)
99: ,DECODE(p_assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10)
100: ,DECODE(p_assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11)
101: ,DECODE(p_assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12)

Line 98: ,DECODE(p_assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9)

94: ,DECODE(p_assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5)
95: ,DECODE(p_assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6)
96: ,DECODE(p_assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7)
97: ,DECODE(p_assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8)
98: ,DECODE(p_assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9)
99: ,DECODE(p_assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10)
100: ,DECODE(p_assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11)
101: ,DECODE(p_assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12)
102: ,DECODE(p_assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13)

Line 99: ,DECODE(p_assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10)

95: ,DECODE(p_assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6)
96: ,DECODE(p_assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7)
97: ,DECODE(p_assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8)
98: ,DECODE(p_assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9)
99: ,DECODE(p_assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10)
100: ,DECODE(p_assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11)
101: ,DECODE(p_assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12)
102: ,DECODE(p_assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13)
103: ,DECODE(p_assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14)

Line 100: ,DECODE(p_assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11)

96: ,DECODE(p_assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7)
97: ,DECODE(p_assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8)
98: ,DECODE(p_assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9)
99: ,DECODE(p_assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10)
100: ,DECODE(p_assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11)
101: ,DECODE(p_assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12)
102: ,DECODE(p_assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13)
103: ,DECODE(p_assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14)
104: ,DECODE(p_assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15)

Line 101: ,DECODE(p_assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12)

97: ,DECODE(p_assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8)
98: ,DECODE(p_assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9)
99: ,DECODE(p_assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10)
100: ,DECODE(p_assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11)
101: ,DECODE(p_assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12)
102: ,DECODE(p_assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13)
103: ,DECODE(p_assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14)
104: ,DECODE(p_assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15)
105: ,DECODE(p_assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16)

Line 102: ,DECODE(p_assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13)

98: ,DECODE(p_assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9)
99: ,DECODE(p_assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10)
100: ,DECODE(p_assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11)
101: ,DECODE(p_assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12)
102: ,DECODE(p_assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13)
103: ,DECODE(p_assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14)
104: ,DECODE(p_assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15)
105: ,DECODE(p_assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16)
106: ,DECODE(p_assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17)

Line 103: ,DECODE(p_assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14)

99: ,DECODE(p_assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10)
100: ,DECODE(p_assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11)
101: ,DECODE(p_assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12)
102: ,DECODE(p_assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13)
103: ,DECODE(p_assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14)
104: ,DECODE(p_assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15)
105: ,DECODE(p_assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16)
106: ,DECODE(p_assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17)
107: ,DECODE(p_assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18)

Line 104: ,DECODE(p_assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15)

100: ,DECODE(p_assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11)
101: ,DECODE(p_assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12)
102: ,DECODE(p_assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13)
103: ,DECODE(p_assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14)
104: ,DECODE(p_assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15)
105: ,DECODE(p_assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16)
106: ,DECODE(p_assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17)
107: ,DECODE(p_assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18)
108: ,DECODE(p_assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19)

Line 105: ,DECODE(p_assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16)

101: ,DECODE(p_assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12)
102: ,DECODE(p_assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13)
103: ,DECODE(p_assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14)
104: ,DECODE(p_assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15)
105: ,DECODE(p_assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16)
106: ,DECODE(p_assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17)
107: ,DECODE(p_assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18)
108: ,DECODE(p_assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19)
109: ,DECODE(p_assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20)

Line 106: ,DECODE(p_assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17)

102: ,DECODE(p_assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13)
103: ,DECODE(p_assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14)
104: ,DECODE(p_assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15)
105: ,DECODE(p_assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16)
106: ,DECODE(p_assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17)
107: ,DECODE(p_assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18)
108: ,DECODE(p_assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19)
109: ,DECODE(p_assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20)
110: ,DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)

Line 107: ,DECODE(p_assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18)

103: ,DECODE(p_assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14)
104: ,DECODE(p_assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15)
105: ,DECODE(p_assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16)
106: ,DECODE(p_assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17)
107: ,DECODE(p_assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18)
108: ,DECODE(p_assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19)
109: ,DECODE(p_assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20)
110: ,DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
111: ,XLE_UTILITY_PUB.LAST_UPDATE_DATE

Line 108: ,DECODE(p_assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19)

104: ,DECODE(p_assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15)
105: ,DECODE(p_assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16)
106: ,DECODE(p_assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17)
107: ,DECODE(p_assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18)
108: ,DECODE(p_assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19)
109: ,DECODE(p_assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20)
110: ,DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
111: ,XLE_UTILITY_PUB.LAST_UPDATE_DATE
112: ,XLE_UTILITY_PUB.LAST_UPDATED_BY

Line 109: ,DECODE(p_assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20)

105: ,DECODE(p_assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16)
106: ,DECODE(p_assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17)
107: ,DECODE(p_assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18)
108: ,DECODE(p_assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19)
109: ,DECODE(p_assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20)
110: ,DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
111: ,XLE_UTILITY_PUB.LAST_UPDATE_DATE
112: ,XLE_UTILITY_PUB.LAST_UPDATED_BY
113: ,XLE_UTILITY_PUB.CREATION_DATE

Line 110: ,DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)

106: ,DECODE(p_assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17)
107: ,DECODE(p_assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18)
108: ,DECODE(p_assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19)
109: ,DECODE(p_assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20)
110: ,DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
111: ,XLE_UTILITY_PUB.LAST_UPDATE_DATE
112: ,XLE_UTILITY_PUB.LAST_UPDATED_BY
113: ,XLE_UTILITY_PUB.CREATION_DATE
114: ,XLE_UTILITY_PUB.CREATED_BY

Line 160: association_type_id = DECODE(p_association_type_id, NULL, association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id),

156: )
157: IS
158: BEGIN
159: UPDATE xle_associations SET
160: association_type_id = DECODE(p_association_type_id, NULL, association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id),
161: subject_id = DECODE(p_subject_id, NULL, subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id),
162: subject_parent_id = DECODE(p_subject_parent_id, NULL, subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id),
163: object_id = DECODE(p_object_id, NULL, object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
164: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),

Line 161: subject_id = DECODE(p_subject_id, NULL, subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id),

157: IS
158: BEGIN
159: UPDATE xle_associations SET
160: association_type_id = DECODE(p_association_type_id, NULL, association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id),
161: subject_id = DECODE(p_subject_id, NULL, subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id),
162: subject_parent_id = DECODE(p_subject_parent_id, NULL, subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id),
163: object_id = DECODE(p_object_id, NULL, object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
164: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
165: effective_to = DECODE(association_type_id,10006,SYSDATE-1/86400,DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)),

Line 162: subject_parent_id = DECODE(p_subject_parent_id, NULL, subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id),

158: BEGIN
159: UPDATE xle_associations SET
160: association_type_id = DECODE(p_association_type_id, NULL, association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id),
161: subject_id = DECODE(p_subject_id, NULL, subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id),
162: subject_parent_id = DECODE(p_subject_parent_id, NULL, subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id),
163: object_id = DECODE(p_object_id, NULL, object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
164: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
165: effective_to = DECODE(association_type_id,10006,SYSDATE-1/86400,DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)),
166: assoc_information_context = DECODE (p_assoc_information_context, NULL, assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context),

Line 163: object_id = DECODE(p_object_id, NULL, object_id, FND_API.G_MISS_NUM, NULL, p_object_id),

159: UPDATE xle_associations SET
160: association_type_id = DECODE(p_association_type_id, NULL, association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id),
161: subject_id = DECODE(p_subject_id, NULL, subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id),
162: subject_parent_id = DECODE(p_subject_parent_id, NULL, subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id),
163: object_id = DECODE(p_object_id, NULL, object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
164: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
165: effective_to = DECODE(association_type_id,10006,SYSDATE-1/86400,DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)),
166: assoc_information_context = DECODE (p_assoc_information_context, NULL, assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context),
167: assoc_information1 = DECODE (p_assoc_information1, NULL, assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1),

Line 164: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),

160: association_type_id = DECODE(p_association_type_id, NULL, association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id),
161: subject_id = DECODE(p_subject_id, NULL, subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id),
162: subject_parent_id = DECODE(p_subject_parent_id, NULL, subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id),
163: object_id = DECODE(p_object_id, NULL, object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
164: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
165: effective_to = DECODE(association_type_id,10006,SYSDATE-1/86400,DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)),
166: assoc_information_context = DECODE (p_assoc_information_context, NULL, assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context),
167: assoc_information1 = DECODE (p_assoc_information1, NULL, assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1),
168: assoc_information2 = DECODE (p_assoc_information2, NULL, assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2),

Line 165: effective_to = DECODE(association_type_id,10006,SYSDATE-1/86400,DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)),

161: subject_id = DECODE(p_subject_id, NULL, subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id),
162: subject_parent_id = DECODE(p_subject_parent_id, NULL, subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id),
163: object_id = DECODE(p_object_id, NULL, object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
164: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
165: effective_to = DECODE(association_type_id,10006,SYSDATE-1/86400,DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)),
166: assoc_information_context = DECODE (p_assoc_information_context, NULL, assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context),
167: assoc_information1 = DECODE (p_assoc_information1, NULL, assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1),
168: assoc_information2 = DECODE (p_assoc_information2, NULL, assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2),
169: assoc_information3 = DECODE (p_assoc_information3, NULL, assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3),

Line 166: assoc_information_context = DECODE (p_assoc_information_context, NULL, assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context),

162: subject_parent_id = DECODE(p_subject_parent_id, NULL, subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id),
163: object_id = DECODE(p_object_id, NULL, object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
164: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
165: effective_to = DECODE(association_type_id,10006,SYSDATE-1/86400,DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)),
166: assoc_information_context = DECODE (p_assoc_information_context, NULL, assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context),
167: assoc_information1 = DECODE (p_assoc_information1, NULL, assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1),
168: assoc_information2 = DECODE (p_assoc_information2, NULL, assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2),
169: assoc_information3 = DECODE (p_assoc_information3, NULL, assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3),
170: assoc_information4 = DECODE (p_assoc_information4, NULL, assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4),

Line 167: assoc_information1 = DECODE (p_assoc_information1, NULL, assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1),

163: object_id = DECODE(p_object_id, NULL, object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
164: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
165: effective_to = DECODE(association_type_id,10006,SYSDATE-1/86400,DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)),
166: assoc_information_context = DECODE (p_assoc_information_context, NULL, assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context),
167: assoc_information1 = DECODE (p_assoc_information1, NULL, assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1),
168: assoc_information2 = DECODE (p_assoc_information2, NULL, assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2),
169: assoc_information3 = DECODE (p_assoc_information3, NULL, assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3),
170: assoc_information4 = DECODE (p_assoc_information4, NULL, assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4),
171: assoc_information5 = DECODE (p_assoc_information5, NULL, assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5),

Line 168: assoc_information2 = DECODE (p_assoc_information2, NULL, assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2),

164: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
165: effective_to = DECODE(association_type_id,10006,SYSDATE-1/86400,DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)),
166: assoc_information_context = DECODE (p_assoc_information_context, NULL, assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context),
167: assoc_information1 = DECODE (p_assoc_information1, NULL, assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1),
168: assoc_information2 = DECODE (p_assoc_information2, NULL, assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2),
169: assoc_information3 = DECODE (p_assoc_information3, NULL, assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3),
170: assoc_information4 = DECODE (p_assoc_information4, NULL, assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4),
171: assoc_information5 = DECODE (p_assoc_information5, NULL, assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5),
172: assoc_information6 = DECODE (p_assoc_information6, NULL, assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6),

Line 169: assoc_information3 = DECODE (p_assoc_information3, NULL, assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3),

165: effective_to = DECODE(association_type_id,10006,SYSDATE-1/86400,DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to)),
166: assoc_information_context = DECODE (p_assoc_information_context, NULL, assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context),
167: assoc_information1 = DECODE (p_assoc_information1, NULL, assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1),
168: assoc_information2 = DECODE (p_assoc_information2, NULL, assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2),
169: assoc_information3 = DECODE (p_assoc_information3, NULL, assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3),
170: assoc_information4 = DECODE (p_assoc_information4, NULL, assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4),
171: assoc_information5 = DECODE (p_assoc_information5, NULL, assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5),
172: assoc_information6 = DECODE (p_assoc_information6, NULL, assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6),
173: assoc_information7 = DECODE (p_assoc_information7, NULL, assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7),

Line 170: assoc_information4 = DECODE (p_assoc_information4, NULL, assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4),

166: assoc_information_context = DECODE (p_assoc_information_context, NULL, assoc_information_context, FND_API.G_MISS_CHAR, NULL, p_assoc_information_context),
167: assoc_information1 = DECODE (p_assoc_information1, NULL, assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1),
168: assoc_information2 = DECODE (p_assoc_information2, NULL, assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2),
169: assoc_information3 = DECODE (p_assoc_information3, NULL, assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3),
170: assoc_information4 = DECODE (p_assoc_information4, NULL, assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4),
171: assoc_information5 = DECODE (p_assoc_information5, NULL, assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5),
172: assoc_information6 = DECODE (p_assoc_information6, NULL, assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6),
173: assoc_information7 = DECODE (p_assoc_information7, NULL, assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7),
174: assoc_information8 = DECODE (p_assoc_information8, NULL, assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8),

Line 171: assoc_information5 = DECODE (p_assoc_information5, NULL, assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5),

167: assoc_information1 = DECODE (p_assoc_information1, NULL, assoc_information1, FND_API.G_MISS_CHAR, NULL, p_assoc_information1),
168: assoc_information2 = DECODE (p_assoc_information2, NULL, assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2),
169: assoc_information3 = DECODE (p_assoc_information3, NULL, assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3),
170: assoc_information4 = DECODE (p_assoc_information4, NULL, assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4),
171: assoc_information5 = DECODE (p_assoc_information5, NULL, assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5),
172: assoc_information6 = DECODE (p_assoc_information6, NULL, assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6),
173: assoc_information7 = DECODE (p_assoc_information7, NULL, assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7),
174: assoc_information8 = DECODE (p_assoc_information8, NULL, assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8),
175: assoc_information9 = DECODE (p_assoc_information9, NULL, assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9),

Line 172: assoc_information6 = DECODE (p_assoc_information6, NULL, assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6),

168: assoc_information2 = DECODE (p_assoc_information2, NULL, assoc_information2, FND_API.G_MISS_CHAR, NULL, p_assoc_information2),
169: assoc_information3 = DECODE (p_assoc_information3, NULL, assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3),
170: assoc_information4 = DECODE (p_assoc_information4, NULL, assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4),
171: assoc_information5 = DECODE (p_assoc_information5, NULL, assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5),
172: assoc_information6 = DECODE (p_assoc_information6, NULL, assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6),
173: assoc_information7 = DECODE (p_assoc_information7, NULL, assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7),
174: assoc_information8 = DECODE (p_assoc_information8, NULL, assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8),
175: assoc_information9 = DECODE (p_assoc_information9, NULL, assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9),
176: assoc_information10 = DECODE (p_assoc_information10, NULL, assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10),

Line 173: assoc_information7 = DECODE (p_assoc_information7, NULL, assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7),

169: assoc_information3 = DECODE (p_assoc_information3, NULL, assoc_information3, FND_API.G_MISS_CHAR, NULL, p_assoc_information3),
170: assoc_information4 = DECODE (p_assoc_information4, NULL, assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4),
171: assoc_information5 = DECODE (p_assoc_information5, NULL, assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5),
172: assoc_information6 = DECODE (p_assoc_information6, NULL, assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6),
173: assoc_information7 = DECODE (p_assoc_information7, NULL, assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7),
174: assoc_information8 = DECODE (p_assoc_information8, NULL, assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8),
175: assoc_information9 = DECODE (p_assoc_information9, NULL, assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9),
176: assoc_information10 = DECODE (p_assoc_information10, NULL, assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10),
177: assoc_information11 = DECODE (p_assoc_information11, NULL, assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11),

Line 174: assoc_information8 = DECODE (p_assoc_information8, NULL, assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8),

170: assoc_information4 = DECODE (p_assoc_information4, NULL, assoc_information4, FND_API.G_MISS_CHAR, NULL, p_assoc_information4),
171: assoc_information5 = DECODE (p_assoc_information5, NULL, assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5),
172: assoc_information6 = DECODE (p_assoc_information6, NULL, assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6),
173: assoc_information7 = DECODE (p_assoc_information7, NULL, assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7),
174: assoc_information8 = DECODE (p_assoc_information8, NULL, assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8),
175: assoc_information9 = DECODE (p_assoc_information9, NULL, assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9),
176: assoc_information10 = DECODE (p_assoc_information10, NULL, assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10),
177: assoc_information11 = DECODE (p_assoc_information11, NULL, assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11),
178: assoc_information12 = DECODE (p_assoc_information12, NULL, assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12),

Line 175: assoc_information9 = DECODE (p_assoc_information9, NULL, assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9),

171: assoc_information5 = DECODE (p_assoc_information5, NULL, assoc_information5, FND_API.G_MISS_CHAR, NULL, p_assoc_information5),
172: assoc_information6 = DECODE (p_assoc_information6, NULL, assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6),
173: assoc_information7 = DECODE (p_assoc_information7, NULL, assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7),
174: assoc_information8 = DECODE (p_assoc_information8, NULL, assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8),
175: assoc_information9 = DECODE (p_assoc_information9, NULL, assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9),
176: assoc_information10 = DECODE (p_assoc_information10, NULL, assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10),
177: assoc_information11 = DECODE (p_assoc_information11, NULL, assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11),
178: assoc_information12 = DECODE (p_assoc_information12, NULL, assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12),
179: assoc_information13 = DECODE (p_assoc_information13, NULL, assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13),

Line 176: assoc_information10 = DECODE (p_assoc_information10, NULL, assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10),

172: assoc_information6 = DECODE (p_assoc_information6, NULL, assoc_information6, FND_API.G_MISS_CHAR, NULL, p_assoc_information6),
173: assoc_information7 = DECODE (p_assoc_information7, NULL, assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7),
174: assoc_information8 = DECODE (p_assoc_information8, NULL, assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8),
175: assoc_information9 = DECODE (p_assoc_information9, NULL, assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9),
176: assoc_information10 = DECODE (p_assoc_information10, NULL, assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10),
177: assoc_information11 = DECODE (p_assoc_information11, NULL, assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11),
178: assoc_information12 = DECODE (p_assoc_information12, NULL, assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12),
179: assoc_information13 = DECODE (p_assoc_information13, NULL, assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13),
180: assoc_information14 = DECODE (p_assoc_information14, NULL, assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14),

Line 177: assoc_information11 = DECODE (p_assoc_information11, NULL, assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11),

173: assoc_information7 = DECODE (p_assoc_information7, NULL, assoc_information7, FND_API.G_MISS_CHAR, NULL, p_assoc_information7),
174: assoc_information8 = DECODE (p_assoc_information8, NULL, assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8),
175: assoc_information9 = DECODE (p_assoc_information9, NULL, assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9),
176: assoc_information10 = DECODE (p_assoc_information10, NULL, assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10),
177: assoc_information11 = DECODE (p_assoc_information11, NULL, assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11),
178: assoc_information12 = DECODE (p_assoc_information12, NULL, assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12),
179: assoc_information13 = DECODE (p_assoc_information13, NULL, assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13),
180: assoc_information14 = DECODE (p_assoc_information14, NULL, assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14),
181: assoc_information15 = DECODE (p_assoc_information15, NULL, assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15),

Line 178: assoc_information12 = DECODE (p_assoc_information12, NULL, assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12),

174: assoc_information8 = DECODE (p_assoc_information8, NULL, assoc_information8, FND_API.G_MISS_CHAR, NULL, p_assoc_information8),
175: assoc_information9 = DECODE (p_assoc_information9, NULL, assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9),
176: assoc_information10 = DECODE (p_assoc_information10, NULL, assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10),
177: assoc_information11 = DECODE (p_assoc_information11, NULL, assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11),
178: assoc_information12 = DECODE (p_assoc_information12, NULL, assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12),
179: assoc_information13 = DECODE (p_assoc_information13, NULL, assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13),
180: assoc_information14 = DECODE (p_assoc_information14, NULL, assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14),
181: assoc_information15 = DECODE (p_assoc_information15, NULL, assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15),
182: assoc_information16 = DECODE (p_assoc_information16, NULL, assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16),

Line 179: assoc_information13 = DECODE (p_assoc_information13, NULL, assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13),

175: assoc_information9 = DECODE (p_assoc_information9, NULL, assoc_information9, FND_API.G_MISS_CHAR, NULL, p_assoc_information9),
176: assoc_information10 = DECODE (p_assoc_information10, NULL, assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10),
177: assoc_information11 = DECODE (p_assoc_information11, NULL, assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11),
178: assoc_information12 = DECODE (p_assoc_information12, NULL, assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12),
179: assoc_information13 = DECODE (p_assoc_information13, NULL, assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13),
180: assoc_information14 = DECODE (p_assoc_information14, NULL, assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14),
181: assoc_information15 = DECODE (p_assoc_information15, NULL, assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15),
182: assoc_information16 = DECODE (p_assoc_information16, NULL, assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16),
183: assoc_information17 = DECODE (p_assoc_information17, NULL, assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17),

Line 180: assoc_information14 = DECODE (p_assoc_information14, NULL, assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14),

176: assoc_information10 = DECODE (p_assoc_information10, NULL, assoc_information10, FND_API.G_MISS_CHAR, NULL, p_assoc_information10),
177: assoc_information11 = DECODE (p_assoc_information11, NULL, assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11),
178: assoc_information12 = DECODE (p_assoc_information12, NULL, assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12),
179: assoc_information13 = DECODE (p_assoc_information13, NULL, assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13),
180: assoc_information14 = DECODE (p_assoc_information14, NULL, assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14),
181: assoc_information15 = DECODE (p_assoc_information15, NULL, assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15),
182: assoc_information16 = DECODE (p_assoc_information16, NULL, assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16),
183: assoc_information17 = DECODE (p_assoc_information17, NULL, assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17),
184: assoc_information18 = DECODE (p_assoc_information18, NULL, assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18),

Line 181: assoc_information15 = DECODE (p_assoc_information15, NULL, assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15),

177: assoc_information11 = DECODE (p_assoc_information11, NULL, assoc_information11, FND_API.G_MISS_CHAR, NULL, p_assoc_information11),
178: assoc_information12 = DECODE (p_assoc_information12, NULL, assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12),
179: assoc_information13 = DECODE (p_assoc_information13, NULL, assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13),
180: assoc_information14 = DECODE (p_assoc_information14, NULL, assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14),
181: assoc_information15 = DECODE (p_assoc_information15, NULL, assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15),
182: assoc_information16 = DECODE (p_assoc_information16, NULL, assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16),
183: assoc_information17 = DECODE (p_assoc_information17, NULL, assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17),
184: assoc_information18 = DECODE (p_assoc_information18, NULL, assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18),
185: assoc_information19 = DECODE (p_assoc_information19, NULL, assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19),

Line 182: assoc_information16 = DECODE (p_assoc_information16, NULL, assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16),

178: assoc_information12 = DECODE (p_assoc_information12, NULL, assoc_information12, FND_API.G_MISS_CHAR, NULL, p_assoc_information12),
179: assoc_information13 = DECODE (p_assoc_information13, NULL, assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13),
180: assoc_information14 = DECODE (p_assoc_information14, NULL, assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14),
181: assoc_information15 = DECODE (p_assoc_information15, NULL, assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15),
182: assoc_information16 = DECODE (p_assoc_information16, NULL, assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16),
183: assoc_information17 = DECODE (p_assoc_information17, NULL, assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17),
184: assoc_information18 = DECODE (p_assoc_information18, NULL, assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18),
185: assoc_information19 = DECODE (p_assoc_information19, NULL, assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19),
186: assoc_information20 = DECODE (p_assoc_information20, NULL, assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20),

Line 183: assoc_information17 = DECODE (p_assoc_information17, NULL, assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17),

179: assoc_information13 = DECODE (p_assoc_information13, NULL, assoc_information13, FND_API.G_MISS_CHAR, NULL, p_assoc_information13),
180: assoc_information14 = DECODE (p_assoc_information14, NULL, assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14),
181: assoc_information15 = DECODE (p_assoc_information15, NULL, assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15),
182: assoc_information16 = DECODE (p_assoc_information16, NULL, assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16),
183: assoc_information17 = DECODE (p_assoc_information17, NULL, assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17),
184: assoc_information18 = DECODE (p_assoc_information18, NULL, assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18),
185: assoc_information19 = DECODE (p_assoc_information19, NULL, assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19),
186: assoc_information20 = DECODE (p_assoc_information20, NULL, assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20),
187: object_version_number = DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number),

Line 184: assoc_information18 = DECODE (p_assoc_information18, NULL, assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18),

180: assoc_information14 = DECODE (p_assoc_information14, NULL, assoc_information14, FND_API.G_MISS_CHAR, NULL, p_assoc_information14),
181: assoc_information15 = DECODE (p_assoc_information15, NULL, assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15),
182: assoc_information16 = DECODE (p_assoc_information16, NULL, assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16),
183: assoc_information17 = DECODE (p_assoc_information17, NULL, assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17),
184: assoc_information18 = DECODE (p_assoc_information18, NULL, assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18),
185: assoc_information19 = DECODE (p_assoc_information19, NULL, assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19),
186: assoc_information20 = DECODE (p_assoc_information20, NULL, assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20),
187: object_version_number = DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number),
188: last_update_date = NVL(p_last_update_date, XLE_UTILITY_PUB.LAST_UPDATE_DATE),

Line 185: assoc_information19 = DECODE (p_assoc_information19, NULL, assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19),

181: assoc_information15 = DECODE (p_assoc_information15, NULL, assoc_information15, FND_API.G_MISS_CHAR, NULL, p_assoc_information15),
182: assoc_information16 = DECODE (p_assoc_information16, NULL, assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16),
183: assoc_information17 = DECODE (p_assoc_information17, NULL, assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17),
184: assoc_information18 = DECODE (p_assoc_information18, NULL, assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18),
185: assoc_information19 = DECODE (p_assoc_information19, NULL, assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19),
186: assoc_information20 = DECODE (p_assoc_information20, NULL, assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20),
187: object_version_number = DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number),
188: last_update_date = NVL(p_last_update_date, XLE_UTILITY_PUB.LAST_UPDATE_DATE),
189: last_updated_by = NVL(p_last_updated_by, XLE_UTILITY_PUB.LAST_UPDATED_BY),

Line 186: assoc_information20 = DECODE (p_assoc_information20, NULL, assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20),

182: assoc_information16 = DECODE (p_assoc_information16, NULL, assoc_information16, FND_API.G_MISS_CHAR, NULL, p_assoc_information16),
183: assoc_information17 = DECODE (p_assoc_information17, NULL, assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17),
184: assoc_information18 = DECODE (p_assoc_information18, NULL, assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18),
185: assoc_information19 = DECODE (p_assoc_information19, NULL, assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19),
186: assoc_information20 = DECODE (p_assoc_information20, NULL, assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20),
187: object_version_number = DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number),
188: last_update_date = NVL(p_last_update_date, XLE_UTILITY_PUB.LAST_UPDATE_DATE),
189: last_updated_by = NVL(p_last_updated_by, XLE_UTILITY_PUB.LAST_UPDATED_BY),
190: last_update_login = NVL(p_last_update_login, XLE_UTILITY_PUB.LAST_UPDATE_LOGIN)

Line 187: object_version_number = DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number),

183: assoc_information17 = DECODE (p_assoc_information17, NULL, assoc_information17, FND_API.G_MISS_CHAR, NULL, p_assoc_information17),
184: assoc_information18 = DECODE (p_assoc_information18, NULL, assoc_information18, FND_API.G_MISS_CHAR, NULL, p_assoc_information18),
185: assoc_information19 = DECODE (p_assoc_information19, NULL, assoc_information19, FND_API.G_MISS_CHAR, NULL, p_assoc_information19),
186: assoc_information20 = DECODE (p_assoc_information20, NULL, assoc_information20, FND_API.G_MISS_CHAR, NULL, p_assoc_information20),
187: object_version_number = DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number),
188: last_update_date = NVL(p_last_update_date, XLE_UTILITY_PUB.LAST_UPDATE_DATE),
189: last_updated_by = NVL(p_last_updated_by, XLE_UTILITY_PUB.LAST_UPDATED_BY),
190: last_update_login = NVL(p_last_update_login, XLE_UTILITY_PUB.LAST_UPDATE_LOGIN)
191:

Line 228: RAISE FND_API.G_EXC_ERROR;

224: IF (C%NOTFOUND) THEN
225: CLOSE C;
226: FND_MESSAGE.Set_Name('XLE', 'XLE_API_NO_RECORD');
227: FND_MSG_PUB.ADD;
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
230: CLOSE C;
231:
232: IF NOT

Line 242: RAISE FND_API.G_EXC_ERROR;

238: )
239: THEN
240: FND_MESSAGE.Set_Name('XLE', 'XLE_API_RECORD_CHANGED');
241: FND_MSG_PUB.ADD;
242: RAISE FND_API.G_EXC_ERROR;
243: END IF;
244:
245: END Lock_Row;
246: