APPS.PER_QH_SUMMARY_UPDATE dependencies on PER_CHK_SHD

Line 126: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

122: or p_chk1_date_due is not null
123: or p_chk1_date_done is not null
124: or p_chk1_notes is not null)) or
125: (l_checklist_item_id is not null and
126: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
127: <> nvl(p_chk1_date_due,hr_api.g_date)
128: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
129: <> nvl(p_chk1_date_done,hr_api.g_date)
130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 128: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

124: or p_chk1_notes is not null)) or
125: (l_checklist_item_id is not null and
126: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
127: <> nvl(p_chk1_date_due,hr_api.g_date)
128: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
129: <> nvl(p_chk1_date_done,hr_api.g_date)
130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
131: <> nvl(p_chk1_status,hr_api.g_varchar2)
132: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

126: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
127: <> nvl(p_chk1_date_due,hr_api.g_date)
128: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
129: <> nvl(p_chk1_date_done,hr_api.g_date)
130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
131: <> nvl(p_chk1_status,hr_api.g_varchar2)
132: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
133: <> nvl(p_chk1_notes,hr_api.g_varchar2))) then
134: --

Line 132: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

128: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
129: <> nvl(p_chk1_date_done,hr_api.g_date)
130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
131: <> nvl(p_chk1_status,hr_api.g_varchar2)
132: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
133: <> nvl(p_chk1_notes,hr_api.g_varchar2))) then
134: --
135: hr_utility.set_location(l_proc, 30);
136: --

Line 164: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

160: or p_chk2_date_due is not null
161: or p_chk2_date_done is not null
162: or p_chk2_notes is not null)) or
163: (l_checklist_item_id is not null and
164: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
165: <> nvl(p_chk2_date_due,hr_api.g_date)
166: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
167: <> nvl(p_chk2_date_done,hr_api.g_date)
168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 166: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

162: or p_chk2_notes is not null)) or
163: (l_checklist_item_id is not null and
164: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
165: <> nvl(p_chk2_date_due,hr_api.g_date)
166: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
167: <> nvl(p_chk2_date_done,hr_api.g_date)
168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
169: <> nvl(p_chk2_status,hr_api.g_varchar2)
170: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

164: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
165: <> nvl(p_chk2_date_due,hr_api.g_date)
166: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
167: <> nvl(p_chk2_date_done,hr_api.g_date)
168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
169: <> nvl(p_chk2_status,hr_api.g_varchar2)
170: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
171: <> nvl(p_chk2_notes,hr_api.g_varchar2))) then
172: --

Line 170: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

166: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
167: <> nvl(p_chk2_date_done,hr_api.g_date)
168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
169: <> nvl(p_chk2_status,hr_api.g_varchar2)
170: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
171: <> nvl(p_chk2_notes,hr_api.g_varchar2))) then
172: --
173: hr_utility.set_location(l_proc, 50);
174: --

Line 202: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

198: or p_chk3_date_due is not null
199: or p_chk3_date_done is not null
200: or p_chk3_notes is not null)) or
201: (l_checklist_item_id is not null and
202: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
203: <> nvl(p_chk3_date_due,hr_api.g_date)
204: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
205: <> nvl(p_chk3_date_done,hr_api.g_date)
206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 204: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

200: or p_chk3_notes is not null)) or
201: (l_checklist_item_id is not null and
202: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
203: <> nvl(p_chk3_date_due,hr_api.g_date)
204: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
205: <> nvl(p_chk3_date_done,hr_api.g_date)
206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
207: <> nvl(p_chk3_status,hr_api.g_varchar2)
208: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

202: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
203: <> nvl(p_chk3_date_due,hr_api.g_date)
204: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
205: <> nvl(p_chk3_date_done,hr_api.g_date)
206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
207: <> nvl(p_chk3_status,hr_api.g_varchar2)
208: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
209: <> nvl(p_chk3_notes,hr_api.g_varchar2))) then
210: --

Line 208: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

204: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
205: <> nvl(p_chk3_date_done,hr_api.g_date)
206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
207: <> nvl(p_chk3_status,hr_api.g_varchar2)
208: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
209: <> nvl(p_chk3_notes,hr_api.g_varchar2))) then
210: --
211: hr_utility.set_location(l_proc, 70);
212: --

Line 240: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

236: or p_chk4_date_due is not null
237: or p_chk4_date_done is not null
238: or p_chk4_notes is not null)) or
239: (l_checklist_item_id is not null and
240: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
241: <> nvl(p_chk4_date_due,hr_api.g_date)
242: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
243: <> nvl(p_chk4_date_done,hr_api.g_date)
244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 242: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

238: or p_chk4_notes is not null)) or
239: (l_checklist_item_id is not null and
240: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
241: <> nvl(p_chk4_date_due,hr_api.g_date)
242: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
243: <> nvl(p_chk4_date_done,hr_api.g_date)
244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
245: <> nvl(p_chk4_status,hr_api.g_varchar2)
246: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

240: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
241: <> nvl(p_chk4_date_due,hr_api.g_date)
242: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
243: <> nvl(p_chk4_date_done,hr_api.g_date)
244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
245: <> nvl(p_chk4_status,hr_api.g_varchar2)
246: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
247: <> nvl(p_chk4_notes,hr_api.g_varchar2))) then
248: --

Line 246: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

242: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
243: <> nvl(p_chk4_date_done,hr_api.g_date)
244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
245: <> nvl(p_chk4_status,hr_api.g_varchar2)
246: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
247: <> nvl(p_chk4_notes,hr_api.g_varchar2))) then
248: --
249: hr_utility.set_location(l_proc, 90);
250: --

Line 278: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

274: or p_chk5_date_due is not null
275: or p_chk5_date_done is not null
276: or p_chk5_notes is not null)) or
277: (l_checklist_item_id is not null and
278: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
279: <> nvl(p_chk5_date_due,hr_api.g_date)
280: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
281: <> nvl(p_chk5_date_done,hr_api.g_date)
282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 280: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

276: or p_chk5_notes is not null)) or
277: (l_checklist_item_id is not null and
278: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
279: <> nvl(p_chk5_date_due,hr_api.g_date)
280: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
281: <> nvl(p_chk5_date_done,hr_api.g_date)
282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
283: <> nvl(p_chk5_status,hr_api.g_varchar2)
284: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

278: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
279: <> nvl(p_chk5_date_due,hr_api.g_date)
280: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
281: <> nvl(p_chk5_date_done,hr_api.g_date)
282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
283: <> nvl(p_chk5_status,hr_api.g_varchar2)
284: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
285: <> nvl(p_chk5_notes,hr_api.g_varchar2))) then
286: --

Line 284: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

280: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
281: <> nvl(p_chk5_date_done,hr_api.g_date)
282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
283: <> nvl(p_chk5_status,hr_api.g_varchar2)
284: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
285: <> nvl(p_chk5_notes,hr_api.g_varchar2))) then
286: --
287: hr_utility.set_location(l_proc, 110);
288: --

Line 316: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

312: or p_chk6_date_due is not null
313: or p_chk6_date_done is not null
314: or p_chk6_notes is not null)) or
315: (l_checklist_item_id is not null and
316: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
317: <> nvl(p_chk6_date_due,hr_api.g_date)
318: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
319: <> nvl(p_chk6_date_done,hr_api.g_date)
320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 318: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

314: or p_chk6_notes is not null)) or
315: (l_checklist_item_id is not null and
316: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
317: <> nvl(p_chk6_date_due,hr_api.g_date)
318: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
319: <> nvl(p_chk6_date_done,hr_api.g_date)
320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
321: <> nvl(p_chk6_status,hr_api.g_varchar2)
322: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

316: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
317: <> nvl(p_chk6_date_due,hr_api.g_date)
318: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
319: <> nvl(p_chk6_date_done,hr_api.g_date)
320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
321: <> nvl(p_chk6_status,hr_api.g_varchar2)
322: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
323: <> nvl(p_chk6_notes,hr_api.g_varchar2))) then
324: --

Line 322: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

318: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
319: <> nvl(p_chk6_date_done,hr_api.g_date)
320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
321: <> nvl(p_chk6_status,hr_api.g_varchar2)
322: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
323: <> nvl(p_chk6_notes,hr_api.g_varchar2))) then
324: --
325: hr_utility.set_location(l_proc, 130);
326: --

Line 354: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

350: or p_chk7_date_due is not null
351: or p_chk7_date_done is not null
352: or p_chk7_notes is not null)) or
353: (l_checklist_item_id is not null and
354: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
355: <> nvl(p_chk7_date_due,hr_api.g_date)
356: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
357: <> nvl(p_chk7_date_done,hr_api.g_date)
358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 356: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

352: or p_chk7_notes is not null)) or
353: (l_checklist_item_id is not null and
354: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
355: <> nvl(p_chk7_date_due,hr_api.g_date)
356: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
357: <> nvl(p_chk7_date_done,hr_api.g_date)
358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
359: <> nvl(p_chk7_status,hr_api.g_varchar2)
360: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

354: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
355: <> nvl(p_chk7_date_due,hr_api.g_date)
356: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
357: <> nvl(p_chk7_date_done,hr_api.g_date)
358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
359: <> nvl(p_chk7_status,hr_api.g_varchar2)
360: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
361: <> nvl(p_chk7_notes,hr_api.g_varchar2))) then
362: --

Line 360: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

356: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
357: <> nvl(p_chk7_date_done,hr_api.g_date)
358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
359: <> nvl(p_chk7_status,hr_api.g_varchar2)
360: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
361: <> nvl(p_chk7_notes,hr_api.g_varchar2))) then
362: --
363: hr_utility.set_location(l_proc, 150);
364: --

Line 392: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

388: or p_chk8_date_due is not null
389: or p_chk8_date_done is not null
390: or p_chk8_notes is not null)) or
391: (l_checklist_item_id is not null and
392: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
393: <> nvl(p_chk8_date_due,hr_api.g_date)
394: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
395: <> nvl(p_chk8_date_done,hr_api.g_date)
396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 394: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

390: or p_chk8_notes is not null)) or
391: (l_checklist_item_id is not null and
392: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
393: <> nvl(p_chk8_date_due,hr_api.g_date)
394: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
395: <> nvl(p_chk8_date_done,hr_api.g_date)
396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
397: <> nvl(p_chk8_status,hr_api.g_varchar2)
398: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

392: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
393: <> nvl(p_chk8_date_due,hr_api.g_date)
394: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
395: <> nvl(p_chk8_date_done,hr_api.g_date)
396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
397: <> nvl(p_chk8_status,hr_api.g_varchar2)
398: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
399: <> nvl(p_chk8_notes,hr_api.g_varchar2))) then
400: --

Line 398: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

394: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
395: <> nvl(p_chk8_date_done,hr_api.g_date)
396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
397: <> nvl(p_chk8_status,hr_api.g_varchar2)
398: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
399: <> nvl(p_chk8_notes,hr_api.g_varchar2))) then
400: --
401: hr_utility.set_location(l_proc, 170);
402: --

Line 430: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

426: or p_chk9_date_due is not null
427: or p_chk9_date_done is not null
428: or p_chk9_notes is not null)) or
429: (l_checklist_item_id is not null and
430: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
431: <> nvl(p_chk9_date_due,hr_api.g_date)
432: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
433: <> nvl(p_chk9_date_done,hr_api.g_date)
434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 432: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

428: or p_chk9_notes is not null)) or
429: (l_checklist_item_id is not null and
430: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
431: <> nvl(p_chk9_date_due,hr_api.g_date)
432: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
433: <> nvl(p_chk9_date_done,hr_api.g_date)
434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
435: <> nvl(p_chk9_status,hr_api.g_varchar2)
436: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

430: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
431: <> nvl(p_chk9_date_due,hr_api.g_date)
432: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
433: <> nvl(p_chk9_date_done,hr_api.g_date)
434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
435: <> nvl(p_chk9_status,hr_api.g_varchar2)
436: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
437: <> nvl(p_chk9_notes,hr_api.g_varchar2))) then
438: --

Line 436: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

432: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
433: <> nvl(p_chk9_date_done,hr_api.g_date)
434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
435: <> nvl(p_chk9_status,hr_api.g_varchar2)
436: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
437: <> nvl(p_chk9_notes,hr_api.g_varchar2))) then
438: --
439: hr_utility.set_location(l_proc, 190);
440: --

Line 468: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

464: or p_chk10_date_due is not null
465: or p_chk10_date_done is not null
466: or p_chk10_notes is not null)) or
467: (l_checklist_item_id is not null and
468: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
469: <> nvl(p_chk10_date_due,hr_api.g_date)
470: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
471: <> nvl(p_chk10_date_done,hr_api.g_date)
472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 470: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

466: or p_chk10_notes is not null)) or
467: (l_checklist_item_id is not null and
468: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
469: <> nvl(p_chk10_date_due,hr_api.g_date)
470: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
471: <> nvl(p_chk10_date_done,hr_api.g_date)
472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
473: <> nvl(p_chk10_status,hr_api.g_varchar2)
474: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

468: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
469: <> nvl(p_chk10_date_due,hr_api.g_date)
470: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
471: <> nvl(p_chk10_date_done,hr_api.g_date)
472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
473: <> nvl(p_chk10_status,hr_api.g_varchar2)
474: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
475: <> nvl(p_chk10_notes,hr_api.g_varchar2))) then
476: --

Line 474: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

470: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
471: <> nvl(p_chk10_date_done,hr_api.g_date)
472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
473: <> nvl(p_chk10_status,hr_api.g_varchar2)
474: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
475: <> nvl(p_chk10_notes,hr_api.g_varchar2))) then
476: --
477: hr_utility.set_location(l_proc, 210);
478: --

Line 526: per_chk_shd.lck

522: --
523: hr_utility.set_location('Entering:'|| l_proc, 10);
524: --
525: if p_chk1_checklist_item_id is not null then
526: per_chk_shd.lck
527: (p_checklist_item_id => p_chk1_checklist_item_id
528: ,p_object_version_number => p_chk1_object_version_number
529: );
530: end if;

Line 535: per_chk_shd.lck

531: --
532: hr_utility.set_location(l_proc, 20);
533: --
534: if p_chk2_checklist_item_id is not null then
535: per_chk_shd.lck
536: (p_checklist_item_id => p_chk2_checklist_item_id
537: ,p_object_version_number => p_chk2_object_version_number
538: );
539: end if;

Line 544: per_chk_shd.lck

540: --
541: hr_utility.set_location(l_proc, 30);
542: --
543: if p_chk3_checklist_item_id is not null then
544: per_chk_shd.lck
545: (p_checklist_item_id => p_chk3_checklist_item_id
546: ,p_object_version_number => p_chk3_object_version_number
547: );
548: end if;

Line 553: per_chk_shd.lck

549: --
550: hr_utility.set_location(l_proc, 40);
551: --
552: if p_chk4_checklist_item_id is not null then
553: per_chk_shd.lck
554: (p_checklist_item_id => p_chk4_checklist_item_id
555: ,p_object_version_number => p_chk4_object_version_number
556: );
557: end if;

Line 562: per_chk_shd.lck

558: --
559: hr_utility.set_location(l_proc, 50);
560: --
561: if p_chk5_checklist_item_id is not null then
562: per_chk_shd.lck
563: (p_checklist_item_id => p_chk5_checklist_item_id
564: ,p_object_version_number => p_chk5_object_version_number
565: );
566: end if;

Line 571: per_chk_shd.lck

567: --
568: hr_utility.set_location(l_proc, 60);
569: --
570: if p_chk6_checklist_item_id is not null then
571: per_chk_shd.lck
572: (p_checklist_item_id => p_chk6_checklist_item_id
573: ,p_object_version_number => p_chk6_object_version_number
574: );
575: end if;

Line 580: per_chk_shd.lck

576: --
577: hr_utility.set_location(l_proc, 70);
578: --
579: if p_chk7_checklist_item_id is not null then
580: per_chk_shd.lck
581: (p_checklist_item_id => p_chk7_checklist_item_id
582: ,p_object_version_number => p_chk7_object_version_number
583: );
584: end if;

Line 589: per_chk_shd.lck

585: --
586: hr_utility.set_location(l_proc, 80);
587: --
588: if p_chk8_checklist_item_id is not null then
589: per_chk_shd.lck
590: (p_checklist_item_id => p_chk8_checklist_item_id
591: ,p_object_version_number => p_chk8_object_version_number
592: );
593: end if;

Line 598: per_chk_shd.lck

594: --
595: hr_utility.set_location(l_proc, 90);
596: --
597: if p_chk9_checklist_item_id is not null then
598: per_chk_shd.lck
599: (p_checklist_item_id => p_chk9_checklist_item_id
600: ,p_object_version_number => p_chk9_object_version_number
601: );
602: end if;

Line 607: per_chk_shd.lck

603: --
604: hr_utility.set_location(l_proc, 100);
605: --
606: if p_chk10_checklist_item_id is not null then
607: per_chk_shd.lck
608: (p_checklist_item_id => p_chk10_checklist_item_id
609: ,p_object_version_number => p_chk10_object_version_number
610: );
611: end if;