APPS.PER_CKL_BUS dependencies on PER_CHECKLISTS

Line 32: , per_checklists ckl

28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , per_checklists ckl
33: where ckl.checklist_id = p_checklist_id
34: and pbg.business_group_id (+) = ckl.business_group_id;
35: --
36: -- Declare local variables

Line 102: , per_checklists ckl

98: --
99: cursor csr_leg_code is
100: select pbg.legislation_code
101: from per_business_groups_perf pbg
102: , per_checklists ckl
103: where ckl.checklist_id = p_checklist_id
104: and pbg.business_group_id (+) = ckl.business_group_id;
105: --
106: -- Declare local variables

Line 166: (p_name in per_checklists.name%TYPE

162: -- |------------------------< chk_name >------------------------------------|
163: -- --------------------------------------------------------------------------
164: --
165: Procedure chk_name
166: (p_name in per_checklists.name%TYPE
167: ,p_category IN per_checklists.checklist_category%TYPE
168: ,p_business_group_id in per_checklists.business_group_id%TYPE
169: ,p_checklist_id in per_checklists.checklist_id%type
170: ,p_object_version_number in per_checklists.object_version_number%type

Line 167: ,p_category IN per_checklists.checklist_category%TYPE

163: -- --------------------------------------------------------------------------
164: --
165: Procedure chk_name
166: (p_name in per_checklists.name%TYPE
167: ,p_category IN per_checklists.checklist_category%TYPE
168: ,p_business_group_id in per_checklists.business_group_id%TYPE
169: ,p_checklist_id in per_checklists.checklist_id%type
170: ,p_object_version_number in per_checklists.object_version_number%type
171: )

Line 168: ,p_business_group_id in per_checklists.business_group_id%TYPE

164: --
165: Procedure chk_name
166: (p_name in per_checklists.name%TYPE
167: ,p_category IN per_checklists.checklist_category%TYPE
168: ,p_business_group_id in per_checklists.business_group_id%TYPE
169: ,p_checklist_id in per_checklists.checklist_id%type
170: ,p_object_version_number in per_checklists.object_version_number%type
171: )
172: is

Line 169: ,p_checklist_id in per_checklists.checklist_id%type

165: Procedure chk_name
166: (p_name in per_checklists.name%TYPE
167: ,p_category IN per_checklists.checklist_category%TYPE
168: ,p_business_group_id in per_checklists.business_group_id%TYPE
169: ,p_checklist_id in per_checklists.checklist_id%type
170: ,p_object_version_number in per_checklists.object_version_number%type
171: )
172: is
173: --

Line 170: ,p_object_version_number in per_checklists.object_version_number%type

166: (p_name in per_checklists.name%TYPE
167: ,p_category IN per_checklists.checklist_category%TYPE
168: ,p_business_group_id in per_checklists.business_group_id%TYPE
169: ,p_checklist_id in per_checklists.checklist_id%type
170: ,p_object_version_number in per_checklists.object_version_number%type
171: )
172: is
173: --
174: -- Declare cursor to check name is unique.

Line 178: from per_checklists

174: -- Declare cursor to check name is unique.
175: --
176: cursor csr_unique_name is
177: select null
178: from per_checklists
179: where name = p_name
180: AND checklist_category = p_category
181: and business_group_id = p_business_group_id;
182: --

Line 240: (p_associated_column1 => 'PER_CHECKLISTS.NAME'

236: if g_debug then hr_utility.set_location('Entering:'||l_proc, 50); end if;
237: --
238: exception when app_exception.application_exception then
239: if hr_multi_message.exception_add
240: (p_associated_column1 => 'PER_CHECKLISTS.NAME'
241: ) then
242: hr_utility.set_location(' Leaving:'|| l_proc, 60);
243: raise;
244: end if;

Line 280: (p_ler_id in per_checklists.event_reason_id%TYPE

276: -- {End of Comments}
277: --
278: -- ---------------------------------------------------------------------------
279: procedure chk_ler_id
280: (p_ler_id in per_checklists.event_reason_id%TYPE
281: ,p_business_group_id in per_checklists.business_group_id%TYPE
282: ,p_effective_date in date
283: ) is
284: --

Line 281: ,p_business_group_id in per_checklists.business_group_id%TYPE

277: --
278: -- ---------------------------------------------------------------------------
279: procedure chk_ler_id
280: (p_ler_id in per_checklists.event_reason_id%TYPE
281: ,p_business_group_id in per_checklists.business_group_id%TYPE
282: ,p_effective_date in date
283: ) is
284: --
285: -- Declare local variables

Line 321: (p_associated_column1 => 'PER_CHECKLISTS.EVENT_REASON_ID'

317: hr_utility.set_location(l_proc, 5);
318: --
319: exception when app_exception.application_exception then
320: if hr_multi_message.exception_add
321: (p_associated_column1 => 'PER_CHECKLISTS.EVENT_REASON_ID'
322: ) then
323: hr_utility.set_location(' Leaving:'|| l_proc, 60);
324: raise;
325: end if;

Line 335: (p_checklist_id in per_checklists.checklist_id%TYPE,

331: -- |--------------------------< chk_ckl_category >--------------------------|
332: -- ---------------------------------------------------------------------------
333: --
334: procedure chk_ckl_category
335: (p_checklist_id in per_checklists.checklist_id%TYPE,
336: p_ckl_category in per_checklists.checklist_category%TYPE,
337: p_effective_date in date) is
338: --
339: -- Declare local variables

Line 336: p_ckl_category in per_checklists.checklist_category%TYPE,

332: -- ---------------------------------------------------------------------------
333: --
334: procedure chk_ckl_category
335: (p_checklist_id in per_checklists.checklist_id%TYPE,
336: p_ckl_category in per_checklists.checklist_category%TYPE,
337: p_effective_date in date) is
338: --
339: -- Declare local variables
340: --

Line 384: (p_associated_column1 => 'PER_CHECKLISTS.CHECKLIST_CATEGORY'

380: hr_utility.set_location(' Leaving:'|| l_proc, 20);
381:
382: exception when app_exception.application_exception then
383: if hr_multi_message.exception_add
384: (p_associated_column1 => 'PER_CHECKLISTS.CHECKLIST_CATEGORY'
385: ) then
386: hr_utility.set_location(' Leaving:'|| l_proc, 60);
387: raise;
388: end if;