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