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