1 Package ben_dpnt_egd_bus AUTHID CURRENT_USER as
2
3 --
4 --
5 /*
6 -- ---------------------------------------------------------------------------
7 -- |---------------------< return_legislation_code >-------------------------|
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_eligy_criteria_id already exists.
15 --
16 -- In Arguments:
17 -- p_eligy_criteria_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 (p_eligy_criteria_dpnt_id in number) return varchar2;
31 */
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(p_rec in ben_dpnt_egd_shd.g_rec_type
67 ,p_effective_date in date);
68 --
69 -- ----------------------------------------------------------------------------
70 -- |---------------------------< update_validate >----------------------------|
71 -- ----------------------------------------------------------------------------
72 -- {Start Of Comments}
73 --
74 -- Description:
75 -- This procedure controls the execution of all update business rules
76 -- validation.
77 --
78 -- Prerequisites:
79 -- This private procedure is called from upd 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 update, 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 update_validate(p_rec in ben_dpnt_egd_shd.g_rec_type
102 ,p_effective_date in date);
103 --
104 -- ----------------------------------------------------------------------------
105 -- |---------------------------< delete_validate >----------------------------|
106 -- ----------------------------------------------------------------------------
107 -- {Start Of Comments}
108 --
109 -- Description:
110 -- This procedure controls the execution of all delete business rules
111 -- validation.
112 --
113 -- Prerequisites:
114 -- This private procedure is called from del procedure.
115 --
116 -- In Parameters:
117 -- A Pl/Sql record structre.
118 --
119 -- Post Success:
120 -- Processing continues.
121 --
122 -- Post Failure:
123 -- If a business rules fails the error will not be handled by this procedure
124 -- unless explicity coded.
125 --
126 -- Developer Implementation Notes:
127 -- For delete, your business rules should be executed from this procedure and
128 -- should ideally (unless really necessary) just be straight procedure or
129 -- function calls. Try and avoid using conditional branching logic.
130 --
131 -- Access Status:
132 -- Internal Row Handler Use Only.
133 --
134 -- {End Of Comments}
135 -- ----------------------------------------------------------------------------
136 Procedure delete_validate(p_rec in ben_dpnt_egd_shd.g_rec_type
137 ,p_effective_date in date);
138 --
139 end ben_dpnt_egd_bus;