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_PLANS_PKG dependencies on CN_ROLE_PLANS

Line 1: PACKAGE BODY CN_ROLE_PLANS_PKG AS

1: PACKAGE BODY CN_ROLE_PLANS_PKG AS
2: /* $Header: cntrlplb.pls 120.0 2005/07/13 00:41:51 chanthon 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_plans.END_DATE%type;

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

Line 45: L_ATTRIBUTE_CATEGORY cn_role_plans.ATTRIBUTE_CATEGORY%type;

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

Line 46: L_ATTRIBUTE1 cn_role_plans.ATTRIBUTE1%type;

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

Line 47: L_ATTRIBUTE2 cn_role_plans.ATTRIBUTE2%type;

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

Line 48: L_ATTRIBUTE3 cn_role_plans.ATTRIBUTE3%type;

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

Line 49: L_ATTRIBUTE4 cn_role_plans.ATTRIBUTE4%type;

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

Line 50: L_ATTRIBUTE5 cn_role_plans.ATTRIBUTE5%type;

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

Line 51: L_ATTRIBUTE6 cn_role_plans.ATTRIBUTE6%type;

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

Line 52: L_ATTRIBUTE7 cn_role_plans.ATTRIBUTE7%type;

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

Line 53: L_ATTRIBUTE8 cn_role_plans.ATTRIBUTE8%type;

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

Line 54: L_ATTRIBUTE9 cn_role_plans.ATTRIBUTE9%type;

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

Line 55: L_ATTRIBUTE10 cn_role_plans.ATTRIBUTE10%type;

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

Line 56: L_ATTRIBUTE11 cn_role_plans.ATTRIBUTE11%type;

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

Line 57: L_ATTRIBUTE12 cn_role_plans.ATTRIBUTE12%type;

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

Line 58: L_ATTRIBUTE13 cn_role_plans.ATTRIBUTE13%type;

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

Line 59: L_ATTRIBUTE14 cn_role_plans.ATTRIBUTE14%type;

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

Line 60: L_ATTRIBUTE15 cn_role_plans.ATTRIBUTE15%type;

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

Line 61: L_CREATED_BY cn_role_plans.CREATED_BY%type;

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

Line 62: L_CREATION_DATE cn_role_plans.CREATION_DATE%type;

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

Line 63: L_LAST_UPDATE_LOGIN cn_role_plans.LAST_UPDATE_LOGIN%type;

59: L_ATTRIBUTE14 cn_role_plans.ATTRIBUTE14%type;
60: L_ATTRIBUTE15 cn_role_plans.ATTRIBUTE15%type;
61: L_CREATED_BY cn_role_plans.CREATED_BY%type;
62: L_CREATION_DATE cn_role_plans.CREATION_DATE%type;
63: L_LAST_UPDATE_LOGIN cn_role_plans.LAST_UPDATE_LOGIN%type;
64: L_LAST_UPDATE_DATE cn_role_plans.LAST_UPDATE_DATE%type;
65: L_LAST_UPDATED_BY cn_role_plans.LAST_UPDATED_BY%type;
66:
67: cursor C is select ROWID from CN_ROLE_PLANS

Line 64: L_LAST_UPDATE_DATE cn_role_plans.LAST_UPDATE_DATE%type;

60: L_ATTRIBUTE15 cn_role_plans.ATTRIBUTE15%type;
61: L_CREATED_BY cn_role_plans.CREATED_BY%type;
62: L_CREATION_DATE cn_role_plans.CREATION_DATE%type;
63: L_LAST_UPDATE_LOGIN cn_role_plans.LAST_UPDATE_LOGIN%type;
64: L_LAST_UPDATE_DATE cn_role_plans.LAST_UPDATE_DATE%type;
65: L_LAST_UPDATED_BY cn_role_plans.LAST_UPDATED_BY%type;
66:
67: cursor C is select ROWID from CN_ROLE_PLANS
68: where ROLE_PLAN_ID = X_ROLE_PLAN_ID;

Line 65: L_LAST_UPDATED_BY cn_role_plans.LAST_UPDATED_BY%type;

61: L_CREATED_BY cn_role_plans.CREATED_BY%type;
62: L_CREATION_DATE cn_role_plans.CREATION_DATE%type;
63: L_LAST_UPDATE_LOGIN cn_role_plans.LAST_UPDATE_LOGIN%type;
64: L_LAST_UPDATE_DATE cn_role_plans.LAST_UPDATE_DATE%type;
65: L_LAST_UPDATED_BY cn_role_plans.LAST_UPDATED_BY%type;
66:
67: cursor C is select ROWID from CN_ROLE_PLANS
68: where ROLE_PLAN_ID = X_ROLE_PLAN_ID;
69:

Line 67: cursor C is select ROWID from CN_ROLE_PLANS

63: L_LAST_UPDATE_LOGIN cn_role_plans.LAST_UPDATE_LOGIN%type;
64: L_LAST_UPDATE_DATE cn_role_plans.LAST_UPDATE_DATE%type;
65: L_LAST_UPDATED_BY cn_role_plans.LAST_UPDATED_BY%type;
66:
67: cursor C is select ROWID from CN_ROLE_PLANS
68: where ROLE_PLAN_ID = X_ROLE_PLAN_ID;
69:
70: BEGIN
71: -- dbms_output.put_line('begin insert_row');

Line 142: INSERT INTO cn_role_plans (

138: INTO L_last_updated_by FROM dual;
139:
140: -- dbms_output.put_line('before insert_row');
141:
142: INSERT INTO cn_role_plans (
143: ROLE_PLAN_ID,
144: ROLE_ID,
145: COMP_PLAN_ID,
146: START_DATE,

Line 251: SELECT * FROM cn_role_plans

247: X_OBJECT_VERSION_NUMBER IN NUMBER,
248: X_ORG_ID IN NUMBER) IS
249:
250: CURSOR cur IS
251: SELECT * FROM cn_role_plans
252: WHERE role_plan_id = x_role_plan_id;
253:
254: rec cur%ROWTYPE;
255:

Line 345: UPDATE cn_role_plans SET

341: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,
342: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_last_updated_by)))
343: INTO rec.last_updated_by FROM dual;
344:
345: UPDATE cn_role_plans SET
346: role_id = rec.role_id,
347: comp_plan_id = rec.comp_plan_id,
348: start_date = rec.start_date,
349: end_date = rec.end_date,

Line 392: DELETE FROM cn_role_plans

388: END lock_row;
389:
390: procedure DELETE_ROW (X_ROLE_PLAN_ID IN NUMBER) IS
391: BEGIN
392: DELETE FROM cn_role_plans
393: WHERE role_plan_id = x_role_plan_id;
394: IF (sql%notfound) THEN
395: raise no_data_found;
396: END IF;

Line 399: END cn_role_plans_pkg;

395: raise no_data_found;
396: END IF;
397: END delete_row;
398:
399: END cn_role_plans_pkg;