DBA Data[Home] [Help]

APPS.PER_PMP_BUS dependencies on PER_PMP_SHD

Line 154: (p_rec in per_pmp_shd.g_rec_type

150: -- Internal Row Handler Use Only.
151: --
152: -- ----------------------------------------------------------------------------
153: procedure chk_df
154: (p_rec in per_pmp_shd.g_rec_type
155: ) is
156: --
157: l_proc varchar2(72) := g_package || 'chk_df';
158: --

Line 163: nvl(per_pmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

159: begin
160: hr_utility.set_location('Entering:'||l_proc,10);
161: --
162: if ((p_rec.plan_id is not null) and (
163: nvl(per_pmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
165: nvl(per_pmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute1, hr_api.g_varchar2) or
167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 165: nvl(per_pmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

161: --
162: if ((p_rec.plan_id is not null) and (
163: nvl(per_pmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
165: nvl(per_pmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute1, hr_api.g_varchar2) or
167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute2, hr_api.g_varchar2) or
169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

163: nvl(per_pmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
165: nvl(per_pmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute1, hr_api.g_varchar2) or
167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute2, hr_api.g_varchar2) or
169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute3, hr_api.g_varchar2) or
171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

165: nvl(per_pmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute1, hr_api.g_varchar2) or
167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute2, hr_api.g_varchar2) or
169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute3, hr_api.g_varchar2) or
171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute4, hr_api.g_varchar2) or
173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute2, hr_api.g_varchar2) or
169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute3, hr_api.g_varchar2) or
171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute4, hr_api.g_varchar2) or
173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute5, hr_api.g_varchar2) or
175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute3, hr_api.g_varchar2) or
171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute4, hr_api.g_varchar2) or
173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute5, hr_api.g_varchar2) or
175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute6, hr_api.g_varchar2) or
177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute4, hr_api.g_varchar2) or
173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute5, hr_api.g_varchar2) or
175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute6, hr_api.g_varchar2) or
177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute7, hr_api.g_varchar2) or
179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute5, hr_api.g_varchar2) or
175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute6, hr_api.g_varchar2) or
177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute7, hr_api.g_varchar2) or
179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute8, hr_api.g_varchar2) or
181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute6, hr_api.g_varchar2) or
177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute7, hr_api.g_varchar2) or
179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute8, hr_api.g_varchar2) or
181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute9, hr_api.g_varchar2) or
183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute7, hr_api.g_varchar2) or
179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute8, hr_api.g_varchar2) or
181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute9, hr_api.g_varchar2) or
183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute10, hr_api.g_varchar2) or
185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute8, hr_api.g_varchar2) or
181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute9, hr_api.g_varchar2) or
183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute10, hr_api.g_varchar2) or
185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute11, hr_api.g_varchar2) or
187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute9, hr_api.g_varchar2) or
183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute10, hr_api.g_varchar2) or
185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute11, hr_api.g_varchar2) or
187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute12, hr_api.g_varchar2) or
189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute10, hr_api.g_varchar2) or
185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute11, hr_api.g_varchar2) or
187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute12, hr_api.g_varchar2) or
189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute13, hr_api.g_varchar2) or
191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute11, hr_api.g_varchar2) or
187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute12, hr_api.g_varchar2) or
189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute13, hr_api.g_varchar2) or
191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute14, hr_api.g_varchar2) or
193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute12, hr_api.g_varchar2) or
189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute13, hr_api.g_varchar2) or
191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute14, hr_api.g_varchar2) or
193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute15, hr_api.g_varchar2) or
195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute13, hr_api.g_varchar2) or
191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute14, hr_api.g_varchar2) or
193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute15, hr_api.g_varchar2) or
195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute16, hr_api.g_varchar2) or
197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute14, hr_api.g_varchar2) or
193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute15, hr_api.g_varchar2) or
195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute16, hr_api.g_varchar2) or
197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute17, hr_api.g_varchar2) or
199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute15, hr_api.g_varchar2) or
195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute16, hr_api.g_varchar2) or
197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute17, hr_api.g_varchar2) or
199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute18, hr_api.g_varchar2) or
201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute16, hr_api.g_varchar2) or
197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute17, hr_api.g_varchar2) or
199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute18, hr_api.g_varchar2) or
201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute19, hr_api.g_varchar2) or
203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute17, hr_api.g_varchar2) or
199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute18, hr_api.g_varchar2) or
201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute19, hr_api.g_varchar2) or
203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute20, hr_api.g_varchar2) or
205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute18, hr_api.g_varchar2) or
201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute19, hr_api.g_varchar2) or
203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute20, hr_api.g_varchar2) or
205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute21, hr_api.g_varchar2) or
207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute19, hr_api.g_varchar2) or
203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute20, hr_api.g_varchar2) or
205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute21, hr_api.g_varchar2) or
207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute22, hr_api.g_varchar2) or
209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute20, hr_api.g_varchar2) or
205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute21, hr_api.g_varchar2) or
207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute22, hr_api.g_varchar2) or
209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute23, hr_api.g_varchar2) or
211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute21, hr_api.g_varchar2) or
207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute22, hr_api.g_varchar2) or
209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute23, hr_api.g_varchar2) or
211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute24, hr_api.g_varchar2) or
213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute22, hr_api.g_varchar2) or
209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute23, hr_api.g_varchar2) or
211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute24, hr_api.g_varchar2) or
213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute25, hr_api.g_varchar2) or
215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute23, hr_api.g_varchar2) or
211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute24, hr_api.g_varchar2) or
213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute25, hr_api.g_varchar2) or
215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute26, hr_api.g_varchar2) or
217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute24, hr_api.g_varchar2) or
213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute25, hr_api.g_varchar2) or
215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute26, hr_api.g_varchar2) or
217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute27, hr_api.g_varchar2) or
219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute25, hr_api.g_varchar2) or
215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute26, hr_api.g_varchar2) or
217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute27, hr_api.g_varchar2) or
219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute28, hr_api.g_varchar2) or
221: nvl(per_pmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute26, hr_api.g_varchar2) or
217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute27, hr_api.g_varchar2) or
219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute28, hr_api.g_varchar2) or
221: nvl(per_pmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute29, hr_api.g_varchar2) or
223: nvl(per_pmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 221: nvl(per_pmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute27, hr_api.g_varchar2) or
219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute28, hr_api.g_varchar2) or
221: nvl(per_pmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute29, hr_api.g_varchar2) or
223: nvl(per_pmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
225: or (p_rec.plan_id is null) then

Line 223: nvl(per_pmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute28, hr_api.g_varchar2) or
221: nvl(per_pmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute29, hr_api.g_varchar2) or
223: nvl(per_pmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
225: or (p_rec.plan_id is null) then
226: --
227: -- Only execute the validation if absolutely necessary:

Line 331: ,p_rec in per_pmp_shd.g_rec_type

327: -- {End Of Comments}
328: -- ----------------------------------------------------------------------------
329: Procedure chk_non_updateable_args
330: (p_effective_date in date
331: ,p_rec in per_pmp_shd.g_rec_type
332: ) IS
333: --
334: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
335: --

Line 341: IF NOT per_pmp_shd.api_updating

337: --
338: -- Only proceed with the validation if a row exists for the current
339: -- record in the HR Schema.
340: --
341: IF NOT per_pmp_shd.api_updating
342: (p_plan_id => p_rec.plan_id
343: ,p_object_version_number => p_rec.object_version_number
344: ) THEN
345: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 419: l_api_updating := per_pmp_shd.api_updating

415: -- Only proceed with validation if :
416: -- a) The current g_old_rec is current and
417: -- b) The date values have changed
418: --
419: l_api_updating := per_pmp_shd.api_updating
420: (p_plan_id => p_plan_id
421: ,p_object_version_number => p_object_version_number);
422: --
423: IF (l_api_updating

Line 424: AND nvl(per_pmp_shd.g_old_rec.plan_name, hr_api.g_varchar2)

420: (p_plan_id => p_plan_id
421: ,p_object_version_number => p_object_version_number);
422: --
423: IF (l_api_updating
424: AND nvl(per_pmp_shd.g_old_rec.plan_name, hr_api.g_varchar2)
425: = nvl(p_plan_name, hr_api.g_varchar2))
426: THEN
427: RETURN;
428: END IF;

Line 509: l_api_updating := per_pmp_shd.api_updating

505: -- Only proceed with validation if :
506: -- a) The current g_old_rec is current and
507: -- b) The date values have changed
508: --
509: l_api_updating := per_pmp_shd.api_updating
510: (p_plan_id => p_plan_id
511: ,p_object_version_number => p_object_version_number);
512: --
513: IF (l_api_updating

Line 514: AND nvl(per_pmp_shd.g_old_rec.administrator_person_id, hr_api.g_number)

510: (p_plan_id => p_plan_id
511: ,p_object_version_number => p_object_version_number);
512: --
513: IF (l_api_updating
514: AND nvl(per_pmp_shd.g_old_rec.administrator_person_id, hr_api.g_number)
515: = nvl(p_administrator_person_id, hr_api.g_number))
516: THEN
517: RETURN;
518: END IF;

Line 613: l_api_updating := per_pmp_shd.api_updating

609: -- Only proceed with validation if :
610: -- a) The current g_old_rec is current and
611: -- b) The date values have changed
612: --
613: l_api_updating := per_pmp_shd.api_updating
614: (p_plan_id => p_plan_id
615: ,p_object_version_number => p_object_version_number);
616: --
617: IF (l_api_updating

Line 618: AND nvl(per_pmp_shd.g_old_rec.previous_plan_id, hr_api.g_number)

614: (p_plan_id => p_plan_id
615: ,p_object_version_number => p_object_version_number);
616: --
617: IF (l_api_updating
618: AND nvl(per_pmp_shd.g_old_rec.previous_plan_id, hr_api.g_number)
619: = nvl(p_previous_plan_id, hr_api.g_number)
620: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
621: = nvl(p_start_date, hr_api.g_date))
622: THEN

Line 620: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)

616: --
617: IF (l_api_updating
618: AND nvl(per_pmp_shd.g_old_rec.previous_plan_id, hr_api.g_number)
619: = nvl(p_previous_plan_id, hr_api.g_number)
620: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
621: = nvl(p_start_date, hr_api.g_date))
622: THEN
623: RETURN;
624: END IF;

Line 736: l_api_updating := per_pmp_shd.api_updating

732: -- Only proceed with validation if :
733: -- a) The current g_old_rec is current and
734: -- b) The date values have changed
735: --
736: l_api_updating := per_pmp_shd.api_updating
737: (p_plan_id => p_plan_id
738: ,p_object_version_number => p_object_version_number);
739: --
740: IF (l_api_updating

Line 741: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)

737: (p_plan_id => p_plan_id
738: ,p_object_version_number => p_object_version_number);
739: --
740: IF (l_api_updating
741: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
742: = nvl(p_start_date, hr_api.g_date)
743: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)
744: = nvl(p_end_date, hr_api.g_date))
745: THEN

Line 743: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)

739: --
740: IF (l_api_updating
741: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
742: = nvl(p_start_date, hr_api.g_date)
743: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)
744: = nvl(p_end_date, hr_api.g_date))
745: THEN
746: RETURN;
747: END IF;

Line 762: nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)

758: --
759: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
760: --
761: IF (l_api_updating AND p_status_code <> 'DRAFT' AND
762: nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
763: <> nvl(p_start_date, hr_api.g_date))
764: THEN
765: fnd_message.set_name('PER','HR_50395_WPM_ST_DATE_UPD');
766: fnd_message.raise_error;

Line 837: l_api_updating := per_pmp_shd.api_updating

833: -- Only proceed with validation if :
834: -- a) The current g_old_rec is current and
835: -- b) The date values have changed
836: --
837: l_api_updating := per_pmp_shd.api_updating
838: (p_plan_id => p_plan_id
839: ,p_object_version_number => p_object_version_number);
840: --
841: IF (l_api_updating

Line 842: AND nvl(per_pmp_shd.g_old_rec.status_code, hr_api.g_varchar2)

838: (p_plan_id => p_plan_id
839: ,p_object_version_number => p_object_version_number);
840: --
841: IF (l_api_updating
842: AND nvl(per_pmp_shd.g_old_rec.status_code, hr_api.g_varchar2)
843: = nvl(p_status_code, hr_api.g_varchar2))
844: THEN
845: RETURN;
846: END IF;

Line 923: l_api_updating := per_pmp_shd.api_updating

919: -- Only proceed with validation if :
920: -- a) The current g_old_rec is current and
921: -- b) The date values have changed
922: --
923: l_api_updating := per_pmp_shd.api_updating
924: (p_plan_id => p_plan_id
925: ,p_object_version_number => p_object_version_number);
926: --
927: IF (l_api_updating

Line 928: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)

924: (p_plan_id => p_plan_id
925: ,p_object_version_number => p_object_version_number);
926: --
927: IF (l_api_updating
928: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
929: = nvl(p_hierarchy_type_code, hr_api.g_varchar2))
930: THEN
931: RETURN;
932: END IF;

Line 1019: l_api_updating := per_pmp_shd.api_updating

1015: -- Only proceed with validation if :
1016: -- a) The current g_old_rec is current and
1017: -- b) The date values have changed
1018: --
1019: l_api_updating := per_pmp_shd.api_updating
1020: (p_plan_id => p_plan_id
1021: ,p_object_version_number => p_object_version_number);
1022: --
1023: IF (l_api_updating

Line 1024: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)

1020: (p_plan_id => p_plan_id
1021: ,p_object_version_number => p_object_version_number);
1022: --
1023: IF (l_api_updating
1024: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1025: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1026: AND nvl(per_pmp_shd.g_old_rec.supervisor_id, hr_api.g_number)
1027: = nvl(p_supervisor_id, hr_api.g_number))
1028: THEN

Line 1026: AND nvl(per_pmp_shd.g_old_rec.supervisor_id, hr_api.g_number)

1022: --
1023: IF (l_api_updating
1024: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1025: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1026: AND nvl(per_pmp_shd.g_old_rec.supervisor_id, hr_api.g_number)
1027: = nvl(p_supervisor_id, hr_api.g_number))
1028: THEN
1029: RETURN;
1030: END IF;

Line 1131: l_api_updating := per_pmp_shd.api_updating

1127: -- Only proceed with validation if :
1128: -- a) The current g_old_rec is current and
1129: -- b) The date values have changed
1130: --
1131: l_api_updating := per_pmp_shd.api_updating
1132: (p_plan_id => p_plan_id
1133: ,p_object_version_number => p_object_version_number);
1134: --
1135: IF (l_api_updating

Line 1136: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)

1132: (p_plan_id => p_plan_id
1133: ,p_object_version_number => p_object_version_number);
1134: --
1135: IF (l_api_updating
1136: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1137: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1138: AND nvl(per_pmp_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number)
1139: = nvl(p_supervisor_assignment_id, hr_api.g_number))
1140: THEN

Line 1138: AND nvl(per_pmp_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number)

1134: --
1135: IF (l_api_updating
1136: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1137: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1138: AND nvl(per_pmp_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number)
1139: = nvl(p_supervisor_assignment_id, hr_api.g_number))
1140: THEN
1141: RETURN;
1142: END IF;

Line 1240: l_api_updating := per_pmp_shd.api_updating

1236: -- Only proceed with validation if :
1237: -- a) The current g_old_rec is current and
1238: -- b) The date values have changed
1239: --
1240: l_api_updating := per_pmp_shd.api_updating
1241: (p_plan_id => p_plan_id
1242: ,p_object_version_number => p_object_version_number);
1243: --
1244: IF (l_api_updating

Line 1245: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)

1241: (p_plan_id => p_plan_id
1242: ,p_object_version_number => p_object_version_number);
1243: --
1244: IF (l_api_updating
1245: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1246: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1247: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)
1248: = nvl(p_organization_structure_id, hr_api.g_number))
1249: THEN

Line 1247: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)

1243: --
1244: IF (l_api_updating
1245: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1246: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1247: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)
1248: = nvl(p_organization_structure_id, hr_api.g_number))
1249: THEN
1250: RETURN;
1251: END IF;

Line 1350: l_api_updating := per_pmp_shd.api_updating

1346: -- Only proceed with validation if :
1347: -- a) The current g_old_rec is current and
1348: -- b) The date values have changed
1349: --
1350: l_api_updating := per_pmp_shd.api_updating
1351: (p_plan_id => p_plan_id
1352: ,p_object_version_number => p_object_version_number);
1353: --
1354: IF (l_api_updating

Line 1355: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)

1351: (p_plan_id => p_plan_id
1352: ,p_object_version_number => p_object_version_number);
1353: --
1354: IF (l_api_updating
1355: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1356: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1357: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1358: = nvl(p_org_structure_version_id, hr_api.g_number))
1359: THEN

Line 1357: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)

1353: --
1354: IF (l_api_updating
1355: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1356: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1357: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1358: = nvl(p_org_structure_version_id, hr_api.g_number))
1359: THEN
1360: RETURN;
1361: END IF;

Line 1460: l_api_updating := per_pmp_shd.api_updating

1456: -- Only proceed with validation if :
1457: -- a) The current g_old_rec is current and
1458: -- b) The date values have changed
1459: --
1460: l_api_updating := per_pmp_shd.api_updating
1461: (p_plan_id => p_plan_id
1462: ,p_object_version_number => p_object_version_number);
1463: --
1464: IF (l_api_updating

Line 1465: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)

1461: (p_plan_id => p_plan_id
1462: ,p_object_version_number => p_object_version_number);
1463: --
1464: IF (l_api_updating
1465: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)
1466: = nvl(p_organization_structure_id, hr_api.g_number)
1467: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1468: = nvl(p_org_structure_version_id, hr_api.g_number))
1469: THEN

Line 1467: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)

1463: --
1464: IF (l_api_updating
1465: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)
1466: = nvl(p_organization_structure_id, hr_api.g_number)
1467: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1468: = nvl(p_org_structure_version_id, hr_api.g_number))
1469: THEN
1470: RETURN;
1471: END IF;

Line 1563: l_api_updating := per_pmp_shd.api_updating

1559: -- Only proceed with validation if :
1560: -- a) The current g_old_rec is current and
1561: -- b) The date values have changed
1562: --
1563: l_api_updating := per_pmp_shd.api_updating
1564: (p_plan_id => p_plan_id
1565: ,p_object_version_number => p_object_version_number);
1566: --
1567: IF (l_api_updating

Line 1568: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)

1564: (p_plan_id => p_plan_id
1565: ,p_object_version_number => p_object_version_number);
1566: --
1567: IF (l_api_updating
1568: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1569: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1570: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1571: = nvl(p_org_structure_version_id, hr_api.g_number)
1572: AND nvl(per_pmp_shd.g_old_rec.top_organization_id, hr_api.g_number)

Line 1570: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)

1566: --
1567: IF (l_api_updating
1568: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1569: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1570: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1571: = nvl(p_org_structure_version_id, hr_api.g_number)
1572: AND nvl(per_pmp_shd.g_old_rec.top_organization_id, hr_api.g_number)
1573: = nvl(p_top_organization_id, hr_api.g_number))
1574: THEN

Line 1572: AND nvl(per_pmp_shd.g_old_rec.top_organization_id, hr_api.g_number)

1568: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1569: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1570: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1571: = nvl(p_org_structure_version_id, hr_api.g_number)
1572: AND nvl(per_pmp_shd.g_old_rec.top_organization_id, hr_api.g_number)
1573: = nvl(p_top_organization_id, hr_api.g_number))
1574: THEN
1575: RETURN;
1576: END IF;

Line 1675: l_api_updating := per_pmp_shd.api_updating

1671: -- Only proceed with validation if :
1672: -- a) The current g_old_rec is current and
1673: -- b) The date values have changed
1674: --
1675: l_api_updating := per_pmp_shd.api_updating
1676: (p_plan_id => p_plan_id
1677: ,p_object_version_number => p_object_version_number);
1678: --
1679: IF (l_api_updating

Line 1680: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)

1676: (p_plan_id => p_plan_id
1677: ,p_object_version_number => p_object_version_number);
1678: --
1679: IF (l_api_updating
1680: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1681: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1682: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)
1683: = nvl(p_position_structure_id, hr_api.g_number))
1684: THEN

Line 1682: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)

1678: --
1679: IF (l_api_updating
1680: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1681: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1682: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)
1683: = nvl(p_position_structure_id, hr_api.g_number))
1684: THEN
1685: RETURN;
1686: END IF;

Line 1785: l_api_updating := per_pmp_shd.api_updating

1781: -- Only proceed with validation if :
1782: -- a) The current g_old_rec is current and
1783: -- b) The date values have changed
1784: --
1785: l_api_updating := per_pmp_shd.api_updating
1786: (p_plan_id => p_plan_id
1787: ,p_object_version_number => p_object_version_number);
1788: --
1789: IF (l_api_updating

Line 1790: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)

1786: (p_plan_id => p_plan_id
1787: ,p_object_version_number => p_object_version_number);
1788: --
1789: IF (l_api_updating
1790: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1791: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1792: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
1793: = nvl(p_pos_structure_version_id, hr_api.g_number))
1794: THEN

Line 1792: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)

1788: --
1789: IF (l_api_updating
1790: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1791: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1792: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
1793: = nvl(p_pos_structure_version_id, hr_api.g_number))
1794: THEN
1795: RETURN;
1796: END IF;

Line 1895: l_api_updating := per_pmp_shd.api_updating

1891: -- Only proceed with validation if :
1892: -- a) The current g_old_rec is current and
1893: -- b) The date values have changed
1894: --
1895: l_api_updating := per_pmp_shd.api_updating
1896: (p_plan_id => p_plan_id
1897: ,p_object_version_number => p_object_version_number);
1898: --
1899: IF (l_api_updating

Line 1900: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)

1896: (p_plan_id => p_plan_id
1897: ,p_object_version_number => p_object_version_number);
1898: --
1899: IF (l_api_updating
1900: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)
1901: = nvl(p_position_structure_id, hr_api.g_number)
1902: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
1903: = nvl(p_pos_structure_version_id, hr_api.g_number))
1904: THEN

Line 1902: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)

1898: --
1899: IF (l_api_updating
1900: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)
1901: = nvl(p_position_structure_id, hr_api.g_number)
1902: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
1903: = nvl(p_pos_structure_version_id, hr_api.g_number))
1904: THEN
1905: RETURN;
1906: END IF;

Line 1998: l_api_updating := per_pmp_shd.api_updating

1994: -- Only proceed with validation if :
1995: -- a) The current g_old_rec is current and
1996: -- b) The date values have changed
1997: --
1998: l_api_updating := per_pmp_shd.api_updating
1999: (p_plan_id => p_plan_id
2000: ,p_object_version_number => p_object_version_number);
2001: --
2002: IF (l_api_updating

Line 2003: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)

1999: (p_plan_id => p_plan_id
2000: ,p_object_version_number => p_object_version_number);
2001: --
2002: IF (l_api_updating
2003: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2004: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2005: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
2006: = nvl(p_pos_structure_version_id, hr_api.g_number)
2007: AND nvl(per_pmp_shd.g_old_rec.top_position_id, hr_api.g_number)

Line 2005: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)

2001: --
2002: IF (l_api_updating
2003: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2004: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2005: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
2006: = nvl(p_pos_structure_version_id, hr_api.g_number)
2007: AND nvl(per_pmp_shd.g_old_rec.top_position_id, hr_api.g_number)
2008: = nvl(p_top_position_id, hr_api.g_number))
2009: THEN

Line 2007: AND nvl(per_pmp_shd.g_old_rec.top_position_id, hr_api.g_number)

2003: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2004: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2005: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
2006: = nvl(p_pos_structure_version_id, hr_api.g_number)
2007: AND nvl(per_pmp_shd.g_old_rec.top_position_id, hr_api.g_number)
2008: = nvl(p_top_position_id, hr_api.g_number))
2009: THEN
2010: RETURN;
2011: END IF;

Line 2100: l_api_updating := per_pmp_shd.api_updating

2096: -- Only proceed with validation if :
2097: -- a) The current g_old_rec is current and
2098: -- b) The date values have changed
2099: --
2100: l_api_updating := per_pmp_shd.api_updating
2101: (p_plan_id => p_plan_id
2102: ,p_object_version_number => p_object_version_number);
2103: --
2104: IF (l_api_updating

Line 2105: AND nvl(per_pmp_shd.g_old_rec.hierarchy_levels, hr_api.g_number)

2101: (p_plan_id => p_plan_id
2102: ,p_object_version_number => p_object_version_number);
2103: --
2104: IF (l_api_updating
2105: AND nvl(per_pmp_shd.g_old_rec.hierarchy_levels, hr_api.g_number)
2106: = nvl(p_hierarchy_levels, hr_api.g_number))
2107: THEN
2108: RETURN;
2109: END IF;

Line 2187: l_api_updating := per_pmp_shd.api_updating

2183: -- Only proceed with validation if :
2184: -- a) The current g_old_rec is current and
2185: -- b) The date values have changed
2186: --
2187: l_api_updating := per_pmp_shd.api_updating
2188: (p_plan_id => p_plan_id
2189: ,p_object_version_number => p_object_version_number);
2190: --
2191: IF (l_api_updating

Line 2192: AND nvl(per_pmp_shd.g_old_rec.automatic_enrollment_flag, hr_api.g_varchar2)

2188: (p_plan_id => p_plan_id
2189: ,p_object_version_number => p_object_version_number);
2190: --
2191: IF (l_api_updating
2192: AND nvl(per_pmp_shd.g_old_rec.automatic_enrollment_flag, hr_api.g_varchar2)
2193: = nvl(p_automatic_enrollment_flag, hr_api.g_varchar2))
2194: THEN
2195: RETURN;
2196: END IF;

Line 2278: l_api_updating := per_pmp_shd.api_updating

2274: -- Only proceed with validation if :
2275: -- a) The current g_old_rec is current and
2276: -- b) The date values have changed
2277: --
2278: l_api_updating := per_pmp_shd.api_updating
2279: (p_plan_id => p_plan_id
2280: ,p_object_version_number => p_object_version_number);
2281: --
2282: IF (l_api_updating

Line 2283: AND nvl(per_pmp_shd.g_old_rec.assignment_types_code, hr_api.g_varchar2)

2279: (p_plan_id => p_plan_id
2280: ,p_object_version_number => p_object_version_number);
2281: --
2282: IF (l_api_updating
2283: AND nvl(per_pmp_shd.g_old_rec.assignment_types_code, hr_api.g_varchar2)
2284: = nvl(p_assignment_types_code, hr_api.g_varchar2))
2285: THEN
2286: RETURN;
2287: END IF;

Line 2369: l_api_updating := per_pmp_shd.api_updating

2365: -- Only proceed with validation if :
2366: -- a) The current g_old_rec is current and
2367: -- b) The date values have changed
2368: --
2369: l_api_updating := per_pmp_shd.api_updating
2370: (p_plan_id => p_plan_id
2371: ,p_object_version_number => p_object_version_number);
2372: --
2373: IF (l_api_updating

Line 2374: AND nvl(per_pmp_shd.g_old_rec.primary_asg_only_flag, hr_api.g_varchar2)

2370: (p_plan_id => p_plan_id
2371: ,p_object_version_number => p_object_version_number);
2372: --
2373: IF (l_api_updating
2374: AND nvl(per_pmp_shd.g_old_rec.primary_asg_only_flag, hr_api.g_varchar2)
2375: = nvl(p_primary_asg_only_flag, hr_api.g_varchar2))
2376: THEN
2377: RETURN;
2378: END IF;

Line 2462: l_api_updating := per_pmp_shd.api_updating

2458: -- Only proceed with validation if :
2459: -- a) The current g_old_rec is current and
2460: -- b) The date values have changed
2461: --
2462: l_api_updating := per_pmp_shd.api_updating
2463: (p_plan_id => p_plan_id
2464: ,p_object_version_number => p_object_version_number);
2465: --
2466: IF (l_api_updating

Line 2467: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)

2463: (p_plan_id => p_plan_id
2464: ,p_object_version_number => p_object_version_number);
2465: --
2466: IF (l_api_updating
2467: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2468: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2469: AND nvl(per_pmp_shd.g_old_rec.primary_asg_only_flag, hr_api.g_varchar2)
2470: = nvl(p_primary_asg_only_flag, hr_api.g_varchar2))
2471: THEN

Line 2469: AND nvl(per_pmp_shd.g_old_rec.primary_asg_only_flag, hr_api.g_varchar2)

2465: --
2466: IF (l_api_updating
2467: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2468: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2469: AND nvl(per_pmp_shd.g_old_rec.primary_asg_only_flag, hr_api.g_varchar2)
2470: = nvl(p_primary_asg_only_flag, hr_api.g_varchar2))
2471: THEN
2472: RETURN;
2473: END IF;

Line 2558: l_api_updating := per_pmp_shd.api_updating

2554: -- Only proceed with validation if :
2555: -- a) The current g_old_rec is current and
2556: -- b) The date values have changed
2557: --
2558: l_api_updating := per_pmp_shd.api_updating
2559: (p_plan_id => p_plan_id
2560: ,p_object_version_number => p_object_version_number);
2561: --
2562: IF (l_api_updating

Line 2563: AND nvl(per_pmp_shd.g_old_rec.include_obj_setting_flag, hr_api.g_varchar2)

2559: (p_plan_id => p_plan_id
2560: ,p_object_version_number => p_object_version_number);
2561: --
2562: IF (l_api_updating
2563: AND nvl(per_pmp_shd.g_old_rec.include_obj_setting_flag, hr_api.g_varchar2)
2564: = nvl(p_include_obj_setting_flag, hr_api.g_varchar2)
2565: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2566: = nvl(p_obj_setting_start_date, hr_api.g_date)
2567: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)

Line 2565: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)

2561: --
2562: IF (l_api_updating
2563: AND nvl(per_pmp_shd.g_old_rec.include_obj_setting_flag, hr_api.g_varchar2)
2564: = nvl(p_include_obj_setting_flag, hr_api.g_varchar2)
2565: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2566: = nvl(p_obj_setting_start_date, hr_api.g_date)
2567: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
2568: = nvl(p_method_code, hr_api.g_varchar2)
2569: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)

Line 2567: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)

2563: AND nvl(per_pmp_shd.g_old_rec.include_obj_setting_flag, hr_api.g_varchar2)
2564: = nvl(p_include_obj_setting_flag, hr_api.g_varchar2)
2565: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2566: = nvl(p_obj_setting_start_date, hr_api.g_date)
2567: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
2568: = nvl(p_method_code, hr_api.g_varchar2)
2569: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)
2570: = nvl(p_notify_population_flag, hr_api.g_varchar2))
2571: THEN

Line 2569: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)

2565: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2566: = nvl(p_obj_setting_start_date, hr_api.g_date)
2567: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
2568: = nvl(p_method_code, hr_api.g_varchar2)
2569: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)
2570: = nvl(p_notify_population_flag, hr_api.g_varchar2))
2571: THEN
2572: RETURN;
2573: END IF;

Line 2676: l_api_updating := per_pmp_shd.api_updating

2672: -- Only proceed with validation if :
2673: -- a) The current g_old_rec is current and
2674: -- b) The date values have changed
2675: --
2676: l_api_updating := per_pmp_shd.api_updating
2677: (p_plan_id => p_plan_id
2678: ,p_object_version_number => p_object_version_number);
2679: --
2680: IF (l_api_updating

Line 2681: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)

2677: (p_plan_id => p_plan_id
2678: ,p_object_version_number => p_object_version_number);
2679: --
2680: IF (l_api_updating
2681: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2682: = nvl(p_obj_setting_start_date, hr_api.g_date)
2683: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)
2684: = nvl(p_obj_setting_deadline, hr_api.g_date))
2685: THEN

Line 2683: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)

2679: --
2680: IF (l_api_updating
2681: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2682: = nvl(p_obj_setting_start_date, hr_api.g_date)
2683: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)
2684: = nvl(p_obj_setting_deadline, hr_api.g_date))
2685: THEN
2686: RETURN;
2687: END IF;

Line 2767: l_api_updating := per_pmp_shd.api_updating

2763: -- Only proceed with validation if :
2764: -- a) The current g_old_rec is current and
2765: -- b) The date values have changed
2766: --
2767: l_api_updating := per_pmp_shd.api_updating
2768: (p_plan_id => p_plan_id
2769: ,p_object_version_number => p_object_version_number);
2770: --
2771: IF (l_api_updating

Line 2772: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)

2768: (p_plan_id => p_plan_id
2769: ,p_object_version_number => p_object_version_number);
2770: --
2771: IF (l_api_updating
2772: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)
2773: = nvl(p_obj_setting_deadline, hr_api.g_date)
2774: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)
2775: = nvl(p_end_date, hr_api.g_date))
2776: THEN

Line 2774: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)

2770: --
2771: IF (l_api_updating
2772: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)
2773: = nvl(p_obj_setting_deadline, hr_api.g_date)
2774: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)
2775: = nvl(p_end_date, hr_api.g_date))
2776: THEN
2777: RETURN;
2778: END IF;

Line 2868: l_api_updating := per_pmp_shd.api_updating

2864: -- Only proceed with validation if :
2865: -- a) The current g_old_rec is current and
2866: -- b) The date values have changed
2867: --
2868: l_api_updating := per_pmp_shd.api_updating
2869: (p_plan_id => p_plan_id
2870: ,p_object_version_number => p_object_version_number);
2871: --
2872: IF (l_api_updating

Line 2873: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)

2869: (p_plan_id => p_plan_id
2870: ,p_object_version_number => p_object_version_number);
2871: --
2872: IF (l_api_updating
2873: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2874: = nvl(p_obj_setting_start_date, hr_api.g_date)
2875: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
2876: = nvl(p_start_date, hr_api.g_date))
2877: THEN

Line 2875: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)

2871: --
2872: IF (l_api_updating
2873: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2874: = nvl(p_obj_setting_start_date, hr_api.g_date)
2875: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
2876: = nvl(p_start_date, hr_api.g_date))
2877: THEN
2878: RETURN;
2879: END IF;

Line 2965: l_api_updating := per_pmp_shd.api_updating

2961: -- Only proceed with validation if :
2962: -- a) The current g_old_rec is current and
2963: -- b) The date values have changed
2964: --
2965: l_api_updating := per_pmp_shd.api_updating
2966: (p_plan_id => p_plan_id
2967: ,p_object_version_number => p_object_version_number);
2968: --
2969: IF (l_api_updating

Line 2970: AND nvl(per_pmp_shd.g_old_rec.obj_set_outside_period_flag, hr_api.g_varchar2)

2966: (p_plan_id => p_plan_id
2967: ,p_object_version_number => p_object_version_number);
2968: --
2969: IF (l_api_updating
2970: AND nvl(per_pmp_shd.g_old_rec.obj_set_outside_period_flag, hr_api.g_varchar2)
2971: = nvl(p_obj_set_outside_period_flag, hr_api.g_varchar2))
2972: THEN
2973: RETURN;
2974: END IF;

Line 3056: l_api_updating := per_pmp_shd.api_updating

3052: -- Only proceed with validation if :
3053: -- a) The current g_old_rec is current and
3054: -- b) The date values have changed
3055: --
3056: l_api_updating := per_pmp_shd.api_updating
3057: (p_plan_id => p_plan_id
3058: ,p_object_version_number => p_object_version_number);
3059: --
3060: IF (l_api_updating

Line 3061: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)

3057: (p_plan_id => p_plan_id
3058: ,p_object_version_number => p_object_version_number);
3059: --
3060: IF (l_api_updating
3061: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
3062: = nvl(p_method_code, hr_api.g_varchar2))
3063: THEN
3064: RETURN;
3065: END IF;

Line 3147: l_api_updating := per_pmp_shd.api_updating

3143: -- Only proceed with validation if :
3144: -- a) The current g_old_rec is current and
3145: -- b) The date values have changed
3146: --
3147: l_api_updating := per_pmp_shd.api_updating
3148: (p_plan_id => p_plan_id
3149: ,p_object_version_number => p_object_version_number);
3150: --
3151: IF (l_api_updating

Line 3152: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)

3148: (p_plan_id => p_plan_id
3149: ,p_object_version_number => p_object_version_number);
3150: --
3151: IF (l_api_updating
3152: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)
3153: = nvl(p_notify_population_flag, hr_api.g_varchar2))
3154: THEN
3155: RETURN;
3156: END IF;

Line 3238: l_api_updating := per_pmp_shd.api_updating

3234: -- Only proceed with validation if :
3235: -- a) The current g_old_rec is current and
3236: -- b) The date values have changed
3237: --
3238: l_api_updating := per_pmp_shd.api_updating
3239: (p_plan_id => p_plan_id
3240: ,p_object_version_number => p_object_version_number);
3241: --
3242: IF (l_api_updating

Line 3243: AND nvl(per_pmp_shd.g_old_rec.automatic_allocation_flag, hr_api.g_varchar2)

3239: (p_plan_id => p_plan_id
3240: ,p_object_version_number => p_object_version_number);
3241: --
3242: IF (l_api_updating
3243: AND nvl(per_pmp_shd.g_old_rec.automatic_allocation_flag, hr_api.g_varchar2)
3244: = nvl(p_automatic_allocation_flag, hr_api.g_varchar2))
3245: THEN
3246: RETURN;
3247: END IF;

Line 3329: l_api_updating := per_pmp_shd.api_updating

3325: -- Only proceed with validation if :
3326: -- a) The current g_old_rec is current and
3327: -- b) The date values have changed
3328: --
3329: l_api_updating := per_pmp_shd.api_updating
3330: (p_plan_id => p_plan_id
3331: ,p_object_version_number => p_object_version_number);
3332: --
3333: IF (l_api_updating

Line 3334: AND nvl(per_pmp_shd.g_old_rec.copy_past_objectives_flag, hr_api.g_varchar2)

3330: (p_plan_id => p_plan_id
3331: ,p_object_version_number => p_object_version_number);
3332: --
3333: IF (l_api_updating
3334: AND nvl(per_pmp_shd.g_old_rec.copy_past_objectives_flag, hr_api.g_varchar2)
3335: = nvl(p_copy_past_objectives_flag, hr_api.g_varchar2))
3336: THEN
3337: RETURN;
3338: END IF;

Line 3420: l_api_updating := per_pmp_shd.api_updating

3416: -- Only proceed with validation if :
3417: -- a) The current g_old_rec is current and
3418: -- b) The date values have changed
3419: --
3420: l_api_updating := per_pmp_shd.api_updating
3421: (p_plan_id => p_plan_id
3422: ,p_object_version_number => p_object_version_number);
3423: --
3424: IF (l_api_updating

Line 3425: AND nvl(per_pmp_shd.g_old_rec.sharing_alignment_task_flag, hr_api.g_varchar2)

3421: (p_plan_id => p_plan_id
3422: ,p_object_version_number => p_object_version_number);
3423: --
3424: IF (l_api_updating
3425: AND nvl(per_pmp_shd.g_old_rec.sharing_alignment_task_flag, hr_api.g_varchar2)
3426: = nvl(p_sharing_alignment_task_flag, hr_api.g_varchar2))
3427: THEN
3428: RETURN;
3429: END IF;

Line 3511: l_api_updating := per_pmp_shd.api_updating

3507: -- Only proceed with validation if :
3508: -- a) The current g_old_rec is current and
3509: -- b) The date values have changed
3510: --
3511: l_api_updating := per_pmp_shd.api_updating
3512: (p_plan_id => p_plan_id
3513: ,p_object_version_number => p_object_version_number);
3514: --
3515: IF (l_api_updating

Line 3516: AND nvl(per_pmp_shd.g_old_rec.include_appraisals_flag, hr_api.g_varchar2)

3512: (p_plan_id => p_plan_id
3513: ,p_object_version_number => p_object_version_number);
3514: --
3515: IF (l_api_updating
3516: AND nvl(per_pmp_shd.g_old_rec.include_appraisals_flag, hr_api.g_varchar2)
3517: = nvl(p_include_appraisals_flag, hr_api.g_varchar2))
3518: THEN
3519: RETURN;
3520: END IF;

Line 3682: ,p_rec in per_pmp_shd.g_rec_type

3678: -- |---------------------------< insert_validate >----------------------------|
3679: -- ----------------------------------------------------------------------------
3680: Procedure insert_validate
3681: (p_effective_date in date
3682: ,p_rec in per_pmp_shd.g_rec_type
3683: ,p_duplicate_name_warning out nocopy boolean
3684: ,p_no_life_events_warning out nocopy boolean
3685: ) is
3686: --

Line 4093: ,p_rec in per_pmp_shd.g_rec_type

4089: -- |---------------------------< update_validate >----------------------------|
4090: -- ----------------------------------------------------------------------------
4091: Procedure update_validate
4092: (p_effective_date in date
4093: ,p_rec in per_pmp_shd.g_rec_type
4094: ,p_duplicate_name_warning out nocopy boolean
4095: ,p_no_life_events_warning out nocopy boolean
4096: ) is
4097: --

Line 4521: (p_rec in per_pmp_shd.g_rec_type

4517: -- ----------------------------------------------------------------------------
4518: -- |---------------------------< delete_validate >----------------------------|
4519: -- ----------------------------------------------------------------------------
4520: Procedure delete_validate
4521: (p_rec in per_pmp_shd.g_rec_type
4522: ) is
4523: --
4524: l_proc varchar2(72) := g_package||'delete_validate';
4525: --