1 Package ben_hwf_bus AUTHID CURRENT_USER as
2 /* $Header: behwfrhi.pkh 120.0 2005/05/28 03:12:24 appldev noship $ */
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_hrs_wkd_in_perd_fctr_id already exists.
14 --
15 -- In Arguments:
16 -- p_hrs_wkd_in_perd_fctr_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_hrs_wkd_in_perd_fctr_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(p_rec in ben_hwf_shd.g_rec_type
65 ,p_effective_date in date);
66 --
67 -- ----------------------------------------------------------------------------
68 -- |---------------------------< update_validate >----------------------------|
69 -- ----------------------------------------------------------------------------
70 -- {Start Of Comments}
71 --
72 -- Description:
73 -- This procedure controls the execution of all update business rules
74 -- validation.
75 --
76 -- Prerequisites:
77 -- This private procedure is called from upd procedure.
78 --
79 -- In Parameters:
80 -- A Pl/Sql record structre.
81 --
82 -- Post Success:
83 -- Processing continues.
84 --
85 -- Post Failure:
86 -- If a business rules fails the error will not be handled by this procedure
87 -- unless explicity coded.
88 --
89 -- Developer Implementation Notes:
90 -- For update, your business rules should be executed from this procedure and
91 -- should ideally (unless really necessary) just be straight procedure or
92 -- function calls. Try and avoid using conditional branching logic.
93 --
94 -- Access Status:
95 -- Internal Row Handler Use Only.
96 --
97 -- {End Of Comments}
98 -- ----------------------------------------------------------------------------
99 Procedure update_validate(p_rec in ben_hwf_shd.g_rec_type
100 ,p_effective_date in date);
101 --
102 -- ----------------------------------------------------------------------------
103 -- |---------------------------< delete_validate >----------------------------|
104 -- ----------------------------------------------------------------------------
105 -- {Start Of Comments}
106 --
107 -- Description:
108 -- This procedure controls the execution of all delete business rules
109 -- validation.
110 --
111 -- Prerequisites:
112 -- This private procedure is called from del procedure.
113 --
114 -- In Parameters:
115 -- A Pl/Sql record structre.
116 --
117 -- Post Success:
118 -- Processing continues.
119 --
120 -- Post Failure:
121 -- If a business rules fails the error will not be handled by this procedure
122 -- unless explicity coded.
123 --
124 -- Developer Implementation Notes:
125 -- For delete, your business rules should be executed from this procedure and
126 -- should ideally (unless really necessary) just be straight procedure or
127 -- function calls. Try and avoid using conditional branching logic.
128 --
129 -- Access Status:
130 -- Internal Row Handler Use Only.
131 --
132 -- {End Of Comments}
133 -- ----------------------------------------------------------------------------
134 Procedure delete_validate(p_rec in ben_hwf_shd.g_rec_type
135 ,p_effective_date in date);
136 --
137 end ben_hwf_bus;