DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_CHECKLIST_ITEMS_API

Line 2245: per_checklist_items_api.cre_or_upd_checklist_items

2241: --
2242: l_checklist_item_id:=NULL;
2243: l_chk_object_version_number:= NULL;
2244: --
2245: per_checklist_items_api.cre_or_upd_checklist_items
2246: (p_checklist_item_id => l_checklist_item_id
2247: ,p_effective_date => l_creation_date --p_effective_date
2248: ,p_object_version_number => l_chk_object_version_number
2249: ,p_person_id => l_person_id

Line 2269: per_checklist_items_api.cre_or_upd_checklist_items

2265: --
2266: l_checklist_item_id:=NULL;
2267: l_chk_object_version_number:= NULL;
2268: --
2269: per_checklist_items_api.cre_or_upd_checklist_items
2270: (p_checklist_item_id => l_checklist_item_id
2271: ,p_effective_date => l_creation_date --p_effective_date
2272: ,p_object_version_number => l_chk_object_version_number
2273: ,p_person_id => l_person_id

Line 2293: per_checklist_items_api.cre_or_upd_checklist_items

2289: --
2290: l_checklist_item_id:=NULL;
2291: l_chk_object_version_number:= NULL;
2292: --
2293: per_checklist_items_api.cre_or_upd_checklist_items
2294: (p_checklist_item_id => l_checklist_item_id
2295: ,p_effective_date => l_creation_date --p_effective_date
2296: ,p_object_version_number => l_chk_object_version_number
2297: ,p_person_id => l_person_id

Line 2317: per_checklist_items_api.cre_or_upd_checklist_items

2313: --
2314: l_checklist_item_id:=NULL;
2315: l_chk_object_version_number:= NULL;
2316: --
2317: per_checklist_items_api.cre_or_upd_checklist_items
2318: (p_checklist_item_id => l_checklist_item_id
2319: ,p_effective_date => l_creation_date --p_effective_date
2320: ,p_object_version_number => l_chk_object_version_number
2321: ,p_person_id => l_person_id

Line 2341: per_checklist_items_api.cre_or_upd_checklist_items

2337: --
2338: l_checklist_item_id:=NULL;
2339: l_chk_object_version_number:= NULL;
2340: --
2341: per_checklist_items_api.cre_or_upd_checklist_items
2342: (p_checklist_item_id => l_checklist_item_id
2343: ,p_effective_date => l_creation_date --p_effective_date
2344: ,p_object_version_number => l_chk_object_version_number
2345: ,p_person_id => l_person_id

Line 2365: per_checklist_items_api.cre_or_upd_checklist_items

2361: --
2362: l_checklist_item_id:=NULL;
2363: l_chk_object_version_number:= NULL;
2364: --
2365: per_checklist_items_api.cre_or_upd_checklist_items
2366: (p_checklist_item_id => l_checklist_item_id
2367: ,p_effective_date => l_creation_date --p_effective_date
2368: ,p_object_version_number => l_chk_object_version_number
2369: ,p_person_id => l_person_id

Line 2389: per_checklist_items_api.cre_or_upd_checklist_items

2385: --
2386: l_checklist_item_id:=NULL;
2387: l_chk_object_version_number:= NULL;
2388: --
2389: per_checklist_items_api.cre_or_upd_checklist_items
2390: (p_checklist_item_id => l_checklist_item_id
2391: ,p_effective_date => l_creation_date --p_effective_date
2392: ,p_object_version_number => l_chk_object_version_number
2393: ,p_person_id => l_person_id

Line 2413: per_checklist_items_api.cre_or_upd_checklist_items

2409: --
2410: l_checklist_item_id:=NULL;
2411: l_chk_object_version_number:= NULL;
2412: --
2413: per_checklist_items_api.cre_or_upd_checklist_items
2414: (p_checklist_item_id => l_checklist_item_id
2415: ,p_effective_date => l_creation_date --p_effective_date
2416: ,p_object_version_number => l_chk_object_version_number
2417: ,p_person_id => l_person_id

Line 2437: per_checklist_items_api.cre_or_upd_checklist_items

2433: --
2434: l_checklist_item_id:=NULL;
2435: l_chk_object_version_number:= NULL;
2436: --
2437: per_checklist_items_api.cre_or_upd_checklist_items
2438: (p_checklist_item_id => l_checklist_item_id
2439: ,p_effective_date => l_creation_date --p_effective_date
2440: ,p_object_version_number => l_chk_object_version_number
2441: ,p_person_id => l_person_id

Line 2461: per_checklist_items_api.cre_or_upd_checklist_items

2457: --
2458: l_checklist_item_id:=NULL;
2459: l_chk_object_version_number:= NULL;
2460: --
2461: per_checklist_items_api.cre_or_upd_checklist_items
2462: (p_checklist_item_id => l_checklist_item_id
2463: ,p_effective_date => l_creation_date --p_effective_date
2464: ,p_object_version_number => l_chk_object_version_number
2465: ,p_person_id => l_person_id

Line 6415: per_checklist_items_api.cre_or_upd_checklist_items

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
6417: ,p_checklist_item_id => l_checklist_item_id
6418: ,p_object_version_number => l_chk_object_version_number
6419: ,p_person_id => p_person_id

Line 6457: per_checklist_items_api.cre_or_upd_checklist_items

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

Line 6499: per_checklist_items_api.cre_or_upd_checklist_items

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

Line 6541: per_checklist_items_api.cre_or_upd_checklist_items

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

Line 6583: per_checklist_items_api.cre_or_upd_checklist_items

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

Line 6625: per_checklist_items_api.cre_or_upd_checklist_items

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

Line 6667: per_checklist_items_api.cre_or_upd_checklist_items

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

Line 6709: per_checklist_items_api.cre_or_upd_checklist_items

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

Line 6751: per_checklist_items_api.cre_or_upd_checklist_items

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

Line 6793: per_checklist_items_api.cre_or_upd_checklist_items

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