1 Package ben_opt_bus AUTHID CURRENT_USER as
2 /* $Header: beoptrhi.pkh 120.0 2005/05/28 09:56:49 appldev noship $ */
3 --
4 --
5 -- ---------------------------------------------------------------------------
6 -- |---------------------< return_legislation_code >-------------------------|
7 -- |---------------------< return_legislation_subgroup >-------------------------|
8 -- ---------------------------------------------------------------------------
9 --
10 -- Description:
11 -- Return the legislation code for a specific primary key value
12 --
13 -- Prerequisites:
14 -- The primary key identified by p_opt_id already exists.
15 --
16 -- In Arguments:
17 -- p_opt_id
18 --
19 -- Post Success:
20 -- If the value is found this function will return the values business
21 -- group legislation code.
22 --
23 -- Post Failure:
24 -- An error is raised if the value does not exist.
25 --
26 -- Access Status:
27 -- Internal Development Use Only.
28 --
29 function return_legislation_code
30
31 (p_opt_id in number) return varchar2;
32 --
33 --
34 -- ----------------------------------------------------------------------------
35 -- |---------------------------< insert_validate >----------------------------|
36 -- ----------------------------------------------------------------------------
37 -- {Start Of Comments}
38 --
39 -- Description:
40 -- This procedure controls the execution of all insert business rules
41 -- validation.
42 --
43 -- Prerequisites:
44 -- This private procedure is called from ins procedure.
45 --
46 -- In Parameters:
47 -- A Pl/Sql record structre.
48 --
49 -- Post Success:
50 -- Processing continues.
51 --
52 -- Post Failure:
53 -- If a business rules fails the error will not be handled by this procedure
54 -- unless explicity coded.
55 --
56 -- Developer Implementation Notes:
57 -- For insert, your business rules should be executed from this procedure and
58 -- should ideally (unless really necessary) just be straight procedure or
59 -- function calls. Try and avoid using conditional branching logic.
60 --
61 -- Access Status:
62 -- Internal Row Handler Use Only.
63 --
64 -- {End Of Comments}
65 -- ----------------------------------------------------------------------------
66 Procedure insert_validate
67 (p_rec in ben_opt_shd.g_rec_type,
68 p_effective_date in date,
69 p_datetrack_mode in varchar2,
70 p_validation_start_date in date,
71 p_validation_end_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 -- Prerequisites:
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 Row Handler Use Only.
102 --
103 -- {End Of Comments}
104 -- ----------------------------------------------------------------------------
105 Procedure update_validate
106 (p_rec in ben_opt_shd.g_rec_type,
107 p_effective_date in date,
108 p_datetrack_mode in varchar2,
109 p_validation_start_date in date,
110 p_validation_end_date in date);
111 --
112 -- ----------------------------------------------------------------------------
113 -- |---------------------------< delete_validate >----------------------------|
114 -- ----------------------------------------------------------------------------
115 -- {Start Of Comments}
116 --
117 -- Description:
118 -- This procedure controls the execution of all delete business rules
119 -- validation.
120 --
121 -- Prerequisites:
122 -- This private procedure is called from del procedure.
123 --
124 -- In Parameters:
125 -- A Pl/Sql record structre.
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 -- Developer Implementation Notes:
135 -- For delete, your business rules should be executed from this procedure and
136 -- should ideally (unless really necessary) just be straight procedure or
137 -- function calls. Try and avoid using conditional branching logic.
138 --
139 -- Access Status:
140 -- Internal Row Handler Use Only.
141 --
142 -- {End Of Comments}
143 -- ----------------------------------------------------------------------------
144 Procedure delete_validate
145 (p_rec in ben_opt_shd.g_rec_type,
146 p_effective_date in date,
147 p_datetrack_mode in varchar2,
148 p_validation_start_date in date,
149 p_validation_end_date in date);
150 --
151 end ben_opt_bus;
[Home] [Help]