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.HXC_PUBLIC_TEMP_GROUP_COMP_API dependencies on HXC_ENTITY_GROUP_COMPS

Line 73: l_object_version_number HXC_ENTITY_GROUP_COMPS.OBJECT_VERSION_NUMBER%TYPE;

69: ,p_attribute1 IN VARCHAR2
70: ,p_attribute_category IN VARCHAR2
71: )
72: IS
73: l_object_version_number HXC_ENTITY_GROUP_COMPS.OBJECT_VERSION_NUMBER%TYPE;
74: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_COMP_ID%TYPE;
75: l_attribute2 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE2%TYPE;
76: l_attribute3 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE3%TYPE;
77: l_attribute4 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE4%TYPE;

Line 74: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_COMP_ID%TYPE;

70: ,p_attribute_category IN VARCHAR2
71: )
72: IS
73: l_object_version_number HXC_ENTITY_GROUP_COMPS.OBJECT_VERSION_NUMBER%TYPE;
74: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_COMP_ID%TYPE;
75: l_attribute2 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE2%TYPE;
76: l_attribute3 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE3%TYPE;
77: l_attribute4 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE4%TYPE;
78: l_attribute5 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE5%TYPE;

Line 75: l_attribute2 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE2%TYPE;

71: )
72: IS
73: l_object_version_number HXC_ENTITY_GROUP_COMPS.OBJECT_VERSION_NUMBER%TYPE;
74: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_COMP_ID%TYPE;
75: l_attribute2 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE2%TYPE;
76: l_attribute3 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE3%TYPE;
77: l_attribute4 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE4%TYPE;
78: l_attribute5 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE5%TYPE;
79: l_attribute6 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE6%TYPE;

Line 76: l_attribute3 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE3%TYPE;

72: IS
73: l_object_version_number HXC_ENTITY_GROUP_COMPS.OBJECT_VERSION_NUMBER%TYPE;
74: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_COMP_ID%TYPE;
75: l_attribute2 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE2%TYPE;
76: l_attribute3 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE3%TYPE;
77: l_attribute4 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE4%TYPE;
78: l_attribute5 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE5%TYPE;
79: l_attribute6 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE6%TYPE;
80: l_attribute7 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE7%TYPE;

Line 77: l_attribute4 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE4%TYPE;

73: l_object_version_number HXC_ENTITY_GROUP_COMPS.OBJECT_VERSION_NUMBER%TYPE;
74: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_COMP_ID%TYPE;
75: l_attribute2 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE2%TYPE;
76: l_attribute3 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE3%TYPE;
77: l_attribute4 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE4%TYPE;
78: l_attribute5 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE5%TYPE;
79: l_attribute6 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE6%TYPE;
80: l_attribute7 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE7%TYPE;
81: l_attribute8 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE8%TYPE;

Line 78: l_attribute5 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE5%TYPE;

74: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_COMP_ID%TYPE;
75: l_attribute2 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE2%TYPE;
76: l_attribute3 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE3%TYPE;
77: l_attribute4 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE4%TYPE;
78: l_attribute5 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE5%TYPE;
79: l_attribute6 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE6%TYPE;
80: l_attribute7 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE7%TYPE;
81: l_attribute8 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE8%TYPE;
82: l_attribute9 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE9%TYPE;

Line 79: l_attribute6 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE6%TYPE;

75: l_attribute2 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE2%TYPE;
76: l_attribute3 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE3%TYPE;
77: l_attribute4 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE4%TYPE;
78: l_attribute5 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE5%TYPE;
79: l_attribute6 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE6%TYPE;
80: l_attribute7 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE7%TYPE;
81: l_attribute8 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE8%TYPE;
82: l_attribute9 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE9%TYPE;
83: l_attribute10 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE10%TYPE;

Line 80: l_attribute7 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE7%TYPE;

76: l_attribute3 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE3%TYPE;
77: l_attribute4 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE4%TYPE;
78: l_attribute5 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE5%TYPE;
79: l_attribute6 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE6%TYPE;
80: l_attribute7 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE7%TYPE;
81: l_attribute8 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE8%TYPE;
82: l_attribute9 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE9%TYPE;
83: l_attribute10 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE10%TYPE;
84: l_attribute11 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE11%TYPE;

Line 81: l_attribute8 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE8%TYPE;

77: l_attribute4 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE4%TYPE;
78: l_attribute5 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE5%TYPE;
79: l_attribute6 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE6%TYPE;
80: l_attribute7 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE7%TYPE;
81: l_attribute8 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE8%TYPE;
82: l_attribute9 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE9%TYPE;
83: l_attribute10 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE10%TYPE;
84: l_attribute11 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE11%TYPE;
85: l_attribute12 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE12%TYPE;

Line 82: l_attribute9 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE9%TYPE;

78: l_attribute5 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE5%TYPE;
79: l_attribute6 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE6%TYPE;
80: l_attribute7 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE7%TYPE;
81: l_attribute8 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE8%TYPE;
82: l_attribute9 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE9%TYPE;
83: l_attribute10 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE10%TYPE;
84: l_attribute11 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE11%TYPE;
85: l_attribute12 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE12%TYPE;
86: l_attribute13 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE13%TYPE;

Line 83: l_attribute10 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE10%TYPE;

79: l_attribute6 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE6%TYPE;
80: l_attribute7 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE7%TYPE;
81: l_attribute8 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE8%TYPE;
82: l_attribute9 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE9%TYPE;
83: l_attribute10 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE10%TYPE;
84: l_attribute11 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE11%TYPE;
85: l_attribute12 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE12%TYPE;
86: l_attribute13 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE13%TYPE;
87: l_attribute14 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE14%TYPE;

Line 84: l_attribute11 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE11%TYPE;

80: l_attribute7 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE7%TYPE;
81: l_attribute8 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE8%TYPE;
82: l_attribute9 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE9%TYPE;
83: l_attribute10 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE10%TYPE;
84: l_attribute11 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE11%TYPE;
85: l_attribute12 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE12%TYPE;
86: l_attribute13 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE13%TYPE;
87: l_attribute14 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE14%TYPE;
88: l_attribute15 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE15%TYPE;

Line 85: l_attribute12 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE12%TYPE;

81: l_attribute8 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE8%TYPE;
82: l_attribute9 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE9%TYPE;
83: l_attribute10 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE10%TYPE;
84: l_attribute11 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE11%TYPE;
85: l_attribute12 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE12%TYPE;
86: l_attribute13 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE13%TYPE;
87: l_attribute14 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE14%TYPE;
88: l_attribute15 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE15%TYPE;
89: l_attribute16 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE16%TYPE;

Line 86: l_attribute13 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE13%TYPE;

82: l_attribute9 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE9%TYPE;
83: l_attribute10 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE10%TYPE;
84: l_attribute11 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE11%TYPE;
85: l_attribute12 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE12%TYPE;
86: l_attribute13 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE13%TYPE;
87: l_attribute14 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE14%TYPE;
88: l_attribute15 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE15%TYPE;
89: l_attribute16 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE16%TYPE;
90: l_attribute17 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE17%TYPE;

Line 87: l_attribute14 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE14%TYPE;

83: l_attribute10 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE10%TYPE;
84: l_attribute11 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE11%TYPE;
85: l_attribute12 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE12%TYPE;
86: l_attribute13 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE13%TYPE;
87: l_attribute14 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE14%TYPE;
88: l_attribute15 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE15%TYPE;
89: l_attribute16 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE16%TYPE;
90: l_attribute17 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE17%TYPE;
91: l_attribute18 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE18%TYPE;

Line 88: l_attribute15 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE15%TYPE;

84: l_attribute11 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE11%TYPE;
85: l_attribute12 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE12%TYPE;
86: l_attribute13 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE13%TYPE;
87: l_attribute14 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE14%TYPE;
88: l_attribute15 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE15%TYPE;
89: l_attribute16 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE16%TYPE;
90: l_attribute17 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE17%TYPE;
91: l_attribute18 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE18%TYPE;
92: l_attribute19 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE19%TYPE;

Line 89: l_attribute16 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE16%TYPE;

85: l_attribute12 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE12%TYPE;
86: l_attribute13 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE13%TYPE;
87: l_attribute14 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE14%TYPE;
88: l_attribute15 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE15%TYPE;
89: l_attribute16 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE16%TYPE;
90: l_attribute17 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE17%TYPE;
91: l_attribute18 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE18%TYPE;
92: l_attribute19 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE19%TYPE;
93: l_attribute20 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE20%TYPE;

Line 90: l_attribute17 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE17%TYPE;

86: l_attribute13 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE13%TYPE;
87: l_attribute14 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE14%TYPE;
88: l_attribute15 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE15%TYPE;
89: l_attribute16 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE16%TYPE;
90: l_attribute17 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE17%TYPE;
91: l_attribute18 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE18%TYPE;
92: l_attribute19 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE19%TYPE;
93: l_attribute20 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE20%TYPE;
94: l_attribute21 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE21%TYPE;

Line 91: l_attribute18 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE18%TYPE;

87: l_attribute14 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE14%TYPE;
88: l_attribute15 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE15%TYPE;
89: l_attribute16 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE16%TYPE;
90: l_attribute17 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE17%TYPE;
91: l_attribute18 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE18%TYPE;
92: l_attribute19 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE19%TYPE;
93: l_attribute20 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE20%TYPE;
94: l_attribute21 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE21%TYPE;
95: l_attribute22 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE22%TYPE;

Line 92: l_attribute19 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE19%TYPE;

88: l_attribute15 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE15%TYPE;
89: l_attribute16 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE16%TYPE;
90: l_attribute17 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE17%TYPE;
91: l_attribute18 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE18%TYPE;
92: l_attribute19 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE19%TYPE;
93: l_attribute20 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE20%TYPE;
94: l_attribute21 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE21%TYPE;
95: l_attribute22 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE22%TYPE;
96: l_attribute23 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE23%TYPE;

Line 93: l_attribute20 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE20%TYPE;

89: l_attribute16 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE16%TYPE;
90: l_attribute17 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE17%TYPE;
91: l_attribute18 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE18%TYPE;
92: l_attribute19 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE19%TYPE;
93: l_attribute20 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE20%TYPE;
94: l_attribute21 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE21%TYPE;
95: l_attribute22 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE22%TYPE;
96: l_attribute23 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE23%TYPE;
97: l_attribute24 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE24%TYPE;

Line 94: l_attribute21 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE21%TYPE;

90: l_attribute17 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE17%TYPE;
91: l_attribute18 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE18%TYPE;
92: l_attribute19 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE19%TYPE;
93: l_attribute20 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE20%TYPE;
94: l_attribute21 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE21%TYPE;
95: l_attribute22 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE22%TYPE;
96: l_attribute23 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE23%TYPE;
97: l_attribute24 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE24%TYPE;
98: l_attribute25 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE25%TYPE;

Line 95: l_attribute22 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE22%TYPE;

91: l_attribute18 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE18%TYPE;
92: l_attribute19 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE19%TYPE;
93: l_attribute20 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE20%TYPE;
94: l_attribute21 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE21%TYPE;
95: l_attribute22 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE22%TYPE;
96: l_attribute23 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE23%TYPE;
97: l_attribute24 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE24%TYPE;
98: l_attribute25 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE25%TYPE;
99: l_attribute26 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE26%TYPE;

Line 96: l_attribute23 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE23%TYPE;

92: l_attribute19 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE19%TYPE;
93: l_attribute20 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE20%TYPE;
94: l_attribute21 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE21%TYPE;
95: l_attribute22 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE22%TYPE;
96: l_attribute23 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE23%TYPE;
97: l_attribute24 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE24%TYPE;
98: l_attribute25 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE25%TYPE;
99: l_attribute26 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE26%TYPE;
100: l_attribute27 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE27%TYPE;

Line 97: l_attribute24 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE24%TYPE;

93: l_attribute20 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE20%TYPE;
94: l_attribute21 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE21%TYPE;
95: l_attribute22 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE22%TYPE;
96: l_attribute23 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE23%TYPE;
97: l_attribute24 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE24%TYPE;
98: l_attribute25 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE25%TYPE;
99: l_attribute26 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE26%TYPE;
100: l_attribute27 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE27%TYPE;
101: l_attribute28 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE28%TYPE;

Line 98: l_attribute25 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE25%TYPE;

94: l_attribute21 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE21%TYPE;
95: l_attribute22 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE22%TYPE;
96: l_attribute23 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE23%TYPE;
97: l_attribute24 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE24%TYPE;
98: l_attribute25 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE25%TYPE;
99: l_attribute26 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE26%TYPE;
100: l_attribute27 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE27%TYPE;
101: l_attribute28 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE28%TYPE;
102: l_attribute29 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE29%TYPE;

Line 99: l_attribute26 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE26%TYPE;

95: l_attribute22 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE22%TYPE;
96: l_attribute23 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE23%TYPE;
97: l_attribute24 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE24%TYPE;
98: l_attribute25 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE25%TYPE;
99: l_attribute26 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE26%TYPE;
100: l_attribute27 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE27%TYPE;
101: l_attribute28 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE28%TYPE;
102: l_attribute29 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE29%TYPE;
103: l_attribute30 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE30%TYPE;

Line 100: l_attribute27 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE27%TYPE;

96: l_attribute23 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE23%TYPE;
97: l_attribute24 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE24%TYPE;
98: l_attribute25 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE25%TYPE;
99: l_attribute26 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE26%TYPE;
100: l_attribute27 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE27%TYPE;
101: l_attribute28 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE28%TYPE;
102: l_attribute29 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE29%TYPE;
103: l_attribute30 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE30%TYPE;
104:

Line 101: l_attribute28 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE28%TYPE;

97: l_attribute24 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE24%TYPE;
98: l_attribute25 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE25%TYPE;
99: l_attribute26 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE26%TYPE;
100: l_attribute27 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE27%TYPE;
101: l_attribute28 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE28%TYPE;
102: l_attribute29 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE29%TYPE;
103: l_attribute30 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE30%TYPE;
104:
105: CURSOR csr_entity_comp_exists IS

Line 102: l_attribute29 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE29%TYPE;

98: l_attribute25 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE25%TYPE;
99: l_attribute26 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE26%TYPE;
100: l_attribute27 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE27%TYPE;
101: l_attribute28 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE28%TYPE;
102: l_attribute29 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE29%TYPE;
103: l_attribute30 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE30%TYPE;
104:
105: CURSOR csr_entity_comp_exists IS
106: SELECT 'error'

Line 103: l_attribute30 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE30%TYPE;

99: l_attribute26 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE26%TYPE;
100: l_attribute27 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE27%TYPE;
101: l_attribute28 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE28%TYPE;
102: l_attribute29 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE29%TYPE;
103: l_attribute30 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE30%TYPE;
104:
105: CURSOR csr_entity_comp_exists IS
106: SELECT 'error'
107: FROM dual

Line 110: FROM hxc_entity_group_comps egc

106: SELECT 'error'
107: FROM dual
108: WHERE EXISTS (
109: SELECT 'x'
110: FROM hxc_entity_group_comps egc
111: WHERE egc.entity_group_id = p_entity_group_id
112: AND egc.entity_type = 'PUBLIC_TEMPLATE_GROUP'
113: AND egc.entity_id = p_entity_id );
114:

Line 120: FROM hxc_entity_group_comps egc

116: SELECT 'error'
117: FROM dual
118: WHERE EXISTS (
119: SELECT 'x'
120: FROM hxc_entity_group_comps egc
121: WHERE egc.entity_group_id = p_entity_group_id
122: AND egc.entity_type = 'PUBLIC_TEMPLATE_GROUP'
123: AND egc.attribute1 = p_attribute1 );
124:

Line 239: l_object_version_number HXC_ENTITY_GROUP_COMPS.OBJECT_VERSION_NUMBER%TYPE;

235: p_entity_group_id IN NUMBER
236: ,p_entity_id IN VARCHAR2
237: )
238: IS
239: l_object_version_number HXC_ENTITY_GROUP_COMPS.OBJECT_VERSION_NUMBER%TYPE;
240: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_COMP_ID%TYPE;
241: l_template_code VARCHAR2(5);
242:
243: CURSOR csr_get_entity_comp_id IS

Line 240: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_COMP_ID%TYPE;

236: ,p_entity_id IN VARCHAR2
237: )
238: IS
239: l_object_version_number HXC_ENTITY_GROUP_COMPS.OBJECT_VERSION_NUMBER%TYPE;
240: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_COMP_ID%TYPE;
241: l_template_code VARCHAR2(5);
242:
243: CURSOR csr_get_entity_comp_id IS
244: SELECT

Line 248: hxc_entity_group_comps egc

244: SELECT
245: object_version_number,
246: entity_group_comp_id
247: FROM
248: hxc_entity_group_comps egc
249: WHERE
250: entity_group_id = p_entity_group_id
251: AND entity_id = TO_NUMBER(p_entity_id) ;
252:

Line 258: hxc_entity_group_comps egc

254: SELECT
255: object_version_number,
256: entity_group_comp_id
257: FROM
258: hxc_entity_group_comps egc
259: WHERE
260: entity_group_id = p_entity_group_id
261: AND attribute1 = p_entity_id ;
262:

Line 393: l_entity_id HXC_ENTITY_GROUP_COMPS.ENTITY_ID%TYPE;

389: )
390: IS
391: l_error VARCHAR2(5) := NULL;
392: l_count NUMBER;
393: l_entity_id HXC_ENTITY_GROUP_COMPS.ENTITY_ID%TYPE;
394: l_template_id VARCHAR2(50);
395: l_template_code VARCHAR2(10);
396: BEGIN
397:

Line 481: hxc_entity_group_comps hegc

477:
478: CURSOR cur_attached_public_temp_grps(p_template_id in hxc_time_building_blocks.time_building_block_id%type)
479: IS
480: SELECT heg.NAME FROM hxc_entity_groups heg ,
481: hxc_entity_group_comps hegc
482: WHERE
483: heg.ENTITY_TYPE = 'PUBLIC_TEMPLATE_GROUP'
484: and heg.entity_group_id =hegc.entity_group_id
485: and hegc.entity_id = p_template_id and rownum