1 Package pay_cnt_bus AUTHID CURRENT_USER as
2 /* $Header: pycntrhi.pkh 120.2 2011/07/06 11:53:16 nkjaladi ship $ */
3 --
4 --
5 -- ----------------------------------------------------------------------------
6 -- | Global Definitions - Internal Development Use Only |
7 -- ----------------------------------------------------------------------------
8 g_cnt_tax_rule_id pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
9 default null;
10 g_legislation_code varchar2(150) default null;
11 --
12 -- ---------------------------------------------------------------------------
13 -- |---------------------< return_legislation_code >-------------------------|
14 -- ---------------------------------------------------------------------------
15 --
16 -- Description:
17 -- Return the legislation code for a specific primary key value
18 --
19 -- Prerequisites:
20 -- The primary key identified by p_emp_county_tax_rule_id already exists.
21 --
22 -- In Arguments:
23 -- p_emp_county_tax_rule_id
24 --
25 -- Post Success:
26 -- If the value is found this function will return the values business
27 -- group legislation code.
28 --
29 -- Post Failure:
30 -- An error is raised if the value does not exist.
31 --
32 -- Access Status:
33 -- Internal Development Use Only.
34 --
35 function return_legislation_code
36 (p_emp_county_tax_rule_id in number) return varchar2;
37 --
38 --
39 -- ----------------------------------------------------------------------------
40 -- |---------------------------< insert_validate >----------------------------|
41 -- ----------------------------------------------------------------------------
42 -- {Start Of Comments}
43 --
44 -- Description:
45 -- This procedure controls the execution of all insert business rules
46 -- validation.
47 --
48 -- Prerequisites:
49 -- This private procedure is called from ins procedure.
50 --
51 -- In Parameters:
52 -- A Pl/Sql record structre.
53 --
54 -- Post Success:
55 -- Processing continues.
56 --
57 -- Post Failure:
58 -- If a business rules fails the error will not be handled by this procedure
59 -- unless explicitly coded.
60 --
61 -- Developer Implementation Notes:
62 -- For insert, your business rules should be executed from this procedure and
63 -- should ideally (unless really necessary) just be straight procedure or
64 -- function calls. Try and avoid using conditional branching logic.
65 --
66 -- Access Status:
67 -- Internal Row Handler Use Only.
68 --
69 -- {End Of Comments}
70 -- ----------------------------------------------------------------------------
71 Procedure insert_validate
72 (p_rec in pay_cnt_shd.g_rec_type,
73 p_effective_date in date,
74 p_datetrack_mode in varchar2,
75 p_validation_start_date in date,
76 p_validation_end_date in date);
77 --
78 -- ----------------------------------------------------------------------------
79 -- |---------------------------< update_validate >----------------------------|
80 -- ----------------------------------------------------------------------------
81 -- {Start Of Comments}
82 --
83 -- Description:
84 -- This procedure controls the execution of all update business rules
85 -- validation.
86 --
87 -- Prerequisites:
88 -- This private procedure is called from upd procedure.
89 --
90 -- In Parameters:
91 -- A Pl/Sql record structre.
92 --
93 -- Post Success:
94 -- Processing continues.
95 --
96 -- Post Failure:
97 -- If a business rules fails the error will not be handled by this procedure
98 -- unless explicitly coded.
99 --
100 -- Developer Implementation Notes:
101 -- For update, your business rules should be executed from this procedure and
102 -- should ideally (unless really necessary) just be straight procedure or
103 -- function calls. Try and avoid using conditional branching logic.
104 --
105 -- Access Status:
106 -- Internal Row Handler Use Only.
107 --
108 -- {End Of Comments}
109 -- ----------------------------------------------------------------------------
110 Procedure update_validate
111 (p_rec in pay_cnt_shd.g_rec_type,
112 p_effective_date in date,
113 p_datetrack_mode in varchar2,
114 p_validation_start_date in date,
115 p_validation_end_date in date);
116 --
117 -- ----------------------------------------------------------------------------
118 -- |---------------------------< delete_validate >----------------------------|
119 -- ----------------------------------------------------------------------------
120 -- {Start Of Comments}
121 --
122 -- Description:
123 -- This procedure controls the execution of all delete business rules
124 -- validation.
125 --
126 -- Prerequisites:
127 -- This private procedure is called from del procedure.
128 --
129 -- In Parameters:
130 -- A Pl/Sql record structre.
131 --
132 -- Post Success:
133 -- Processing continues.
134 --
135 -- Post Failure:
136 -- If a business rules fails the error will not be handled by this procedure
137 -- unless explicitly coded.
138 --
139 -- Developer Implementation Notes:
140 -- For delete, your business rules should be executed from this procedure and
141 -- should ideally (unless really necessary) just be straight procedure or
142 -- function calls. Try and avoid using conditional branching logic.
143 --
144 -- Access Status:
145 -- Internal Row Handler Use Only.
146 --
147 -- {End Of Comments}
148 -- ----------------------------------------------------------------------------
149 Procedure delete_validate
150 (p_rec in pay_cnt_shd.g_rec_type,
151 p_effective_date in date,
152 p_datetrack_mode in varchar2,
153 p_delete_routine in varchar2,
154 p_validation_start_date in date,
155 p_validation_end_date in date);
156 --
157 end pay_cnt_bus;