eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_CHK_SHD

Line 6434: per_chk_shd.lck

6430: l_checklist_item_id:=p_chk1_checklist_item_id;
6431: l_chk_object_version_number:= p_chk1_object_version_number;
6432: --
6433: IF l_checklist_item_id IS NOT NULL THEN
6434: per_chk_shd.lck
6435: (p_checklist_item_id => l_checklist_item_id
6436: ,p_object_version_number => l_chk_object_version_number);
6437: END IF;
6438: --

Line 6446: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

6442: OR p_chk1_date_due IS NOT NULL
6443: OR p_chk1_date_done IS NOT NULL
6444: OR p_chk1_notes IS NOT NULL)) OR
6445: (l_checklist_item_id IS NOT NULL AND
6446: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6447: <> NVL(p_chk1_status,hr_api.g_varchar2)
6448: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6449: <> NVL(p_chk1_date_due,hr_api.g_date)
6450: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

Line 6448: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

6444: OR p_chk1_notes IS NOT NULL)) OR
6445: (l_checklist_item_id IS NOT NULL AND
6446: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6447: <> NVL(p_chk1_status,hr_api.g_varchar2)
6448: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6449: <> NVL(p_chk1_date_due,hr_api.g_date)
6450: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6451: <> NVL(p_chk1_date_done,hr_api.g_date)
6452: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 6450: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

6446: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6447: <> NVL(p_chk1_status,hr_api.g_varchar2)
6448: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6449: <> NVL(p_chk1_date_due,hr_api.g_date)
6450: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6451: <> NVL(p_chk1_date_done,hr_api.g_date)
6452: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6453: <> NVL(p_chk1_notes,hr_api.g_varchar2))) THEN
6454: --

Line 6452: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

6448: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6449: <> NVL(p_chk1_date_due,hr_api.g_date)
6450: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6451: <> NVL(p_chk1_date_done,hr_api.g_date)
6452: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6453: <> NVL(p_chk1_notes,hr_api.g_varchar2))) THEN
6454: --
6455: per_checklist_items_api.cre_or_upd_checklist_items
6456: (p_effective_date => p_effective_date

Line 6476: per_chk_shd.lck

6472: l_checklist_item_id:=p_chk2_checklist_item_id;
6473: l_chk_object_version_number:= p_chk2_object_version_number;
6474: --
6475: IF l_checklist_item_id IS NOT NULL THEN
6476: per_chk_shd.lck
6477: (p_checklist_item_id => l_checklist_item_id
6478: ,p_object_version_number => l_chk_object_version_number);
6479: END IF;
6480: --

Line 6488: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

6484: OR p_chk2_date_due IS NOT NULL
6485: OR p_chk2_date_done IS NOT NULL
6486: OR p_chk2_notes IS NOT NULL)) OR
6487: (l_checklist_item_id IS NOT NULL AND
6488: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6489: <> NVL(p_chk2_status,hr_api.g_varchar2)
6490: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6491: <> NVL(p_chk2_date_due,hr_api.g_date)
6492: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

Line 6490: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

6486: OR p_chk2_notes IS NOT NULL)) OR
6487: (l_checklist_item_id IS NOT NULL AND
6488: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6489: <> NVL(p_chk2_status,hr_api.g_varchar2)
6490: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6491: <> NVL(p_chk2_date_due,hr_api.g_date)
6492: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6493: <> NVL(p_chk2_date_done,hr_api.g_date)
6494: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 6492: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

6488: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6489: <> NVL(p_chk2_status,hr_api.g_varchar2)
6490: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6491: <> NVL(p_chk2_date_due,hr_api.g_date)
6492: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6493: <> NVL(p_chk2_date_done,hr_api.g_date)
6494: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6495: <> NVL(p_chk2_notes,hr_api.g_varchar2))) THEN
6496: --

Line 6494: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

6490: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6491: <> NVL(p_chk2_date_due,hr_api.g_date)
6492: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6493: <> NVL(p_chk2_date_done,hr_api.g_date)
6494: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6495: <> NVL(p_chk2_notes,hr_api.g_varchar2))) THEN
6496: --
6497: per_checklist_items_api.cre_or_upd_checklist_items
6498: (p_effective_date => p_effective_date

Line 6518: per_chk_shd.lck

6514: l_checklist_item_id:=p_chk3_checklist_item_id;
6515: l_chk_object_version_number:= p_chk3_object_version_number;
6516: --
6517: IF l_checklist_item_id IS NOT NULL THEN
6518: per_chk_shd.lck
6519: (p_checklist_item_id => l_checklist_item_id
6520: ,p_object_version_number => l_chk_object_version_number);
6521: END IF;
6522: --

Line 6530: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

6526: OR p_chk3_date_due IS NOT NULL
6527: OR p_chk3_date_done IS NOT NULL
6528: OR p_chk3_notes IS NOT NULL)) OR
6529: (l_checklist_item_id IS NOT NULL AND
6530: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6531: <> NVL(p_chk3_status,hr_api.g_varchar2)
6532: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6533: <> NVL(p_chk3_date_due,hr_api.g_date)
6534: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

Line 6532: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

6528: OR p_chk3_notes IS NOT NULL)) OR
6529: (l_checklist_item_id IS NOT NULL AND
6530: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6531: <> NVL(p_chk3_status,hr_api.g_varchar2)
6532: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6533: <> NVL(p_chk3_date_due,hr_api.g_date)
6534: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6535: <> NVL(p_chk3_date_done,hr_api.g_date)
6536: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 6534: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

6530: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6531: <> NVL(p_chk3_status,hr_api.g_varchar2)
6532: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6533: <> NVL(p_chk3_date_due,hr_api.g_date)
6534: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6535: <> NVL(p_chk3_date_done,hr_api.g_date)
6536: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6537: <> NVL(p_chk3_notes,hr_api.g_varchar2))) THEN
6538: --

Line 6536: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

6532: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6533: <> NVL(p_chk3_date_due,hr_api.g_date)
6534: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6535: <> NVL(p_chk3_date_done,hr_api.g_date)
6536: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6537: <> NVL(p_chk3_notes,hr_api.g_varchar2))) THEN
6538: --
6539: per_checklist_items_api.cre_or_upd_checklist_items
6540: (p_effective_date => p_effective_date

Line 6560: per_chk_shd.lck

6556: l_checklist_item_id:=p_chk4_checklist_item_id;
6557: l_chk_object_version_number:= p_chk4_object_version_number;
6558: --
6559: IF l_checklist_item_id IS NOT NULL THEN
6560: per_chk_shd.lck
6561: (p_checklist_item_id => l_checklist_item_id
6562: ,p_object_version_number => l_chk_object_version_number);
6563: END IF;
6564: --

Line 6572: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

6568: OR p_chk4_date_due IS NOT NULL
6569: OR p_chk4_date_done IS NOT NULL
6570: OR p_chk4_notes IS NOT NULL)) OR
6571: (l_checklist_item_id IS NOT NULL AND
6572: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6573: <> NVL(p_chk4_status,hr_api.g_varchar2)
6574: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6575: <> NVL(p_chk4_date_due,hr_api.g_date)
6576: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

Line 6574: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

6570: OR p_chk4_notes IS NOT NULL)) OR
6571: (l_checklist_item_id IS NOT NULL AND
6572: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6573: <> NVL(p_chk4_status,hr_api.g_varchar2)
6574: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6575: <> NVL(p_chk4_date_due,hr_api.g_date)
6576: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6577: <> NVL(p_chk4_date_done,hr_api.g_date)
6578: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 6576: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

6572: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6573: <> NVL(p_chk4_status,hr_api.g_varchar2)
6574: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6575: <> NVL(p_chk4_date_due,hr_api.g_date)
6576: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6577: <> NVL(p_chk4_date_done,hr_api.g_date)
6578: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6579: <> NVL(p_chk4_notes,hr_api.g_varchar2))) THEN
6580: --

Line 6578: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

6574: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6575: <> NVL(p_chk4_date_due,hr_api.g_date)
6576: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6577: <> NVL(p_chk4_date_done,hr_api.g_date)
6578: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6579: <> NVL(p_chk4_notes,hr_api.g_varchar2))) THEN
6580: --
6581: per_checklist_items_api.cre_or_upd_checklist_items
6582: (p_effective_date => p_effective_date

Line 6602: per_chk_shd.lck

6598: l_checklist_item_id:=p_chk5_checklist_item_id;
6599: l_chk_object_version_number:= p_chk5_object_version_number;
6600: --
6601: IF l_checklist_item_id IS NOT NULL THEN
6602: per_chk_shd.lck
6603: (p_checklist_item_id => l_checklist_item_id
6604: ,p_object_version_number => l_chk_object_version_number);
6605: END IF;
6606: --

Line 6614: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

6610: OR p_chk5_date_due IS NOT NULL
6611: OR p_chk5_date_done IS NOT NULL
6612: OR p_chk5_notes IS NOT NULL)) OR
6613: (l_checklist_item_id IS NOT NULL AND
6614: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6615: <> NVL(p_chk5_status,hr_api.g_varchar2)
6616: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6617: <> NVL(p_chk5_date_due,hr_api.g_date)
6618: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

Line 6616: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

6612: OR p_chk5_notes IS NOT NULL)) OR
6613: (l_checklist_item_id IS NOT NULL AND
6614: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6615: <> NVL(p_chk5_status,hr_api.g_varchar2)
6616: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6617: <> NVL(p_chk5_date_due,hr_api.g_date)
6618: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6619: <> NVL(p_chk5_date_done,hr_api.g_date)
6620: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 6618: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

6614: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6615: <> NVL(p_chk5_status,hr_api.g_varchar2)
6616: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6617: <> NVL(p_chk5_date_due,hr_api.g_date)
6618: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6619: <> NVL(p_chk5_date_done,hr_api.g_date)
6620: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6621: <> NVL(p_chk5_notes,hr_api.g_varchar2))) THEN
6622: --

Line 6620: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

6616: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6617: <> NVL(p_chk5_date_due,hr_api.g_date)
6618: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6619: <> NVL(p_chk5_date_done,hr_api.g_date)
6620: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6621: <> NVL(p_chk5_notes,hr_api.g_varchar2))) THEN
6622: --
6623: per_checklist_items_api.cre_or_upd_checklist_items
6624: (p_effective_date => p_effective_date

Line 6644: per_chk_shd.lck

6640: l_checklist_item_id:=p_chk6_checklist_item_id;
6641: l_chk_object_version_number:= p_chk6_object_version_number;
6642: --
6643: IF l_checklist_item_id IS NOT NULL THEN
6644: per_chk_shd.lck
6645: (p_checklist_item_id => l_checklist_item_id
6646: ,p_object_version_number => l_chk_object_version_number);
6647: END IF;
6648: --

Line 6656: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

6652: OR p_chk6_date_due IS NOT NULL
6653: OR p_chk6_date_done IS NOT NULL
6654: OR p_chk6_notes IS NOT NULL)) OR
6655: (l_checklist_item_id IS NOT NULL AND
6656: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6657: <> NVL(p_chk6_status,hr_api.g_varchar2)
6658: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6659: <> NVL(p_chk6_date_due,hr_api.g_date)
6660: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

Line 6658: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

6654: OR p_chk6_notes IS NOT NULL)) OR
6655: (l_checklist_item_id IS NOT NULL AND
6656: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6657: <> NVL(p_chk6_status,hr_api.g_varchar2)
6658: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6659: <> NVL(p_chk6_date_due,hr_api.g_date)
6660: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6661: <> NVL(p_chk6_date_done,hr_api.g_date)
6662: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 6660: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

6656: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6657: <> NVL(p_chk6_status,hr_api.g_varchar2)
6658: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6659: <> NVL(p_chk6_date_due,hr_api.g_date)
6660: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6661: <> NVL(p_chk6_date_done,hr_api.g_date)
6662: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6663: <> NVL(p_chk6_notes,hr_api.g_varchar2))) THEN
6664: --

Line 6662: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

6658: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6659: <> NVL(p_chk6_date_due,hr_api.g_date)
6660: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6661: <> NVL(p_chk6_date_done,hr_api.g_date)
6662: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6663: <> NVL(p_chk6_notes,hr_api.g_varchar2))) THEN
6664: --
6665: per_checklist_items_api.cre_or_upd_checklist_items
6666: (p_effective_date => p_effective_date

Line 6686: per_chk_shd.lck

6682: l_checklist_item_id:=p_chk7_checklist_item_id;
6683: l_chk_object_version_number:= p_chk7_object_version_number;
6684: --
6685: IF l_checklist_item_id IS NOT NULL THEN
6686: per_chk_shd.lck
6687: (p_checklist_item_id => l_checklist_item_id
6688: ,p_object_version_number => l_chk_object_version_number);
6689: END IF;
6690: --

Line 6698: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

6694: OR p_chk7_date_due IS NOT NULL
6695: OR p_chk7_date_done IS NOT NULL
6696: OR p_chk7_notes IS NOT NULL)) OR
6697: (l_checklist_item_id IS NOT NULL AND
6698: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6699: <> NVL(p_chk7_status,hr_api.g_varchar2)
6700: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6701: <> NVL(p_chk7_date_due,hr_api.g_date)
6702: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

Line 6700: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

6696: OR p_chk7_notes IS NOT NULL)) OR
6697: (l_checklist_item_id IS NOT NULL AND
6698: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6699: <> NVL(p_chk7_status,hr_api.g_varchar2)
6700: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6701: <> NVL(p_chk7_date_due,hr_api.g_date)
6702: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6703: <> NVL(p_chk7_date_done,hr_api.g_date)
6704: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 6702: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

6698: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6699: <> NVL(p_chk7_status,hr_api.g_varchar2)
6700: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6701: <> NVL(p_chk7_date_due,hr_api.g_date)
6702: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6703: <> NVL(p_chk7_date_done,hr_api.g_date)
6704: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6705: <> NVL(p_chk7_notes,hr_api.g_varchar2))) THEN
6706: --

Line 6704: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

6700: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6701: <> NVL(p_chk7_date_due,hr_api.g_date)
6702: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6703: <> NVL(p_chk7_date_done,hr_api.g_date)
6704: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6705: <> NVL(p_chk7_notes,hr_api.g_varchar2))) THEN
6706: --
6707: per_checklist_items_api.cre_or_upd_checklist_items
6708: (p_effective_date => p_effective_date

Line 6728: per_chk_shd.lck

6724: l_checklist_item_id:=p_chk8_checklist_item_id;
6725: l_chk_object_version_number:= p_chk8_object_version_number;
6726: --
6727: IF l_checklist_item_id IS NOT NULL THEN
6728: per_chk_shd.lck
6729: (p_checklist_item_id => l_checklist_item_id
6730: ,p_object_version_number => l_chk_object_version_number);
6731: END IF;
6732: --

Line 6740: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

6736: OR p_chk8_date_due IS NOT NULL
6737: OR p_chk8_date_done IS NOT NULL
6738: OR p_chk8_notes IS NOT NULL)) OR
6739: (l_checklist_item_id IS NOT NULL AND
6740: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6741: <> NVL(p_chk8_status,hr_api.g_varchar2)
6742: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6743: <> NVL(p_chk8_date_due,hr_api.g_date)
6744: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

Line 6742: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

6738: OR p_chk8_notes IS NOT NULL)) OR
6739: (l_checklist_item_id IS NOT NULL AND
6740: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6741: <> NVL(p_chk8_status,hr_api.g_varchar2)
6742: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6743: <> NVL(p_chk8_date_due,hr_api.g_date)
6744: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6745: <> NVL(p_chk8_date_done,hr_api.g_date)
6746: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 6744: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

6740: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6741: <> NVL(p_chk8_status,hr_api.g_varchar2)
6742: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6743: <> NVL(p_chk8_date_due,hr_api.g_date)
6744: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6745: <> NVL(p_chk8_date_done,hr_api.g_date)
6746: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6747: <> NVL(p_chk8_notes,hr_api.g_varchar2))) THEN
6748: --

Line 6746: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

6742: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6743: <> NVL(p_chk8_date_due,hr_api.g_date)
6744: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6745: <> NVL(p_chk8_date_done,hr_api.g_date)
6746: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6747: <> NVL(p_chk8_notes,hr_api.g_varchar2))) THEN
6748: --
6749: per_checklist_items_api.cre_or_upd_checklist_items
6750: (p_effective_date => p_effective_date

Line 6770: per_chk_shd.lck

6766: l_checklist_item_id:=p_chk9_checklist_item_id;
6767: l_chk_object_version_number:= p_chk9_object_version_number;
6768: --
6769: IF l_checklist_item_id IS NOT NULL THEN
6770: per_chk_shd.lck
6771: (p_checklist_item_id => l_checklist_item_id
6772: ,p_object_version_number => l_chk_object_version_number);
6773: END IF;
6774: --

Line 6782: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

6778: OR p_chk9_date_due IS NOT NULL
6779: OR p_chk9_date_done IS NOT NULL
6780: OR p_chk9_notes IS NOT NULL)) OR
6781: (l_checklist_item_id IS NOT NULL AND
6782: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6783: <> NVL(p_chk9_status,hr_api.g_varchar2)
6784: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6785: <> NVL(p_chk9_date_due,hr_api.g_date)
6786: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

Line 6784: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

6780: OR p_chk9_notes IS NOT NULL)) OR
6781: (l_checklist_item_id IS NOT NULL AND
6782: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6783: <> NVL(p_chk9_status,hr_api.g_varchar2)
6784: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6785: <> NVL(p_chk9_date_due,hr_api.g_date)
6786: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6787: <> NVL(p_chk9_date_done,hr_api.g_date)
6788: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 6786: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

6782: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6783: <> NVL(p_chk9_status,hr_api.g_varchar2)
6784: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6785: <> NVL(p_chk9_date_due,hr_api.g_date)
6786: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6787: <> NVL(p_chk9_date_done,hr_api.g_date)
6788: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6789: <> NVL(p_chk9_notes,hr_api.g_varchar2))) THEN
6790: --

Line 6788: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

6784: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6785: <> NVL(p_chk9_date_due,hr_api.g_date)
6786: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6787: <> NVL(p_chk9_date_done,hr_api.g_date)
6788: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6789: <> NVL(p_chk9_notes,hr_api.g_varchar2))) THEN
6790: --
6791: per_checklist_items_api.cre_or_upd_checklist_items
6792: (p_effective_date => p_effective_date

Line 6812: per_chk_shd.lck

6808: l_checklist_item_id:=p_chk10_checklist_item_id;
6809: l_chk_object_version_number:= p_chk10_object_version_number;
6810: --
6811: IF l_checklist_item_id IS NOT NULL THEN
6812: per_chk_shd.lck
6813: (p_checklist_item_id => l_checklist_item_id
6814: ,p_object_version_number => l_chk_object_version_number);
6815: END IF;
6816: --

Line 6824: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

6820: OR p_chk10_date_due IS NOT NULL
6821: OR p_chk10_date_done IS NOT NULL
6822: OR p_chk10_notes IS NOT NULL)) OR
6823: (l_checklist_item_id IS NOT NULL AND
6824: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6825: <> NVL(p_chk10_status,hr_api.g_varchar2)
6826: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6827: <> NVL(p_chk10_date_due,hr_api.g_date)
6828: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

Line 6826: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

6822: OR p_chk10_notes IS NOT NULL)) OR
6823: (l_checklist_item_id IS NOT NULL AND
6824: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6825: <> NVL(p_chk10_status,hr_api.g_varchar2)
6826: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6827: <> NVL(p_chk10_date_due,hr_api.g_date)
6828: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6829: <> NVL(p_chk10_date_done,hr_api.g_date)
6830: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 6828: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

6824: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6825: <> NVL(p_chk10_status,hr_api.g_varchar2)
6826: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6827: <> NVL(p_chk10_date_due,hr_api.g_date)
6828: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6829: <> NVL(p_chk10_date_done,hr_api.g_date)
6830: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6831: <> NVL(p_chk10_notes,hr_api.g_varchar2))) THEN
6832: --

Line 6830: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

6826: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6827: <> NVL(p_chk10_date_due,hr_api.g_date)
6828: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6829: <> NVL(p_chk10_date_done,hr_api.g_date)
6830: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6831: <> NVL(p_chk10_notes,hr_api.g_varchar2))) THEN
6832: --
6833: per_checklist_items_api.cre_or_upd_checklist_items
6834: (p_effective_date => p_effective_date

Line 7283: per_chk_shd.lck

7279: --
7280: IF p_chk1_checklist_item_id IS NOT NULL THEN
7281: hr_utility.set_location(l_proc, 120);
7282: --
7283: per_chk_shd.lck
7284: (p_checklist_item_id => p_chk1_checklist_item_id
7285: ,p_object_version_number => p_chk1_object_version_number);
7286: END IF;
7287: --

Line 7291: per_chk_shd.lck

7287: --
7288: IF p_chk2_checklist_item_id IS NOT NULL THEN
7289: hr_utility.set_location(l_proc, 130);
7290: --
7291: per_chk_shd.lck
7292: (p_checklist_item_id => p_chk2_checklist_item_id
7293: ,p_object_version_number => p_chk2_object_version_number);
7294: END IF;
7295: --

Line 7299: per_chk_shd.lck

7295: --
7296: IF p_chk3_checklist_item_id IS NOT NULL THEN
7297: hr_utility.set_location(l_proc, 140);
7298: --
7299: per_chk_shd.lck
7300: (p_checklist_item_id => p_chk3_checklist_item_id
7301: ,p_object_version_number => p_chk3_object_version_number);
7302: END IF;
7303: --

Line 7307: per_chk_shd.lck

7303: --
7304: IF p_chk4_checklist_item_id IS NOT NULL THEN
7305: hr_utility.set_location(l_proc, 150);
7306: --
7307: per_chk_shd.lck
7308: (p_checklist_item_id => p_chk4_checklist_item_id
7309: ,p_object_version_number => p_chk4_object_version_number);
7310: END IF;
7311: --

Line 7315: per_chk_shd.lck

7311: --
7312: IF p_chk5_checklist_item_id IS NOT NULL THEN
7313: hr_utility.set_location(l_proc, 160);
7314: --
7315: per_chk_shd.lck
7316: (p_checklist_item_id => p_chk5_checklist_item_id
7317: ,p_object_version_number => p_chk5_object_version_number);
7318: END IF;
7319: --

Line 7323: per_chk_shd.lck

7319: --
7320: IF p_chk6_checklist_item_id IS NOT NULL THEN
7321: hr_utility.set_location(l_proc, 170);
7322: --
7323: per_chk_shd.lck
7324: (p_checklist_item_id => p_chk6_checklist_item_id
7325: ,p_object_version_number => p_chk6_object_version_number);
7326: END IF;
7327: --

Line 7331: per_chk_shd.lck

7327: --
7328: IF p_chk7_checklist_item_id IS NOT NULL THEN
7329: hr_utility.set_location(l_proc, 180);
7330: --
7331: per_chk_shd.lck
7332: (p_checklist_item_id => p_chk7_checklist_item_id
7333: ,p_object_version_number => p_chk7_object_version_number);
7334: END IF;
7335: --

Line 7339: per_chk_shd.lck

7335: --
7336: IF p_chk8_checklist_item_id IS NOT NULL THEN
7337: hr_utility.set_location(l_proc, 190);
7338: --
7339: per_chk_shd.lck
7340: (p_checklist_item_id => p_chk8_checklist_item_id
7341: ,p_object_version_number => p_chk8_object_version_number);
7342: END IF;
7343: --

Line 7347: per_chk_shd.lck

7343: --
7344: IF p_chk9_checklist_item_id IS NOT NULL THEN
7345: hr_utility.set_location(l_proc, 200);
7346: --
7347: per_chk_shd.lck
7348: (p_checklist_item_id => p_chk9_checklist_item_id
7349: ,p_object_version_number => p_chk9_object_version_number);
7350: END IF;
7351: --

Line 7355: per_chk_shd.lck

7351: --
7352: IF p_chk10_checklist_item_id IS NOT NULL THEN
7353: hr_utility.set_location(l_proc, 210);
7354: --
7355: per_chk_shd.lck
7356: (p_checklist_item_id => p_chk10_checklist_item_id
7357: ,p_object_version_number => p_chk10_object_version_number);
7358: END IF;
7359: --