1 PACKAGE PAY_PAYMENT_METHODS_PKG AUTHID CURRENT_USER AS
2 /* $Header: pyppm01t.pkh 120.0 2005/05/29 07:41:08 appldev noship $ */
3
4 PROCEDURE INSERT_ROW(P_ROWID IN OUT NOCOPY VARCHAR2,
5 P_PERSONAL_PAYMENT_METHOD_ID IN OUT NOCOPY NUMBER,
6 P_EFFECTIVE_START_DATE DATE,
7 P_EFFECTIVE_END_DATE DATE,
8 P_BUSINESS_GROUP_ID NUMBER,
9 P_EXTERNAL_ACCOUNT_ID NUMBER,
10 P_ASSIGNMENT_ID NUMBER,
11 P_PERSON_ID NUMBER,
12 P_RUN_TYPE_ID NUMBER,
13 P_ORG_PAYMENT_METHOD_ID NUMBER,
14 P_AMOUNT NUMBER,
15 P_COMMENT_ID NUMBER,
16 P_PERCENTAGE NUMBER,
17 P_PRIORITY NUMBER,
18 P_PAYEE_TYPE VARCHAR2,
19 P_PAYEE_ID NUMBER,
20 P_ATTRIBUTE_CATEGORY VARCHAR2,
21 P_ATTRIBUTE1 VARCHAR2,
22 P_ATTRIBUTE2 VARCHAR2,
23 P_ATTRIBUTE3 VARCHAR2,
24 P_ATTRIBUTE4 VARCHAR2,
25 P_ATTRIBUTE5 VARCHAR2,
26 P_ATTRIBUTE6 VARCHAR2,
27 P_ATTRIBUTE7 VARCHAR2,
28 P_ATTRIBUTE8 VARCHAR2,
29 P_ATTRIBUTE9 VARCHAR2,
30 P_ATTRIBUTE10 VARCHAR2,
31 P_ATTRIBUTE11 VARCHAR2,
32 P_ATTRIBUTE12 VARCHAR2,
33 P_ATTRIBUTE13 VARCHAR2,
34 P_ATTRIBUTE14 VARCHAR2,
35 P_ATTRIBUTE15 VARCHAR2,
36 P_ATTRIBUTE16 VARCHAR2,
37 P_ATTRIBUTE17 VARCHAR2,
38 P_ATTRIBUTE18 VARCHAR2,
39 P_ATTRIBUTE19 VARCHAR2,
40 P_ATTRIBUTE20 VARCHAR2,
41 P_PRENOTE_DATE DATE,
42 /** sbilling **/
43 P_TERRITORY_CODE VARCHAR2,
44 P_PPM_INFORMATION_CATEGORY VARCHAR2,
45 P_PPM_INFORMATION1 VARCHAR2,
46 P_PPM_INFORMATION2 VARCHAR2,
47 P_PPM_INFORMATION3 VARCHAR2,
48 P_PPM_INFORMATION4 VARCHAR2,
49 P_PPM_INFORMATION5 VARCHAR2,
50 P_PPM_INFORMATION6 VARCHAR2,
51 P_PPM_INFORMATION7 VARCHAR2,
52 P_PPM_INFORMATION8 VARCHAR2,
53 P_PPM_INFORMATION9 VARCHAR2,
54 P_PPM_INFORMATION10 VARCHAR2,
55 P_PPM_INFORMATION11 VARCHAR2,
56 P_PPM_INFORMATION12 VARCHAR2,
57 P_PPM_INFORMATION13 VARCHAR2,
58 P_PPM_INFORMATION14 VARCHAR2,
59 P_PPM_INFORMATION15 VARCHAR2,
60 P_PPM_INFORMATION16 VARCHAR2,
61 P_PPM_INFORMATION17 VARCHAR2,
62 P_PPM_INFORMATION18 VARCHAR2,
63 P_PPM_INFORMATION19 VARCHAR2,
64 P_PPM_INFORMATION20 VARCHAR2,
65 P_PPM_INFORMATION21 VARCHAR2,
66 P_PPM_INFORMATION22 VARCHAR2,
67 P_PPM_INFORMATION23 VARCHAR2,
68 P_PPM_INFORMATION24 VARCHAR2,
69 P_PPM_INFORMATION25 VARCHAR2,
70 P_PPM_INFORMATION26 VARCHAR2,
71 P_PPM_INFORMATION27 VARCHAR2,
72 P_PPM_INFORMATION28 VARCHAR2,
73 P_PPM_INFORMATION29 VARCHAR2,
74 P_PPM_INFORMATION30 VARCHAR2
75 );
76 --
77 PROCEDURE UPDATE_ROW(P_ROWID VARCHAR2,
78 P_PERSONAL_PAYMENT_METHOD_ID NUMBER,
79 P_EFFECTIVE_START_DATE DATE,
80 P_EFFECTIVE_END_DATE DATE,
81 P_BUSINESS_GROUP_ID NUMBER,
82 P_EXTERNAL_ACCOUNT_ID NUMBER,
83 P_ASSIGNMENT_ID NUMBER,
84 P_PERSON_ID NUMBER,
85 P_RUN_TYPE_ID NUMBER,
86 P_ORG_PAYMENT_METHOD_ID NUMBER,
87 P_AMOUNT NUMBER,
88 P_COMMENT_ID NUMBER,
89 P_PERCENTAGE NUMBER,
90 P_PRIORITY NUMBER,
91 P_PAYEE_TYPE VARCHAR2,
92 P_PAYEE_ID NUMBER,
93 P_ATTRIBUTE_CATEGORY VARCHAR2,
94 P_ATTRIBUTE1 VARCHAR2,
95 P_ATTRIBUTE2 VARCHAR2,
96 P_ATTRIBUTE3 VARCHAR2,
97 P_ATTRIBUTE4 VARCHAR2,
98 P_ATTRIBUTE5 VARCHAR2,
99 P_ATTRIBUTE6 VARCHAR2,
100 P_ATTRIBUTE7 VARCHAR2,
101 P_ATTRIBUTE8 VARCHAR2,
102 P_ATTRIBUTE9 VARCHAR2,
103 P_ATTRIBUTE10 VARCHAR2,
104 P_ATTRIBUTE11 VARCHAR2,
105 P_ATTRIBUTE12 VARCHAR2,
106 P_ATTRIBUTE13 VARCHAR2,
107 P_ATTRIBUTE14 VARCHAR2,
108 P_ATTRIBUTE15 VARCHAR2,
109 P_ATTRIBUTE16 VARCHAR2,
110 P_ATTRIBUTE17 VARCHAR2,
111 P_ATTRIBUTE18 VARCHAR2,
112 P_ATTRIBUTE19 VARCHAR2,
113 P_ATTRIBUTE20 VARCHAR2,
114 P_PRENOTE_DATE DATE,
115 /** sbilling **/
116 P_TERRITORY_CODE VARCHAR2,
117 P_PPM_INFORMATION_CATEGORY VARCHAR2,
118 P_PPM_INFORMATION1 VARCHAR2,
119 P_PPM_INFORMATION2 VARCHAR2,
120 P_PPM_INFORMATION3 VARCHAR2,
121 P_PPM_INFORMATION4 VARCHAR2,
122 P_PPM_INFORMATION5 VARCHAR2,
123 P_PPM_INFORMATION6 VARCHAR2,
124 P_PPM_INFORMATION7 VARCHAR2,
125 P_PPM_INFORMATION8 VARCHAR2,
126 P_PPM_INFORMATION9 VARCHAR2,
127 P_PPM_INFORMATION10 VARCHAR2,
128 P_PPM_INFORMATION11 VARCHAR2,
129 P_PPM_INFORMATION12 VARCHAR2,
130 P_PPM_INFORMATION13 VARCHAR2,
131 P_PPM_INFORMATION14 VARCHAR2,
132 P_PPM_INFORMATION15 VARCHAR2,
133 P_PPM_INFORMATION16 VARCHAR2,
134 P_PPM_INFORMATION17 VARCHAR2,
135 P_PPM_INFORMATION18 VARCHAR2,
136 P_PPM_INFORMATION19 VARCHAR2,
137 P_PPM_INFORMATION20 VARCHAR2,
138 P_PPM_INFORMATION21 VARCHAR2,
139 P_PPM_INFORMATION22 VARCHAR2,
140 P_PPM_INFORMATION23 VARCHAR2,
141 P_PPM_INFORMATION24 VARCHAR2,
142 P_PPM_INFORMATION25 VARCHAR2,
143 P_PPM_INFORMATION26 VARCHAR2,
144 P_PPM_INFORMATION27 VARCHAR2,
145 P_PPM_INFORMATION28 VARCHAR2,
146 P_PPM_INFORMATION29 VARCHAR2,
147 P_PPM_INFORMATION30 VARCHAR2
148 );
149 --
150 PROCEDURE DELETE_ROW(P_ROWID VARCHAR2,
151 P_PPM_ID NUMBER,
152 P_AFTER_THIS_DATE DATE,
153 P_PAYEE_TYPE VARCHAR2);
154 --
155 PROCEDURE LOCK_ROW(P_ROWID VARCHAR2,
156 P_PERSONAL_PAYMENT_METHOD_ID NUMBER,
157 P_EFFECTIVE_START_DATE DATE,
158 P_EFFECTIVE_END_DATE DATE,
159 P_BUSINESS_GROUP_ID NUMBER,
160 P_EXTERNAL_ACCOUNT_ID NUMBER,
161 P_ASSIGNMENT_ID NUMBER,
162 P_PERSON_ID NUMBER,
163 P_RUN_TYPE_ID NUMBER,
164 P_ORG_PAYMENT_METHOD_ID NUMBER,
165 P_AMOUNT NUMBER,
166 P_COMMENT_ID NUMBER,
167 P_PERCENTAGE NUMBER,
168 P_PRIORITY NUMBER,
169 P_PAYEE_TYPE VARCHAR2,
170 P_PAYEE_ID NUMBER,
171 P_ATTRIBUTE_CATEGORY VARCHAR2,
172 P_ATTRIBUTE1 VARCHAR2,
173 P_ATTRIBUTE2 VARCHAR2,
174 P_ATTRIBUTE3 VARCHAR2,
175 P_ATTRIBUTE4 VARCHAR2,
176 P_ATTRIBUTE5 VARCHAR2,
177 P_ATTRIBUTE6 VARCHAR2,
178 P_ATTRIBUTE7 VARCHAR2,
179 P_ATTRIBUTE8 VARCHAR2,
180 P_ATTRIBUTE9 VARCHAR2,
181 P_ATTRIBUTE10 VARCHAR2,
182 P_ATTRIBUTE11 VARCHAR2,
183 P_ATTRIBUTE12 VARCHAR2,
184 P_ATTRIBUTE13 VARCHAR2,
185 P_ATTRIBUTE14 VARCHAR2,
186 P_ATTRIBUTE15 VARCHAR2,
187 P_ATTRIBUTE16 VARCHAR2,
188 P_ATTRIBUTE17 VARCHAR2,
189 P_ATTRIBUTE18 VARCHAR2,
190 P_ATTRIBUTE19 VARCHAR2,
191 P_ATTRIBUTE20 VARCHAR2,
192 P_PRENOTE_DATE DATE,
193 P_PPM_INFORMATION_CATEGORY VARCHAR2,
194 P_PPM_INFORMATION1 VARCHAR2,
195 P_PPM_INFORMATION2 VARCHAR2,
196 P_PPM_INFORMATION3 VARCHAR2,
197 P_PPM_INFORMATION4 VARCHAR2,
198 P_PPM_INFORMATION5 VARCHAR2,
199 P_PPM_INFORMATION6 VARCHAR2,
200 P_PPM_INFORMATION7 VARCHAR2,
201 P_PPM_INFORMATION8 VARCHAR2,
202 P_PPM_INFORMATION9 VARCHAR2,
203 P_PPM_INFORMATION10 VARCHAR2,
204 P_PPM_INFORMATION11 VARCHAR2,
205 P_PPM_INFORMATION12 VARCHAR2,
206 P_PPM_INFORMATION13 VARCHAR2,
207 P_PPM_INFORMATION14 VARCHAR2,
208 P_PPM_INFORMATION15 VARCHAR2,
209 P_PPM_INFORMATION16 VARCHAR2,
210 P_PPM_INFORMATION17 VARCHAR2,
211 P_PPM_INFORMATION18 VARCHAR2,
212 P_PPM_INFORMATION19 VARCHAR2,
213 P_PPM_INFORMATION20 VARCHAR2,
214 P_PPM_INFORMATION21 VARCHAR2,
215 P_PPM_INFORMATION22 VARCHAR2,
216 P_PPM_INFORMATION23 VARCHAR2,
217 P_PPM_INFORMATION24 VARCHAR2,
218 P_PPM_INFORMATION25 VARCHAR2,
219 P_PPM_INFORMATION26 VARCHAR2,
220 P_PPM_INFORMATION27 VARCHAR2,
221 P_PPM_INFORMATION28 VARCHAR2,
222 P_PPM_INFORMATION29 VARCHAR2,
223 P_PPM_INFORMATION30 VARCHAR2);
224 --
225 procedure check_asg_on_payroll (p_asg_id varchar2,
226 p_new_date varchar2);
227 --
228 END PAY_PAYMENT_METHODS_PKG;
|
|
|