1 PACKAGE PAY_ELEMENT_SETS_PKG AUTHID CURRENT_USER as
2 /* $Header: pyels01t.pkh 120.0 2005/09/27 04:03:51 shisriva noship $ */
3 --
4 /*==========================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +===========================================================================+
9 Name
10 pay_element_sets_pkg
11 Purpose
12 Supports the ELS block in the form PAYWSDRP (Define Element and
13 Distributuion Set.
14 Notes
15
16 History
17 24-Mar-94 J.S.Hobbs 40.0 Date created.
18 26-Aug-05 Shisriva 115.1 Changes for MLS enabling.
19 Added extra parameter in update_row proc. and
20 New procedures - validate_translations,
21 add_language,
22 translate_row,
23 set_translation_globals
24 26-Sep-05 Shisriva 115.2 Added dbdrv commands.
25 26-Sep-05 Shisriva 115.3 Removed gscc violation for in out parameters.
26 Added NOCOPY for two parameters.
27 ============================================================================*/
28 --
29 --
30 g_dml_status boolean := FALSE; -- Global package variable
31 --
32 -----------------------------------------------------------------------------
33 -- Name --
34 -- lock_element_set --
35 -- Purpose --
36 -- Places a lock on the element set. --
37 -- Arguments --
38 -- See Be;ow. --
39 -- Notes --
40 -- Used when maintaining the members of an element set ie. when dealing --
41 -- with element type rules and classification rules. --
42 -----------------------------------------------------------------------------
43 --
44 procedure lock_element_set
45 (
46 p_element_set_id number
47 );
48 --
49 -----------------------------------------------------------------------------
50 -- Name --
51 -- chk_debit_or_credit --
52 -- Purpose --
53 -- When creating a distribution set all the elements within the set must --
54 -- have the same debit or credit status ie. the combination of element --
55 -- rules and classification rules should result in a set of elements --
56 -- that have the same debit or credit status. --
57 -- Arguments --
58 -- p_classification_id - If adding an element type rule then this is the --
59 -- classification_of the element being added. --
60 -- If adding a classification rule then this is --
61 -- classification_of of the classification being --
62 -- added. --
63 -- Notes --
64 -- This is used when adding element type or classification rules. --
65 -----------------------------------------------------------------------------
66 --
67 procedure chk_debit_or_credit
68 (
69 p_element_set_id number,
70 p_classification_id number
71 );
72 --
73 -----------------------------------------------------------------------------
74 -- Name --
75 -- Insert_Row --
76 -- Purpose --
77 -- Table handler procedure that supports the insert of an element set --
78 -- via the Define Element and Distributuion Set form. --
79 -- Arguments --
80 -- See below. --
81 -- Notes --
82 -- None. --
83 -----------------------------------------------------------------------------
84 --
85 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
86 X_Element_Set_Id IN OUT NOCOPY NUMBER,
87 X_Business_Group_Id NUMBER,
88 X_Legislation_Code VARCHAR2,
89 X_Element_Set_Name VARCHAR2,
90 X_Element_Set_Type VARCHAR2,
91 X_Comments VARCHAR2,
92 -- Extra Columns
93 X_Session_Business_Group_Id NUMBER,
94 X_Session_Legislation_Code VARCHAR2);
95
96 --
97 -----------------------------------------------------------------------------
98 -- Name --
99 -- Lock_Row --
100 -- Purpose --
101 -- Table handler procedure that supports the insert , update and delete --
102 -- of an element set by applying a lock on an element set within the --
103 -- Define Element and Distribution Set form. --
104 -- Arguments --
105 -- See below. --
106 -- None. --
107 -----------------------------------------------------------------------------
108 --
109 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
110 X_Element_Set_Id NUMBER,
111 X_Business_Group_Id NUMBER,
112 X_Legislation_Code VARCHAR2,
113 X_Element_Set_Name VARCHAR2,
114 X_Element_Set_Type VARCHAR2,
115 X_Comments VARCHAR2);
116 --
117 -----------------------------------------------------------------------------
118 -- Name --
119 -- Update_Row --
120 -- Purpose --
121 -- Table handler procedure that supports the update of an element set --
122 -- via the Define Element and Distributuion Set form. --
123 -- Arguments --
124 -- See below. --
125 -- Notes --
126 -- None. --
127 -----------------------------------------------------------------------------
128 --
129 PROCEDURE Update_Row(X_Rowid VARCHAR2,
130 X_Element_Set_Id NUMBER,
131 X_Business_Group_Id NUMBER,
132 X_Legislation_Code VARCHAR2,
133 X_Element_Set_Name VARCHAR2,
134 X_Element_Set_Type VARCHAR2,
135 X_Comments VARCHAR2,
136 -- Extra Columns
137 X_Session_Business_Group_Id NUMBER,
138 X_Session_Legislation_Code VARCHAR2,
139 X_Base_Element_Set_Name in varchar2 default hr_api.g_varchar2);
140 --
141 -----------------------------------------------------------------------------
142 -- Name --
143 -- Delete_Row --
144 -- Purpose --
145 -- Table handler procedure that supports the delete of an element set --
146 -- via the Define Element and Distributuion Set form. --
147 -- Arguments --
148 -- See below. --
149 -- Notes --
150 -- None. --
151 -----------------------------------------------------------------------------
152 --
153 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
154 -- Extra Columns
155 X_Element_Set_Id NUMBER,
156 X_Element_Set_Type VARCHAR2);
157 --
158 --MLS Additions--
159 --
160 procedure ADD_LANGUAGE;
161
162 procedure TRANSLATE_ROW (X_B_ELEMENT_SET_NAME in VARCHAR2,
163 X_B_LEGISLATION_CODE in VARCHAR2,
164 X_ELEMENT_SET_NAME in VARCHAR2,
165 X_OWNER in VARCHAR2);
166
167 procedure set_translation_globals( p_business_group_id IN NUMBER
168 , p_legislation_code IN NUMBER);
169
170 procedure validate_translation(element_set_id NUMBER,
171 language VARCHAR2,
172 element_set_name VARCHAR2,
173 p_business_group_id IN NUMBER DEFAULT NULL,
174 p_legislation_code IN VARCHAR2 DEFAULT NULL);
175
176 function return_dml_status return boolean;
177 ---
178 END PAY_ELEMENT_SETS_PKG;