1 Package ben_pln_bus as
2 /* $Header: beplnrhi.pkh 120.2.12010000.1 2008/07/29 12:51:04 appldev ship $ */
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_pl_id already exists.
14 --
15 -- In Arguments:
16 -- p_pl_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
30 (p_pl_id in number) return varchar2;
31 --
32 --
33 -- ----------------------------------------------------------------------------
34 -- |---------------------------< insert_validate >----------------------------|
35 -- ----------------------------------------------------------------------------
36 -- {Start Of Comments}
37 --
38 -- Description:
39 -- This procedure controls the execution of all insert business rules
40 -- validation.
41 --
42 -- Prerequisites:
43 -- This private procedure is called from ins procedure.
44 --
45 -- In Parameters:
46 -- A Pl/Sql record structre.
47 --
48 -- Post Success:
49 -- Processing continues.
50 --
51 -- Post Failure:
52 -- If a business rules fails the error will not be handled by this procedure
53 -- unless explicity coded.
54 --
55 -- Developer Implementation Notes:
56 -- For insert, your business rules should be executed from this procedure and
57 -- should ideally (unless really necessary) just be straight procedure or
58 -- function calls. Try and avoid using conditional branching logic.
59 --
60 -- Access Status:
61 -- Internal Row Handler Use Only.
62 --
63 -- {End Of Comments}
64 -- ----------------------------------------------------------------------------
65 Procedure insert_validate
66 (p_rec in ben_pln_shd.g_rec_type,
67 p_effective_date in date,
68 p_datetrack_mode in varchar2,
69 p_validation_start_date in date,
70 p_validation_end_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 -- Prerequisites:
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 Row Handler Use Only.
101 --
102 -- {End Of Comments}
103 -- ----------------------------------------------------------------------------
104 Procedure update_validate
105 (p_rec in ben_pln_shd.g_rec_type,
106 p_effective_date in date,
107 p_datetrack_mode in varchar2,
108 p_validation_start_date in date,
109 p_validation_end_date in date);
110 --
111 -- ----------------------------------------------------------------------------
112 -- |---------------------------< delete_validate >----------------------------|
113 -- ----------------------------------------------------------------------------
114 -- {Start Of Comments}
115 --
116 -- Description:
117 -- This procedure controls the execution of all delete business rules
118 -- validation.
119 --
120 -- Prerequisites:
121 -- This private procedure is called from del procedure.
122 --
123 -- In Parameters:
124 -- A Pl/Sql record structre.
125 --
126 -- Post Success:
127 -- Processing continues.
128 --
129 -- Post Failure:
130 -- If a business rules fails the error will not be handled by this procedure
131 -- unless explicity coded.
132 --
133 -- Developer Implementation Notes:
134 -- For delete, your business rules should be executed from this procedure and
135 -- should ideally (unless really necessary) just be straight procedure or
136 -- function calls. Try and avoid using conditional branching logic.
137 --
138 -- Access Status:
139 -- Internal Row Handler Use Only.
140 --
141 -- {End Of Comments}
142 -- ----------------------------------------------------------------------------
143 Procedure delete_validate
144 (p_rec in ben_pln_shd.g_rec_type,
145 p_effective_date in date,
146 p_datetrack_mode in varchar2,
147 p_validation_start_date in date,
148 p_validation_end_date in date);
149 --
150
151 --
152 -- ----------------------------------------------------------------------------
153 -- |---------------------------< chk_pl_group_id >----------------------------|
154 -- ----------------------------------------------------------------------------
155 -- The call to this procedure is moved from insert_validate to pre_insert
156 -- Bug : 3460429
157 Procedure chk_pl_group_id(p_pl_id in number,
158 p_group_pl_id in number,
159 p_pl_typ_id in number,
160 p_effective_date in date,
161 p_name in varchar2 /* Bug 4057566 */
162 );
163 --
164 end ben_pln_bus;
[Home] [Help]