DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on DUAL

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 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 (