APPS.PER_CHK_BUS dependencies on PER_CHECKLIST_ITEMS

Line 29: , per_checklist_items chk

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , per_checklist_items chk
30: , per_all_people_f peo
31: where chk.checklist_item_id = p_checklist_item_id
32: and chk.person_id = peo.person_id
33: and pbg.business_group_id = peo.business_group_id;

Line 89: , per_checklist_items chk

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , per_checklist_items chk
90: , per_all_people_f peo
91: where chk.checklist_item_id = p_checklist_item_id
92: and chk.person_id = peo.person_id
93: and pbg.business_group_id = peo.business_group_id;

Line 255: p_person_id in per_checklist_items.person_id%type) IS

251: -- Access Status
252: -- Internal table handler use only.
253: --
254: Procedure chk_is_person_valid(p_effective_date in date,
255: p_person_id in per_checklist_items.person_id%type) IS
256: --
257: l_proc varchar2(72) := g_package||'chk_is_person_valid';
258: --
259: CURSOR chk_valid_person

Line 265: l_person_id per_checklist_items.person_id%TYPE;

261: SELECT person_id
262: FROM per_all_people_f
263: WHERE person_id = p_person_id;
264:
265: l_person_id per_checklist_items.person_id%TYPE;
266:
267: Begin
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);

Line 312: p_status in per_checklist_items.status%type )

308: -- Internal table handler use only.
309: --
310: Procedure chk_is_status_valid(p_effective_date in date,
311: p_checklist_item_id in number,
312: p_status in per_checklist_items.status%type )
313: is
314: --
315: l_proc varchar2(72) := g_package||'chk_is_status_valid';
316: --

Line 368: p_item_code in per_checklist_items.item_code%type) IS

364: -- Access Status
365: -- Internal table handler use only.
366: --
367: Procedure chk_is_itemcode_valid(p_effective_date in date,
368: p_item_code in per_checklist_items.item_code%type) IS
369: --
370: l_proc varchar2(72) := g_package||'chk_is_itemcode_valid';
371:
372: Begin

Line 389: -- PER_CHECKLIST_ITEMS_U1

385:
386: -- Checking to see it the item code entered is unique for that
387: -- person
388: -- This check will be done during the insert_dml
389: -- PER_CHECKLIST_ITEMS_U1
390:
391: --
392: hr_utility.set_location('Leaving:'||l_proc, 10);
393: --

Line 597: ,p_descflex_name => 'PER_CHECKLIST_ITEMS'

593: -- validate flex segment values
594: --
595: hr_dflex_utility.ins_or_upd_descflex_attribs(
596: p_appl_short_name => 'PER'
597: ,p_descflex_name => 'PER_CHECKLIST_ITEMS'
598: ,p_attribute_category => p_rec.attribute_category
599: ,p_attribute1_name => 'ATTRIBUTE1'
600: ,p_attribute1_value => p_rec.attribute1
601: ,p_attribute2_name => 'ATTRIBUTE2'