eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PAY_GROUPS_PKG dependencies on CN_PAY_GROUPS

Line 1: PACKAGE BODY CN_PAY_GROUPS_PKG as

1: PACKAGE BODY CN_PAY_GROUPS_PKG as
2: -- $Header: cnpgrptb.pls 120.3 2005/07/26 02:36:09 sjustina ship $
3:
4:
5: g_temp_status_code VARCHAR2(30) := NULL;

Line 17: SELECT cn_pay_groups_s.nextval

13: PROCEDURE Get_UID( X_pay_group_id IN OUT NOCOPY NUMBER) IS
14:
15: BEGIN
16:
17: SELECT cn_pay_groups_s.nextval
18: INTO X_pay_group_id
19: FROM sys.dual;
20:
21: END Get_UID;

Line 71: INSERT INTO cn_pay_groups(

67: THEN
68: Get_UID( X_pay_group_id );
69: END IF;
70:
71: INSERT INTO cn_pay_groups(
72: pay_group_id
73: ,name
74: ,period_set_name
75: ,period_type

Line 178: l_name cn_pay_groups.name%TYPE;

174: ,x_Last_Update_Login NUMBER
175: ,x_object_version_number OUT NOCOPY NUMBER
176: ,x_org_id NUMBER ) IS
177:
178: l_name cn_pay_groups.name%TYPE;
179: l_period_set_name cn_pay_groups.period_set_name%TYPE;
180: l_period_type cn_pay_groups.period_type%TYPE;
181: l_start_date cn_pay_groups.start_date%TYPE;
182: l_end_date cn_pay_groups.end_date%TYPE;

Line 179: l_period_set_name cn_pay_groups.period_set_name%TYPE;

175: ,x_object_version_number OUT NOCOPY NUMBER
176: ,x_org_id NUMBER ) IS
177:
178: l_name cn_pay_groups.name%TYPE;
179: l_period_set_name cn_pay_groups.period_set_name%TYPE;
180: l_period_type cn_pay_groups.period_type%TYPE;
181: l_start_date cn_pay_groups.start_date%TYPE;
182: l_end_date cn_pay_groups.end_date%TYPE;
183: l_pay_group_description cn_pay_groups.pay_group_description%TYPE;

Line 180: l_period_type cn_pay_groups.period_type%TYPE;

176: ,x_org_id NUMBER ) IS
177:
178: l_name cn_pay_groups.name%TYPE;
179: l_period_set_name cn_pay_groups.period_set_name%TYPE;
180: l_period_type cn_pay_groups.period_type%TYPE;
181: l_start_date cn_pay_groups.start_date%TYPE;
182: l_end_date cn_pay_groups.end_date%TYPE;
183: l_pay_group_description cn_pay_groups.pay_group_description%TYPE;
184: l_period_set_id cn_pay_groups.period_set_id%TYPE;

Line 181: l_start_date cn_pay_groups.start_date%TYPE;

177:
178: l_name cn_pay_groups.name%TYPE;
179: l_period_set_name cn_pay_groups.period_set_name%TYPE;
180: l_period_type cn_pay_groups.period_type%TYPE;
181: l_start_date cn_pay_groups.start_date%TYPE;
182: l_end_date cn_pay_groups.end_date%TYPE;
183: l_pay_group_description cn_pay_groups.pay_group_description%TYPE;
184: l_period_set_id cn_pay_groups.period_set_id%TYPE;
185: l_period_type_id cn_pay_groups.period_type_id%TYPE;

Line 182: l_end_date cn_pay_groups.end_date%TYPE;

178: l_name cn_pay_groups.name%TYPE;
179: l_period_set_name cn_pay_groups.period_set_name%TYPE;
180: l_period_type cn_pay_groups.period_type%TYPE;
181: l_start_date cn_pay_groups.start_date%TYPE;
182: l_end_date cn_pay_groups.end_date%TYPE;
183: l_pay_group_description cn_pay_groups.pay_group_description%TYPE;
184: l_period_set_id cn_pay_groups.period_set_id%TYPE;
185: l_period_type_id cn_pay_groups.period_type_id%TYPE;
186: l_attribute_category cn_pay_groups.attribute_category%TYPE;

Line 183: l_pay_group_description cn_pay_groups.pay_group_description%TYPE;

179: l_period_set_name cn_pay_groups.period_set_name%TYPE;
180: l_period_type cn_pay_groups.period_type%TYPE;
181: l_start_date cn_pay_groups.start_date%TYPE;
182: l_end_date cn_pay_groups.end_date%TYPE;
183: l_pay_group_description cn_pay_groups.pay_group_description%TYPE;
184: l_period_set_id cn_pay_groups.period_set_id%TYPE;
185: l_period_type_id cn_pay_groups.period_type_id%TYPE;
186: l_attribute_category cn_pay_groups.attribute_category%TYPE;
187: l_attribute1 cn_pay_groups.attribute1%TYPE;

Line 184: l_period_set_id cn_pay_groups.period_set_id%TYPE;

180: l_period_type cn_pay_groups.period_type%TYPE;
181: l_start_date cn_pay_groups.start_date%TYPE;
182: l_end_date cn_pay_groups.end_date%TYPE;
183: l_pay_group_description cn_pay_groups.pay_group_description%TYPE;
184: l_period_set_id cn_pay_groups.period_set_id%TYPE;
185: l_period_type_id cn_pay_groups.period_type_id%TYPE;
186: l_attribute_category cn_pay_groups.attribute_category%TYPE;
187: l_attribute1 cn_pay_groups.attribute1%TYPE;
188: l_attribute2 cn_pay_groups.attribute2%TYPE;

Line 185: l_period_type_id cn_pay_groups.period_type_id%TYPE;

181: l_start_date cn_pay_groups.start_date%TYPE;
182: l_end_date cn_pay_groups.end_date%TYPE;
183: l_pay_group_description cn_pay_groups.pay_group_description%TYPE;
184: l_period_set_id cn_pay_groups.period_set_id%TYPE;
185: l_period_type_id cn_pay_groups.period_type_id%TYPE;
186: l_attribute_category cn_pay_groups.attribute_category%TYPE;
187: l_attribute1 cn_pay_groups.attribute1%TYPE;
188: l_attribute2 cn_pay_groups.attribute2%TYPE;
189: l_attribute3 cn_pay_groups.attribute3%TYPE;

Line 186: l_attribute_category cn_pay_groups.attribute_category%TYPE;

182: l_end_date cn_pay_groups.end_date%TYPE;
183: l_pay_group_description cn_pay_groups.pay_group_description%TYPE;
184: l_period_set_id cn_pay_groups.period_set_id%TYPE;
185: l_period_type_id cn_pay_groups.period_type_id%TYPE;
186: l_attribute_category cn_pay_groups.attribute_category%TYPE;
187: l_attribute1 cn_pay_groups.attribute1%TYPE;
188: l_attribute2 cn_pay_groups.attribute2%TYPE;
189: l_attribute3 cn_pay_groups.attribute3%TYPE;
190: l_attribute4 cn_pay_groups.attribute4%TYPE;

Line 187: l_attribute1 cn_pay_groups.attribute1%TYPE;

183: l_pay_group_description cn_pay_groups.pay_group_description%TYPE;
184: l_period_set_id cn_pay_groups.period_set_id%TYPE;
185: l_period_type_id cn_pay_groups.period_type_id%TYPE;
186: l_attribute_category cn_pay_groups.attribute_category%TYPE;
187: l_attribute1 cn_pay_groups.attribute1%TYPE;
188: l_attribute2 cn_pay_groups.attribute2%TYPE;
189: l_attribute3 cn_pay_groups.attribute3%TYPE;
190: l_attribute4 cn_pay_groups.attribute4%TYPE;
191: l_attribute5 cn_pay_groups.attribute5%TYPE;

Line 188: l_attribute2 cn_pay_groups.attribute2%TYPE;

184: l_period_set_id cn_pay_groups.period_set_id%TYPE;
185: l_period_type_id cn_pay_groups.period_type_id%TYPE;
186: l_attribute_category cn_pay_groups.attribute_category%TYPE;
187: l_attribute1 cn_pay_groups.attribute1%TYPE;
188: l_attribute2 cn_pay_groups.attribute2%TYPE;
189: l_attribute3 cn_pay_groups.attribute3%TYPE;
190: l_attribute4 cn_pay_groups.attribute4%TYPE;
191: l_attribute5 cn_pay_groups.attribute5%TYPE;
192: l_attribute6 cn_pay_groups.attribute6%TYPE;

Line 189: l_attribute3 cn_pay_groups.attribute3%TYPE;

185: l_period_type_id cn_pay_groups.period_type_id%TYPE;
186: l_attribute_category cn_pay_groups.attribute_category%TYPE;
187: l_attribute1 cn_pay_groups.attribute1%TYPE;
188: l_attribute2 cn_pay_groups.attribute2%TYPE;
189: l_attribute3 cn_pay_groups.attribute3%TYPE;
190: l_attribute4 cn_pay_groups.attribute4%TYPE;
191: l_attribute5 cn_pay_groups.attribute5%TYPE;
192: l_attribute6 cn_pay_groups.attribute6%TYPE;
193: l_attribute7 cn_pay_groups.attribute7%TYPE;

Line 190: l_attribute4 cn_pay_groups.attribute4%TYPE;

186: l_attribute_category cn_pay_groups.attribute_category%TYPE;
187: l_attribute1 cn_pay_groups.attribute1%TYPE;
188: l_attribute2 cn_pay_groups.attribute2%TYPE;
189: l_attribute3 cn_pay_groups.attribute3%TYPE;
190: l_attribute4 cn_pay_groups.attribute4%TYPE;
191: l_attribute5 cn_pay_groups.attribute5%TYPE;
192: l_attribute6 cn_pay_groups.attribute6%TYPE;
193: l_attribute7 cn_pay_groups.attribute7%TYPE;
194: l_attribute8 cn_pay_groups.attribute8%TYPE;

Line 191: l_attribute5 cn_pay_groups.attribute5%TYPE;

187: l_attribute1 cn_pay_groups.attribute1%TYPE;
188: l_attribute2 cn_pay_groups.attribute2%TYPE;
189: l_attribute3 cn_pay_groups.attribute3%TYPE;
190: l_attribute4 cn_pay_groups.attribute4%TYPE;
191: l_attribute5 cn_pay_groups.attribute5%TYPE;
192: l_attribute6 cn_pay_groups.attribute6%TYPE;
193: l_attribute7 cn_pay_groups.attribute7%TYPE;
194: l_attribute8 cn_pay_groups.attribute8%TYPE;
195: l_attribute9 cn_pay_groups.attribute9%TYPE;

Line 192: l_attribute6 cn_pay_groups.attribute6%TYPE;

188: l_attribute2 cn_pay_groups.attribute2%TYPE;
189: l_attribute3 cn_pay_groups.attribute3%TYPE;
190: l_attribute4 cn_pay_groups.attribute4%TYPE;
191: l_attribute5 cn_pay_groups.attribute5%TYPE;
192: l_attribute6 cn_pay_groups.attribute6%TYPE;
193: l_attribute7 cn_pay_groups.attribute7%TYPE;
194: l_attribute8 cn_pay_groups.attribute8%TYPE;
195: l_attribute9 cn_pay_groups.attribute9%TYPE;
196: l_attribute10 cn_pay_groups.attribute10%TYPE;

Line 193: l_attribute7 cn_pay_groups.attribute7%TYPE;

189: l_attribute3 cn_pay_groups.attribute3%TYPE;
190: l_attribute4 cn_pay_groups.attribute4%TYPE;
191: l_attribute5 cn_pay_groups.attribute5%TYPE;
192: l_attribute6 cn_pay_groups.attribute6%TYPE;
193: l_attribute7 cn_pay_groups.attribute7%TYPE;
194: l_attribute8 cn_pay_groups.attribute8%TYPE;
195: l_attribute9 cn_pay_groups.attribute9%TYPE;
196: l_attribute10 cn_pay_groups.attribute10%TYPE;
197: l_attribute11 cn_pay_groups.attribute11%TYPE;

Line 194: l_attribute8 cn_pay_groups.attribute8%TYPE;

190: l_attribute4 cn_pay_groups.attribute4%TYPE;
191: l_attribute5 cn_pay_groups.attribute5%TYPE;
192: l_attribute6 cn_pay_groups.attribute6%TYPE;
193: l_attribute7 cn_pay_groups.attribute7%TYPE;
194: l_attribute8 cn_pay_groups.attribute8%TYPE;
195: l_attribute9 cn_pay_groups.attribute9%TYPE;
196: l_attribute10 cn_pay_groups.attribute10%TYPE;
197: l_attribute11 cn_pay_groups.attribute11%TYPE;
198: l_attribute12 cn_pay_groups.attribute12%TYPE;

Line 195: l_attribute9 cn_pay_groups.attribute9%TYPE;

191: l_attribute5 cn_pay_groups.attribute5%TYPE;
192: l_attribute6 cn_pay_groups.attribute6%TYPE;
193: l_attribute7 cn_pay_groups.attribute7%TYPE;
194: l_attribute8 cn_pay_groups.attribute8%TYPE;
195: l_attribute9 cn_pay_groups.attribute9%TYPE;
196: l_attribute10 cn_pay_groups.attribute10%TYPE;
197: l_attribute11 cn_pay_groups.attribute11%TYPE;
198: l_attribute12 cn_pay_groups.attribute12%TYPE;
199: l_attribute13 cn_pay_groups.attribute13%TYPE;

Line 196: l_attribute10 cn_pay_groups.attribute10%TYPE;

192: l_attribute6 cn_pay_groups.attribute6%TYPE;
193: l_attribute7 cn_pay_groups.attribute7%TYPE;
194: l_attribute8 cn_pay_groups.attribute8%TYPE;
195: l_attribute9 cn_pay_groups.attribute9%TYPE;
196: l_attribute10 cn_pay_groups.attribute10%TYPE;
197: l_attribute11 cn_pay_groups.attribute11%TYPE;
198: l_attribute12 cn_pay_groups.attribute12%TYPE;
199: l_attribute13 cn_pay_groups.attribute13%TYPE;
200: l_attribute14 cn_pay_groups.attribute14%TYPE;

Line 197: l_attribute11 cn_pay_groups.attribute11%TYPE;

193: l_attribute7 cn_pay_groups.attribute7%TYPE;
194: l_attribute8 cn_pay_groups.attribute8%TYPE;
195: l_attribute9 cn_pay_groups.attribute9%TYPE;
196: l_attribute10 cn_pay_groups.attribute10%TYPE;
197: l_attribute11 cn_pay_groups.attribute11%TYPE;
198: l_attribute12 cn_pay_groups.attribute12%TYPE;
199: l_attribute13 cn_pay_groups.attribute13%TYPE;
200: l_attribute14 cn_pay_groups.attribute14%TYPE;
201: l_attribute15 cn_pay_groups.attribute15%TYPE;

Line 198: l_attribute12 cn_pay_groups.attribute12%TYPE;

194: l_attribute8 cn_pay_groups.attribute8%TYPE;
195: l_attribute9 cn_pay_groups.attribute9%TYPE;
196: l_attribute10 cn_pay_groups.attribute10%TYPE;
197: l_attribute11 cn_pay_groups.attribute11%TYPE;
198: l_attribute12 cn_pay_groups.attribute12%TYPE;
199: l_attribute13 cn_pay_groups.attribute13%TYPE;
200: l_attribute14 cn_pay_groups.attribute14%TYPE;
201: l_attribute15 cn_pay_groups.attribute15%TYPE;
202: l_org_id cn_pay_groups.org_id%TYPE;

Line 199: l_attribute13 cn_pay_groups.attribute13%TYPE;

195: l_attribute9 cn_pay_groups.attribute9%TYPE;
196: l_attribute10 cn_pay_groups.attribute10%TYPE;
197: l_attribute11 cn_pay_groups.attribute11%TYPE;
198: l_attribute12 cn_pay_groups.attribute12%TYPE;
199: l_attribute13 cn_pay_groups.attribute13%TYPE;
200: l_attribute14 cn_pay_groups.attribute14%TYPE;
201: l_attribute15 cn_pay_groups.attribute15%TYPE;
202: l_org_id cn_pay_groups.org_id%TYPE;
203:

Line 200: l_attribute14 cn_pay_groups.attribute14%TYPE;

196: l_attribute10 cn_pay_groups.attribute10%TYPE;
197: l_attribute11 cn_pay_groups.attribute11%TYPE;
198: l_attribute12 cn_pay_groups.attribute12%TYPE;
199: l_attribute13 cn_pay_groups.attribute13%TYPE;
200: l_attribute14 cn_pay_groups.attribute14%TYPE;
201: l_attribute15 cn_pay_groups.attribute15%TYPE;
202: l_org_id cn_pay_groups.org_id%TYPE;
203:
204: CURSOR pay_group_cur IS

Line 201: l_attribute15 cn_pay_groups.attribute15%TYPE;

197: l_attribute11 cn_pay_groups.attribute11%TYPE;
198: l_attribute12 cn_pay_groups.attribute12%TYPE;
199: l_attribute13 cn_pay_groups.attribute13%TYPE;
200: l_attribute14 cn_pay_groups.attribute14%TYPE;
201: l_attribute15 cn_pay_groups.attribute15%TYPE;
202: l_org_id cn_pay_groups.org_id%TYPE;
203:
204: CURSOR pay_group_cur IS
205: SELECT *

Line 202: l_org_id cn_pay_groups.org_id%TYPE;

198: l_attribute12 cn_pay_groups.attribute12%TYPE;
199: l_attribute13 cn_pay_groups.attribute13%TYPE;
200: l_attribute14 cn_pay_groups.attribute14%TYPE;
201: l_attribute15 cn_pay_groups.attribute15%TYPE;
202: l_org_id cn_pay_groups.org_id%TYPE;
203:
204: CURSOR pay_group_cur IS
205: SELECT *
206: FROM cn_pay_groups

Line 206: FROM cn_pay_groups

202: l_org_id cn_pay_groups.org_id%TYPE;
203:
204: CURSOR pay_group_cur IS
205: SELECT *
206: FROM cn_pay_groups
207: WHERE pay_group_id = x_pay_group_id;
208:
209: l_pay_group_rec pay_group_cur%ROWTYPE;
210:

Line 321: UPDATE cn_pay_groups

317: l_org_id
318: FROM dual;
319:
320:
321: UPDATE cn_pay_groups
322: SET
323: name = l_name,
324: period_set_name = l_period_set_name,
325: period_type = l_period_type,

Line 354: from cn_pay_groups where pay_group_id = x_pay_group_id;

350: object_version_number = object_version_number + 1
351: WHERE pay_group_id = x_pay_group_id ;
352:
353: select object_version_number into x_object_version_number
354: from cn_pay_groups where pay_group_id = x_pay_group_id;
355:
356: if (SQL%NOTFOUND) then
357: Raise NO_DATA_FOUND;
358: end if;

Line 372: DELETE FROM cn_pay_groups

368:
369: PROCEDURE Delete_Record( x_pay_group_id NUMBER ) IS
370: BEGIN
371:
372: DELETE FROM cn_pay_groups
373: WHERE pay_group_id = x_pay_group_id;
374:
375:
376: END Delete_Record;

Line 500: END CN_PAY_GROUPS_PKG;

496: END IF;
497:
498: END Begin_Record;
499:
500: END CN_PAY_GROUPS_PKG;