1 Package ben_vrp_bus as
2 /* $Header: bevrprhi.pkh 120.0.12010000.1 2008/07/29 13:08:28 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_vald_rlshp_for_reimb_id already exists.
14 --
15 -- In Arguments:
16 -- p_vald_rlshp_for_reimb_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 (p_vald_rlshp_for_reimb_id in number) return varchar2;
30 --
31 --
32 -- ----------------------------------------------------------------------------
33 -- |---------------------------< insert_validate >----------------------------|
34 -- ----------------------------------------------------------------------------
35 -- {Start Of Comments}
36 --
37 -- Description:
38 -- This procedure controls the execution of all insert business rules
39 -- validation.
40 --
41 -- Prerequisites:
42 -- This private procedure is called from ins procedure.
43 --
44 -- In Parameters:
45 -- A Pl/Sql record structre.
46 --
47 -- Post Success:
48 -- Processing continues.
49 --
50 -- Post Failure:
51 -- If a business rules fails the error will not be handled by this procedure
52 -- unless explicity coded.
53 --
54 -- Developer Implementation Notes:
55 -- For insert, your business rules should be executed from this procedure and
56 -- should ideally (unless really necessary) just be straight procedure or
57 -- function calls. Try and avoid using conditional branching logic.
58 --
59 -- Access Status:
60 -- Internal Row Handler Use Only.
61 --
62 -- {End Of Comments}
63 -- ----------------------------------------------------------------------------
64 Procedure insert_validate
65 (p_rec in ben_vrp_shd.g_rec_type,
66 p_effective_date in date,
67 p_datetrack_mode in varchar2,
68 p_validation_start_date in date,
69 p_validation_end_date in date);
70 --
71 -- ----------------------------------------------------------------------------
72 -- |---------------------------< update_validate >----------------------------|
73 -- ----------------------------------------------------------------------------
74 -- {Start Of Comments}
75 --
76 -- Description:
77 -- This procedure controls the execution of all update business rules
78 -- validation.
79 --
80 -- Prerequisites:
81 -- This private procedure is called from upd procedure.
82 --
83 -- In Parameters:
84 -- A Pl/Sql record structre.
85 --
86 -- Post Success:
87 -- Processing continues.
88 --
89 -- Post Failure:
90 -- If a business rules fails the error will not be handled by this procedure
91 -- unless explicity coded.
92 --
93 -- Developer Implementation Notes:
94 -- For update, your business rules should be executed from this procedure and
95 -- should ideally (unless really necessary) just be straight procedure or
96 -- function calls. Try and avoid using conditional branching logic.
97 --
98 -- Access Status:
99 -- Internal Row Handler Use Only.
100 --
101 -- {End Of Comments}
102 -- ----------------------------------------------------------------------------
103 Procedure update_validate
104 (p_rec in ben_vrp_shd.g_rec_type,
105 p_effective_date in date,
106 p_datetrack_mode in varchar2,
107 p_validation_start_date in date,
108 p_validation_end_date in date);
109 --
110 -- ----------------------------------------------------------------------------
111 -- |---------------------------< delete_validate >----------------------------|
112 -- ----------------------------------------------------------------------------
113 -- {Start Of Comments}
114 --
115 -- Description:
116 -- This procedure controls the execution of all delete business rules
117 -- validation.
118 --
119 -- Prerequisites:
120 -- This private procedure is called from del procedure.
121 --
122 -- In Parameters:
123 -- A Pl/Sql record structre.
124 --
125 -- Post Success:
126 -- Processing continues.
127 --
128 -- Post Failure:
129 -- If a business rules fails the error will not be handled by this procedure
130 -- unless explicity coded.
131 --
132 -- Developer Implementation Notes:
133 -- For delete, your business rules should be executed from this procedure and
134 -- should ideally (unless really necessary) just be straight procedure or
135 -- function calls. Try and avoid using conditional branching logic.
136 --
137 -- Access Status:
138 -- Internal Row Handler Use Only.
139 --
140 -- {End Of Comments}
141 -- ----------------------------------------------------------------------------
142 Procedure delete_validate
143 (p_rec in ben_vrp_shd.g_rec_type,
144 p_effective_date in date,
145 p_datetrack_mode in varchar2,
146 p_validation_start_date in date,
147 p_validation_end_date in date);
148 --
149 end ben_vrp_bus;