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_GEOGRAPHY_STRUCTURE_PUB dependencies on FND_OBJECT_INSTANCE_SETS

Line 156: -- initialize the variables for creating fnd_object_instance_sets

152: x_program_login_id => NULL
153: );
154:
155:
156: -- initialize the variables for creating fnd_object_instance_sets
157:
158:
159: SELECT object_id into l_object_id
160: FROM FND_OBJECTS

Line 169: FROM FND_OBJECT_INSTANCE_SETS

165:
166: BEGIN
167: SELECT count(*)
168: INTO l_count
169: FROM FND_OBJECT_INSTANCE_SETS
170: WHERE INSTANCE_SET_NAME = l_geography_type;
171:
172: IF l_count = 0 THEN
173:

Line 174: SELECT FND_OBJECT_INSTANCE_SETS_S.nextval INTO l_instance_set_id FROM dual;

170: WHERE INSTANCE_SET_NAME = l_geography_type;
171:
172: IF l_count = 0 THEN
173:
174: SELECT FND_OBJECT_INSTANCE_SETS_S.nextval INTO l_instance_set_id FROM dual;
175: l_rowid := NULL;
176:
177: -- call the table handler to create fnd_object_instance_sets
178: FND_OBJECT_INSTANCE_SETS_PKG.INSERT_ROW (

Line 177: -- call the table handler to create fnd_object_instance_sets

173:
174: SELECT FND_OBJECT_INSTANCE_SETS_S.nextval INTO l_instance_set_id FROM dual;
175: l_rowid := NULL;
176:
177: -- call the table handler to create fnd_object_instance_sets
178: FND_OBJECT_INSTANCE_SETS_PKG.INSERT_ROW (
179: X_ROWID => l_rowid,
180: X_INSTANCE_SET_ID => l_instance_set_id,
181: X_INSTANCE_SET_NAME => l_geography_type,

Line 178: FND_OBJECT_INSTANCE_SETS_PKG.INSERT_ROW (

174: SELECT FND_OBJECT_INSTANCE_SETS_S.nextval INTO l_instance_set_id FROM dual;
175: l_rowid := NULL;
176:
177: -- call the table handler to create fnd_object_instance_sets
178: FND_OBJECT_INSTANCE_SETS_PKG.INSERT_ROW (
179: X_ROWID => l_rowid,
180: X_INSTANCE_SET_ID => l_instance_set_id,
181: X_INSTANCE_SET_NAME => l_geography_type,
182: X_OBJECT_ID => l_object_id,

Line 1295: -- initialize the variables for creating fnd_object_instance_sets

1291: );
1292:
1293: --dbms_output.put_line('After geography_type insert');
1294:
1295: -- initialize the variables for creating fnd_object_instance_sets
1296:
1297:
1298: SELECT object_id into l_object_id
1299: FROM FND_OBJECTS

Line 1308: FROM FND_OBJECT_INSTANCE_SETS

1304:
1305: BEGIN
1306: SELECT count(*)
1307: INTO l_count
1308: FROM FND_OBJECT_INSTANCE_SETS
1309: WHERE INSTANCE_SET_NAME = p_zone_type_rec.geography_type;
1310:
1311: IF l_count = 0 THEN
1312:

Line 1313: SELECT FND_OBJECT_INSTANCE_SETS_S.nextval INTO l_instance_set_id FROM dual;

1309: WHERE INSTANCE_SET_NAME = p_zone_type_rec.geography_type;
1310:
1311: IF l_count = 0 THEN
1312:
1313: SELECT FND_OBJECT_INSTANCE_SETS_S.nextval INTO l_instance_set_id FROM dual;
1314: l_rowid := NULL;
1315:
1316: -- call the table handler to create fnd_object_instance_sets
1317: FND_OBJECT_INSTANCE_SETS_PKG.INSERT_ROW (

Line 1316: -- call the table handler to create fnd_object_instance_sets

1312:
1313: SELECT FND_OBJECT_INSTANCE_SETS_S.nextval INTO l_instance_set_id FROM dual;
1314: l_rowid := NULL;
1315:
1316: -- call the table handler to create fnd_object_instance_sets
1317: FND_OBJECT_INSTANCE_SETS_PKG.INSERT_ROW (
1318: X_ROWID => l_rowid,
1319: X_INSTANCE_SET_ID => l_instance_set_id,
1320: X_INSTANCE_SET_NAME => p_zone_type_rec.geography_type,

Line 1317: FND_OBJECT_INSTANCE_SETS_PKG.INSERT_ROW (

1313: SELECT FND_OBJECT_INSTANCE_SETS_S.nextval INTO l_instance_set_id FROM dual;
1314: l_rowid := NULL;
1315:
1316: -- call the table handler to create fnd_object_instance_sets
1317: FND_OBJECT_INSTANCE_SETS_PKG.INSERT_ROW (
1318: X_ROWID => l_rowid,
1319: X_INSTANCE_SET_ID => l_instance_set_id,
1320: X_INSTANCE_SET_NAME => p_zone_type_rec.geography_type,
1321: X_OBJECT_ID => l_object_id,