DBA Data[Home] [Help]

APPS.HXC_ULQ_BUS dependencies on HR_API

Line 87: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute_category, hr_api.g_varchar2) <>

83: hr_utility.set_location('Entering:'||l_proc,10);
84: end if;
85: --
86: if ((p_rec.layout_comp_qualifier_id is not null) and (
87: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute_category, hr_api.g_varchar2) <>
88: nvl(p_rec.qualifier_attribute_category, hr_api.g_varchar2) or
89: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute1, hr_api.g_varchar2) <>
90: nvl(p_rec.qualifier_attribute1, hr_api.g_varchar2) or
91: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute2, hr_api.g_varchar2) <>

Line 88: nvl(p_rec.qualifier_attribute_category, hr_api.g_varchar2) or

84: end if;
85: --
86: if ((p_rec.layout_comp_qualifier_id is not null) and (
87: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute_category, hr_api.g_varchar2) <>
88: nvl(p_rec.qualifier_attribute_category, hr_api.g_varchar2) or
89: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute1, hr_api.g_varchar2) <>
90: nvl(p_rec.qualifier_attribute1, hr_api.g_varchar2) or
91: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute2, hr_api.g_varchar2) <>
92: nvl(p_rec.qualifier_attribute2, hr_api.g_varchar2) or

Line 89: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute1, hr_api.g_varchar2) <>

85: --
86: if ((p_rec.layout_comp_qualifier_id is not null) and (
87: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute_category, hr_api.g_varchar2) <>
88: nvl(p_rec.qualifier_attribute_category, hr_api.g_varchar2) or
89: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute1, hr_api.g_varchar2) <>
90: nvl(p_rec.qualifier_attribute1, hr_api.g_varchar2) or
91: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute2, hr_api.g_varchar2) <>
92: nvl(p_rec.qualifier_attribute2, hr_api.g_varchar2) or
93: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute3, hr_api.g_varchar2) <>

Line 90: nvl(p_rec.qualifier_attribute1, hr_api.g_varchar2) or

86: if ((p_rec.layout_comp_qualifier_id is not null) and (
87: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute_category, hr_api.g_varchar2) <>
88: nvl(p_rec.qualifier_attribute_category, hr_api.g_varchar2) or
89: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute1, hr_api.g_varchar2) <>
90: nvl(p_rec.qualifier_attribute1, hr_api.g_varchar2) or
91: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute2, hr_api.g_varchar2) <>
92: nvl(p_rec.qualifier_attribute2, hr_api.g_varchar2) or
93: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute3, hr_api.g_varchar2) <>
94: nvl(p_rec.qualifier_attribute3, hr_api.g_varchar2) or

Line 91: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute2, hr_api.g_varchar2) <>

87: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute_category, hr_api.g_varchar2) <>
88: nvl(p_rec.qualifier_attribute_category, hr_api.g_varchar2) or
89: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute1, hr_api.g_varchar2) <>
90: nvl(p_rec.qualifier_attribute1, hr_api.g_varchar2) or
91: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute2, hr_api.g_varchar2) <>
92: nvl(p_rec.qualifier_attribute2, hr_api.g_varchar2) or
93: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute3, hr_api.g_varchar2) <>
94: nvl(p_rec.qualifier_attribute3, hr_api.g_varchar2) or
95: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute4, hr_api.g_varchar2) <>

Line 92: nvl(p_rec.qualifier_attribute2, hr_api.g_varchar2) or

88: nvl(p_rec.qualifier_attribute_category, hr_api.g_varchar2) or
89: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute1, hr_api.g_varchar2) <>
90: nvl(p_rec.qualifier_attribute1, hr_api.g_varchar2) or
91: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute2, hr_api.g_varchar2) <>
92: nvl(p_rec.qualifier_attribute2, hr_api.g_varchar2) or
93: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute3, hr_api.g_varchar2) <>
94: nvl(p_rec.qualifier_attribute3, hr_api.g_varchar2) or
95: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute4, hr_api.g_varchar2) <>
96: nvl(p_rec.qualifier_attribute4, hr_api.g_varchar2) or

Line 93: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute3, hr_api.g_varchar2) <>

89: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute1, hr_api.g_varchar2) <>
90: nvl(p_rec.qualifier_attribute1, hr_api.g_varchar2) or
91: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute2, hr_api.g_varchar2) <>
92: nvl(p_rec.qualifier_attribute2, hr_api.g_varchar2) or
93: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute3, hr_api.g_varchar2) <>
94: nvl(p_rec.qualifier_attribute3, hr_api.g_varchar2) or
95: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute4, hr_api.g_varchar2) <>
96: nvl(p_rec.qualifier_attribute4, hr_api.g_varchar2) or
97: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute5, hr_api.g_varchar2) <>

Line 94: nvl(p_rec.qualifier_attribute3, hr_api.g_varchar2) or

90: nvl(p_rec.qualifier_attribute1, hr_api.g_varchar2) or
91: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute2, hr_api.g_varchar2) <>
92: nvl(p_rec.qualifier_attribute2, hr_api.g_varchar2) or
93: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute3, hr_api.g_varchar2) <>
94: nvl(p_rec.qualifier_attribute3, hr_api.g_varchar2) or
95: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute4, hr_api.g_varchar2) <>
96: nvl(p_rec.qualifier_attribute4, hr_api.g_varchar2) or
97: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute5, hr_api.g_varchar2) <>
98: nvl(p_rec.qualifier_attribute5, hr_api.g_varchar2) or

Line 95: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute4, hr_api.g_varchar2) <>

91: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute2, hr_api.g_varchar2) <>
92: nvl(p_rec.qualifier_attribute2, hr_api.g_varchar2) or
93: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute3, hr_api.g_varchar2) <>
94: nvl(p_rec.qualifier_attribute3, hr_api.g_varchar2) or
95: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute4, hr_api.g_varchar2) <>
96: nvl(p_rec.qualifier_attribute4, hr_api.g_varchar2) or
97: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute5, hr_api.g_varchar2) <>
98: nvl(p_rec.qualifier_attribute5, hr_api.g_varchar2) or
99: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute6, hr_api.g_varchar2) <>

Line 96: nvl(p_rec.qualifier_attribute4, hr_api.g_varchar2) or

92: nvl(p_rec.qualifier_attribute2, hr_api.g_varchar2) or
93: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute3, hr_api.g_varchar2) <>
94: nvl(p_rec.qualifier_attribute3, hr_api.g_varchar2) or
95: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute4, hr_api.g_varchar2) <>
96: nvl(p_rec.qualifier_attribute4, hr_api.g_varchar2) or
97: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute5, hr_api.g_varchar2) <>
98: nvl(p_rec.qualifier_attribute5, hr_api.g_varchar2) or
99: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute6, hr_api.g_varchar2) <>
100: nvl(p_rec.qualifier_attribute6, hr_api.g_varchar2) or

Line 97: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute5, hr_api.g_varchar2) <>

93: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute3, hr_api.g_varchar2) <>
94: nvl(p_rec.qualifier_attribute3, hr_api.g_varchar2) or
95: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute4, hr_api.g_varchar2) <>
96: nvl(p_rec.qualifier_attribute4, hr_api.g_varchar2) or
97: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute5, hr_api.g_varchar2) <>
98: nvl(p_rec.qualifier_attribute5, hr_api.g_varchar2) or
99: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute6, hr_api.g_varchar2) <>
100: nvl(p_rec.qualifier_attribute6, hr_api.g_varchar2) or
101: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute7, hr_api.g_varchar2) <>

Line 98: nvl(p_rec.qualifier_attribute5, hr_api.g_varchar2) or

94: nvl(p_rec.qualifier_attribute3, hr_api.g_varchar2) or
95: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute4, hr_api.g_varchar2) <>
96: nvl(p_rec.qualifier_attribute4, hr_api.g_varchar2) or
97: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute5, hr_api.g_varchar2) <>
98: nvl(p_rec.qualifier_attribute5, hr_api.g_varchar2) or
99: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute6, hr_api.g_varchar2) <>
100: nvl(p_rec.qualifier_attribute6, hr_api.g_varchar2) or
101: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute7, hr_api.g_varchar2) <>
102: nvl(p_rec.qualifier_attribute7, hr_api.g_varchar2) or

Line 99: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute6, hr_api.g_varchar2) <>

95: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute4, hr_api.g_varchar2) <>
96: nvl(p_rec.qualifier_attribute4, hr_api.g_varchar2) or
97: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute5, hr_api.g_varchar2) <>
98: nvl(p_rec.qualifier_attribute5, hr_api.g_varchar2) or
99: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute6, hr_api.g_varchar2) <>
100: nvl(p_rec.qualifier_attribute6, hr_api.g_varchar2) or
101: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute7, hr_api.g_varchar2) <>
102: nvl(p_rec.qualifier_attribute7, hr_api.g_varchar2) or
103: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute8, hr_api.g_varchar2) <>

Line 100: nvl(p_rec.qualifier_attribute6, hr_api.g_varchar2) or

96: nvl(p_rec.qualifier_attribute4, hr_api.g_varchar2) or
97: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute5, hr_api.g_varchar2) <>
98: nvl(p_rec.qualifier_attribute5, hr_api.g_varchar2) or
99: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute6, hr_api.g_varchar2) <>
100: nvl(p_rec.qualifier_attribute6, hr_api.g_varchar2) or
101: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute7, hr_api.g_varchar2) <>
102: nvl(p_rec.qualifier_attribute7, hr_api.g_varchar2) or
103: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute8, hr_api.g_varchar2) <>
104: nvl(p_rec.qualifier_attribute8, hr_api.g_varchar2) or

Line 101: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute7, hr_api.g_varchar2) <>

97: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute5, hr_api.g_varchar2) <>
98: nvl(p_rec.qualifier_attribute5, hr_api.g_varchar2) or
99: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute6, hr_api.g_varchar2) <>
100: nvl(p_rec.qualifier_attribute6, hr_api.g_varchar2) or
101: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute7, hr_api.g_varchar2) <>
102: nvl(p_rec.qualifier_attribute7, hr_api.g_varchar2) or
103: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute8, hr_api.g_varchar2) <>
104: nvl(p_rec.qualifier_attribute8, hr_api.g_varchar2) or
105: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute9, hr_api.g_varchar2) <>

Line 102: nvl(p_rec.qualifier_attribute7, hr_api.g_varchar2) or

98: nvl(p_rec.qualifier_attribute5, hr_api.g_varchar2) or
99: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute6, hr_api.g_varchar2) <>
100: nvl(p_rec.qualifier_attribute6, hr_api.g_varchar2) or
101: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute7, hr_api.g_varchar2) <>
102: nvl(p_rec.qualifier_attribute7, hr_api.g_varchar2) or
103: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute8, hr_api.g_varchar2) <>
104: nvl(p_rec.qualifier_attribute8, hr_api.g_varchar2) or
105: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute9, hr_api.g_varchar2) <>
106: nvl(p_rec.qualifier_attribute9, hr_api.g_varchar2) or

Line 103: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute8, hr_api.g_varchar2) <>

99: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute6, hr_api.g_varchar2) <>
100: nvl(p_rec.qualifier_attribute6, hr_api.g_varchar2) or
101: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute7, hr_api.g_varchar2) <>
102: nvl(p_rec.qualifier_attribute7, hr_api.g_varchar2) or
103: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute8, hr_api.g_varchar2) <>
104: nvl(p_rec.qualifier_attribute8, hr_api.g_varchar2) or
105: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute9, hr_api.g_varchar2) <>
106: nvl(p_rec.qualifier_attribute9, hr_api.g_varchar2) or
107: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute10, hr_api.g_varchar2) <>

Line 104: nvl(p_rec.qualifier_attribute8, hr_api.g_varchar2) or

100: nvl(p_rec.qualifier_attribute6, hr_api.g_varchar2) or
101: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute7, hr_api.g_varchar2) <>
102: nvl(p_rec.qualifier_attribute7, hr_api.g_varchar2) or
103: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute8, hr_api.g_varchar2) <>
104: nvl(p_rec.qualifier_attribute8, hr_api.g_varchar2) or
105: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute9, hr_api.g_varchar2) <>
106: nvl(p_rec.qualifier_attribute9, hr_api.g_varchar2) or
107: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute10, hr_api.g_varchar2) <>
108: nvl(p_rec.qualifier_attribute10, hr_api.g_varchar2) or

Line 105: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute9, hr_api.g_varchar2) <>

101: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute7, hr_api.g_varchar2) <>
102: nvl(p_rec.qualifier_attribute7, hr_api.g_varchar2) or
103: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute8, hr_api.g_varchar2) <>
104: nvl(p_rec.qualifier_attribute8, hr_api.g_varchar2) or
105: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute9, hr_api.g_varchar2) <>
106: nvl(p_rec.qualifier_attribute9, hr_api.g_varchar2) or
107: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute10, hr_api.g_varchar2) <>
108: nvl(p_rec.qualifier_attribute10, hr_api.g_varchar2) or
109: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute11, hr_api.g_varchar2) <>

Line 106: nvl(p_rec.qualifier_attribute9, hr_api.g_varchar2) or

102: nvl(p_rec.qualifier_attribute7, hr_api.g_varchar2) or
103: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute8, hr_api.g_varchar2) <>
104: nvl(p_rec.qualifier_attribute8, hr_api.g_varchar2) or
105: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute9, hr_api.g_varchar2) <>
106: nvl(p_rec.qualifier_attribute9, hr_api.g_varchar2) or
107: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute10, hr_api.g_varchar2) <>
108: nvl(p_rec.qualifier_attribute10, hr_api.g_varchar2) or
109: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute11, hr_api.g_varchar2) <>
110: nvl(p_rec.qualifier_attribute11, hr_api.g_varchar2) or

Line 107: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute10, hr_api.g_varchar2) <>

103: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute8, hr_api.g_varchar2) <>
104: nvl(p_rec.qualifier_attribute8, hr_api.g_varchar2) or
105: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute9, hr_api.g_varchar2) <>
106: nvl(p_rec.qualifier_attribute9, hr_api.g_varchar2) or
107: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute10, hr_api.g_varchar2) <>
108: nvl(p_rec.qualifier_attribute10, hr_api.g_varchar2) or
109: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute11, hr_api.g_varchar2) <>
110: nvl(p_rec.qualifier_attribute11, hr_api.g_varchar2) or
111: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute12, hr_api.g_varchar2) <>

Line 108: nvl(p_rec.qualifier_attribute10, hr_api.g_varchar2) or

104: nvl(p_rec.qualifier_attribute8, hr_api.g_varchar2) or
105: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute9, hr_api.g_varchar2) <>
106: nvl(p_rec.qualifier_attribute9, hr_api.g_varchar2) or
107: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute10, hr_api.g_varchar2) <>
108: nvl(p_rec.qualifier_attribute10, hr_api.g_varchar2) or
109: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute11, hr_api.g_varchar2) <>
110: nvl(p_rec.qualifier_attribute11, hr_api.g_varchar2) or
111: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute12, hr_api.g_varchar2) <>
112: nvl(p_rec.qualifier_attribute12, hr_api.g_varchar2) or

Line 109: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute11, hr_api.g_varchar2) <>

105: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute9, hr_api.g_varchar2) <>
106: nvl(p_rec.qualifier_attribute9, hr_api.g_varchar2) or
107: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute10, hr_api.g_varchar2) <>
108: nvl(p_rec.qualifier_attribute10, hr_api.g_varchar2) or
109: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute11, hr_api.g_varchar2) <>
110: nvl(p_rec.qualifier_attribute11, hr_api.g_varchar2) or
111: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute12, hr_api.g_varchar2) <>
112: nvl(p_rec.qualifier_attribute12, hr_api.g_varchar2) or
113: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute13, hr_api.g_varchar2) <>

Line 110: nvl(p_rec.qualifier_attribute11, hr_api.g_varchar2) or

106: nvl(p_rec.qualifier_attribute9, hr_api.g_varchar2) or
107: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute10, hr_api.g_varchar2) <>
108: nvl(p_rec.qualifier_attribute10, hr_api.g_varchar2) or
109: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute11, hr_api.g_varchar2) <>
110: nvl(p_rec.qualifier_attribute11, hr_api.g_varchar2) or
111: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute12, hr_api.g_varchar2) <>
112: nvl(p_rec.qualifier_attribute12, hr_api.g_varchar2) or
113: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute13, hr_api.g_varchar2) <>
114: nvl(p_rec.qualifier_attribute13, hr_api.g_varchar2) or

Line 111: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute12, hr_api.g_varchar2) <>

107: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute10, hr_api.g_varchar2) <>
108: nvl(p_rec.qualifier_attribute10, hr_api.g_varchar2) or
109: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute11, hr_api.g_varchar2) <>
110: nvl(p_rec.qualifier_attribute11, hr_api.g_varchar2) or
111: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute12, hr_api.g_varchar2) <>
112: nvl(p_rec.qualifier_attribute12, hr_api.g_varchar2) or
113: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute13, hr_api.g_varchar2) <>
114: nvl(p_rec.qualifier_attribute13, hr_api.g_varchar2) or
115: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute14, hr_api.g_varchar2) <>

Line 112: nvl(p_rec.qualifier_attribute12, hr_api.g_varchar2) or

108: nvl(p_rec.qualifier_attribute10, hr_api.g_varchar2) or
109: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute11, hr_api.g_varchar2) <>
110: nvl(p_rec.qualifier_attribute11, hr_api.g_varchar2) or
111: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute12, hr_api.g_varchar2) <>
112: nvl(p_rec.qualifier_attribute12, hr_api.g_varchar2) or
113: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute13, hr_api.g_varchar2) <>
114: nvl(p_rec.qualifier_attribute13, hr_api.g_varchar2) or
115: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute14, hr_api.g_varchar2) <>
116: nvl(p_rec.qualifier_attribute14, hr_api.g_varchar2) or

Line 113: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute13, hr_api.g_varchar2) <>

109: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute11, hr_api.g_varchar2) <>
110: nvl(p_rec.qualifier_attribute11, hr_api.g_varchar2) or
111: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute12, hr_api.g_varchar2) <>
112: nvl(p_rec.qualifier_attribute12, hr_api.g_varchar2) or
113: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute13, hr_api.g_varchar2) <>
114: nvl(p_rec.qualifier_attribute13, hr_api.g_varchar2) or
115: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute14, hr_api.g_varchar2) <>
116: nvl(p_rec.qualifier_attribute14, hr_api.g_varchar2) or
117: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute15, hr_api.g_varchar2) <>

Line 114: nvl(p_rec.qualifier_attribute13, hr_api.g_varchar2) or

110: nvl(p_rec.qualifier_attribute11, hr_api.g_varchar2) or
111: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute12, hr_api.g_varchar2) <>
112: nvl(p_rec.qualifier_attribute12, hr_api.g_varchar2) or
113: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute13, hr_api.g_varchar2) <>
114: nvl(p_rec.qualifier_attribute13, hr_api.g_varchar2) or
115: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute14, hr_api.g_varchar2) <>
116: nvl(p_rec.qualifier_attribute14, hr_api.g_varchar2) or
117: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute15, hr_api.g_varchar2) <>
118: nvl(p_rec.qualifier_attribute15, hr_api.g_varchar2) or

Line 115: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute14, hr_api.g_varchar2) <>

111: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute12, hr_api.g_varchar2) <>
112: nvl(p_rec.qualifier_attribute12, hr_api.g_varchar2) or
113: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute13, hr_api.g_varchar2) <>
114: nvl(p_rec.qualifier_attribute13, hr_api.g_varchar2) or
115: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute14, hr_api.g_varchar2) <>
116: nvl(p_rec.qualifier_attribute14, hr_api.g_varchar2) or
117: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute15, hr_api.g_varchar2) <>
118: nvl(p_rec.qualifier_attribute15, hr_api.g_varchar2) or
119: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute16, hr_api.g_varchar2) <>

Line 116: nvl(p_rec.qualifier_attribute14, hr_api.g_varchar2) or

112: nvl(p_rec.qualifier_attribute12, hr_api.g_varchar2) or
113: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute13, hr_api.g_varchar2) <>
114: nvl(p_rec.qualifier_attribute13, hr_api.g_varchar2) or
115: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute14, hr_api.g_varchar2) <>
116: nvl(p_rec.qualifier_attribute14, hr_api.g_varchar2) or
117: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute15, hr_api.g_varchar2) <>
118: nvl(p_rec.qualifier_attribute15, hr_api.g_varchar2) or
119: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute16, hr_api.g_varchar2) <>
120: nvl(p_rec.qualifier_attribute16, hr_api.g_varchar2) or

Line 117: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute15, hr_api.g_varchar2) <>

113: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute13, hr_api.g_varchar2) <>
114: nvl(p_rec.qualifier_attribute13, hr_api.g_varchar2) or
115: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute14, hr_api.g_varchar2) <>
116: nvl(p_rec.qualifier_attribute14, hr_api.g_varchar2) or
117: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute15, hr_api.g_varchar2) <>
118: nvl(p_rec.qualifier_attribute15, hr_api.g_varchar2) or
119: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute16, hr_api.g_varchar2) <>
120: nvl(p_rec.qualifier_attribute16, hr_api.g_varchar2) or
121: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute17, hr_api.g_varchar2) <>

Line 118: nvl(p_rec.qualifier_attribute15, hr_api.g_varchar2) or

114: nvl(p_rec.qualifier_attribute13, hr_api.g_varchar2) or
115: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute14, hr_api.g_varchar2) <>
116: nvl(p_rec.qualifier_attribute14, hr_api.g_varchar2) or
117: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute15, hr_api.g_varchar2) <>
118: nvl(p_rec.qualifier_attribute15, hr_api.g_varchar2) or
119: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute16, hr_api.g_varchar2) <>
120: nvl(p_rec.qualifier_attribute16, hr_api.g_varchar2) or
121: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute17, hr_api.g_varchar2) <>
122: nvl(p_rec.qualifier_attribute17, hr_api.g_varchar2) or

Line 119: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute16, hr_api.g_varchar2) <>

115: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute14, hr_api.g_varchar2) <>
116: nvl(p_rec.qualifier_attribute14, hr_api.g_varchar2) or
117: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute15, hr_api.g_varchar2) <>
118: nvl(p_rec.qualifier_attribute15, hr_api.g_varchar2) or
119: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute16, hr_api.g_varchar2) <>
120: nvl(p_rec.qualifier_attribute16, hr_api.g_varchar2) or
121: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute17, hr_api.g_varchar2) <>
122: nvl(p_rec.qualifier_attribute17, hr_api.g_varchar2) or
123: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute18, hr_api.g_varchar2) <>

Line 120: nvl(p_rec.qualifier_attribute16, hr_api.g_varchar2) or

116: nvl(p_rec.qualifier_attribute14, hr_api.g_varchar2) or
117: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute15, hr_api.g_varchar2) <>
118: nvl(p_rec.qualifier_attribute15, hr_api.g_varchar2) or
119: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute16, hr_api.g_varchar2) <>
120: nvl(p_rec.qualifier_attribute16, hr_api.g_varchar2) or
121: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute17, hr_api.g_varchar2) <>
122: nvl(p_rec.qualifier_attribute17, hr_api.g_varchar2) or
123: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute18, hr_api.g_varchar2) <>
124: nvl(p_rec.qualifier_attribute18, hr_api.g_varchar2) or

Line 121: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute17, hr_api.g_varchar2) <>

117: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute15, hr_api.g_varchar2) <>
118: nvl(p_rec.qualifier_attribute15, hr_api.g_varchar2) or
119: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute16, hr_api.g_varchar2) <>
120: nvl(p_rec.qualifier_attribute16, hr_api.g_varchar2) or
121: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute17, hr_api.g_varchar2) <>
122: nvl(p_rec.qualifier_attribute17, hr_api.g_varchar2) or
123: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute18, hr_api.g_varchar2) <>
124: nvl(p_rec.qualifier_attribute18, hr_api.g_varchar2) or
125: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute19, hr_api.g_varchar2) <>

Line 122: nvl(p_rec.qualifier_attribute17, hr_api.g_varchar2) or

118: nvl(p_rec.qualifier_attribute15, hr_api.g_varchar2) or
119: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute16, hr_api.g_varchar2) <>
120: nvl(p_rec.qualifier_attribute16, hr_api.g_varchar2) or
121: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute17, hr_api.g_varchar2) <>
122: nvl(p_rec.qualifier_attribute17, hr_api.g_varchar2) or
123: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute18, hr_api.g_varchar2) <>
124: nvl(p_rec.qualifier_attribute18, hr_api.g_varchar2) or
125: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute19, hr_api.g_varchar2) <>
126: nvl(p_rec.qualifier_attribute19, hr_api.g_varchar2) or

Line 123: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute18, hr_api.g_varchar2) <>

119: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute16, hr_api.g_varchar2) <>
120: nvl(p_rec.qualifier_attribute16, hr_api.g_varchar2) or
121: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute17, hr_api.g_varchar2) <>
122: nvl(p_rec.qualifier_attribute17, hr_api.g_varchar2) or
123: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute18, hr_api.g_varchar2) <>
124: nvl(p_rec.qualifier_attribute18, hr_api.g_varchar2) or
125: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute19, hr_api.g_varchar2) <>
126: nvl(p_rec.qualifier_attribute19, hr_api.g_varchar2) or
127: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute20, hr_api.g_varchar2) <>

Line 124: nvl(p_rec.qualifier_attribute18, hr_api.g_varchar2) or

120: nvl(p_rec.qualifier_attribute16, hr_api.g_varchar2) or
121: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute17, hr_api.g_varchar2) <>
122: nvl(p_rec.qualifier_attribute17, hr_api.g_varchar2) or
123: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute18, hr_api.g_varchar2) <>
124: nvl(p_rec.qualifier_attribute18, hr_api.g_varchar2) or
125: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute19, hr_api.g_varchar2) <>
126: nvl(p_rec.qualifier_attribute19, hr_api.g_varchar2) or
127: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute20, hr_api.g_varchar2) <>
128: nvl(p_rec.qualifier_attribute20, hr_api.g_varchar2) or

Line 125: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute19, hr_api.g_varchar2) <>

121: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute17, hr_api.g_varchar2) <>
122: nvl(p_rec.qualifier_attribute17, hr_api.g_varchar2) or
123: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute18, hr_api.g_varchar2) <>
124: nvl(p_rec.qualifier_attribute18, hr_api.g_varchar2) or
125: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute19, hr_api.g_varchar2) <>
126: nvl(p_rec.qualifier_attribute19, hr_api.g_varchar2) or
127: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute20, hr_api.g_varchar2) <>
128: nvl(p_rec.qualifier_attribute20, hr_api.g_varchar2) or
129: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute21, hr_api.g_varchar2) <>

Line 126: nvl(p_rec.qualifier_attribute19, hr_api.g_varchar2) or

122: nvl(p_rec.qualifier_attribute17, hr_api.g_varchar2) or
123: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute18, hr_api.g_varchar2) <>
124: nvl(p_rec.qualifier_attribute18, hr_api.g_varchar2) or
125: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute19, hr_api.g_varchar2) <>
126: nvl(p_rec.qualifier_attribute19, hr_api.g_varchar2) or
127: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute20, hr_api.g_varchar2) <>
128: nvl(p_rec.qualifier_attribute20, hr_api.g_varchar2) or
129: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute21, hr_api.g_varchar2) <>
130: nvl(p_rec.qualifier_attribute21, hr_api.g_varchar2) or

Line 127: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute20, hr_api.g_varchar2) <>

123: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute18, hr_api.g_varchar2) <>
124: nvl(p_rec.qualifier_attribute18, hr_api.g_varchar2) or
125: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute19, hr_api.g_varchar2) <>
126: nvl(p_rec.qualifier_attribute19, hr_api.g_varchar2) or
127: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute20, hr_api.g_varchar2) <>
128: nvl(p_rec.qualifier_attribute20, hr_api.g_varchar2) or
129: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute21, hr_api.g_varchar2) <>
130: nvl(p_rec.qualifier_attribute21, hr_api.g_varchar2) or
131: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute22, hr_api.g_varchar2) <>

Line 128: nvl(p_rec.qualifier_attribute20, hr_api.g_varchar2) or

124: nvl(p_rec.qualifier_attribute18, hr_api.g_varchar2) or
125: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute19, hr_api.g_varchar2) <>
126: nvl(p_rec.qualifier_attribute19, hr_api.g_varchar2) or
127: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute20, hr_api.g_varchar2) <>
128: nvl(p_rec.qualifier_attribute20, hr_api.g_varchar2) or
129: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute21, hr_api.g_varchar2) <>
130: nvl(p_rec.qualifier_attribute21, hr_api.g_varchar2) or
131: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute22, hr_api.g_varchar2) <>
132: nvl(p_rec.qualifier_attribute22, hr_api.g_varchar2) or

Line 129: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute21, hr_api.g_varchar2) <>

125: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute19, hr_api.g_varchar2) <>
126: nvl(p_rec.qualifier_attribute19, hr_api.g_varchar2) or
127: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute20, hr_api.g_varchar2) <>
128: nvl(p_rec.qualifier_attribute20, hr_api.g_varchar2) or
129: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute21, hr_api.g_varchar2) <>
130: nvl(p_rec.qualifier_attribute21, hr_api.g_varchar2) or
131: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute22, hr_api.g_varchar2) <>
132: nvl(p_rec.qualifier_attribute22, hr_api.g_varchar2) or
133: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute23, hr_api.g_varchar2) <>

Line 130: nvl(p_rec.qualifier_attribute21, hr_api.g_varchar2) or

126: nvl(p_rec.qualifier_attribute19, hr_api.g_varchar2) or
127: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute20, hr_api.g_varchar2) <>
128: nvl(p_rec.qualifier_attribute20, hr_api.g_varchar2) or
129: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute21, hr_api.g_varchar2) <>
130: nvl(p_rec.qualifier_attribute21, hr_api.g_varchar2) or
131: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute22, hr_api.g_varchar2) <>
132: nvl(p_rec.qualifier_attribute22, hr_api.g_varchar2) or
133: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute23, hr_api.g_varchar2) <>
134: nvl(p_rec.qualifier_attribute23, hr_api.g_varchar2) or

Line 131: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute22, hr_api.g_varchar2) <>

127: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute20, hr_api.g_varchar2) <>
128: nvl(p_rec.qualifier_attribute20, hr_api.g_varchar2) or
129: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute21, hr_api.g_varchar2) <>
130: nvl(p_rec.qualifier_attribute21, hr_api.g_varchar2) or
131: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute22, hr_api.g_varchar2) <>
132: nvl(p_rec.qualifier_attribute22, hr_api.g_varchar2) or
133: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute23, hr_api.g_varchar2) <>
134: nvl(p_rec.qualifier_attribute23, hr_api.g_varchar2) or
135: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute24, hr_api.g_varchar2) <>

Line 132: nvl(p_rec.qualifier_attribute22, hr_api.g_varchar2) or

128: nvl(p_rec.qualifier_attribute20, hr_api.g_varchar2) or
129: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute21, hr_api.g_varchar2) <>
130: nvl(p_rec.qualifier_attribute21, hr_api.g_varchar2) or
131: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute22, hr_api.g_varchar2) <>
132: nvl(p_rec.qualifier_attribute22, hr_api.g_varchar2) or
133: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute23, hr_api.g_varchar2) <>
134: nvl(p_rec.qualifier_attribute23, hr_api.g_varchar2) or
135: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute24, hr_api.g_varchar2) <>
136: nvl(p_rec.qualifier_attribute24, hr_api.g_varchar2) or

Line 133: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute23, hr_api.g_varchar2) <>

129: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute21, hr_api.g_varchar2) <>
130: nvl(p_rec.qualifier_attribute21, hr_api.g_varchar2) or
131: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute22, hr_api.g_varchar2) <>
132: nvl(p_rec.qualifier_attribute22, hr_api.g_varchar2) or
133: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute23, hr_api.g_varchar2) <>
134: nvl(p_rec.qualifier_attribute23, hr_api.g_varchar2) or
135: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute24, hr_api.g_varchar2) <>
136: nvl(p_rec.qualifier_attribute24, hr_api.g_varchar2) or
137: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute25, hr_api.g_varchar2) <>

Line 134: nvl(p_rec.qualifier_attribute23, hr_api.g_varchar2) or

130: nvl(p_rec.qualifier_attribute21, hr_api.g_varchar2) or
131: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute22, hr_api.g_varchar2) <>
132: nvl(p_rec.qualifier_attribute22, hr_api.g_varchar2) or
133: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute23, hr_api.g_varchar2) <>
134: nvl(p_rec.qualifier_attribute23, hr_api.g_varchar2) or
135: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute24, hr_api.g_varchar2) <>
136: nvl(p_rec.qualifier_attribute24, hr_api.g_varchar2) or
137: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute25, hr_api.g_varchar2) <>
138: nvl(p_rec.qualifier_attribute25, hr_api.g_varchar2) or

Line 135: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute24, hr_api.g_varchar2) <>

131: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute22, hr_api.g_varchar2) <>
132: nvl(p_rec.qualifier_attribute22, hr_api.g_varchar2) or
133: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute23, hr_api.g_varchar2) <>
134: nvl(p_rec.qualifier_attribute23, hr_api.g_varchar2) or
135: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute24, hr_api.g_varchar2) <>
136: nvl(p_rec.qualifier_attribute24, hr_api.g_varchar2) or
137: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute25, hr_api.g_varchar2) <>
138: nvl(p_rec.qualifier_attribute25, hr_api.g_varchar2) or
139: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute26, hr_api.g_varchar2) <>

Line 136: nvl(p_rec.qualifier_attribute24, hr_api.g_varchar2) or

132: nvl(p_rec.qualifier_attribute22, hr_api.g_varchar2) or
133: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute23, hr_api.g_varchar2) <>
134: nvl(p_rec.qualifier_attribute23, hr_api.g_varchar2) or
135: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute24, hr_api.g_varchar2) <>
136: nvl(p_rec.qualifier_attribute24, hr_api.g_varchar2) or
137: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute25, hr_api.g_varchar2) <>
138: nvl(p_rec.qualifier_attribute25, hr_api.g_varchar2) or
139: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute26, hr_api.g_varchar2) <>
140: nvl(p_rec.qualifier_attribute26, hr_api.g_varchar2) or

Line 137: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute25, hr_api.g_varchar2) <>

133: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute23, hr_api.g_varchar2) <>
134: nvl(p_rec.qualifier_attribute23, hr_api.g_varchar2) or
135: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute24, hr_api.g_varchar2) <>
136: nvl(p_rec.qualifier_attribute24, hr_api.g_varchar2) or
137: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute25, hr_api.g_varchar2) <>
138: nvl(p_rec.qualifier_attribute25, hr_api.g_varchar2) or
139: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute26, hr_api.g_varchar2) <>
140: nvl(p_rec.qualifier_attribute26, hr_api.g_varchar2) or
141: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute27, hr_api.g_varchar2) <>

Line 138: nvl(p_rec.qualifier_attribute25, hr_api.g_varchar2) or

134: nvl(p_rec.qualifier_attribute23, hr_api.g_varchar2) or
135: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute24, hr_api.g_varchar2) <>
136: nvl(p_rec.qualifier_attribute24, hr_api.g_varchar2) or
137: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute25, hr_api.g_varchar2) <>
138: nvl(p_rec.qualifier_attribute25, hr_api.g_varchar2) or
139: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute26, hr_api.g_varchar2) <>
140: nvl(p_rec.qualifier_attribute26, hr_api.g_varchar2) or
141: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute27, hr_api.g_varchar2) <>
142: nvl(p_rec.qualifier_attribute27, hr_api.g_varchar2) or

Line 139: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute26, hr_api.g_varchar2) <>

135: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute24, hr_api.g_varchar2) <>
136: nvl(p_rec.qualifier_attribute24, hr_api.g_varchar2) or
137: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute25, hr_api.g_varchar2) <>
138: nvl(p_rec.qualifier_attribute25, hr_api.g_varchar2) or
139: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute26, hr_api.g_varchar2) <>
140: nvl(p_rec.qualifier_attribute26, hr_api.g_varchar2) or
141: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute27, hr_api.g_varchar2) <>
142: nvl(p_rec.qualifier_attribute27, hr_api.g_varchar2) or
143: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute28, hr_api.g_varchar2) <>

Line 140: nvl(p_rec.qualifier_attribute26, hr_api.g_varchar2) or

136: nvl(p_rec.qualifier_attribute24, hr_api.g_varchar2) or
137: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute25, hr_api.g_varchar2) <>
138: nvl(p_rec.qualifier_attribute25, hr_api.g_varchar2) or
139: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute26, hr_api.g_varchar2) <>
140: nvl(p_rec.qualifier_attribute26, hr_api.g_varchar2) or
141: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute27, hr_api.g_varchar2) <>
142: nvl(p_rec.qualifier_attribute27, hr_api.g_varchar2) or
143: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute28, hr_api.g_varchar2) <>
144: nvl(p_rec.qualifier_attribute28, hr_api.g_varchar2) or

Line 141: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute27, hr_api.g_varchar2) <>

137: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute25, hr_api.g_varchar2) <>
138: nvl(p_rec.qualifier_attribute25, hr_api.g_varchar2) or
139: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute26, hr_api.g_varchar2) <>
140: nvl(p_rec.qualifier_attribute26, hr_api.g_varchar2) or
141: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute27, hr_api.g_varchar2) <>
142: nvl(p_rec.qualifier_attribute27, hr_api.g_varchar2) or
143: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute28, hr_api.g_varchar2) <>
144: nvl(p_rec.qualifier_attribute28, hr_api.g_varchar2) or
145: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute29, hr_api.g_varchar2) <>

Line 142: nvl(p_rec.qualifier_attribute27, hr_api.g_varchar2) or

138: nvl(p_rec.qualifier_attribute25, hr_api.g_varchar2) or
139: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute26, hr_api.g_varchar2) <>
140: nvl(p_rec.qualifier_attribute26, hr_api.g_varchar2) or
141: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute27, hr_api.g_varchar2) <>
142: nvl(p_rec.qualifier_attribute27, hr_api.g_varchar2) or
143: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute28, hr_api.g_varchar2) <>
144: nvl(p_rec.qualifier_attribute28, hr_api.g_varchar2) or
145: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute29, hr_api.g_varchar2) <>
146: nvl(p_rec.qualifier_attribute29, hr_api.g_varchar2) or

Line 143: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute28, hr_api.g_varchar2) <>

139: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute26, hr_api.g_varchar2) <>
140: nvl(p_rec.qualifier_attribute26, hr_api.g_varchar2) or
141: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute27, hr_api.g_varchar2) <>
142: nvl(p_rec.qualifier_attribute27, hr_api.g_varchar2) or
143: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute28, hr_api.g_varchar2) <>
144: nvl(p_rec.qualifier_attribute28, hr_api.g_varchar2) or
145: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute29, hr_api.g_varchar2) <>
146: nvl(p_rec.qualifier_attribute29, hr_api.g_varchar2) or
147: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute30, hr_api.g_varchar2) <>

Line 144: nvl(p_rec.qualifier_attribute28, hr_api.g_varchar2) or

140: nvl(p_rec.qualifier_attribute26, hr_api.g_varchar2) or
141: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute27, hr_api.g_varchar2) <>
142: nvl(p_rec.qualifier_attribute27, hr_api.g_varchar2) or
143: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute28, hr_api.g_varchar2) <>
144: nvl(p_rec.qualifier_attribute28, hr_api.g_varchar2) or
145: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute29, hr_api.g_varchar2) <>
146: nvl(p_rec.qualifier_attribute29, hr_api.g_varchar2) or
147: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute30, hr_api.g_varchar2) <>
148: nvl(p_rec.qualifier_attribute30, hr_api.g_varchar2) ))

Line 145: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute29, hr_api.g_varchar2) <>

141: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute27, hr_api.g_varchar2) <>
142: nvl(p_rec.qualifier_attribute27, hr_api.g_varchar2) or
143: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute28, hr_api.g_varchar2) <>
144: nvl(p_rec.qualifier_attribute28, hr_api.g_varchar2) or
145: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute29, hr_api.g_varchar2) <>
146: nvl(p_rec.qualifier_attribute29, hr_api.g_varchar2) or
147: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute30, hr_api.g_varchar2) <>
148: nvl(p_rec.qualifier_attribute30, hr_api.g_varchar2) ))
149: or (p_rec.layout_comp_qualifier_id is null) then

Line 146: nvl(p_rec.qualifier_attribute29, hr_api.g_varchar2) or

142: nvl(p_rec.qualifier_attribute27, hr_api.g_varchar2) or
143: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute28, hr_api.g_varchar2) <>
144: nvl(p_rec.qualifier_attribute28, hr_api.g_varchar2) or
145: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute29, hr_api.g_varchar2) <>
146: nvl(p_rec.qualifier_attribute29, hr_api.g_varchar2) or
147: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute30, hr_api.g_varchar2) <>
148: nvl(p_rec.qualifier_attribute30, hr_api.g_varchar2) ))
149: or (p_rec.layout_comp_qualifier_id is null) then
150: --

Line 147: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute30, hr_api.g_varchar2) <>

143: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute28, hr_api.g_varchar2) <>
144: nvl(p_rec.qualifier_attribute28, hr_api.g_varchar2) or
145: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute29, hr_api.g_varchar2) <>
146: nvl(p_rec.qualifier_attribute29, hr_api.g_varchar2) or
147: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute30, hr_api.g_varchar2) <>
148: nvl(p_rec.qualifier_attribute30, hr_api.g_varchar2) ))
149: or (p_rec.layout_comp_qualifier_id is null) then
150: --
151: -- Only execute the validation if absolutely necessary:

Line 148: nvl(p_rec.qualifier_attribute30, hr_api.g_varchar2) ))

144: nvl(p_rec.qualifier_attribute28, hr_api.g_varchar2) or
145: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute29, hr_api.g_varchar2) <>
146: nvl(p_rec.qualifier_attribute29, hr_api.g_varchar2) or
147: nvl(hxc_ulq_shd.g_old_rec.qualifier_attribute30, hr_api.g_varchar2) <>
148: nvl(p_rec.qualifier_attribute30, hr_api.g_varchar2) ))
149: or (p_rec.layout_comp_qualifier_id is null) then
150: --
151: -- Only execute the validation if absolutely necessary:
152: -- a) During update, the structure column value or any

Line 283: hr_api.argument_changed_error

279: -- not been updated.
280: --
281: EXCEPTION
282: WHEN l_error THEN
283: hr_api.argument_changed_error
284: (p_api_name => l_proc
285: ,p_argument => l_argument);
286: WHEN OTHERS THEN
287: RAISE;