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_ROLE_PAY_GROUPS_PKG dependencies on CN_ROLE_PAY_GROUPS

Line 1: PACKAGE BODY CN_ROLE_PAY_GROUPS_PKG AS

1: PACKAGE BODY CN_ROLE_PAY_GROUPS_PKG AS
2: /* $Header: cntrlpgb.pls 120.3 2005/07/26 02:39:02 sjustina noship $ */
3:
4: G_LAST_UPDATE_DATE DATE := sysdate;
5: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

Line 44: L_END_DATE cn_role_pay_groups.END_DATE%type;

40: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
41: ) IS
42:
43:
44: L_END_DATE cn_role_pay_groups.END_DATE%type;
45: L_ATTRIBUTE_CATEGORY cn_role_pay_groups.ATTRIBUTE_CATEGORY%type;
46: L_ATTRIBUTE1 cn_role_pay_groups.ATTRIBUTE1%type;
47: L_ATTRIBUTE2 cn_role_pay_groups.ATTRIBUTE2%type;
48: L_ATTRIBUTE3 cn_role_pay_groups.ATTRIBUTE3%type;

Line 45: L_ATTRIBUTE_CATEGORY cn_role_pay_groups.ATTRIBUTE_CATEGORY%type;

41: ) IS
42:
43:
44: L_END_DATE cn_role_pay_groups.END_DATE%type;
45: L_ATTRIBUTE_CATEGORY cn_role_pay_groups.ATTRIBUTE_CATEGORY%type;
46: L_ATTRIBUTE1 cn_role_pay_groups.ATTRIBUTE1%type;
47: L_ATTRIBUTE2 cn_role_pay_groups.ATTRIBUTE2%type;
48: L_ATTRIBUTE3 cn_role_pay_groups.ATTRIBUTE3%type;
49: L_ATTRIBUTE4 cn_role_pay_groups.ATTRIBUTE4%type;

Line 46: L_ATTRIBUTE1 cn_role_pay_groups.ATTRIBUTE1%type;

42:
43:
44: L_END_DATE cn_role_pay_groups.END_DATE%type;
45: L_ATTRIBUTE_CATEGORY cn_role_pay_groups.ATTRIBUTE_CATEGORY%type;
46: L_ATTRIBUTE1 cn_role_pay_groups.ATTRIBUTE1%type;
47: L_ATTRIBUTE2 cn_role_pay_groups.ATTRIBUTE2%type;
48: L_ATTRIBUTE3 cn_role_pay_groups.ATTRIBUTE3%type;
49: L_ATTRIBUTE4 cn_role_pay_groups.ATTRIBUTE4%type;
50: L_ATTRIBUTE5 cn_role_pay_groups.ATTRIBUTE5%type;

Line 47: L_ATTRIBUTE2 cn_role_pay_groups.ATTRIBUTE2%type;

43:
44: L_END_DATE cn_role_pay_groups.END_DATE%type;
45: L_ATTRIBUTE_CATEGORY cn_role_pay_groups.ATTRIBUTE_CATEGORY%type;
46: L_ATTRIBUTE1 cn_role_pay_groups.ATTRIBUTE1%type;
47: L_ATTRIBUTE2 cn_role_pay_groups.ATTRIBUTE2%type;
48: L_ATTRIBUTE3 cn_role_pay_groups.ATTRIBUTE3%type;
49: L_ATTRIBUTE4 cn_role_pay_groups.ATTRIBUTE4%type;
50: L_ATTRIBUTE5 cn_role_pay_groups.ATTRIBUTE5%type;
51: L_ATTRIBUTE6 cn_role_pay_groups.ATTRIBUTE6%type;

Line 48: L_ATTRIBUTE3 cn_role_pay_groups.ATTRIBUTE3%type;

44: L_END_DATE cn_role_pay_groups.END_DATE%type;
45: L_ATTRIBUTE_CATEGORY cn_role_pay_groups.ATTRIBUTE_CATEGORY%type;
46: L_ATTRIBUTE1 cn_role_pay_groups.ATTRIBUTE1%type;
47: L_ATTRIBUTE2 cn_role_pay_groups.ATTRIBUTE2%type;
48: L_ATTRIBUTE3 cn_role_pay_groups.ATTRIBUTE3%type;
49: L_ATTRIBUTE4 cn_role_pay_groups.ATTRIBUTE4%type;
50: L_ATTRIBUTE5 cn_role_pay_groups.ATTRIBUTE5%type;
51: L_ATTRIBUTE6 cn_role_pay_groups.ATTRIBUTE6%type;
52: L_ATTRIBUTE7 cn_role_pay_groups.ATTRIBUTE7%type;

Line 49: L_ATTRIBUTE4 cn_role_pay_groups.ATTRIBUTE4%type;

45: L_ATTRIBUTE_CATEGORY cn_role_pay_groups.ATTRIBUTE_CATEGORY%type;
46: L_ATTRIBUTE1 cn_role_pay_groups.ATTRIBUTE1%type;
47: L_ATTRIBUTE2 cn_role_pay_groups.ATTRIBUTE2%type;
48: L_ATTRIBUTE3 cn_role_pay_groups.ATTRIBUTE3%type;
49: L_ATTRIBUTE4 cn_role_pay_groups.ATTRIBUTE4%type;
50: L_ATTRIBUTE5 cn_role_pay_groups.ATTRIBUTE5%type;
51: L_ATTRIBUTE6 cn_role_pay_groups.ATTRIBUTE6%type;
52: L_ATTRIBUTE7 cn_role_pay_groups.ATTRIBUTE7%type;
53: L_ATTRIBUTE8 cn_role_pay_groups.ATTRIBUTE8%type;

Line 50: L_ATTRIBUTE5 cn_role_pay_groups.ATTRIBUTE5%type;

46: L_ATTRIBUTE1 cn_role_pay_groups.ATTRIBUTE1%type;
47: L_ATTRIBUTE2 cn_role_pay_groups.ATTRIBUTE2%type;
48: L_ATTRIBUTE3 cn_role_pay_groups.ATTRIBUTE3%type;
49: L_ATTRIBUTE4 cn_role_pay_groups.ATTRIBUTE4%type;
50: L_ATTRIBUTE5 cn_role_pay_groups.ATTRIBUTE5%type;
51: L_ATTRIBUTE6 cn_role_pay_groups.ATTRIBUTE6%type;
52: L_ATTRIBUTE7 cn_role_pay_groups.ATTRIBUTE7%type;
53: L_ATTRIBUTE8 cn_role_pay_groups.ATTRIBUTE8%type;
54: L_ATTRIBUTE9 cn_role_pay_groups.ATTRIBUTE9%type;

Line 51: L_ATTRIBUTE6 cn_role_pay_groups.ATTRIBUTE6%type;

47: L_ATTRIBUTE2 cn_role_pay_groups.ATTRIBUTE2%type;
48: L_ATTRIBUTE3 cn_role_pay_groups.ATTRIBUTE3%type;
49: L_ATTRIBUTE4 cn_role_pay_groups.ATTRIBUTE4%type;
50: L_ATTRIBUTE5 cn_role_pay_groups.ATTRIBUTE5%type;
51: L_ATTRIBUTE6 cn_role_pay_groups.ATTRIBUTE6%type;
52: L_ATTRIBUTE7 cn_role_pay_groups.ATTRIBUTE7%type;
53: L_ATTRIBUTE8 cn_role_pay_groups.ATTRIBUTE8%type;
54: L_ATTRIBUTE9 cn_role_pay_groups.ATTRIBUTE9%type;
55: L_ATTRIBUTE10 cn_role_pay_groups.ATTRIBUTE10%type;

Line 52: L_ATTRIBUTE7 cn_role_pay_groups.ATTRIBUTE7%type;

48: L_ATTRIBUTE3 cn_role_pay_groups.ATTRIBUTE3%type;
49: L_ATTRIBUTE4 cn_role_pay_groups.ATTRIBUTE4%type;
50: L_ATTRIBUTE5 cn_role_pay_groups.ATTRIBUTE5%type;
51: L_ATTRIBUTE6 cn_role_pay_groups.ATTRIBUTE6%type;
52: L_ATTRIBUTE7 cn_role_pay_groups.ATTRIBUTE7%type;
53: L_ATTRIBUTE8 cn_role_pay_groups.ATTRIBUTE8%type;
54: L_ATTRIBUTE9 cn_role_pay_groups.ATTRIBUTE9%type;
55: L_ATTRIBUTE10 cn_role_pay_groups.ATTRIBUTE10%type;
56: L_ATTRIBUTE11 cn_role_pay_groups.ATTRIBUTE11%type;

Line 53: L_ATTRIBUTE8 cn_role_pay_groups.ATTRIBUTE8%type;

49: L_ATTRIBUTE4 cn_role_pay_groups.ATTRIBUTE4%type;
50: L_ATTRIBUTE5 cn_role_pay_groups.ATTRIBUTE5%type;
51: L_ATTRIBUTE6 cn_role_pay_groups.ATTRIBUTE6%type;
52: L_ATTRIBUTE7 cn_role_pay_groups.ATTRIBUTE7%type;
53: L_ATTRIBUTE8 cn_role_pay_groups.ATTRIBUTE8%type;
54: L_ATTRIBUTE9 cn_role_pay_groups.ATTRIBUTE9%type;
55: L_ATTRIBUTE10 cn_role_pay_groups.ATTRIBUTE10%type;
56: L_ATTRIBUTE11 cn_role_pay_groups.ATTRIBUTE11%type;
57: L_ATTRIBUTE12 cn_role_pay_groups.ATTRIBUTE12%type;

Line 54: L_ATTRIBUTE9 cn_role_pay_groups.ATTRIBUTE9%type;

50: L_ATTRIBUTE5 cn_role_pay_groups.ATTRIBUTE5%type;
51: L_ATTRIBUTE6 cn_role_pay_groups.ATTRIBUTE6%type;
52: L_ATTRIBUTE7 cn_role_pay_groups.ATTRIBUTE7%type;
53: L_ATTRIBUTE8 cn_role_pay_groups.ATTRIBUTE8%type;
54: L_ATTRIBUTE9 cn_role_pay_groups.ATTRIBUTE9%type;
55: L_ATTRIBUTE10 cn_role_pay_groups.ATTRIBUTE10%type;
56: L_ATTRIBUTE11 cn_role_pay_groups.ATTRIBUTE11%type;
57: L_ATTRIBUTE12 cn_role_pay_groups.ATTRIBUTE12%type;
58: L_ATTRIBUTE13 cn_role_pay_groups.ATTRIBUTE13%type;

Line 55: L_ATTRIBUTE10 cn_role_pay_groups.ATTRIBUTE10%type;

51: L_ATTRIBUTE6 cn_role_pay_groups.ATTRIBUTE6%type;
52: L_ATTRIBUTE7 cn_role_pay_groups.ATTRIBUTE7%type;
53: L_ATTRIBUTE8 cn_role_pay_groups.ATTRIBUTE8%type;
54: L_ATTRIBUTE9 cn_role_pay_groups.ATTRIBUTE9%type;
55: L_ATTRIBUTE10 cn_role_pay_groups.ATTRIBUTE10%type;
56: L_ATTRIBUTE11 cn_role_pay_groups.ATTRIBUTE11%type;
57: L_ATTRIBUTE12 cn_role_pay_groups.ATTRIBUTE12%type;
58: L_ATTRIBUTE13 cn_role_pay_groups.ATTRIBUTE13%type;
59: L_ATTRIBUTE14 cn_role_pay_groups.ATTRIBUTE14%type;

Line 56: L_ATTRIBUTE11 cn_role_pay_groups.ATTRIBUTE11%type;

52: L_ATTRIBUTE7 cn_role_pay_groups.ATTRIBUTE7%type;
53: L_ATTRIBUTE8 cn_role_pay_groups.ATTRIBUTE8%type;
54: L_ATTRIBUTE9 cn_role_pay_groups.ATTRIBUTE9%type;
55: L_ATTRIBUTE10 cn_role_pay_groups.ATTRIBUTE10%type;
56: L_ATTRIBUTE11 cn_role_pay_groups.ATTRIBUTE11%type;
57: L_ATTRIBUTE12 cn_role_pay_groups.ATTRIBUTE12%type;
58: L_ATTRIBUTE13 cn_role_pay_groups.ATTRIBUTE13%type;
59: L_ATTRIBUTE14 cn_role_pay_groups.ATTRIBUTE14%type;
60: L_ATTRIBUTE15 cn_role_pay_groups.ATTRIBUTE15%type;

Line 57: L_ATTRIBUTE12 cn_role_pay_groups.ATTRIBUTE12%type;

53: L_ATTRIBUTE8 cn_role_pay_groups.ATTRIBUTE8%type;
54: L_ATTRIBUTE9 cn_role_pay_groups.ATTRIBUTE9%type;
55: L_ATTRIBUTE10 cn_role_pay_groups.ATTRIBUTE10%type;
56: L_ATTRIBUTE11 cn_role_pay_groups.ATTRIBUTE11%type;
57: L_ATTRIBUTE12 cn_role_pay_groups.ATTRIBUTE12%type;
58: L_ATTRIBUTE13 cn_role_pay_groups.ATTRIBUTE13%type;
59: L_ATTRIBUTE14 cn_role_pay_groups.ATTRIBUTE14%type;
60: L_ATTRIBUTE15 cn_role_pay_groups.ATTRIBUTE15%type;
61: L_CREATED_BY cn_role_pay_groups.CREATED_BY%type;

Line 58: L_ATTRIBUTE13 cn_role_pay_groups.ATTRIBUTE13%type;

54: L_ATTRIBUTE9 cn_role_pay_groups.ATTRIBUTE9%type;
55: L_ATTRIBUTE10 cn_role_pay_groups.ATTRIBUTE10%type;
56: L_ATTRIBUTE11 cn_role_pay_groups.ATTRIBUTE11%type;
57: L_ATTRIBUTE12 cn_role_pay_groups.ATTRIBUTE12%type;
58: L_ATTRIBUTE13 cn_role_pay_groups.ATTRIBUTE13%type;
59: L_ATTRIBUTE14 cn_role_pay_groups.ATTRIBUTE14%type;
60: L_ATTRIBUTE15 cn_role_pay_groups.ATTRIBUTE15%type;
61: L_CREATED_BY cn_role_pay_groups.CREATED_BY%type;
62: L_CREATION_DATE cn_role_pay_groups.CREATION_DATE%type;

Line 59: L_ATTRIBUTE14 cn_role_pay_groups.ATTRIBUTE14%type;

55: L_ATTRIBUTE10 cn_role_pay_groups.ATTRIBUTE10%type;
56: L_ATTRIBUTE11 cn_role_pay_groups.ATTRIBUTE11%type;
57: L_ATTRIBUTE12 cn_role_pay_groups.ATTRIBUTE12%type;
58: L_ATTRIBUTE13 cn_role_pay_groups.ATTRIBUTE13%type;
59: L_ATTRIBUTE14 cn_role_pay_groups.ATTRIBUTE14%type;
60: L_ATTRIBUTE15 cn_role_pay_groups.ATTRIBUTE15%type;
61: L_CREATED_BY cn_role_pay_groups.CREATED_BY%type;
62: L_CREATION_DATE cn_role_pay_groups.CREATION_DATE%type;
63: L_LAST_UPDATE_LOGIN cn_role_pay_groups.LAST_UPDATE_LOGIN%type;

Line 60: L_ATTRIBUTE15 cn_role_pay_groups.ATTRIBUTE15%type;

56: L_ATTRIBUTE11 cn_role_pay_groups.ATTRIBUTE11%type;
57: L_ATTRIBUTE12 cn_role_pay_groups.ATTRIBUTE12%type;
58: L_ATTRIBUTE13 cn_role_pay_groups.ATTRIBUTE13%type;
59: L_ATTRIBUTE14 cn_role_pay_groups.ATTRIBUTE14%type;
60: L_ATTRIBUTE15 cn_role_pay_groups.ATTRIBUTE15%type;
61: L_CREATED_BY cn_role_pay_groups.CREATED_BY%type;
62: L_CREATION_DATE cn_role_pay_groups.CREATION_DATE%type;
63: L_LAST_UPDATE_LOGIN cn_role_pay_groups.LAST_UPDATE_LOGIN%type;
64: L_LAST_UPDATE_DATE cn_role_pay_groups.LAST_UPDATE_DATE%type;

Line 61: L_CREATED_BY cn_role_pay_groups.CREATED_BY%type;

57: L_ATTRIBUTE12 cn_role_pay_groups.ATTRIBUTE12%type;
58: L_ATTRIBUTE13 cn_role_pay_groups.ATTRIBUTE13%type;
59: L_ATTRIBUTE14 cn_role_pay_groups.ATTRIBUTE14%type;
60: L_ATTRIBUTE15 cn_role_pay_groups.ATTRIBUTE15%type;
61: L_CREATED_BY cn_role_pay_groups.CREATED_BY%type;
62: L_CREATION_DATE cn_role_pay_groups.CREATION_DATE%type;
63: L_LAST_UPDATE_LOGIN cn_role_pay_groups.LAST_UPDATE_LOGIN%type;
64: L_LAST_UPDATE_DATE cn_role_pay_groups.LAST_UPDATE_DATE%type;
65: L_LAST_UPDATED_BY cn_role_pay_groups.LAST_UPDATED_BY%type;

Line 62: L_CREATION_DATE cn_role_pay_groups.CREATION_DATE%type;

58: L_ATTRIBUTE13 cn_role_pay_groups.ATTRIBUTE13%type;
59: L_ATTRIBUTE14 cn_role_pay_groups.ATTRIBUTE14%type;
60: L_ATTRIBUTE15 cn_role_pay_groups.ATTRIBUTE15%type;
61: L_CREATED_BY cn_role_pay_groups.CREATED_BY%type;
62: L_CREATION_DATE cn_role_pay_groups.CREATION_DATE%type;
63: L_LAST_UPDATE_LOGIN cn_role_pay_groups.LAST_UPDATE_LOGIN%type;
64: L_LAST_UPDATE_DATE cn_role_pay_groups.LAST_UPDATE_DATE%type;
65: L_LAST_UPDATED_BY cn_role_pay_groups.LAST_UPDATED_BY%type;
66: L_ORG_ID cn_role_pay_groups.ORG_ID%type;

Line 63: L_LAST_UPDATE_LOGIN cn_role_pay_groups.LAST_UPDATE_LOGIN%type;

59: L_ATTRIBUTE14 cn_role_pay_groups.ATTRIBUTE14%type;
60: L_ATTRIBUTE15 cn_role_pay_groups.ATTRIBUTE15%type;
61: L_CREATED_BY cn_role_pay_groups.CREATED_BY%type;
62: L_CREATION_DATE cn_role_pay_groups.CREATION_DATE%type;
63: L_LAST_UPDATE_LOGIN cn_role_pay_groups.LAST_UPDATE_LOGIN%type;
64: L_LAST_UPDATE_DATE cn_role_pay_groups.LAST_UPDATE_DATE%type;
65: L_LAST_UPDATED_BY cn_role_pay_groups.LAST_UPDATED_BY%type;
66: L_ORG_ID cn_role_pay_groups.ORG_ID%type;
67:

Line 64: L_LAST_UPDATE_DATE cn_role_pay_groups.LAST_UPDATE_DATE%type;

60: L_ATTRIBUTE15 cn_role_pay_groups.ATTRIBUTE15%type;
61: L_CREATED_BY cn_role_pay_groups.CREATED_BY%type;
62: L_CREATION_DATE cn_role_pay_groups.CREATION_DATE%type;
63: L_LAST_UPDATE_LOGIN cn_role_pay_groups.LAST_UPDATE_LOGIN%type;
64: L_LAST_UPDATE_DATE cn_role_pay_groups.LAST_UPDATE_DATE%type;
65: L_LAST_UPDATED_BY cn_role_pay_groups.LAST_UPDATED_BY%type;
66: L_ORG_ID cn_role_pay_groups.ORG_ID%type;
67:
68: cursor C is select ROWID from CN_ROLE_PAY_GROUPS

Line 65: L_LAST_UPDATED_BY cn_role_pay_groups.LAST_UPDATED_BY%type;

61: L_CREATED_BY cn_role_pay_groups.CREATED_BY%type;
62: L_CREATION_DATE cn_role_pay_groups.CREATION_DATE%type;
63: L_LAST_UPDATE_LOGIN cn_role_pay_groups.LAST_UPDATE_LOGIN%type;
64: L_LAST_UPDATE_DATE cn_role_pay_groups.LAST_UPDATE_DATE%type;
65: L_LAST_UPDATED_BY cn_role_pay_groups.LAST_UPDATED_BY%type;
66: L_ORG_ID cn_role_pay_groups.ORG_ID%type;
67:
68: cursor C is select ROWID from CN_ROLE_PAY_GROUPS
69: where ROLE_PAY_GROUP_ID = X_ROLE_PAY_GROUP_ID;

Line 66: L_ORG_ID cn_role_pay_groups.ORG_ID%type;

62: L_CREATION_DATE cn_role_pay_groups.CREATION_DATE%type;
63: L_LAST_UPDATE_LOGIN cn_role_pay_groups.LAST_UPDATE_LOGIN%type;
64: L_LAST_UPDATE_DATE cn_role_pay_groups.LAST_UPDATE_DATE%type;
65: L_LAST_UPDATED_BY cn_role_pay_groups.LAST_UPDATED_BY%type;
66: L_ORG_ID cn_role_pay_groups.ORG_ID%type;
67:
68: cursor C is select ROWID from CN_ROLE_PAY_GROUPS
69: where ROLE_PAY_GROUP_ID = X_ROLE_PAY_GROUP_ID;
70:

Line 68: cursor C is select ROWID from CN_ROLE_PAY_GROUPS

64: L_LAST_UPDATE_DATE cn_role_pay_groups.LAST_UPDATE_DATE%type;
65: L_LAST_UPDATED_BY cn_role_pay_groups.LAST_UPDATED_BY%type;
66: L_ORG_ID cn_role_pay_groups.ORG_ID%type;
67:
68: cursor C is select ROWID from CN_ROLE_PAY_GROUPS
69: where ROLE_PAY_GROUP_ID = X_ROLE_PAY_GROUP_ID;
70:
71: BEGIN
72: -- dbms_output.put_line('begin insert_row');

Line 146: INSERT INTO cn_role_pay_groups (

142: INTO L_ORG_ID FROM dual;
143:
144: -- dbms_output.put_line('before insert_row');
145:
146: INSERT INTO cn_role_pay_groups (
147: ROLE_PAY_GROUP_ID,
148: ROLE_ID,
149: PAY_GROUP_ID,
150: START_DATE,

Line 212: DELETE FROM cn_role_pay_groups

208:
209:
210: procedure DELETE_ROW (X_ROLE_PAY_GROUP_ID IN NUMBER) IS
211: BEGIN
212: DELETE FROM cn_role_pay_groups
213: WHERE role_pay_group_id = x_role_pay_group_id;
214: IF (sql%notfound) THEN
215: raise no_data_found;
216: END IF;

Line 219: END cn_role_pay_groups_pkg;

215: raise no_data_found;
216: END IF;
217: END delete_row;
218:
219: END cn_role_pay_groups_pkg;