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.FEM_HIER_UTILS_PVT dependencies on DUAL

Line 1452: l_select_stmt := ' SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||

1448:
1449: IF(l_child_depth_num <> 1) -- Not a root node
1450: THEN
1451:
1452: l_select_stmt := ' SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||
1453: ' SELECT 1 FROM ' || p_hier_table_name ||
1454: ' WHERE hierarchy_obj_def_id = :1 ' ||
1455: ' AND parent_id = :2 ' ||
1456: ' AND child_id <> :3 ' ||

Line 1629: l_select_stmt := ' SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||

1625:
1626: IF(l_child_depth_num <> 1) -- Not a root node
1627: THEN
1628:
1629: l_select_stmt := ' SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||
1630: ' SELECT 1 FROM ' || p_hier_table_name ||
1631: ' WHERE hierarchy_obj_def_id = :1 ' ||
1632: ' AND parent_id = :2 ' ||
1633: ' AND child_id <> :3 ' ||

Line 2311: from dual;

2307: close l_hier_details_csr;
2308:
2309: select fem_object_id_seq.nextval
2310: into l_new_object_id
2311: from dual;
2312:
2313: -- dbms_output.put_line('duplicate_hierarchy: l_new_object_id = '||l_new_object_id);
2314: FEM_OBJECT_CATALOG_PKG.insert_row(
2315: X_ROWID => l_row_id,

Line 4437: from dual;

4433: close l_object_definition_csr;
4434:
4435: select fem_object_definition_id_seq.nextval
4436: into l_new_version_id
4437: from dual;
4438:
4439: FEM_OBJECT_DEFINITION_PKG.INSERT_ROW (X_ROWID => l_row_id,
4440: X_OBJECT_DEFINITION_ID => l_new_version_id,
4441: X_OBJECT_VERSION_NUMBER => 1,

Line 5094: SELECT 'Y' FROM dual

5090:
5091: CURSOR other_version_exists_csr (p_object_id IN NUMBER,
5092: p_version_id IN NUMBER)
5093: IS
5094: SELECT 'Y' FROM dual
5095: WHERE EXISTs
5096: (SELECT 1
5097: FROM fem_object_catalog_vl obj,
5098: fem_object_definition_vl ver

Line 7205: l_stmt := 'SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||

7201: THEN
7202: -- construct select statement for root node
7203: IF (l_value_set_required_flag = 'Y')
7204: THEN
7205: l_stmt := 'SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||
7206: 'SELECT H.CHILD_ID ';
7207:
7208: -- Will need to use different hierarchy table for secure user
7209: IF (p_user_mode IS NOT NULL AND p_user_mode = 'SECURED')

Line 7265: l_stmt := 'SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||

7261:
7262: ELSE
7263: -- construct select statement for dimension not using value set
7264:
7265: l_stmt := 'SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||
7266: 'SELECT H.CHILD_ID ';
7267:
7268: -- Will need to use different hierarchy table for secure user
7269: IF (p_user_mode IS NOT NULL AND p_user_mode = 'SECURED')

Line 7318: l_stmt := 'SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||

7314: ELSE
7315: -- construct select statement for intermediate node
7316: IF (l_value_set_required_flag = 'Y')
7317: THEN
7318: l_stmt := 'SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||
7319: 'SELECT H.CHILD_ID ';
7320:
7321: -- Will need to use different hierarchy table for secure user
7322: IF (p_user_mode IS NOT NULL AND p_user_mode = 'SECURED')

Line 7373: l_stmt := 'SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||

7369:
7370: ELSE
7371: -- construct select statement for dimension not using value set
7372:
7373: l_stmt := 'SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||
7374: 'SELECT H.CHILD_ID ';
7375:
7376: -- Will need to use different hierarchy table for secure user
7377: IF (p_user_mode IS NOT NULL AND p_user_mode = 'SECURED')

Line 7427: l_stmt := 'SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||

7423:
7424: -- Construct select statement
7425: -- construct select statement for root node
7426:
7427: l_stmt := 'SELECT ''Y'' FROM DUAL WHERE EXISTS ( ' ||
7428: 'SELECT CO.COST_OBJECT_ID ';
7429:
7430: -- Will need to use different hierarchy table for secure user
7431:

Line 7618: SELECT 'Y' FROM dual

7614:
7615: CURSOR l_is_prior_version_csr (c_hierarchy_id IN NUMBER,
7616: c_version_id IN NUMBER)
7617: IS
7618: SELECT 'Y' FROM dual
7619: WHERE EXISTS( SELECT 1
7620: FROM fem_object_definition_b a,
7621: fem_object_definition_b b
7622: WHERE a.object_id = b.object_id

Line 7706: FROM dual;

7702: END IF;
7703:
7704: SELECT fem_cost_objects_hier_s.NEXTVAL
7705: INTO l_new_relationship_id
7706: FROM dual;
7707:
7708: INSERT INTO fem_cost_objects_hier
7709: (relationship_id,
7710: effective_start_date,

Line 8037: SELECT 'Y' FROM dual

8033:
8034: CURSOR l_prior_version_exists_csr (c_hierarchy_id IN NUMBER,
8035: c_eff_start_date IN DATE)
8036: IS
8037: SELECT 'Y' FROM dual
8038: WHERE EXISTS( SELECT 1
8039: FROM fem_object_definition_b
8040: WHERE object_id = c_hierarchy_id
8041: AND effective_start_date < c_eff_start_date);

Line 8046: SELECT 'Y' FROM dual

8042:
8043: CURSOR l_later_version_exists_csr(c_hierarchy_id IN NUMBER,
8044: c_eff_end_date IN DATE)
8045: IS
8046: SELECT 'Y' FROM dual
8047: WHERE EXISTS (SELECT 1
8048: FROM fem_object_definition_vl a
8049: WHERE object_id = c_hierarchy_id
8050: AND effective_end_date > c_eff_end_date);

Line 8265: FROM dual;

8261: c_parent_id => l_parent_id) LOOP
8262:
8263: SELECT fem_cost_objects_hier_s.NEXTVAL
8264: INTO l_new_relationship_id
8265: FROM dual;
8266:
8267: INSERT INTO fem_cost_objects_hier
8268: (relationship_id,
8269: effective_start_date,

Line 8306: FROM dual;

8302: ELSE
8303:
8304: SELECT fem_cost_objects_hier_s.NEXTVAL
8305: INTO l_new_relationship_id
8306: FROM dual;
8307:
8308: INSERT INTO fem_cost_objects_hier
8309: (relationship_id,
8310: effective_start_date,

Line 9145: l_access_sql := ' SELECT COUNT(*) FROM DUAL WHERE EXISTS ' ||

9141: l_result NUMBER := 0;
9142:
9143: begin
9144:
9145: l_access_sql := ' SELECT COUNT(*) FROM DUAL WHERE EXISTS ' ||
9146: ' (SELECT 1 FROM ' || p_hier_table || ' WHERE ' ||
9147: ' HIERARCHY_OBJ_DEF_ID IN (SELECT OBJECT_DEFINITION_ID ' ||
9148: ' FROM FEM_OBJECT_DEFINITION_B WHERE OBJECT_ID = :1) ' ||
9149: ' AND CHILD_VALUE_SET_ID = :2) ';