1 Package pay_ncr_bus as
2 /* $Header: pyncrrhi.pkh 120.0 2005/05/29 06:52:22 appldev noship $ */
3 --
4 --
5 -- ---------------------------------------------------------------------------
6 -- |---------------------< return_legislation_code >-------------------------|
7 -- ---------------------------------------------------------------------------
8 --
9 -- Description:
10 -- Return the legislation code for a specific primary key value
11 --
12 -- Prerequisites:
13 -- The primary key identified by p_net_calculation_rule_id already exists.
14 --
15 -- In Arguments:
16 -- p_net_calculation_rule_id
17 --
18 -- Post Success:
19 -- If the value is found this function will return the values business
20 -- group legislation code.
21 --
22 -- Post Failure:
23 -- An error is raised if the value does not exist.
24 --
25 -- Access Status:
26 -- Internal Development Use Only.
27 --
28 function return_legislation_code
29 (p_net_calculation_rule_id in number) return varchar2;
30 --
31 -- ---------------------------------------------------------------------------
32 -- |----------------------< chk_date_input_value >----------------------------|
33 -- ---------------------------------------------------------------------------
34 --
35 -- Description:
36 -- Validates the date input value for a net calculation rule -
37 -- this input value must be present for all rules on an accrual plan,
38 -- with the exception of the absence element's rule.
39 --
40 -- Prerequisites:
41 --
42 -- In Arguments:
43 -- p_accrual_plan_id
44 -- p_input_value_id
45 -- p_date_input_value_id
46 --
47 -- Post Success:
48 -- If date input value is present, processing continues.
49 --
50 -- Post Failure:
51 -- An error is raised if date input value is null.
52 --
53 -- Access Status:
54 -- Internal Development Use Only.
55 --
56 procedure chk_date_input_value (p_accrual_plan_id in number,
57 p_input_value_id in number,
58 p_date_input_value_id in number );
59 --
60 -- ---------------------------------------------------------------------------
61 -- |----------------------< chk_duplicate_rule >-----------------------------|
62 -- ---------------------------------------------------------------------------
63 --
64 -- Description:
65 -- Checks the rule is not a duplicate for a particular plan.
66 --
67 -- Prerequisites:
68 --
69 -- In Arguments:
70 -- p_accrual_plan_id
71 -- p_net_calc_rule_id
72 -- p_input_value_id
73 -- p_date_input_value_id
74 --
75 -- Post Success:
76 -- If duplicate not found, processing continues.
77 --
78 -- Post Failure:
79 -- An error is raised if duplicate is found
80 --
81 -- Access Status:
82 -- Internal Development Use Only.
83 --
84 procedure chk_duplicate_rule (p_accrual_plan_id in number,
85 p_net_calc_rule_id in number,
86 p_input_value_id in number,
87 p_date_input_value_id in number );
88 --
89 -- ----------------------------------------------------------------------------
90 -- |---------------------------< insert_validate >----------------------------|
91 -- ----------------------------------------------------------------------------
92 -- {Start Of Comments}
93 --
94 -- Description:
95 -- This procedure controls the execution of all insert business rules
96 -- validation.
97 --
98 -- Prerequisites:
99 -- This private procedure is called from ins procedure.
100 --
101 -- In Parameters:
102 -- A Pl/Sql record structre.
103 --
104 -- Post Success:
105 -- Processing continues.
106 --
107 -- Post Failure:
108 -- If a business rules fails the error will not be handled by this procedure
109 -- unless explicity coded.
110 --
111 -- Developer Implementation Notes:
112 -- For insert, your business rules should be executed from this procedure and
113 -- should ideally (unless really necessary) just be straight procedure or
114 -- function calls. Try and avoid using conditional branching logic.
115 --
116 -- Access Status:
117 -- Internal Row Handler Use Only.
118 --
119 -- {End Of Comments}
120 -- ----------------------------------------------------------------------------
121 Procedure insert_validate(p_rec in pay_ncr_shd.g_rec_type);
122 --
123 -- ----------------------------------------------------------------------------
124 -- |---------------------------< update_validate >----------------------------|
125 -- ----------------------------------------------------------------------------
126 -- {Start Of Comments}
127 --
128 -- Description:
129 -- This procedure controls the execution of all update business rules
130 -- validation.
131 --
132 -- Prerequisites:
133 -- This private procedure is called from upd procedure.
134 --
135 -- In Parameters:
136 -- A Pl/Sql record structre.
137 --
138 -- Post Success:
139 -- Processing continues.
140 --
141 -- Post Failure:
142 -- If a business rules fails the error will not be handled by this procedure
143 -- unless explicity coded.
144 --
145 -- Developer Implementation Notes:
146 -- For update, your business rules should be executed from this procedure and
147 -- should ideally (unless really necessary) just be straight procedure or
148 -- function calls. Try and avoid using conditional branching logic.
149 --
150 -- Access Status:
151 -- Internal Row Handler Use Only.
152 --
153 -- {End Of Comments}
154 -- ----------------------------------------------------------------------------
155 Procedure update_validate(p_rec in pay_ncr_shd.g_rec_type);
156 --
157 -- ----------------------------------------------------------------------------
158 -- |---------------------------< delete_validate >----------------------------|
159 -- ----------------------------------------------------------------------------
160 -- {Start Of Comments}
161 --
162 -- Description:
163 -- This procedure controls the execution of all delete business rules
164 -- validation.
165 --
166 -- Prerequisites:
167 -- This private procedure is called from del procedure.
168 --
169 -- In Parameters:
170 -- A Pl/Sql record structre.
171 --
172 -- Post Success:
173 -- Processing continues.
174 --
175 -- Post Failure:
176 -- If a business rules fails the error will not be handled by this procedure
177 -- unless explicity coded.
178 --
179 -- Developer Implementation Notes:
180 -- For delete, your business rules should be executed from this procedure and
181 -- should ideally (unless really necessary) just be straight procedure or
182 -- function calls. Try and avoid using conditional branching logic.
183 --
184 -- Access Status:
185 -- Internal Row Handler Use Only.
186 --
187 -- {End Of Comments}
188 -- ----------------------------------------------------------------------------
189 Procedure delete_validate(p_rec in pay_ncr_shd.g_rec_type);
190 --
191 end pay_ncr_bus;