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