1 Package per_rtl_bus as
2 /* $Header: pertlrhi.pkh 120.0 2005/05/31 19:57:51 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,competnce_id or step) have been altered.
28 --
29 -- Access Status:
30 -- Internal Table Handler Use Only.
31 --
32 --
33 Procedure chk_non_updateable_args(p_rec in per_rtl_shd.g_rec_type);
34 --
35 --
36 --
37 -- ----------------------------------------------------------------------------
38 -- |---------------------------< insert_validate >----------------------------|
39 -- ----------------------------------------------------------------------------
40 -- {Start Of Comments}
41 --
42 -- Description:
43 -- This procedure controls the execution of all insert business rules
44 -- validation.
45 --
46 -- Pre Conditions:
47 -- This private procedure is called from ins procedure.
48 --
49 -- In Parameters:
50 -- A Pl/Sql record structre.
51 --
52 -- Post Success:
53 -- Processing continues.
54 --
55 -- Post Failure:
56 -- If a business rules fails the error will not be handled by this procedure
57 -- unless explicity coded.
58 --
59 -- Developer Implementation Notes:
60 -- For insert, your business rules should be executed from this procedure and
61 -- should ideally (unless really necessary) just be straight procedure or
62 -- function calls. Try and avoid using conditional branching logic.
63 --
64 -- Access Status:
65 -- Internal Table Handler Use Only.
66 --
67 -- {End Of Comments}
68 -- ----------------------------------------------------------------------------
69 Procedure insert_validate(p_rec in per_rtl_shd.g_rec_type,
70 p_effective_date in date);
71 --
72 -- ----------------------------------------------------------------------------
73 -- |---------------------------< update_validate >----------------------------|
74 -- ----------------------------------------------------------------------------
75 -- {Start Of Comments}
76 --
77 -- Description:
78 -- This procedure controls the execution of all update business rules
79 -- validation.
80 --
81 -- Pre Conditions:
82 -- This private procedure is called from upd procedure.
83 --
84 -- In Parameters:
85 -- A Pl/Sql record structre.
86 --
87 -- Post Success:
88 -- Processing continues.
89 --
90 -- Post Failure:
91 -- If a business rules fails the error will not be handled by this procedure
92 -- unless explicity coded.
93 --
94 -- Developer Implementation Notes:
95 -- For update, your business rules should be executed from this procedure and
96 -- should ideally (unless really necessary) just be straight procedure or
97 -- function calls. Try and avoid using conditional branching logic.
98 --
99 -- Access Status:
100 -- Internal Table Handler Use Only.
101 --
102 -- {End Of Comments}
103 -- ----------------------------------------------------------------------------
104 Procedure update_validate(p_rec in per_rtl_shd.g_rec_type,
105 p_effective_date in date);
106 --
107 -- ----------------------------------------------------------------------------
108 -- |---------------------------< delete_validate >----------------------------|
109 -- ----------------------------------------------------------------------------
110 -- {Start Of Comments}
111 --
112 -- Description:
113 -- This procedure controls the execution of all delete business rules
114 -- validation.
115 --
116 -- Pre Conditions:
117 -- This private procedure is called from del procedure.
118 --
119 -- In Parameters:
120 -- A Pl/Sql record structre.
121 --
122 -- Post Success:
123 -- Processing continues.
124 --
125 -- Post Failure:
126 -- If a business rules fails the error will not be handled by this procedure
127 -- unless explicity coded.
128 --
129 -- Developer Implementation Notes:
130 -- For delete, your business rules should be executed from this procedure and
131 -- should ideally (unless really necessary) just be straight procedure or
132 -- function calls. Try and avoid using conditional branching logic.
133 --
134 -- Access Status:
135 -- Internal Table Handler Use Only.
136 --
137 -- {End Of Comments}
138 -- ----------------------------------------------------------------------------
139 Procedure delete_validate(p_rec in per_rtl_shd.g_rec_type);
140 --
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_levels)
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 Implementation Notes:
163 --
164 -- Access Status:
165 -- Internal Table Handler Use Only.
166 --
167 -- {End Of Comments}
168 --
169 Function return_legislation_code (
170 p_rating_level_id in number)
171 return varchar2;
172 --
173 --
174 end per_rtl_bus;