1 PACKAGE hr_balances AUTHID CURRENT_USER AS
2 /* $Header: pybalnce.pkh 120.0 2005/05/29 03:15:33 appldev noship $ */
3 --
4 /*
5 /*
6
7 ******************************************************************
8 * *
9 * Copyright (C) 1989 Oracle Corporation UK Ltd., *
10 * Richmond, England. *
11 * *
12 * All rights reserved. *
13 * *
14 * This material has been provided pursuant to an agreement *
15 * containing restrictions on its use. The material is also *
16 * protected by copyright law. No part of this material may *
17 * be copied or distributed, transmitted or transcribed, in *
18 * any form or by any means, electronic, mechanical, magnetic, *
19 * manual, or otherwise, or disclosed to third parties without *
20 * the express written permission of Oracle Corporation UK Ltd, *
21 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
22 * England. *
23 * *
24 ******************************************************************
25
26 Name : hr_balances
27
28 Description : This package holds procedures and functions related to the
29 following tables :
30
31 PAY_ELEMENT_TYPES_F
32 PAY_INPUT_VALUES_F
33 PAY_SUB_CLASSIFICATION_RULES_F
34 PAY_BALANCE_FEEDS_F
35 PAY_BALANCE_TYPES
36 PAY_BALANCE_CLASSIFCIATIONS
37 PAY_DEFINED_BALANCES
38
39 Uses : hr_utility
40 Used By : hr_input_values
41 : hr_elements
42
43 Change List
44 -----------
45 Date Name Vers Bug No Description
46 ---- ---- ---- ------ -----------
47 07-DEC-92 NLBarlow 1.00 Added comments.
48 29-DEC-92 NLBarlow 1.01 Added business group
49 and legislation code.
50 11-JAN-93 NLBarlow 1.02 Added startup code.
51 20-JAN-93 NLBarlow 1.03 Change in Standards.
52 08-FEB-93 NLBarlow 1.04 Added Delete Next Change
53 and optimised.
54 11-MAR-93 HMINTON 1.05 Added exit at end.
55 28-MAR-94 R.Neale 40.02 Added header info
56 08-NOV-99 meshah 115.1 Added new function decode_balance.
57 --
58 */
59 /*
60 NAME
61 ins_balance_feed
62 DESCRIPTION
63 Insert balance feeds.
64 */
65 --
66 PROCEDURE ins_balance_feed
67 (p_option in varchar2,
68 p_input_value_id in number,
69 p_element_type_id in number,
70 p_primary_classification_id in number,
71 p_sub_classification_id in number,
72 p_sub_classification_rule_id in number,
73 p_balance_type_id in number,
74 p_scale in varchar2,
75 p_session_date in date,
76 p_business_group in varchar2,
77 p_legislation_code in varchar2,
78 p_mode in varchar2);
79 --
80 /*
81 NAME
82 upd_balance_feed
83 DESCRIPTION
84 Updated balance feeds.
85 */
86 --
87 PROCEDURE upd_balance_feed
88 (p_option in varchar2,
89 p_balance_feed_id in number,
90 p_primary_classification_id in number,
91 p_sub_classification_id in number,
92 p_balance_type_id in number,
93 p_scale in varchar2,
94 p_legislation_code in varchar2);
95 --
96 /*
97 NAME
98 chk_del_balance_feed
99 DESCRIPTION
100 checks to see if it is permissable to delete balance feeds displayed on
101 the element type form. This will not be allowed if the balance feed has
102 been created by a balance classification.
103 */
104 PROCEDURE chk_del_balance_feed
105 (p_balance_feed_id in number,
106 p_balance_type_id in number);
107 /*
108 NAME
109 del_balance_feed
110 DESCRIPTION
111 Delete balance feeds.
112 */
113 --
114 PROCEDURE del_balance_feed
115 (p_option in varchar2,
116 p_delete_mode in varchar2,
117 p_balance_feed_id in number,
118 p_input_value_id in number,
119 p_element_type_id in number,
120 p_primary_classification_id in number,
121 p_sub_classification_id in number,
122 p_sub_classification_rule_id in number,
123 p_balance_type_id in number,
124 p_session_date in date,
125 p_effective_end_date in date,
126 p_legislation_code in varchar2,
127 p_mode in varchar2);
128 --
129 /*
130 NAME
131 del_balance_type_cascade
132 DESCRIPTION
133 Cascade delete children records of balance type record,
134 Balance dimensions, Balance classifications, Balance feeds.
135 */
136 --
137 PROCEDURE del_balance_type_cascade
138 (p_balance_type_id in number,
139 p_legislation_code in varchar2,
140 p_mode in varchar2);
141 --
142 /*
143 NAME
144 chk_ins_sub_class_rules
145 DESCRIPTION
146 Checks to see if it is ok to insert a sub classification rule. If it
147 is then a new end date will be returned. This will be either the last
148 end date of the element type or the last date the rule will not
149 overlap with another sub_classification_rule.
150 */
151 FUNCTION chk_ins_sub_class_rules(
152 p_sub_class_rule_id number,
153 p_element_type_id number,
154 p_classification_id number,
155 p_session_date date) return date;
156 --
157 --
158 /*
159 NAME
160 chk_ins_balance_feed
161 DESCRIPTION
162 Checks to see if it is ok to insert a manual balance feed. If it
163 is then a new end date will be returned. This will be either the last
164 end date of the element type or the last date the feed will not
165 overlap with another balance feed.
166 */
167 FUNCTION chk_ins_balance_feed(
168 p_balance_feed_id number,
169 p_input_value_id number,
170 p_balance_type_id number,
171 p_session_date date) return date;
172 --
173
174 /*
175 NAME
176 decode_balance
177 DESCRIPTION
178 This function looks in the table pay_balance_types_tl for balance type id passed to
179 the function. This function is called for the creation of the view
180 pay_us_earnings_amounts_v which is in the payusblv.odf.
181 */
182
183 FUNCTION decode_balance( p_balance_type_id number) return varchar2;
184 --
185
186 END hr_balances;