APPS.HR_TMP_BUS dependencies on HR_TMP_SHD

Line 138: (p_rec in hr_tmp_shd.g_rec_type

134: -- Internal Row Handler Use Only.
135: --
136: -- ----------------------------------------------------------------------------
137: procedure chk_df
138: (p_rec in hr_tmp_shd.g_rec_type
139: ) is
140: --
141: l_proc varchar2(72) := g_package || 'chk_df';
142: --

Line 147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

143: begin
144: hr_utility.set_location('Entering:'||l_proc,10);
145: --
146: if ((p_rec.form_template_id is not null) and (
147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

145: --
146: if ((p_rec.form_template_id is not null) and (
147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute30, hr_api.g_varchar2) )
209: or (p_rec.form_template_id is null) ) then

Line 207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute30, hr_api.g_varchar2) )
209: or (p_rec.form_template_id is null) ) then
210: --
211: -- Only execute the validation if absolutely necessary:

Line 315: ,p_rec in hr_tmp_shd.g_rec_type

311: -- {End Of Comments}
312: -- ----------------------------------------------------------------------------
313: Procedure chk_non_updateable_args
314: (p_effective_date in date
315: ,p_rec in hr_tmp_shd.g_rec_type
316: ) IS
317: --
318: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
319: l_error EXCEPTION;

Line 327: IF NOT hr_tmp_shd.api_updating

323: --
324: -- Only proceed with the validation if a row exists for the current
325: -- record in the HR Schema.
326: --
327: IF NOT hr_tmp_shd.api_updating
328: (p_form_template_id => p_rec.form_template_id
329: ,p_object_version_number => p_rec.object_version_number
330: ) THEN
331: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 338: nvl(hr_tmp_shd.g_old_rec.application_id,hr_api.g_number)

334: fnd_message.raise_error;
335: END IF;
336: --
337: IF (nvl(p_rec.application_id,hr_api.g_number) <>
338: nvl(hr_tmp_shd.g_old_rec.application_id,hr_api.g_number)
339: ) THEN
340: l_argument := 'application_id';
341: RAISE l_error;
342: END IF;

Line 345: nvl(hr_tmp_shd.g_old_rec.form_id,hr_api.g_number)

341: RAISE l_error;
342: END IF;
343: --
344: IF (nvl(p_rec.form_id,hr_api.g_number) <>
345: nvl(hr_tmp_shd.g_old_rec.form_id,hr_api.g_number)
346: ) THEN
347: l_argument := 'form_id';
348: RAISE l_error;
349: END IF;

Line 556: l_api_updating := hr_tmp_shd.api_updating

552: ,p_argument => 'effective_date'
553: ,p_argument_value => p_effective_date
554: );
555: --
556: l_api_updating := hr_tmp_shd.api_updating
557: (p_form_template_id => p_form_template_id
558: ,p_object_version_number => p_object_version_number
559: );
560: hr_utility.set_location(l_proc,20);

Line 565: and nvl(hr_tmp_shd.g_old_rec.enabled_flag,hr_api.g_varchar2) <>

561: --
562: -- Only proceed with SQL validation if absolutely necessary
563: --
564: if ( ( l_api_updating
565: and nvl(hr_tmp_shd.g_old_rec.enabled_flag,hr_api.g_varchar2) <>
566: nvl(p_enabled_flag,hr_api.g_varchar2))
567: or (NOT l_api_updating)) then
568: --
569: hr_utility.set_location(l_proc,30);

Line 601: (p_rec in hr_tmp_shd.g_rec_type

597: -- ----------------------------------------------------------------------------
598: -- |------------------------------< chk_delete >------------------------------|
599: -- ----------------------------------------------------------------------------
600: Procedure chk_delete
601: (p_rec in hr_tmp_shd.g_rec_type
602: ) is
603: --
604: l_proc varchar2(72) := g_package||'chk_delete';
605: --

Line 621: ,p_rec in hr_tmp_shd.g_rec_type

617: -- |---------------------------< insert_validate >----------------------------|
618: -- ----------------------------------------------------------------------------
619: Procedure insert_validate
620: (p_effective_date in date
621: ,p_rec in hr_tmp_shd.g_rec_type
622: ) is
623: --
624: l_proc varchar2(72) := g_package||'insert_validate';
625: --

Line 688: ,p_rec in hr_tmp_shd.g_rec_type

684: -- |---------------------------< update_validate >----------------------------|
685: -- ----------------------------------------------------------------------------
686: Procedure update_validate
687: (p_effective_date in date
688: ,p_rec in hr_tmp_shd.g_rec_type
689: ) is
690: --
691: l_proc varchar2(72) := g_package||'update_validate';
692: --

Line 759: (p_rec in hr_tmp_shd.g_rec_type

755: -- ----------------------------------------------------------------------------
756: -- |---------------------------< delete_validate >----------------------------|
757: -- ----------------------------------------------------------------------------
758: Procedure delete_validate
759: (p_rec in hr_tmp_shd.g_rec_type
760: ) is
761: --
762: l_proc varchar2(72) := g_package||'delete_validate';
763: --