DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_CHECKLIST_ITEMS_API

Line 2278: per_checklist_items_api.cre_or_upd_checklist_items

2274: --
2275: l_checklist_item_id:=NULL;
2276: l_chk_object_version_number:= NULL;
2277: --
2278: per_checklist_items_api.cre_or_upd_checklist_items
2279: (p_checklist_item_id => l_checklist_item_id
2280: ,p_effective_date => l_creation_date --p_effective_date
2281: ,p_object_version_number => l_chk_object_version_number
2282: ,p_person_id => l_person_id

Line 2302: per_checklist_items_api.cre_or_upd_checklist_items

2298: --
2299: l_checklist_item_id:=NULL;
2300: l_chk_object_version_number:= NULL;
2301: --
2302: per_checklist_items_api.cre_or_upd_checklist_items
2303: (p_checklist_item_id => l_checklist_item_id
2304: ,p_effective_date => l_creation_date --p_effective_date
2305: ,p_object_version_number => l_chk_object_version_number
2306: ,p_person_id => l_person_id

Line 2326: per_checklist_items_api.cre_or_upd_checklist_items

2322: --
2323: l_checklist_item_id:=NULL;
2324: l_chk_object_version_number:= NULL;
2325: --
2326: per_checklist_items_api.cre_or_upd_checklist_items
2327: (p_checklist_item_id => l_checklist_item_id
2328: ,p_effective_date => l_creation_date --p_effective_date
2329: ,p_object_version_number => l_chk_object_version_number
2330: ,p_person_id => l_person_id

Line 2350: per_checklist_items_api.cre_or_upd_checklist_items

2346: --
2347: l_checklist_item_id:=NULL;
2348: l_chk_object_version_number:= NULL;
2349: --
2350: per_checklist_items_api.cre_or_upd_checklist_items
2351: (p_checklist_item_id => l_checklist_item_id
2352: ,p_effective_date => l_creation_date --p_effective_date
2353: ,p_object_version_number => l_chk_object_version_number
2354: ,p_person_id => l_person_id

Line 2374: per_checklist_items_api.cre_or_upd_checklist_items

2370: --
2371: l_checklist_item_id:=NULL;
2372: l_chk_object_version_number:= NULL;
2373: --
2374: per_checklist_items_api.cre_or_upd_checklist_items
2375: (p_checklist_item_id => l_checklist_item_id
2376: ,p_effective_date => l_creation_date --p_effective_date
2377: ,p_object_version_number => l_chk_object_version_number
2378: ,p_person_id => l_person_id

Line 2398: per_checklist_items_api.cre_or_upd_checklist_items

2394: --
2395: l_checklist_item_id:=NULL;
2396: l_chk_object_version_number:= NULL;
2397: --
2398: per_checklist_items_api.cre_or_upd_checklist_items
2399: (p_checklist_item_id => l_checklist_item_id
2400: ,p_effective_date => l_creation_date --p_effective_date
2401: ,p_object_version_number => l_chk_object_version_number
2402: ,p_person_id => l_person_id

Line 2422: per_checklist_items_api.cre_or_upd_checklist_items

2418: --
2419: l_checklist_item_id:=NULL;
2420: l_chk_object_version_number:= NULL;
2421: --
2422: per_checklist_items_api.cre_or_upd_checklist_items
2423: (p_checklist_item_id => l_checklist_item_id
2424: ,p_effective_date => l_creation_date --p_effective_date
2425: ,p_object_version_number => l_chk_object_version_number
2426: ,p_person_id => l_person_id

Line 2446: per_checklist_items_api.cre_or_upd_checklist_items

2442: --
2443: l_checklist_item_id:=NULL;
2444: l_chk_object_version_number:= NULL;
2445: --
2446: per_checklist_items_api.cre_or_upd_checklist_items
2447: (p_checklist_item_id => l_checklist_item_id
2448: ,p_effective_date => l_creation_date --p_effective_date
2449: ,p_object_version_number => l_chk_object_version_number
2450: ,p_person_id => l_person_id

Line 2470: per_checklist_items_api.cre_or_upd_checklist_items

2466: --
2467: l_checklist_item_id:=NULL;
2468: l_chk_object_version_number:= NULL;
2469: --
2470: per_checklist_items_api.cre_or_upd_checklist_items
2471: (p_checklist_item_id => l_checklist_item_id
2472: ,p_effective_date => l_creation_date --p_effective_date
2473: ,p_object_version_number => l_chk_object_version_number
2474: ,p_person_id => l_person_id

Line 2494: per_checklist_items_api.cre_or_upd_checklist_items

2490: --
2491: l_checklist_item_id:=NULL;
2492: l_chk_object_version_number:= NULL;
2493: --
2494: per_checklist_items_api.cre_or_upd_checklist_items
2495: (p_checklist_item_id => l_checklist_item_id
2496: ,p_effective_date => l_creation_date --p_effective_date
2497: ,p_object_version_number => l_chk_object_version_number
2498: ,p_person_id => l_person_id

Line 6455: per_checklist_items_api.cre_or_upd_checklist_items

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
6457: ,p_checklist_item_id => l_checklist_item_id
6458: ,p_object_version_number => l_chk_object_version_number
6459: ,p_person_id => p_person_id

Line 6497: per_checklist_items_api.cre_or_upd_checklist_items

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
6499: ,p_checklist_item_id => l_checklist_item_id
6500: ,p_object_version_number => l_chk_object_version_number
6501: ,p_person_id => p_person_id

Line 6539: per_checklist_items_api.cre_or_upd_checklist_items

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
6541: ,p_checklist_item_id => l_checklist_item_id
6542: ,p_object_version_number => l_chk_object_version_number
6543: ,p_person_id => p_person_id

Line 6581: per_checklist_items_api.cre_or_upd_checklist_items

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
6583: ,p_checklist_item_id => l_checklist_item_id
6584: ,p_object_version_number => l_chk_object_version_number
6585: ,p_person_id => p_person_id

Line 6623: per_checklist_items_api.cre_or_upd_checklist_items

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
6625: ,p_checklist_item_id => l_checklist_item_id
6626: ,p_object_version_number => l_chk_object_version_number
6627: ,p_person_id => p_person_id

Line 6665: per_checklist_items_api.cre_or_upd_checklist_items

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
6667: ,p_checklist_item_id => l_checklist_item_id
6668: ,p_object_version_number => l_chk_object_version_number
6669: ,p_person_id => p_person_id

Line 6707: per_checklist_items_api.cre_or_upd_checklist_items

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
6709: ,p_checklist_item_id => l_checklist_item_id
6710: ,p_object_version_number => l_chk_object_version_number
6711: ,p_person_id => p_person_id

Line 6749: per_checklist_items_api.cre_or_upd_checklist_items

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
6751: ,p_checklist_item_id => l_checklist_item_id
6752: ,p_object_version_number => l_chk_object_version_number
6753: ,p_person_id => p_person_id

Line 6791: per_checklist_items_api.cre_or_upd_checklist_items

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
6793: ,p_checklist_item_id => l_checklist_item_id
6794: ,p_object_version_number => l_chk_object_version_number
6795: ,p_person_id => p_person_id

Line 6833: per_checklist_items_api.cre_or_upd_checklist_items

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
6835: ,p_checklist_item_id => l_checklist_item_id
6836: ,p_object_version_number => l_chk_object_version_number
6837: ,p_person_id => p_person_id