APPS.PER_SPS_BUS dependencies on PER_SPINAL_POINTS

Line 249: -- exists in table per_spinal_points.

245: -- ---------------------------------------------------------------------------
246: --
247: -- Description:
248: -- Validates that a spinal_point_id is mandatory and
249: -- exists in table per_spinal_points.
250: --
251: -- Validates business_group_id in per_spinal_points talble should be
252: -- the same as business_group_id to be passed as a parameter and
253: -- parent_spine_id in per_spinal_points should be the same as parent_spine_id

Line 251: -- Validates business_group_id in per_spinal_points talble should be

247: -- Description:
248: -- Validates that a spinal_point_id is mandatory and
249: -- exists in table per_spinal_points.
250: --
251: -- Validates business_group_id in per_spinal_points talble should be
252: -- the same as business_group_id to be passed as a parameter and
253: -- parent_spine_id in per_spinal_points should be the same as parent_spine_id
254: -- in per_grade_spines_f to be refered by grade_spine_id to be passed as
255: -- a parameter.

Line 253: -- parent_spine_id in per_spinal_points should be the same as parent_spine_id

249: -- exists in table per_spinal_points.
250: --
251: -- Validates business_group_id in per_spinal_points talble should be
252: -- the same as business_group_id to be passed as a parameter and
253: -- parent_spine_id in per_spinal_points should be the same as parent_spine_id
254: -- in per_grade_spines_f to be refered by grade_spine_id to be passed as
255: -- a parameter.
256: --
257: -- Pre-conditions:

Line 298: from per_spinal_points psp

294: l_api_updating boolean;
295: --
296: cursor csr_valid_spinal_point is
297: select null
298: from per_spinal_points psp
299: where psp.business_group_id = p_business_group_id
300: and psp.spinal_point_id = p_spinal_point_id;
301: --
302: cursor csr_valid_parent_spine is

Line 304: from per_spinal_points psp

300: and psp.spinal_point_id = p_spinal_point_id;
301: --
302: cursor csr_valid_parent_spine is
303: select null
304: from per_spinal_points psp
305: ,per_grade_spines_f pgs
306: where psp.business_group_id = p_business_group_id
307: and psp.spinal_point_id = p_spinal_point_id
308: and pgs.grade_spine_id = p_grade_spine_id

Line 356: -- check parent_spine_id in per_spinal_points is the same as

352:
353: hr_utility.set_location(l_proc, 30);
354:
355: --
356: -- check parent_spine_id in per_spinal_points is the same as
357: -- parent_spine_id in per_grade_spines_f
358: --
359: open csr_valid_parent_spine;
360: fetch csr_valid_parent_spine into l_exists;

Line 478: -- Validates that a sequence is mandatory and exists in table per_spinal_points.

474: -- |------------------------< chk_sequence >---------------------------------|
475: -- ---------------------------------------------------------------------------
476: --
477: -- Description:
478: -- Validates that a sequence is mandatory and exists in table per_spinal_points.
479: --
480: -- Pre-conditions:
481: -- step_id must be valid.
482: -- business_group_id must be valid.

Line 520: from per_spinal_points psp

516: l_api_updating boolean;
517: --
518: cursor csr_valid_sequence is
519: select null
520: from per_spinal_points psp
521: where psp.business_group_id = p_business_group_id
522: and psp.spinal_point_id = p_spinal_point_id
523: and psp.sequence = p_sequence;
524: --