DBA Data[Home] [Help]

APPS.GCS_WEBADI_PKG dependencies on FEM_TAB_COLUMNS_TL

Line 348: TYPE l_display_name_tbl_type IS TABLE OF FEM_TAB_COLUMNS_TL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;

344: -- update with forall will not work, so we will create multiple tables and
345: -- bulk-fetch into them.
346: TYPE l_interface_code_tbl_type IS TABLE OF BNE_INTERFACE_COLS_B.INTERFACE_CODE%TYPE INDEX BY BINARY_INTEGER;
347: TYPE l_sequence_num_tbl_type IS TABLE OF BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE INDEX BY BINARY_INTEGER;
348: TYPE l_display_name_tbl_type IS TABLE OF FEM_TAB_COLUMNS_TL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;
349: TYPE l_language_tbl_type IS TABLE OF BNE_INTERFACE_COLS_TL.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
350:
351: l_interface_code l_interface_code_tbl_type;
352: l_sequence_num l_sequence_num_tbl_type;

Line 428: FROM fem_tab_columns_tl ftctl,

424: FROM (SELECT bicb.interface_code,
425: bicb.sequence_num,
426: ftctl.display_name,
427: ftctl.language
428: FROM fem_tab_columns_tl ftctl,
429: bne_interface_cols_b bicb,
430: fem_tab_columns_b ftcb
431: WHERE ftctl.table_name = 'FEM_BALANCES'
432: AND bicb.application_id = l_app_id