1 Package per_rsc_bus as
2 /* $Header: perscrhi.pkh 120.0 2005/05/31 19:46:21 appldev noship $ */
3 --
4 --
5 -- ----------------------------------------------------------------------------
6 -- |----------------------< check_non_updateable_args >-----------------------|
7 -- ----------------------------------------------------------------------------
8 -- {Start Of Comments}
9 --
10 -- Description:
11 -- This procedure is used to ensure that non updatetable attributes have
12 -- not been updated. If an attribute has been updated an error is generated.
13 --
14 -- Pre Conditions:
15 -- g_old_rec has been populated with details of the values currently in
16 -- the database.
17 --
18 -- In Arguments:
19 -- p_rec has been populated with the updated values the user would like the
20 --
21 -- Post Success:
22 -- Processing continues if all the non updateable attributes have not
23 -- changed.
24 --
25 -- Post Failure:
26 -- An application error is raised if any of the non updatable attributes
27 -- (business_group_id, rating_scale_id, name or type) have been altered.
28 --
29 -- Access Status:
30 -- Internal Table Handler Use Only.
31 --
32 --
33 --
34 --
35 Procedure check_non_updateable_args(p_rec in per_rsc_shd.g_rec_type);
36 --
37 --
38 -- ----------------------------------------------------------------------------
39 -- |---------------------------< insert_validate >----------------------------|
40 -- ----------------------------------------------------------------------------
41 -- {Start Of Comments}
42 --
43 -- Description:
44 -- This procedure controls the execution of all insert business rules
45 -- validation.
46 --
47 -- Pre Conditions:
48 -- This private procedure is called from ins procedure.
49 --
50 -- In Parameters:
51 -- A Pl/Sql record structre.
52 --
53 -- Post Success:
54 -- Processing continues.
55 --
56 -- Post Failure:
57 -- If a business rules fails the error will not be handled by this procedure
58 -- unless explicity coded.
59 --
60 -- Developer Implementation Notes:
61 -- For insert, your business rules should be executed from this procedure and
62 -- should ideally (unless really necessary) just be straight procedure or
63 -- function calls. Try and avoid using conditional branching logic.
64 --
65 -- Access Status:
66 -- Internal Table Handler Use Only.
67 --
68 -- {End Of Comments}
69 -- ----------------------------------------------------------------------------
70 Procedure insert_validate(p_rec in per_rsc_shd.g_rec_type
71 ,p_effective_date in date);
72 --
73 -- ----------------------------------------------------------------------------
74 -- |---------------------------< update_validate >----------------------------|
75 -- ----------------------------------------------------------------------------
76 -- {Start Of Comments}
77 --
78 -- Description:
79 -- This procedure controls the execution of all update business rules
80 -- validation.
81 --
82 -- Pre Conditions:
83 -- This private procedure is called from upd procedure.
84 --
85 -- In Parameters:
86 -- A Pl/Sql record structre.
87 --
88 -- Post Success:
89 -- Processing continues.
90 --
91 -- Post Failure:
92 -- If a business rules fails the error will not be handled by this procedure
93 -- unless explicity coded.
94 --
95 -- Developer Implementation Notes:
96 -- For update, your business rules should be executed from this procedure and
97 -- should ideally (unless really necessary) just be straight procedure or
98 -- function calls. Try and avoid using conditional branching logic.
99 --
100 -- Access Status:
101 -- Internal Table Handler Use Only.
102 --
103 -- {End Of Comments}
104 -- ----------------------------------------------------------------------------
105 Procedure update_validate(p_rec in per_rsc_shd.g_rec_type
106 ,p_effective_date in date);
107 --
108 -- ----------------------------------------------------------------------------
109 -- |---------------------------< delete_validate >----------------------------|
110 -- ----------------------------------------------------------------------------
111 -- {Start Of Comments}
112 --
113 -- Description:
114 -- This procedure controls the execution of all delete business rules
115 -- validation.
116 --
117 -- Pre Conditions:
118 -- This private procedure is called from del procedure.
119 --
120 -- In Parameters:
121 -- A Pl/Sql record structre.
122 --
123 -- Post Success:
124 -- Processing continues.
125 --
126 -- Post Failure:
127 -- If a business rules fails the error will not be handled by this procedure
128 -- unless explicity coded.
129 --
130 -- Developer Implementation Notes:
131 -- For delete, your business rules should be executed from this procedure and
132 -- should ideally (unless really necessary) just be straight procedure or
133 -- function calls. Try and avoid using conditional branching logic.
134 --
135 -- Access Status:
136 -- Internal Table Handler Use Only.
137 --
138 -- {End Of Comments}
139 -- ----------------------------------------------------------------------------
140 Procedure delete_validate(p_rec in per_rsc_shd.g_rec_type);
141 --
142 -- ----------------------------------------------------------------------------
143 -- |----------------------< return_legislation_code >--------------------------|
144 -- ----------------------------------------------------------------------------
145 -- {Start Of Comments}
146 --
147 -- Description:
148 -- This function gets the legislation code
149 --
150 -- Pre Conditions:
151 -- This private procedure will be called from the user hook procedures.
152 --
153 -- In Parameters:
154 -- the primary key of the table (per_rating_scales)
155 --
156 -- Post Success:
157 -- Processing continues.
158 --
159 -- Post Failure:
160 -- If the legislation code is not found then it errors out
161 --
162 -- Developer Iplementation Notes:
163 --
164 -- Access Status:
165 -- Internal Table Handler Use Only.
166 --
167 -- {End Of Coents}
168 --
169 Function return_legislation_code (
170 p_rating_scale_id in number)
171 return varchar2;
172 --
173 --
174 end per_rsc_bus;
[Home] [Help]