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_DIM_HIERARCHIES_PVT dependencies on FND_API

Line 7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3:
4: -- Create a new hierarchy type
5: PROCEDURE Create_Hierarchy_Type
6: (p_api_version IN NUMBER, -- required
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_name IN CN_DIMENSIONS.NAME%TYPE,
11: p_base_table_id IN CN_OBJ_TABLES_V.TABLE_ID%TYPE,

Line 8: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4: -- Create a new hierarchy type
5: PROCEDURE Create_Hierarchy_Type
6: (p_api_version IN NUMBER, -- required
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_name IN CN_DIMENSIONS.NAME%TYPE,
11: p_base_table_id IN CN_OBJ_TABLES_V.TABLE_ID%TYPE,
12: p_primary_key_id IN CN_OBJ_COLUMNS_V.COLUMN_ID%TYPE,

Line 9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

5: PROCEDURE Create_Hierarchy_Type
6: (p_api_version IN NUMBER, -- required
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_name IN CN_DIMENSIONS.NAME%TYPE,
11: p_base_table_id IN CN_OBJ_TABLES_V.TABLE_ID%TYPE,
12: p_primary_key_id IN CN_OBJ_COLUMNS_V.COLUMN_ID%TYPE,
13: p_user_column_id IN CN_OBJ_COLUMNS_V.COLUMN_ID%TYPE,

Line 26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

22:
23: -- Update hierarchy type (only name is updateable)
24: PROCEDURE Update_Hierarchy_Type
25: (p_api_version IN NUMBER, -- required
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
30: p_name IN CN_DIMENSIONS.NAME%TYPE,

Line 27: p_commit IN VARCHAR2 := FND_API.G_FALSE,

23: -- Update hierarchy type (only name is updateable)
24: PROCEDURE Update_Hierarchy_Type
25: (p_api_version IN NUMBER, -- required
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
30: p_name IN CN_DIMENSIONS.NAME%TYPE,
31: p_object_version_number IN OUT NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,

Line 28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

24: PROCEDURE Update_Hierarchy_Type
25: (p_api_version IN NUMBER, -- required
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
30: p_name IN CN_DIMENSIONS.NAME%TYPE,
31: p_object_version_number IN OUT NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
32: --R12 MOAC Changes--Start

Line 43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

39:
40: -- Delete hierarchy type
41: PROCEDURE Delete_Hierarchy_Type
42: (p_api_version IN NUMBER, -- required
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
47: --R12 MOAC Changes--Start

Line 44: p_commit IN VARCHAR2 := FND_API.G_FALSE,

40: -- Delete hierarchy type
41: PROCEDURE Delete_Hierarchy_Type
42: (p_api_version IN NUMBER, -- required
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
47: --R12 MOAC Changes--Start
48: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,

Line 45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

41: PROCEDURE Delete_Hierarchy_Type
42: (p_api_version IN NUMBER, -- required
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
47: --R12 MOAC Changes--Start
48: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
49: --R12 MOAC Changes--End

Line 57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

53:
54: -- Create head hierarchy
55: PROCEDURE Create_Head_Hierarchy
56: (p_api_version IN NUMBER, -- required
57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_dimension_id IN CN_HEAD_HIERARCHIES.DIMENSION_ID%TYPE,
61: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,

Line 58: p_commit IN VARCHAR2 := FND_API.G_FALSE,

54: -- Create head hierarchy
55: PROCEDURE Create_Head_Hierarchy
56: (p_api_version IN NUMBER, -- required
57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_dimension_id IN CN_HEAD_HIERARCHIES.DIMENSION_ID%TYPE,
61: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,
62: --R12 MOAC Changes--Start

Line 59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

55: PROCEDURE Create_Head_Hierarchy
56: (p_api_version IN NUMBER, -- required
57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_dimension_id IN CN_HEAD_HIERARCHIES.DIMENSION_ID%TYPE,
61: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,
62: --R12 MOAC Changes--Start
63: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,

Line 73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

69:
70: -- Update head hierarchy (only name is updateable)
71: PROCEDURE Update_Head_Hierarchy
72: (p_api_version IN NUMBER, -- required
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,
77: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,

Line 74: p_commit IN VARCHAR2 := FND_API.G_FALSE,

70: -- Update head hierarchy (only name is updateable)
71: PROCEDURE Update_Head_Hierarchy
72: (p_api_version IN NUMBER, -- required
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,
77: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,
78: p_object_version_number IN OUT NOCOPY CN_HEAD_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,

Line 75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

71: PROCEDURE Update_Head_Hierarchy
72: (p_api_version IN NUMBER, -- required
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,
77: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,
78: p_object_version_number IN OUT NOCOPY CN_HEAD_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
79: --R12 MOAC Changes--Start

Line 89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

85:
86: -- Delete head hierarchy
87: PROCEDURE Delete_Head_Hierarchy
88: (p_api_version IN NUMBER, -- required
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,
93: --R12 MOAC Changes--Start

Line 90: p_commit IN VARCHAR2 := FND_API.G_FALSE,

86: -- Delete head hierarchy
87: PROCEDURE Delete_Head_Hierarchy
88: (p_api_version IN NUMBER, -- required
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,
93: --R12 MOAC Changes--Start
94: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,

Line 91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

87: PROCEDURE Delete_Head_Hierarchy
88: (p_api_version IN NUMBER, -- required
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,
93: --R12 MOAC Changes--Start
94: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,
95: --R12 MOAC Changes--End

Line 103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

99:
100: -- Create dimension hierarchy
101: PROCEDURE Create_Dim_Hierarchy
102: (p_api_version IN NUMBER, -- required
103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106: p_head_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
107: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,

Line 104: p_commit IN VARCHAR2 := FND_API.G_FALSE,

100: -- Create dimension hierarchy
101: PROCEDURE Create_Dim_Hierarchy
102: (p_api_version IN NUMBER, -- required
103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106: p_head_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
107: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
108: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,

Line 105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

101: PROCEDURE Create_Dim_Hierarchy
102: (p_api_version IN NUMBER, -- required
103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106: p_head_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
107: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
108: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
109: p_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,

Line 121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

117:
118: -- Update dimension hierarchy (only dates are updateable)
119: PROCEDURE Update_Dim_Hierarchy
120: (p_api_version IN NUMBER, -- required
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
125: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,

Line 122: p_commit IN VARCHAR2 := FND_API.G_FALSE,

118: -- Update dimension hierarchy (only dates are updateable)
119: PROCEDURE Update_Dim_Hierarchy
120: (p_api_version IN NUMBER, -- required
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
125: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
126: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,

Line 123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

119: PROCEDURE Update_Dim_Hierarchy
120: (p_api_version IN NUMBER, -- required
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
125: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
126: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
127: p_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,

Line 138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

134:
135: -- Delete dimension hierarchy
136: PROCEDURE Delete_Dim_Hierarchy
137: (p_api_version IN NUMBER, -- required
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
142: --R12 MOAC Changes--Start

Line 139: p_commit IN VARCHAR2 := FND_API.G_FALSE,

135: -- Delete dimension hierarchy
136: PROCEDURE Delete_Dim_Hierarchy
137: (p_api_version IN NUMBER, -- required
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
142: --R12 MOAC Changes--Start
143: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,

Line 140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

136: PROCEDURE Delete_Dim_Hierarchy
137: (p_api_version IN NUMBER, -- required
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
142: --R12 MOAC Changes--Start
143: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
144: --R12 MOAC Changes--End

Line 152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

148:
149: -- Create edge
150: PROCEDURE Create_Edge
151: (p_api_version IN NUMBER, -- required
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
156: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,

Line 153: p_commit IN VARCHAR2 := FND_API.G_FALSE,

149: -- Create edge
150: PROCEDURE Create_Edge
151: (p_api_version IN NUMBER, -- required
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
156: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
157: p_name IN CN_HIERARCHY_NODES.NAME%TYPE,

Line 154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

150: PROCEDURE Create_Edge
151: (p_api_version IN NUMBER, -- required
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
156: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
157: p_name IN CN_HIERARCHY_NODES.NAME%TYPE,
158: p_external_id IN CN_HIERARCHY_NODES.EXTERNAL_ID%TYPE,

Line 170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

166:
167: -- Delete edge
168: PROCEDURE Delete_Edge
169: (p_api_version IN NUMBER, -- required
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
174: p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,

Line 171: p_commit IN VARCHAR2 := FND_API.G_FALSE,

167: -- Delete edge
168: PROCEDURE Delete_Edge
169: (p_api_version IN NUMBER, -- required
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
174: p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,
175: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,

Line 172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

168: PROCEDURE Delete_Edge
169: (p_api_version IN NUMBER, -- required
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
174: p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,
175: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
176: --R12 MOAC Changes--Start