APPS.FEM_TABLE_REGISTRATION_PKG dependencies on FEM_TAB_COLUMNS_TL

Line 125: DELETE FROM fem_tab_columns_tl

121: AND table_name = p_table_name
122: RETURNING column_name BULK COLLECT INTO l_column_tab;
123:
124: FORALL i IN l_column_tab.FIRST..l_column_tab.LAST
125: DELETE FROM fem_tab_columns_tl
126: WHERE table_name = p_table_name
127: AND column_name = l_column_tab(i);
128:
129: FOR i IN l_column_tab.FIRST..l_column_tab.LAST LOOP

Line 707: FROM fem_tab_columns_tl

703: AND fd.language = USERENV('LANG')
704: AND rownum = 1) as Dimension_name,
705: fcr.uom_column_name,
706: DECODE(uom_column_name,NULL, NULL, (SELECT display_name
707: FROM fem_tab_columns_tl
708: WHERE column_name = uom_column_name
709: AND language = USERENV('LANG')
710: AND rownum = 1)) as uom_col_display_name,
711: 'Y' selected,

Line 786: FROM fem_tab_columns_tl

782: AND fd.language = USERENV('LANG')
783: AND rownum = 1)) as Dimension_name,
784: ftc.uom_column_name,
785: DECODE(uom_column_name,NULL, NULL, (SELECT display_name
786: FROM fem_tab_columns_tl
787: WHERE column_name = ftc.uom_column_name
788: AND language = USERENV('LANG')
789: AND rownum = 1)) as uom_col_display_name,
790: 'Y' selected,

Line 947: FROM fem_tab_columns_tl

943: AND fd.language = USERENV('LANG')
944: AND rownum = 1)),
945: dtc.uom_column_name,
946: DECODE(dtc.uom_column_name,NULL, NULL, (SELECT display_name
947: FROM fem_tab_columns_tl
948: WHERE column_name = dtc.uom_column_name
949: AND language = USERENV('LANG')
950: AND rownum = 1)),
951: dtc.enabled_flag selected,

Line 1025: FROM fem_tab_columns_tl

1021: AND fd.language = USERENV('LANG')
1022: AND rownum = 1)),
1023: dtc.uom_column_name,
1024: DECODE(dtc.uom_column_name,NULL, NULL, (SELECT display_name
1025: FROM fem_tab_columns_tl
1026: WHERE column_name = dtc.uom_column_name
1027: AND language = USERENV('LANG')
1028: AND rownum = 1)),
1029: dtc.enabled_flag selected,

Line 1615: MERGE INTO fem_tab_columns_tl ftc

1611: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1612: ,p_module => g_block||'.populate_tab_col_vl'
1613: ,p_msg_text => 'Before insert into _TL');
1614:
1615: MERGE INTO fem_tab_columns_tl ftc
1616: USING (SELECT tcgt.*,fndl.language_code
1617: FROM fem_tab_columns_gt tcgt,
1618: fnd_languages fndl
1619: WHERE fndl.installed_flag IN ('I','B')) ftcg