70: -- Internal Row Handler Use Only.
71: --
72: -- ----------------------------------------------------------------------------
73: procedure chk_df
74: (p_rec in hxc_ulq_shd.g_rec_type
75: ) is
76: --
77: l_proc varchar2(72) ;
78: --
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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
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:
252: --
253: -- {End Of Comments}
254: -- ----------------------------------------------------------------------------
255: Procedure chk_non_updateable_args
256: (p_rec in hxc_ulq_shd.g_rec_type
257: ) IS
258: --
259: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
260: l_error EXCEPTION;
264: --
265: -- Only proceed with the validation if a row exists for the current
266: -- record in the hxc Schema.
267: --
268: IF NOT hxc_ulq_shd.api_updating
269: (p_layout_comp_qualifier_id => p_rec.layout_comp_qualifier_id
270: ,p_object_version_number => p_rec.object_version_number
271: ) THEN
272: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
290: -- ----------------------------------------------------------------------------
291: -- |---------------------------< insert_validate >----------------------------|
292: -- ----------------------------------------------------------------------------
293: Procedure insert_validate
294: (p_rec in hxc_ulq_shd.g_rec_type
295: ) is
296: --
297: l_proc varchar2(72) ;
298: --
329: -- ----------------------------------------------------------------------------
330: -- |---------------------------< update_validate >----------------------------|
331: -- ----------------------------------------------------------------------------
332: Procedure update_validate
333: (p_rec in hxc_ulq_shd.g_rec_type
334: ) is
335: --
336: l_proc varchar2(72) ;
337: --
372: -- ----------------------------------------------------------------------------
373: -- |---------------------------< delete_validate >----------------------------|
374: -- ----------------------------------------------------------------------------
375: Procedure delete_validate
376: (p_rec in hxc_ulq_shd.g_rec_type
377: ) is
378: --
379: l_proc varchar2(72) ;
380: --