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