16: -- |---------------------------< chk_participation_in_id >--------------------|
17: -- ----------------------------------------------------------------------------
18: procedure chk_participation_in_id
19: (p_participation_in_table in
20: per_participants.participation_in_table%TYPE
21: ,p_participation_in_column in
22: per_participants.participation_in_column%TYPE
23: ,p_participation_in_id in
24: per_participants.participation_in_id%TYPE
18: procedure chk_participation_in_id
19: (p_participation_in_table in
20: per_participants.participation_in_table%TYPE
21: ,p_participation_in_column in
22: per_participants.participation_in_column%TYPE
23: ,p_participation_in_id in
24: per_participants.participation_in_id%TYPE
25: ,p_business_group_id in
26: per_participants.business_group_id%TYPE
20: per_participants.participation_in_table%TYPE
21: ,p_participation_in_column in
22: per_participants.participation_in_column%TYPE
23: ,p_participation_in_id in
24: per_participants.participation_in_id%TYPE
25: ,p_business_group_id in
26: per_participants.business_group_id%TYPE
27: );
28: -- ----------------------------------------------------------------------------
22: per_participants.participation_in_column%TYPE
23: ,p_participation_in_id in
24: per_participants.participation_in_id%TYPE
25: ,p_business_group_id in
26: per_participants.business_group_id%TYPE
27: );
28: -- ----------------------------------------------------------------------------
29: -- |---------------------------< chk_person_id >------------------------------|
30: -- ----------------------------------------------------------------------------
28: -- ----------------------------------------------------------------------------
29: -- |---------------------------< chk_person_id >------------------------------|
30: -- ----------------------------------------------------------------------------
31: procedure chk_person_id
32: (p_participant_id in per_participants.participant_id%TYPE
33: ,p_object_version_number in per_participants.object_version_number%TYPE
34: ,p_person_id in per_participants.person_id%TYPE
35: ,p_business_group_id in per_participants.business_group_id%TYPE
36: ,p_participation_in_table in
29: -- |---------------------------< chk_person_id >------------------------------|
30: -- ----------------------------------------------------------------------------
31: procedure chk_person_id
32: (p_participant_id in per_participants.participant_id%TYPE
33: ,p_object_version_number in per_participants.object_version_number%TYPE
34: ,p_person_id in per_participants.person_id%TYPE
35: ,p_business_group_id in per_participants.business_group_id%TYPE
36: ,p_participation_in_table in
37: per_participants.participation_in_table%TYPE
30: -- ----------------------------------------------------------------------------
31: procedure chk_person_id
32: (p_participant_id in per_participants.participant_id%TYPE
33: ,p_object_version_number in per_participants.object_version_number%TYPE
34: ,p_person_id in per_participants.person_id%TYPE
35: ,p_business_group_id in per_participants.business_group_id%TYPE
36: ,p_participation_in_table in
37: per_participants.participation_in_table%TYPE
38: ,p_participation_in_column in
31: procedure chk_person_id
32: (p_participant_id in per_participants.participant_id%TYPE
33: ,p_object_version_number in per_participants.object_version_number%TYPE
34: ,p_person_id in per_participants.person_id%TYPE
35: ,p_business_group_id in per_participants.business_group_id%TYPE
36: ,p_participation_in_table in
37: per_participants.participation_in_table%TYPE
38: ,p_participation_in_column in
39: per_participants.participation_in_column%TYPE
33: ,p_object_version_number in per_participants.object_version_number%TYPE
34: ,p_person_id in per_participants.person_id%TYPE
35: ,p_business_group_id in per_participants.business_group_id%TYPE
36: ,p_participation_in_table in
37: per_participants.participation_in_table%TYPE
38: ,p_participation_in_column in
39: per_participants.participation_in_column%TYPE
40: ,p_participation_in_id in per_participants.participation_in_id%TYPE
41: ,p_effective_date in date
35: ,p_business_group_id in per_participants.business_group_id%TYPE
36: ,p_participation_in_table in
37: per_participants.participation_in_table%TYPE
38: ,p_participation_in_column in
39: per_participants.participation_in_column%TYPE
40: ,p_participation_in_id in per_participants.participation_in_id%TYPE
41: ,p_effective_date in date
42: );
43: --
36: ,p_participation_in_table in
37: per_participants.participation_in_table%TYPE
38: ,p_participation_in_column in
39: per_participants.participation_in_column%TYPE
40: ,p_participation_in_id in per_participants.participation_in_id%TYPE
41: ,p_effective_date in date
42: );
43: --
44: -- ----------------------------------------------------------------------------
156: -- Pre Conditions:
157: -- This private procedure will be called from the user hook procedures.
158: --
159: -- In Parameters:
160: -- the primary key of the table (per_participants)
161: --
162: -- Post Success:
163: -- Processing continues.
164: --