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_DIM_UTILS_PVT dependencies on DUAL

Line 53: 'select null from dual where exists (' ||

49:
50: -- to determine if the group is being used by member
51: execute immediate
52: 'select count(*) from (' ||
53: 'select null from dual where exists (' ||
54: 'select null from ' || l_member_b_table_name || '))'
55: into l_result;
56:
57: if (l_result is null or l_result = 0) then

Line 169: 'select null from dual where exists (' ||

165: if (l_grp_use_code <> 'REQUIRED') then
166: -- to determine if the attribute is being used by member
167: execute immediate
168: 'select count(*) from (' ||
169: 'select null from dual where exists (' ||
170: 'select null from ' || l_attr_table_name || ' where '||
171: 'attribute_id = :1 ))'
172: into l_result USING p_attribute_id;
173:

Line 277: select 1 from dual where exists ( select 1

273: -- For Bug# 3980015
274: --Cursor to determine if there are levels associated witha dimension
275: --
276: Cursor l_grp_use_csr is
277: select 1 from dual where exists ( select 1
278: from fem_dimension_grps_vl
279: where dimension_id = l_dimension_id);
280:
281:

Line 287: select 1 from dual where exists(select 1

283:
284: --Cursor to determine if the attr is being used by Col pop tmplt
285:
286: Cursor l_col_pop_usage_csr is
287: select 1 from dual where exists(select 1
288: from fem_col_population_tmplt_b where attribute_id = p_attribute_id);
289:
290: --Cursor to determine if the attr is being used by Conditions.
291:

Line 293: select 1 from dual where exists(select 1

289:
290: --Cursor to determine if the attr is being used by Conditions.
291:
292: Cursor l_cond_usage_csr is
293: select 1 from dual where exists(select 1
294: from fem_cond_dim_cmp_dtl where dim_attr_varchar_label =
295: (select attribute_varchar_label from fem_dim_attributes_b
296: where attribute_id = p_attribute_id));
297:

Line 364: 'select null from dual where exists (' ||

360: if (l_grp_use_code <> 'REQUIRED') then
361: -- to determine if the attribute is being used by member
362: execute immediate
363: 'select count(*) from (' ||
364: 'select null from dual where exists (' ||
365: 'select null from ' || l_attr_table_name || ' where '||
366: 'attribute_id = '||p_attribute_id||' ))'
367: into l_result;
368:

Line 402: 'select null from dual where exists (' ||

398: -- checking if its being used by a member
399: -- to determine if the attribute is being used by member
400: execute immediate
401: 'select count(*) from (' ||
402: 'select null from dual where exists (' ||
403: 'select null from ' || l_attr_table_name || ' where '||
404: 'attribute_id = '||p_attribute_id||' ))'
405: into l_result;
406:

Line 609: l_sql_stmt := 'SELECT COUNT(*) FROM dual WHERE EXISTS ( SELECT 1 FROM ' ||

605: END IF ;
606:
607: END LOOP;
608:
609: l_sql_stmt := 'SELECT COUNT(*) FROM dual WHERE EXISTS ( SELECT 1 FROM ' ||
610: l_hier_tbl_name || ' WHERE child_id = :1)' ;
611: EXECUTE IMMEDIATE l_sql_stmt INTO l_result USING p_member_id;
612:
613: -- Check if member is being used by a hierarchy.

Line 639: l_sql_stmt := 'SELECT COUNT(*) FROM dual WHERE EXISTS ( ' ||

635: END IF ;
636:
637: END LOOP;
638:
639: l_sql_stmt := 'SELECT COUNT(*) FROM dual WHERE EXISTS ( ' ||
640: 'SELECT 1 ' ||
641: 'FROM ' || l_hier_tbl_name || ' D, ' ||
642: ' FEM_OBJECT_DEFINITION_VL OD, ' ||
643: ' FEM_HIERARCHIES H ' ||

Line 1244: FROM dual;

1240:
1241: -- Bug#3799813: Raise Dimension event on creation of CCTR Member
1242:
1243: SELECT FEM_DHM_METADATA_OPS_KEY_S.NEXTVAL into l_event_key
1244: FROM dual;
1245:
1246: WF_Event.AddParameterToList( p_name => 'DIMENSION_VARCHAR_LABEL' ,
1247: p_value => p_dimension_varchar_label ,
1248: p_parameterlist => l_parameter_list_t );

Line 10176: query:='Select 1 as result from dual where exists ' ||

10172: query varchar2(200);
10173:
10174: BEGIN
10175:
10176: query:='Select 1 as result from dual where exists ' ||
10177: '(Select 1 from ' || p_dim_mem_tbl_name ||
10178: ' where dimension_group_id ='|| p_group_id || ')';
10179:
10180: EXECUTE IMMEDIATE query INTO l_result;

Line 10518: from dual;

10514: IF p_dim_varchar_label = 'COST_OBJECT' THEN
10515:
10516: select fem_cost_objects_s.nextval
10517: into l_cost_object_id
10518: from dual;
10519:
10520: /*l_ledger_id := FND_PROFILE.value('FEM_LEDGER');
10521:
10522:

Line 10823: from dual;

10819: ELSIF p_dim_varchar_label = 'ACTIVITY' THEN
10820:
10821: select fem_activities_s.nextval
10822: into l_activity_id
10823: from dual;
10824:
10825: /* l_ledger_id := FND_PROFILE.value('FEM_LEDGER');
10826:
10827: -- bug#3973591

Line 11386: l_line_nat_dims_flag from dual;

11382: BEGIN
11383:
11384: select decode((select 'Y' from FEM_DIM_ATTRIBUTES_B where attribute_id = p_attribute_id and attribute_varchar_label = 'EXTENDED_ACCOUNT_TYPE' and dimension_id in
11385: (select dimension_id from fem_dimensions_b where dimension_varchar_label in ('NATURAL_ACCOUNT','LINE_ITEM'))),'Y','Y','N') into
11386: l_line_nat_dims_flag from dual;
11387:
11388: if(l_line_nat_dims_flag = 'Y') then
11389: l_read_only_flag := 'N';
11390: return l_read_only_flag;