1 Package per_par_bus as
2 /* $Header: peparrhi.pkh 120.1 2007/06/20 07:48:33 rapandi ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |---------------------------< chk_ procedures >----------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start Of Comments}
7 -- Description:
8 -- Following chk procedures externalized for use with web pages
9 -- so body for details
10 --
11 -- Access Status:
12 -- HR Development USe only
13 --
14 -- {End Of Comments}
15 -- ----------------------------------------------------------------------------
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
25 ,p_business_group_id in
26 per_participants.business_group_id%TYPE
27 );
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
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 -- ----------------------------------------------------------------------------
45 -- |---------------------------< insert_validate >----------------------------|
46 -- ----------------------------------------------------------------------------
47 -- {Start Of Comments}
48 --
49 -- Description:
50 -- This procedure controls the execution of all insert business rules
51 -- validation.
52 --
53 -- Pre Conditions:
54 -- This private procedure is called from ins procedure.
55 --
56 -- In Parameters:
57 -- A Pl/Sql record structre.
58 --
59 -- Post Success:
60 -- Processing continues.
61 --
62 -- Post Failure:
63 -- If a business rules fails the error will not be handled by this procedure
64 -- unless explicity coded.
65 --
66 -- Developer Implementation Notes:
67 -- For insert, your business rules should be executed from this procedure and
68 -- should ideally (unless really necessary) just be straight procedure or
69 -- function calls. Try and avoid using conditional branching logic.
70 --
71 -- Access Status:
72 -- Internal Table Handler Use Only.
73 --
74 -- {End Of Comments}
75 -- ----------------------------------------------------------------------------
76 Procedure insert_validate(p_rec in per_par_shd.g_rec_type
77 ,p_effective_date in date);
78 --
79 -- ----------------------------------------------------------------------------
80 -- |---------------------------< update_validate >----------------------------|
81 -- ----------------------------------------------------------------------------
82 -- {Start Of Comments}
83 --
84 -- Description:
85 -- This procedure controls the execution of all update business rules
86 -- validation.
87 --
88 -- Pre Conditions:
89 -- This private procedure is called from upd procedure.
90 --
91 -- In Parameters:
92 -- A Pl/Sql record structre.
93 --
94 -- Post Success:
95 -- Processing continues.
96 --
97 -- Post Failure:
98 -- If a business rules fails the error will not be handled by this procedure
99 -- unless explicity coded.
100 --
101 -- Developer Implementation Notes:
102 -- For update, your business rules should be executed from this procedure and
103 -- should ideally (unless really necessary) just be straight procedure or
104 -- function calls. Try and avoid using conditional branching logic.
105 --
106 -- Access Status:
107 -- Internal Table Handler Use Only.
108 --
109 -- {End Of Comments}
110 -- ----------------------------------------------------------------------------
111 Procedure update_validate(p_rec in per_par_shd.g_rec_type
112 ,p_effective_date in date);
113 --
114 -- ----------------------------------------------------------------------------
115 -- |---------------------------< delete_validate >----------------------------|
116 -- ----------------------------------------------------------------------------
117 -- {Start Of Comments}
118 --
119 -- Description:
120 -- This procedure controls the execution of all delete business rules
121 -- validation.
122 --
123 -- Pre Conditions:
124 -- This private procedure is called from del procedure.
125 --
126 -- In Parameters:
127 -- A Pl/Sql record structre.
128 --
129 -- Post Success:
130 -- Processing continues.
131 --
132 -- Post Failure:
133 -- If a business rules fails the error will not be handled by this procedure
134 -- unless explicity coded.
135 --
136 -- Developer Implementation Notes:
137 -- For delete, your business rules should be executed from this procedure and
138 -- should ideally (unless really necessary) just be straight procedure or
139 -- function calls. Try and avoid using conditional branching logic.
140 --
141 -- Access Status:
142 -- Internal Table Handler Use Only.
143 --
144 -- {End Of Comments}
145 -- ----------------------------------------------------------------------------
146 Procedure delete_validate(p_rec in per_par_shd.g_rec_type);
147 --
148 -- ----------------------------------------------------------------------------
149 -- |----------------------< return_legislation_code >--------------------------|
150 -- ----------------------------------------------------------------------------
151 -- {Start Of Comments}
152 --
153 -- Description:
154 -- This function gets the legislation code
155 --
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 --
165 -- Post Failure:
166 -- If the legislation code is not found then it errors out
167 --
168 -- Developer Implementation Notes:
169 --
170 -- Access Status:
171 -- Internal Table Handler Use Only.
172 --
173 -- {End Of Comments}
174 --
175 Function return_legislation_code (
176 p_participant_id in number)
177 return varchar2;
178 --
179 --
180 end per_par_bus;