1 PACKAGE PSB_PAY_ELEMENTS_PVT AS
2 /* $Header: PSBVELMS.pls 120.2 2005/07/13 11:24:42 shtripat ship $ */
3
4
5 PROCEDURE INSERT_ROW
6 ( p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8 p_commit IN VARCHAR2 := FND_API.G_FALSE,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 p_return_status OUT NOCOPY VARCHAR2,
11 p_msg_count OUT NOCOPY NUMBER,
12 p_msg_data OUT NOCOPY VARCHAR2,
13 --
14 P_ROW_ID in OUT NOCOPY VARCHAR2,
15 P_PAY_ELEMENT_ID in NUMBER,
16 P_BUSINESS_GROUP_ID in NUMBER,
17 P_DATA_EXTRACT_ID in NUMBER,
18 P_BUDGET_SET_ID in NUMBER := FND_API.G_MISS_NUM,
19 P_NAME in VARCHAR2,
20 P_DESCRIPTION in VARCHAR2,
21 P_ELEMENT_VALUE_TYPE in VARCHAR2,
22 P_FORMULA_ID in NUMBER,
23 P_OVERWRITE_FLAG in VARCHAR2,
24 P_REQUIRED_FLAG in VARCHAR2,
25 P_FOLLOW_SALARY in VARCHAR2,
26 P_PAY_BASIS IN VARCHAR2,
27 P_START_DATE in DATE,
28 P_END_DATE in DATE,
29 P_PROCESSING_TYPE in VARCHAR2,
30 P_PERIOD_TYPE in VARCHAR2,
31 P_PROCESS_PERIOD_TYPE in VARCHAR2,
32 P_MAX_ELEMENT_VALUE_TYPE in VARCHAR2,
33 P_MAX_ELEMENT_VALUE in NUMBER,
34 P_SALARY_FLAG in VARCHAR2,
35 P_SALARY_TYPE in VARCHAR2,
36 P_OPTION_FLAG in VARCHAR2,
37 P_HR_ELEMENT_TYPE_ID in NUMBER,
38 P_ATTRIBUTE_CATEGORY in VARCHAR2,
39 P_ATTRIBUTE1 in VARCHAR2,
40 P_ATTRIBUTE2 in VARCHAR2,
41 P_ATTRIBUTE3 in VARCHAR2,
42 P_ATTRIBUTE4 in VARCHAR2,
43 P_ATTRIBUTE5 in VARCHAR2,
44 P_ATTRIBUTE6 in VARCHAR2,
45 P_ATTRIBUTE7 in VARCHAR2,
46 P_ATTRIBUTE8 in VARCHAR2,
47 P_ATTRIBUTE9 in VARCHAR2,
48 P_ATTRIBUTE10 in VARCHAR2,
49 P_LAST_UPDATE_DATE in DATE,
50 P_LAST_UPDATED_BY in NUMBER,
51 P_LAST_UPDATE_LOGIN in NUMBER,
52 P_CREATED_BY in NUMBER,
53 P_CREATION_DATE in DATE
54 );
55
56 PROCEDURE UPDATE_ROW
57 ( p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59 p_commit IN VARCHAR2 := FND_API.G_FALSE,
60 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61 p_return_status OUT NOCOPY VARCHAR2,
62 p_msg_count OUT NOCOPY NUMBER,
63 p_msg_data OUT NOCOPY VARCHAR2,
64 --
65 P_ROW_ID in VARCHAR2,
66 P_PAY_ELEMENT_ID in NUMBER,
67 P_BUSINESS_GROUP_ID in NUMBER,
68 P_DATA_EXTRACT_ID in NUMBER,
69 P_BUDGET_SET_ID in NUMBER := FND_API.G_MISS_NUM,
70 P_NAME in VARCHAR2,
71 P_DESCRIPTION in VARCHAR2,
72 P_ELEMENT_VALUE_TYPE in VARCHAR2,
73 P_FORMULA_ID in NUMBER,
74 P_OVERWRITE_FLAG in VARCHAR2,
75 P_REQUIRED_FLAG in VARCHAR2,
76 P_FOLLOW_SALARY in VARCHAR2,
77 P_PAY_BASIS IN VARCHAR2,
78 P_START_DATE in DATE,
79 P_END_DATE in DATE,
80 P_PROCESSING_TYPE in VARCHAR2,
81 P_PERIOD_TYPE in VARCHAR2,
82 P_PROCESS_PERIOD_TYPE in VARCHAR2,
83 P_MAX_ELEMENT_VALUE_TYPE in VARCHAR2,
84 P_MAX_ELEMENT_VALUE in NUMBER,
85 P_SALARY_FLAG in VARCHAR2,
86 P_SALARY_TYPE in VARCHAR2,
87 P_OPTION_FLAG in VARCHAR2,
88 P_HR_ELEMENT_TYPE_ID in NUMBER,
89 P_ATTRIBUTE_CATEGORY in VARCHAR2,
90 P_ATTRIBUTE1 in VARCHAR2,
91 P_ATTRIBUTE2 in VARCHAR2,
92 P_ATTRIBUTE3 in VARCHAR2,
93 P_ATTRIBUTE4 in VARCHAR2,
94 P_ATTRIBUTE5 in VARCHAR2,
95 P_ATTRIBUTE6 in VARCHAR2,
96 P_ATTRIBUTE7 in VARCHAR2,
97 P_ATTRIBUTE8 in VARCHAR2,
98 P_ATTRIBUTE9 in VARCHAR2,
99 P_ATTRIBUTE10 in VARCHAR2,
100 P_LAST_UPDATE_DATE in DATE,
101 P_LAST_UPDATED_BY in NUMBER,
102 P_LAST_UPDATE_LOGIN in NUMBER
103 );
104
105 PROCEDURE DELETE_ROW
106 ( p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108 p_commit IN VARCHAR2 := FND_API.G_FALSE,
109 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110 p_return_status OUT NOCOPY VARCHAR2,
111 p_msg_count OUT NOCOPY NUMBER,
112 p_msg_data OUT NOCOPY VARCHAR2,
113 --
114 P_ROW_ID IN VARCHAR2
115 );
116
117 PROCEDURE LOCK_ROW
118 ( p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120 p_commit IN VARCHAR2 := FND_API.G_FALSE,
121 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122 p_return_status OUT NOCOPY VARCHAR2,
123 p_msg_count OUT NOCOPY NUMBER,
124 p_msg_data OUT NOCOPY VARCHAR2,
125 --
126 p_row_locked OUT NOCOPY VARCHAR2,
127 --
128 P_ROW_ID in VARCHAR2,
129 P_PAY_ELEMENT_ID in NUMBER,
130 P_BUSINESS_GROUP_ID in NUMBER,
131 P_DATA_EXTRACT_ID in NUMBER,
132 P_BUDGET_SET_ID in NUMBER := FND_API.G_MISS_NUM,
133 P_NAME in VARCHAR2,
134 P_DESCRIPTION in VARCHAR2,
135 P_ELEMENT_VALUE_TYPE in VARCHAR2,
136 P_FORMULA_ID in NUMBER,
137 P_OVERWRITE_FLAG in VARCHAR2,
138 P_REQUIRED_FLAG in VARCHAR2,
139 P_FOLLOW_SALARY in VARCHAR2,
140 P_PAY_BASIS IN VARCHAR2,
141 P_START_DATE in DATE,
142 P_END_DATE in DATE,
143 P_PROCESSING_TYPE in VARCHAR2,
144 P_PERIOD_TYPE in VARCHAR2,
145 P_PROCESS_PERIOD_TYPE in VARCHAR2,
146 P_MAX_ELEMENT_VALUE_TYPE in VARCHAR2,
147 P_MAX_ELEMENT_VALUE in NUMBER,
148 P_SALARY_FLAG in VARCHAR2,
149 P_SALARY_TYPE in VARCHAR2,
150 P_OPTION_FLAG in VARCHAR2,
151 P_HR_ELEMENT_TYPE_ID in NUMBER,
152 P_ATTRIBUTE_CATEGORY in VARCHAR2,
153 P_ATTRIBUTE1 in VARCHAR2,
154 P_ATTRIBUTE2 in VARCHAR2,
155 P_ATTRIBUTE3 in VARCHAR2,
156 P_ATTRIBUTE4 in VARCHAR2,
157 P_ATTRIBUTE5 in VARCHAR2,
158 P_ATTRIBUTE6 in VARCHAR2,
159 P_ATTRIBUTE7 in VARCHAR2,
160 P_ATTRIBUTE8 in VARCHAR2,
161 P_ATTRIBUTE9 in VARCHAR2,
162 P_ATTRIBUTE10 in VARCHAR2
163 );
164
165 PROCEDURE Check_Unique
166 (
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
169 p_commit IN VARCHAR2 := FND_API.G_FALSE,
170 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171 p_return_status OUT NOCOPY VARCHAR2,
172 p_msg_count OUT NOCOPY NUMBER,
173 p_msg_data OUT NOCOPY VARCHAR2,
174 --
175 P_Row_Id IN VARCHAR2,
176 P_Name IN VARCHAR2,
177 P_DATA_EXTRACT_ID IN NUMBER,
178 P_Return_Value IN OUT NOCOPY VARCHAR2
179 );
180
181 PROCEDURE Check_References
182 (
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185 p_commit IN VARCHAR2 := FND_API.G_FALSE,
186 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187 p_return_status OUT NOCOPY VARCHAR2,
188 p_msg_count OUT NOCOPY NUMBER,
189 p_msg_data OUT NOCOPY VARCHAR2,
190 --
191 P_PAY_ELEMENT_Id IN NUMBER,
192 P_Return_Value IN OUT NOCOPY VARCHAR2
193 );
194
195 PROCEDURE Copy_Pay_Elements
196 ( p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
198 p_commit IN VARCHAR2 := FND_API.G_FALSE,
199 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200 p_return_status OUT NOCOPY VARCHAR2,
201 p_msg_count OUT NOCOPY NUMBER,
202 p_msg_data OUT NOCOPY VARCHAR2,
203 p_source_pay_element_id IN NUMBER,
204 p_source_data_extract_id IN NUMBER,
205 p_target_data_extract_id IN NUMBER
206 );
207
208 END PSB_PAY_ELEMENTS_PVT;