1 Package pay_pwr_bus as
2 /* $Header: pypwrrhi.pkh 120.0 2005/05/29 08:09:25 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_rate_id already exists.
14 --
15 -- In Arguments:
16 -- p_rate_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_rate_id in number) return varchar2;
30 --
31 --
32 -- ----------------------------------------------------------------------------
33 --|----------------------------<chk_rate_code>--------------------------------|
34 -- ----------------------------------------------------------------------------
35 -- Description : This function is used to validate a new Rate Code (just code in
36 -- the table pay_wci_rates.
37 -- Validation : A rate code must be unique within an Account Number.
38 -- On Failure : Raise message 'The Rate Code you have entered already exists
39 -- within the current Account Number. Enter a different Rate
40 -- Code.
41 -- ----------------------------------------------------------------------------
42 FUNCTION chk_valid_rate_code (p_rate_code in varchar2
43 ,p_account_id in number
44 ,p_business_group_id in number)
45 RETURN BOOLEAN;
46 -------------------------------------------------------------------------------
47 -- ----------------------------------------------------------------------------
48 -- |---------------------------< insert_validate >----------------------------|
49 -- ----------------------------------------------------------------------------
50 -- {Start Of Comments}
51 --
52 -- Description:
53 -- This procedure controls the execution of all insert business rules
54 -- validation.
55 --
56 -- Prerequisites:
57 -- This private procedure is called from ins procedure.
58 --
59 -- In Parameters:
60 -- A Pl/Sql record structre.
61 --
62 -- Post Success:
63 -- Processing continues.
64 --
65 -- Post Failure:
66 -- If a business rules fails the error will not be handled by this procedure
67 -- unless explicity coded.
68 --
69 -- Developer Implementation Notes:
70 -- For insert, your business rules should be executed from this procedure and
71 -- should ideally (unless really necessary) just be straight procedure or
72 -- function calls. Try and avoid using conditional branching logic.
73 --
74 -- Access Status:
75 -- Internal Row Handler Use Only.
76 --
77 -- {End Of Comments}
78 -- ----------------------------------------------------------------------------
79 Procedure insert_validate(p_rec in pay_pwr_shd.g_rec_type);
80 --
81 -- ----------------------------------------------------------------------------
82 -- |---------------------------< update_validate >----------------------------|
83 -- ----------------------------------------------------------------------------
84 -- {Start Of Comments}
85 --
86 -- Description:
87 -- This procedure controls the execution of all update business rules
88 -- validation.
89 --
90 -- Prerequisites:
91 -- This private procedure is called from upd procedure.
92 --
93 -- In Parameters:
94 -- A Pl/Sql record structre.
95 --
96 -- Post Success:
97 -- Processing continues.
98 --
99 -- Post Failure:
100 -- If a business rules fails the error will not be handled by this procedure
101 -- unless explicity coded.
102 --
103 -- Developer Implementation Notes:
104 -- For update, your business rules should be executed from this procedure and
105 -- should ideally (unless really necessary) just be straight procedure or
106 -- function calls. Try and avoid using conditional branching logic.
107 --
108 -- Access Status:
109 -- Internal Row Handler Use Only.
110 --
111 -- {End Of Comments}
112 -- ----------------------------------------------------------------------------
113 Procedure update_validate(p_rec in pay_pwr_shd.g_rec_type);
114 --
115 -- ----------------------------------------------------------------------------
116 -- |---------------------------< delete_validate >----------------------------|
117 -- ----------------------------------------------------------------------------
118 -- {Start Of Comments}
119 --
120 -- Description:
121 -- This procedure controls the execution of all delete business rules
122 -- validation.
123 --
124 -- Prerequisites:
125 -- This private procedure is called from del procedure.
126 --
127 -- In Parameters:
128 -- A Pl/Sql record structre.
129 --
130 -- Post Success:
131 -- Processing continues.
132 --
133 -- Post Failure:
134 -- If a business rules fails the error will not be handled by this procedure
135 -- unless explicity coded.
136 --
137 -- Developer Implementation Notes:
138 -- For delete, your business rules should be executed from this procedure and
139 -- should ideally (unless really necessary) just be straight procedure or
140 -- function calls. Try and avoid using conditional branching logic.
141 --
142 -- Access Status:
143 -- Internal Row Handler Use Only.
144 --
145 -- {End Of Comments}
146 -- ----------------------------------------------------------------------------
147 Procedure delete_validate(p_rec in pay_pwr_shd.g_rec_type);
148 --
149 end pay_pwr_bus;