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