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_PUB dependencies on CN_API

Line 31: role_name cn_roles.name%TYPE := cn_api.G_MISS_CHAR,

27: -- Note: form bug 725654 for G_MISS
28:
29: TYPE role_plan_rec_type IS RECORD
30: (
31: role_name cn_roles.name%TYPE := cn_api.G_MISS_CHAR,
32: role_id cn_role_plans.role_id%TYPE := NULL,
33: comp_plan_name cn_comp_plans.name%TYPE := cn_api.G_MISS_CHAR,
34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,
35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,

Line 33: comp_plan_name cn_comp_plans.name%TYPE := cn_api.G_MISS_CHAR,

29: TYPE role_plan_rec_type IS RECORD
30: (
31: role_name cn_roles.name%TYPE := cn_api.G_MISS_CHAR,
32: role_id cn_role_plans.role_id%TYPE := NULL,
33: comp_plan_name cn_comp_plans.name%TYPE := cn_api.G_MISS_CHAR,
34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,
35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,

Line 35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,

31: role_name cn_roles.name%TYPE := cn_api.G_MISS_CHAR,
32: role_id cn_role_plans.role_id%TYPE := NULL,
33: comp_plan_name cn_comp_plans.name%TYPE := cn_api.G_MISS_CHAR,
34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,
35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,

Line 36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,

32: role_id cn_role_plans.role_id%TYPE := NULL,
33: comp_plan_name cn_comp_plans.name%TYPE := cn_api.G_MISS_CHAR,
34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,
35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,

Line 37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,

33: comp_plan_name cn_comp_plans.name%TYPE := cn_api.G_MISS_CHAR,
34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,
35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,

Line 38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,

34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,
35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,

Line 39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,

35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,

Line 40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,

36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,

Line 41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,

37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,

Line 42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,

38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,

Line 43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,

39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,

Line 44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,

40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,

Line 45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,

41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,

Line 46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,

42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,

Line 47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,

43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,

Line 48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,

44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,
52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,

Line 49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,

45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,
52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,
53: object_version_number cn_role_plans.object_version_number%TYPE := NULL,

Line 50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,

46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,
52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,
53: object_version_number cn_role_plans.object_version_number%TYPE := NULL,
54: org_id cn_role_plans.org_id%TYPE := NULL

Line 51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,

47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,
52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,
53: object_version_number cn_role_plans.object_version_number%TYPE := NULL,
54: org_id cn_role_plans.org_id%TYPE := NULL
55:

Line 52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,

48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,
52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,
53: object_version_number cn_role_plans.object_version_number%TYPE := NULL,
54: org_id cn_role_plans.org_id%TYPE := NULL
55:
56: );

Line 70: := cn_api.get_lkup_meaning('ROLE_NAME','ROLE_OBJECT_TYPE');

66: --
67: G_MISS_ROLE_PLAN_REC role_plan_rec_type;
68: G_MISS_ROLE_PLAN_TBL role_plan_rec_tbl_type;
69: G_ROLE_NAME CONSTANT VARCHAR2(80)
70: := cn_api.get_lkup_meaning('ROLE_NAME','ROLE_OBJECT_TYPE');
71: G_CP_NAME CONSTANT VARCHAR2(80)
72: := cn_api.get_lkup_meaning('CP_NAME','CP_OBJECT_TYPE');
73: G_START_DATE CONSTANT VARCHAR2(80)
74: := cn_api.get_lkup_meaning('START_DATE','CN_OBJECT_TYPE');

Line 72: := cn_api.get_lkup_meaning('CP_NAME','CP_OBJECT_TYPE');

68: G_MISS_ROLE_PLAN_TBL role_plan_rec_tbl_type;
69: G_ROLE_NAME CONSTANT VARCHAR2(80)
70: := cn_api.get_lkup_meaning('ROLE_NAME','ROLE_OBJECT_TYPE');
71: G_CP_NAME CONSTANT VARCHAR2(80)
72: := cn_api.get_lkup_meaning('CP_NAME','CP_OBJECT_TYPE');
73: G_START_DATE CONSTANT VARCHAR2(80)
74: := cn_api.get_lkup_meaning('START_DATE','CN_OBJECT_TYPE');
75:
76: -- Start of Comments

Line 74: := cn_api.get_lkup_meaning('START_DATE','CN_OBJECT_TYPE');

70: := cn_api.get_lkup_meaning('ROLE_NAME','ROLE_OBJECT_TYPE');
71: G_CP_NAME CONSTANT VARCHAR2(80)
72: := cn_api.get_lkup_meaning('CP_NAME','CP_OBJECT_TYPE');
73: G_START_DATE CONSTANT VARCHAR2(80)
74: := cn_api.get_lkup_meaning('START_DATE','CN_OBJECT_TYPE');
75:
76: -- Start of Comments
77: -- API name : Create_Role_Plan
78: -- Type : Public.