APPS.FEM_WEBADI_TABLES_UTILS_PVT dependencies on FEM_TABLES_VL

Line 279: select display_name into l_table_display_name from fem_tables_vl

275: l_no_map_columns varchar2(1000);
276: l_log_string varchar2(5000);
277: begin
278:
279: select display_name into l_table_display_name from fem_tables_vl
280: where table_name = p_table_name;
281:
282: l_object_code := p_table_name;
283:

Line 524: select display_name into l_table_display_name from fem_tables_vl

520: l_user_id number := 2;
521: l_table_display_name varchar2(150) := null;
522: begin
523:
524: select display_name into l_table_display_name from fem_tables_vl
525: where table_name = p_table_name;
526:
527:
528: ---- Create a security rule ---------------------------

Line 549: P_QUERY => 'select display_name from fem_tables_vl where table_name = $PARAM$.table_name',

545: P_OBJECT_CODE => p_object_code,
546: P_INTEGRATOR_CODE => l_integrator_code,
547: P_CONTENT_DESC => 'Enterprise Performace Foundation: ' || l_table_display_name || ' Content',
548: P_COL_LIST => 'DISPLAY_NAME',
549: P_QUERY => 'select display_name from fem_tables_vl where table_name = $PARAM$.table_name',
550: P_LANGUAGE => USERENV('LANG'),
551: P_SOURCE_LANGUAGE => USERENV('LANG'),
552: P_USER_ID => l_user_id,
553: P_CONTENT_CODE => l_content_code);

Line 1647: select display_name into l_table_display_name from fem_tables_vl

1643:
1644: delete from bne_interface_cols_tl
1645: where interface_code = p_interface_code;
1646:
1647: select display_name into l_table_display_name from fem_tables_vl
1648: where table_name = l_table_name;
1649:
1650: -----------------------------------------------------------------------------
1651: -- Set up plsql table for interface column definition

Line 1664: l_interface_cols_tbl(1).DEFAULT_VALUE := 'select display_name from fem_tables_vl where table_name = $PARAM$.table_name';

1660: l_interface_cols_tbl(1).READ_ONLY_FLAG := 'Y';
1661: l_interface_cols_tbl(1).MAPPING_ENABLED_FLAG := 'Y';
1662: l_interface_cols_tbl(1).DATA_TYPE := 2; --VARCHAR
1663: l_interface_cols_tbl(1).FIELD_SIZE := 80;
1664: l_interface_cols_tbl(1).DEFAULT_VALUE := 'select display_name from fem_tables_vl where table_name = $PARAM$.table_name';
1665: l_interface_cols_tbl(1).DEFAULT_TYPE := 'SQL';
1666: l_interface_cols_tbl(1).SEGMENT_VALUE := NULL;
1667: l_interface_cols_tbl(1).GROUP_NAME := NULL; -- 'TABLE_GROUP_VALIDATOR';
1668: l_interface_cols_tbl(1).VAL_TYPE := NULL;

Line 2712: select table_name into l_table_name from fem_tables_vl

2708: || ',' || '''' || l_cal_period_number || ''''
2709: || ',' || 'to_date(' || '''' || l_end_date || '''' || ',' || '''' ||l_canonical_format || '''' || ')'
2710: || ',' || '''' || l_cal_grp_display_code || '''';
2711:
2712: select table_name into l_table_name from fem_tables_vl
2713: where display_name = p_table_name;
2714:
2715: select interface_table_name,table_name || '_INTF' into l_interface_table_name,l_interface_code from
2716: fem_tables_vl where display_name = p_table_name;

Line 2716: fem_tables_vl where display_name = p_table_name;

2712: select table_name into l_table_name from fem_tables_vl
2713: where display_name = p_table_name;
2714:
2715: select interface_table_name,table_name || '_INTF' into l_interface_table_name,l_interface_code from
2716: fem_tables_vl where display_name = p_table_name;
2717:
2718: -------------------------------------------------------------------------------------------------------------------------
2719: -- For table length with more than 20 chars the integrator/interface code won't be simply table_name || '_INTG' / '_INTF'
2720: -- We need to fetch that interface/integrator code with some other logic. One such logic used here