1 Package ben_bdi_bus as
2 /* $Header: bebdirhi.pkh 120.0.12000000.1 2007/01/19 00:50:01 appldev noship $ */
3 --
4 -- ---------------------------------------------------------------------------
5 -- |---------------------< return_legislation_code >-------------------------|
6 -- ---------------------------------------------------------------------------
7 --
8 -- Description:
9 -- Return the legislation code for a specific primary key value
10 --
11 -- Prerequisites:
12 -- The primary key identified by p_batch_dpnt_id already exists.
13 --
14 -- In Arguments:
15 -- p_batch_dpnt_id
16 --
17 -- Post Success:
18 -- If the value is found this function will return the values business
19 -- group legislation code.
20 --
21 -- Post Failure:
22 -- An error is raised if the value does not exist.
23 --
24 -- Access Status:
25 -- Internal Development Use Only.
26 --
27 function return_legislation_code
28 (p_batch_dpnt_id in number) return varchar2;
29 --
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_bdi_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_bdi_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_bdi_shd.g_rec_type
134 ,p_effective_date in date);
135 --
136 end ben_bdi_bus;