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 6394: per_chk_shd.lck

6390: l_checklist_item_id:=p_chk1_checklist_item_id;
6391: l_chk_object_version_number:= p_chk1_object_version_number;
6392: --
6393: IF l_checklist_item_id IS NOT NULL THEN
6394: per_chk_shd.lck
6395: (p_checklist_item_id => l_checklist_item_id
6396: ,p_object_version_number => l_chk_object_version_number);
6397: END IF;
6398: --

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

6402: OR p_chk1_date_due IS NOT NULL
6403: OR p_chk1_date_done IS NOT NULL
6404: OR p_chk1_notes IS NOT NULL)) OR
6405: (l_checklist_item_id IS NOT NULL AND
6406: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6407: <> NVL(p_chk1_status,hr_api.g_varchar2)
6408: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6409: <> NVL(p_chk1_date_due,hr_api.g_date)
6410: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

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

6404: OR p_chk1_notes IS NOT NULL)) OR
6405: (l_checklist_item_id IS NOT NULL AND
6406: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6407: <> NVL(p_chk1_status,hr_api.g_varchar2)
6408: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6409: <> NVL(p_chk1_date_due,hr_api.g_date)
6410: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6411: <> NVL(p_chk1_date_done,hr_api.g_date)
6412: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

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

6406: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6407: <> NVL(p_chk1_status,hr_api.g_varchar2)
6408: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6409: <> NVL(p_chk1_date_due,hr_api.g_date)
6410: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6411: <> NVL(p_chk1_date_done,hr_api.g_date)
6412: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6413: <> NVL(p_chk1_notes,hr_api.g_varchar2))) THEN
6414: --

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

6408: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6409: <> NVL(p_chk1_date_due,hr_api.g_date)
6410: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6411: <> NVL(p_chk1_date_done,hr_api.g_date)
6412: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6413: <> NVL(p_chk1_notes,hr_api.g_varchar2))) THEN
6414: --
6415: per_checklist_items_api.cre_or_upd_checklist_items
6416: (p_effective_date => p_effective_date

Line 6436: per_chk_shd.lck

6432: l_checklist_item_id:=p_chk2_checklist_item_id;
6433: l_chk_object_version_number:= p_chk2_object_version_number;
6434: --
6435: IF l_checklist_item_id IS NOT NULL THEN
6436: per_chk_shd.lck
6437: (p_checklist_item_id => l_checklist_item_id
6438: ,p_object_version_number => l_chk_object_version_number);
6439: END IF;
6440: --

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

6444: OR p_chk2_date_due IS NOT NULL
6445: OR p_chk2_date_done IS NOT NULL
6446: OR p_chk2_notes IS NOT NULL)) OR
6447: (l_checklist_item_id IS NOT NULL AND
6448: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6449: <> NVL(p_chk2_status,hr_api.g_varchar2)
6450: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6451: <> NVL(p_chk2_date_due,hr_api.g_date)
6452: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

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

6446: OR p_chk2_notes IS NOT NULL)) OR
6447: (l_checklist_item_id IS NOT NULL AND
6448: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6449: <> NVL(p_chk2_status,hr_api.g_varchar2)
6450: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6451: <> NVL(p_chk2_date_due,hr_api.g_date)
6452: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6453: <> NVL(p_chk2_date_done,hr_api.g_date)
6454: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

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

6448: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6449: <> NVL(p_chk2_status,hr_api.g_varchar2)
6450: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6451: <> NVL(p_chk2_date_due,hr_api.g_date)
6452: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6453: <> NVL(p_chk2_date_done,hr_api.g_date)
6454: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6455: <> NVL(p_chk2_notes,hr_api.g_varchar2))) THEN
6456: --

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

6450: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6451: <> NVL(p_chk2_date_due,hr_api.g_date)
6452: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6453: <> NVL(p_chk2_date_done,hr_api.g_date)
6454: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6455: <> NVL(p_chk2_notes,hr_api.g_varchar2))) THEN
6456: --
6457: per_checklist_items_api.cre_or_upd_checklist_items
6458: (p_effective_date => p_effective_date

Line 6478: per_chk_shd.lck

6474: l_checklist_item_id:=p_chk3_checklist_item_id;
6475: l_chk_object_version_number:= p_chk3_object_version_number;
6476: --
6477: IF l_checklist_item_id IS NOT NULL THEN
6478: per_chk_shd.lck
6479: (p_checklist_item_id => l_checklist_item_id
6480: ,p_object_version_number => l_chk_object_version_number);
6481: END IF;
6482: --

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

6486: OR p_chk3_date_due IS NOT NULL
6487: OR p_chk3_date_done IS NOT NULL
6488: OR p_chk3_notes IS NOT NULL)) OR
6489: (l_checklist_item_id IS NOT NULL AND
6490: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6491: <> NVL(p_chk3_status,hr_api.g_varchar2)
6492: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6493: <> NVL(p_chk3_date_due,hr_api.g_date)
6494: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

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

6488: OR p_chk3_notes IS NOT NULL)) OR
6489: (l_checklist_item_id IS NOT NULL AND
6490: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6491: <> NVL(p_chk3_status,hr_api.g_varchar2)
6492: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6493: <> NVL(p_chk3_date_due,hr_api.g_date)
6494: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6495: <> NVL(p_chk3_date_done,hr_api.g_date)
6496: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

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

6490: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6491: <> NVL(p_chk3_status,hr_api.g_varchar2)
6492: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6493: <> NVL(p_chk3_date_due,hr_api.g_date)
6494: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6495: <> NVL(p_chk3_date_done,hr_api.g_date)
6496: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6497: <> NVL(p_chk3_notes,hr_api.g_varchar2))) THEN
6498: --

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

6492: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6493: <> NVL(p_chk3_date_due,hr_api.g_date)
6494: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6495: <> NVL(p_chk3_date_done,hr_api.g_date)
6496: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6497: <> NVL(p_chk3_notes,hr_api.g_varchar2))) THEN
6498: --
6499: per_checklist_items_api.cre_or_upd_checklist_items
6500: (p_effective_date => p_effective_date

Line 6520: per_chk_shd.lck

6516: l_checklist_item_id:=p_chk4_checklist_item_id;
6517: l_chk_object_version_number:= p_chk4_object_version_number;
6518: --
6519: IF l_checklist_item_id IS NOT NULL THEN
6520: per_chk_shd.lck
6521: (p_checklist_item_id => l_checklist_item_id
6522: ,p_object_version_number => l_chk_object_version_number);
6523: END IF;
6524: --

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

6528: OR p_chk4_date_due IS NOT NULL
6529: OR p_chk4_date_done IS NOT NULL
6530: OR p_chk4_notes IS NOT NULL)) OR
6531: (l_checklist_item_id IS NOT NULL AND
6532: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6533: <> NVL(p_chk4_status,hr_api.g_varchar2)
6534: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6535: <> NVL(p_chk4_date_due,hr_api.g_date)
6536: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

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

6530: OR p_chk4_notes IS NOT NULL)) OR
6531: (l_checklist_item_id IS NOT NULL AND
6532: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6533: <> NVL(p_chk4_status,hr_api.g_varchar2)
6534: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6535: <> NVL(p_chk4_date_due,hr_api.g_date)
6536: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6537: <> NVL(p_chk4_date_done,hr_api.g_date)
6538: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

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

6532: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6533: <> NVL(p_chk4_status,hr_api.g_varchar2)
6534: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6535: <> NVL(p_chk4_date_due,hr_api.g_date)
6536: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6537: <> NVL(p_chk4_date_done,hr_api.g_date)
6538: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6539: <> NVL(p_chk4_notes,hr_api.g_varchar2))) THEN
6540: --

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

6534: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6535: <> NVL(p_chk4_date_due,hr_api.g_date)
6536: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6537: <> NVL(p_chk4_date_done,hr_api.g_date)
6538: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6539: <> NVL(p_chk4_notes,hr_api.g_varchar2))) THEN
6540: --
6541: per_checklist_items_api.cre_or_upd_checklist_items
6542: (p_effective_date => p_effective_date

Line 6562: per_chk_shd.lck

6558: l_checklist_item_id:=p_chk5_checklist_item_id;
6559: l_chk_object_version_number:= p_chk5_object_version_number;
6560: --
6561: IF l_checklist_item_id IS NOT NULL THEN
6562: per_chk_shd.lck
6563: (p_checklist_item_id => l_checklist_item_id
6564: ,p_object_version_number => l_chk_object_version_number);
6565: END IF;
6566: --

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

6570: OR p_chk5_date_due IS NOT NULL
6571: OR p_chk5_date_done IS NOT NULL
6572: OR p_chk5_notes IS NOT NULL)) OR
6573: (l_checklist_item_id IS NOT NULL AND
6574: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6575: <> NVL(p_chk5_status,hr_api.g_varchar2)
6576: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6577: <> NVL(p_chk5_date_due,hr_api.g_date)
6578: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

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

6572: OR p_chk5_notes IS NOT NULL)) OR
6573: (l_checklist_item_id IS NOT NULL AND
6574: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6575: <> NVL(p_chk5_status,hr_api.g_varchar2)
6576: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6577: <> NVL(p_chk5_date_due,hr_api.g_date)
6578: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6579: <> NVL(p_chk5_date_done,hr_api.g_date)
6580: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

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

6574: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6575: <> NVL(p_chk5_status,hr_api.g_varchar2)
6576: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6577: <> NVL(p_chk5_date_due,hr_api.g_date)
6578: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6579: <> NVL(p_chk5_date_done,hr_api.g_date)
6580: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6581: <> NVL(p_chk5_notes,hr_api.g_varchar2))) THEN
6582: --

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

6576: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6577: <> NVL(p_chk5_date_due,hr_api.g_date)
6578: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6579: <> NVL(p_chk5_date_done,hr_api.g_date)
6580: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6581: <> NVL(p_chk5_notes,hr_api.g_varchar2))) THEN
6582: --
6583: per_checklist_items_api.cre_or_upd_checklist_items
6584: (p_effective_date => p_effective_date

Line 6604: per_chk_shd.lck

6600: l_checklist_item_id:=p_chk6_checklist_item_id;
6601: l_chk_object_version_number:= p_chk6_object_version_number;
6602: --
6603: IF l_checklist_item_id IS NOT NULL THEN
6604: per_chk_shd.lck
6605: (p_checklist_item_id => l_checklist_item_id
6606: ,p_object_version_number => l_chk_object_version_number);
6607: END IF;
6608: --

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

6612: OR p_chk6_date_due IS NOT NULL
6613: OR p_chk6_date_done IS NOT NULL
6614: OR p_chk6_notes IS NOT NULL)) OR
6615: (l_checklist_item_id IS NOT NULL AND
6616: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6617: <> NVL(p_chk6_status,hr_api.g_varchar2)
6618: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6619: <> NVL(p_chk6_date_due,hr_api.g_date)
6620: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

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

6614: OR p_chk6_notes IS NOT NULL)) OR
6615: (l_checklist_item_id IS NOT NULL AND
6616: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6617: <> NVL(p_chk6_status,hr_api.g_varchar2)
6618: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6619: <> NVL(p_chk6_date_due,hr_api.g_date)
6620: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6621: <> NVL(p_chk6_date_done,hr_api.g_date)
6622: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

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

6616: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6617: <> NVL(p_chk6_status,hr_api.g_varchar2)
6618: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6619: <> NVL(p_chk6_date_due,hr_api.g_date)
6620: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6621: <> NVL(p_chk6_date_done,hr_api.g_date)
6622: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6623: <> NVL(p_chk6_notes,hr_api.g_varchar2))) THEN
6624: --

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

6618: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6619: <> NVL(p_chk6_date_due,hr_api.g_date)
6620: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6621: <> NVL(p_chk6_date_done,hr_api.g_date)
6622: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6623: <> NVL(p_chk6_notes,hr_api.g_varchar2))) THEN
6624: --
6625: per_checklist_items_api.cre_or_upd_checklist_items
6626: (p_effective_date => p_effective_date

Line 6646: per_chk_shd.lck

6642: l_checklist_item_id:=p_chk7_checklist_item_id;
6643: l_chk_object_version_number:= p_chk7_object_version_number;
6644: --
6645: IF l_checklist_item_id IS NOT NULL THEN
6646: per_chk_shd.lck
6647: (p_checklist_item_id => l_checklist_item_id
6648: ,p_object_version_number => l_chk_object_version_number);
6649: END IF;
6650: --

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

6654: OR p_chk7_date_due IS NOT NULL
6655: OR p_chk7_date_done IS NOT NULL
6656: OR p_chk7_notes IS NOT NULL)) OR
6657: (l_checklist_item_id IS NOT NULL AND
6658: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6659: <> NVL(p_chk7_status,hr_api.g_varchar2)
6660: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6661: <> NVL(p_chk7_date_due,hr_api.g_date)
6662: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

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

6656: OR p_chk7_notes IS NOT NULL)) OR
6657: (l_checklist_item_id IS NOT NULL AND
6658: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6659: <> NVL(p_chk7_status,hr_api.g_varchar2)
6660: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6661: <> NVL(p_chk7_date_due,hr_api.g_date)
6662: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6663: <> NVL(p_chk7_date_done,hr_api.g_date)
6664: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

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

6658: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6659: <> NVL(p_chk7_status,hr_api.g_varchar2)
6660: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6661: <> NVL(p_chk7_date_due,hr_api.g_date)
6662: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6663: <> NVL(p_chk7_date_done,hr_api.g_date)
6664: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6665: <> NVL(p_chk7_notes,hr_api.g_varchar2))) THEN
6666: --

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

6660: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6661: <> NVL(p_chk7_date_due,hr_api.g_date)
6662: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6663: <> NVL(p_chk7_date_done,hr_api.g_date)
6664: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6665: <> NVL(p_chk7_notes,hr_api.g_varchar2))) THEN
6666: --
6667: per_checklist_items_api.cre_or_upd_checklist_items
6668: (p_effective_date => p_effective_date

Line 6688: per_chk_shd.lck

6684: l_checklist_item_id:=p_chk8_checklist_item_id;
6685: l_chk_object_version_number:= p_chk8_object_version_number;
6686: --
6687: IF l_checklist_item_id IS NOT NULL THEN
6688: per_chk_shd.lck
6689: (p_checklist_item_id => l_checklist_item_id
6690: ,p_object_version_number => l_chk_object_version_number);
6691: END IF;
6692: --

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

6696: OR p_chk8_date_due IS NOT NULL
6697: OR p_chk8_date_done IS NOT NULL
6698: OR p_chk8_notes IS NOT NULL)) OR
6699: (l_checklist_item_id IS NOT NULL AND
6700: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6701: <> NVL(p_chk8_status,hr_api.g_varchar2)
6702: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6703: <> NVL(p_chk8_date_due,hr_api.g_date)
6704: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

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

6698: OR p_chk8_notes IS NOT NULL)) OR
6699: (l_checklist_item_id IS NOT NULL AND
6700: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6701: <> NVL(p_chk8_status,hr_api.g_varchar2)
6702: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6703: <> NVL(p_chk8_date_due,hr_api.g_date)
6704: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6705: <> NVL(p_chk8_date_done,hr_api.g_date)
6706: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

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

6700: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6701: <> NVL(p_chk8_status,hr_api.g_varchar2)
6702: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6703: <> NVL(p_chk8_date_due,hr_api.g_date)
6704: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6705: <> NVL(p_chk8_date_done,hr_api.g_date)
6706: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6707: <> NVL(p_chk8_notes,hr_api.g_varchar2))) THEN
6708: --

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

6702: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6703: <> NVL(p_chk8_date_due,hr_api.g_date)
6704: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6705: <> NVL(p_chk8_date_done,hr_api.g_date)
6706: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6707: <> NVL(p_chk8_notes,hr_api.g_varchar2))) THEN
6708: --
6709: per_checklist_items_api.cre_or_upd_checklist_items
6710: (p_effective_date => p_effective_date

Line 6730: per_chk_shd.lck

6726: l_checklist_item_id:=p_chk9_checklist_item_id;
6727: l_chk_object_version_number:= p_chk9_object_version_number;
6728: --
6729: IF l_checklist_item_id IS NOT NULL THEN
6730: per_chk_shd.lck
6731: (p_checklist_item_id => l_checklist_item_id
6732: ,p_object_version_number => l_chk_object_version_number);
6733: END IF;
6734: --

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

6738: OR p_chk9_date_due IS NOT NULL
6739: OR p_chk9_date_done IS NOT NULL
6740: OR p_chk9_notes IS NOT NULL)) OR
6741: (l_checklist_item_id IS NOT NULL AND
6742: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6743: <> NVL(p_chk9_status,hr_api.g_varchar2)
6744: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6745: <> NVL(p_chk9_date_due,hr_api.g_date)
6746: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

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

6740: OR p_chk9_notes IS NOT NULL)) OR
6741: (l_checklist_item_id IS NOT NULL AND
6742: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6743: <> NVL(p_chk9_status,hr_api.g_varchar2)
6744: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6745: <> NVL(p_chk9_date_due,hr_api.g_date)
6746: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6747: <> NVL(p_chk9_date_done,hr_api.g_date)
6748: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

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

6742: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6743: <> NVL(p_chk9_status,hr_api.g_varchar2)
6744: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6745: <> NVL(p_chk9_date_due,hr_api.g_date)
6746: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6747: <> NVL(p_chk9_date_done,hr_api.g_date)
6748: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6749: <> NVL(p_chk9_notes,hr_api.g_varchar2))) THEN
6750: --

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

6744: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6745: <> NVL(p_chk9_date_due,hr_api.g_date)
6746: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6747: <> NVL(p_chk9_date_done,hr_api.g_date)
6748: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6749: <> NVL(p_chk9_notes,hr_api.g_varchar2))) THEN
6750: --
6751: per_checklist_items_api.cre_or_upd_checklist_items
6752: (p_effective_date => p_effective_date

Line 6772: per_chk_shd.lck

6768: l_checklist_item_id:=p_chk10_checklist_item_id;
6769: l_chk_object_version_number:= p_chk10_object_version_number;
6770: --
6771: IF l_checklist_item_id IS NOT NULL THEN
6772: per_chk_shd.lck
6773: (p_checklist_item_id => l_checklist_item_id
6774: ,p_object_version_number => l_chk_object_version_number);
6775: END IF;
6776: --

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

6780: OR p_chk10_date_due IS NOT NULL
6781: OR p_chk10_date_done IS NOT NULL
6782: OR p_chk10_notes IS NOT NULL)) OR
6783: (l_checklist_item_id IS NOT NULL AND
6784: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6785: <> NVL(p_chk10_status,hr_api.g_varchar2)
6786: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6787: <> NVL(p_chk10_date_due,hr_api.g_date)
6788: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

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

6782: OR p_chk10_notes IS NOT NULL)) OR
6783: (l_checklist_item_id IS NOT NULL AND
6784: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6785: <> NVL(p_chk10_status,hr_api.g_varchar2)
6786: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6787: <> NVL(p_chk10_date_due,hr_api.g_date)
6788: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6789: <> NVL(p_chk10_date_done,hr_api.g_date)
6790: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

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

6784: ( NVL(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
6785: <> NVL(p_chk10_status,hr_api.g_varchar2)
6786: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6787: <> NVL(p_chk10_date_due,hr_api.g_date)
6788: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6789: <> NVL(p_chk10_date_done,hr_api.g_date)
6790: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6791: <> NVL(p_chk10_notes,hr_api.g_varchar2))) THEN
6792: --

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

6786: OR NVL(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
6787: <> NVL(p_chk10_date_due,hr_api.g_date)
6788: OR NVL(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
6789: <> NVL(p_chk10_date_done,hr_api.g_date)
6790: OR NVL(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
6791: <> NVL(p_chk10_notes,hr_api.g_varchar2))) THEN
6792: --
6793: per_checklist_items_api.cre_or_upd_checklist_items
6794: (p_effective_date => p_effective_date

Line 7243: per_chk_shd.lck

7239: --
7240: IF p_chk1_checklist_item_id IS NOT NULL THEN
7241: hr_utility.set_location(l_proc, 120);
7242: --
7243: per_chk_shd.lck
7244: (p_checklist_item_id => p_chk1_checklist_item_id
7245: ,p_object_version_number => p_chk1_object_version_number);
7246: END IF;
7247: --

Line 7251: per_chk_shd.lck

7247: --
7248: IF p_chk2_checklist_item_id IS NOT NULL THEN
7249: hr_utility.set_location(l_proc, 130);
7250: --
7251: per_chk_shd.lck
7252: (p_checklist_item_id => p_chk2_checklist_item_id
7253: ,p_object_version_number => p_chk2_object_version_number);
7254: END IF;
7255: --

Line 7259: per_chk_shd.lck

7255: --
7256: IF p_chk3_checklist_item_id IS NOT NULL THEN
7257: hr_utility.set_location(l_proc, 140);
7258: --
7259: per_chk_shd.lck
7260: (p_checklist_item_id => p_chk3_checklist_item_id
7261: ,p_object_version_number => p_chk3_object_version_number);
7262: END IF;
7263: --

Line 7267: per_chk_shd.lck

7263: --
7264: IF p_chk4_checklist_item_id IS NOT NULL THEN
7265: hr_utility.set_location(l_proc, 150);
7266: --
7267: per_chk_shd.lck
7268: (p_checklist_item_id => p_chk4_checklist_item_id
7269: ,p_object_version_number => p_chk4_object_version_number);
7270: END IF;
7271: --

Line 7275: per_chk_shd.lck

7271: --
7272: IF p_chk5_checklist_item_id IS NOT NULL THEN
7273: hr_utility.set_location(l_proc, 160);
7274: --
7275: per_chk_shd.lck
7276: (p_checklist_item_id => p_chk5_checklist_item_id
7277: ,p_object_version_number => p_chk5_object_version_number);
7278: END IF;
7279: --

Line 7283: per_chk_shd.lck

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

Line 7291: per_chk_shd.lck

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

Line 7299: per_chk_shd.lck

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

Line 7307: per_chk_shd.lck

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

Line 7315: per_chk_shd.lck

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