APPS.PER_PDM_BUS dependencies on PER_PERSON_DLVRY_METHODS

Line 115: per_pdm_shd.constraint_error('PER_PERSON_DLVRY_METHODS_FK1');

111: open csr_valid_person_id;
112: fetch csr_valid_person_id into l_person_id;
113: if csr_valid_person_id%notfound then
114: close csr_valid_person_id;
115: per_pdm_shd.constraint_error('PER_PERSON_DLVRY_METHODS_FK1');
116: end if;
117: close csr_valid_person_id;
118:
119: hr_utility.set_location('Leaving: '||l_proc,10);

Line 165: from per_person_dlvry_methods

161: -- Setup cursor for combination check
162: --
163: cursor csr_check_uniqueness is
164: select delivery_method_id
165: from per_person_dlvry_methods
166: where comm_dlvry_method = p_comm_dlvry_method
167: and person_id = p_person_id;
168: --
169: Begin

Line 219: per_pdm_shd.constraint_error('PER_PERSON_DLVRY_METHODS_UK1');

215: open csr_check_uniqueness;
216: fetch csr_check_uniqueness into l_delivery_method_id;
217: if csr_check_uniqueness%found then
218: close csr_check_uniqueness;
219: per_pdm_shd.constraint_error('PER_PERSON_DLVRY_METHODS_UK1');
220: end if;
221: close csr_check_uniqueness;
222: --
223: --

Line 345: from per_person_dlvry_methods

341: -- Setup cursor for combination check
342: --
343: cursor csr_check_uniqueness is
344: select delivery_method_id
345: from per_person_dlvry_methods
346: where preferred_flag = 'Y'
347: and person_id = p_person_id;
348: --
349: Begin

Line 481: ,p_descflex_name => 'PER_PERSON_DLVRY_METHODS'

477: -- b) During insert.
478: --
479: hr_dflex_utility.ins_or_upd_descflex_attribs
480: (p_appl_short_name => 'PER'
481: ,p_descflex_name => 'PER_PERSON_DLVRY_METHODS'
482: ,p_attribute_category => p_rec.attribute_category
483: ,p_attribute1_name => 'ATTRIBUTE1'
484: ,p_attribute1_value => p_rec.attribute1
485: ,p_attribute2_name => 'ATTRIBUTE2'

Line 654: , per_person_dlvry_methods pdm

650: --
651: cursor csr_leg_code is
652: select pbg.legislation_code
653: from per_business_groups pbg
654: , per_person_dlvry_methods pdm
655: , per_all_people_f per
656: where pdm.delivery_method_id = p_delivery_method_id
657: and pdm.person_id = per.person_id
658: and pbg.business_group_id = per.business_group_id;