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.HZ_HIERARCHY_V2PUB dependencies on FND_OBJECTS

Line 160: -- subject_table_name has foreign key fnd_objects.obj_name

156:
157: -----------------------------
158: -- validate parent_table_name
159: -----------------------------
160: -- subject_table_name has foreign key fnd_objects.obj_name
161: IF p_parent_table_name IS NOT NULL THEN
162: BEGIN
163: SELECT 'Y'
164: INTO l_dummy

Line 165: FROM fnd_objects fo

161: IF p_parent_table_name IS NOT NULL THEN
162: BEGIN
163: SELECT 'Y'
164: INTO l_dummy
165: FROM fnd_objects fo
166: WHERE fo.obj_name = p_parent_table_name;
167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN
169: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 172: fnd_message.set_token('TABLE', 'fnd_objects');

168: WHEN NO_DATA_FOUND THEN
169: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
170: fnd_message.set_token('FK', 'parent_table_name');
171: fnd_message.set_token('COLUMN', 'obj_name');
172: fnd_message.set_token('TABLE', 'fnd_objects');
173: fnd_msg_pub.add;
174: x_return_status := fnd_api.g_ret_sts_error;
175: END;
176: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 177: hz_utility_v2pub.debug(p_message=>'parent_table_name has foreign key fnd_objects.obj_name. ' ||

173: fnd_msg_pub.add;
174: x_return_status := fnd_api.g_ret_sts_error;
175: END;
176: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
177: hz_utility_v2pub.debug(p_message=>'parent_table_name has foreign key fnd_objects.obj_name. ' ||
178: 'x_return_status = ' || x_return_status,
179: p_prefix =>l_debug_prefix,
180: p_msg_level=>fnd_log.level_statement);
181: END IF;

Line 218: -- subject_table_name has foreign key fnd_objects.obj_name

214:
215: -----------------------------
216: -- validate child_table_name
217: -----------------------------
218: -- subject_table_name has foreign key fnd_objects.obj_name
219: IF p_child_table_name IS NOT NULL THEN
220: BEGIN
221: SELECT 'Y'
222: INTO l_dummy

Line 223: FROM fnd_objects fo

219: IF p_child_table_name IS NOT NULL THEN
220: BEGIN
221: SELECT 'Y'
222: INTO l_dummy
223: FROM fnd_objects fo
224: WHERE fo.obj_name = p_child_table_name;
225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN
227: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 230: fnd_message.set_token('TABLE', 'fnd_objects');

226: WHEN NO_DATA_FOUND THEN
227: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
228: fnd_message.set_token('FK', 'child_table_name');
229: fnd_message.set_token('COLUMN', 'obj_name');
230: fnd_message.set_token('TABLE', 'fnd_objects');
231: fnd_msg_pub.add;
232: x_return_status := fnd_api.g_ret_sts_error;
233: END;
234:

Line 236: hz_utility_v2pub.debug(p_message=>'child_table_name has foreign key fnd_objects.obj_name. ' ||

232: x_return_status := fnd_api.g_ret_sts_error;
233: END;
234:
235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
236: hz_utility_v2pub.debug(p_message=>'child_table_name has foreign key fnd_objects.obj_name. ' ||
237: 'x_return_status = ' || x_return_status,
238: p_prefix =>l_debug_prefix,
239: p_msg_level=>fnd_log.level_statement);
240: END IF;

Line 1234: FROM FND_OBJECTS FO,

1230: CURSOR c_obj_inst IS
1231: SELECT OBJ_NAME,
1232: PK1_COLUMN_NAME,
1233: PREDICATE
1234: FROM FND_OBJECTS FO,
1235: FND_OBJECT_INSTANCE_SETS FOIS
1236: WHERE FOIS.INSTANCE_SET_NAME = p_parent_object_type
1237: AND FOIS.OBJECT_ID = FO.OBJECT_ID;
1238: