[Home] [Help]
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;
353: l_display_name l_display_name_tbl_type;
409:
410: -- start bugfix: 5496678 - Retrieve the display name for the dimensions to be
411: -- updated in the bne_interface_tl table.
412: -- bugfix 5655870: Added the special decode for company cost center for data sub interface.
413: -- Bug Fix : 6502423, Update bne_interface_cols_tl for HRate RE interface to show user display names
414:
415: SELECT interface_code,
416: sequence_num,
417: display_name,
448: SUBSTR(ftctl.column_name, 0, LENGTH(
449: ftctl.column_name) - 3) ||
450: '_DISPLAY_CODE'))));
451:
452: -- update the table bne_interface_cols_tl's dimension display name.
453: IF (l_interface_code.COUNT <> 0) THEN
454: FORALL l_counter IN l_interface_code.FIRST .. l_interface_code.LAST
455: UPDATE bne_interface_cols_tl
456: SET prompt_left = l_display_name(l_counter),
451:
452: -- update the table bne_interface_cols_tl's dimension display name.
453: IF (l_interface_code.COUNT <> 0) THEN
454: FORALL l_counter IN l_interface_code.FIRST .. l_interface_code.LAST
455: UPDATE bne_interface_cols_tl
456: SET prompt_left = l_display_name(l_counter),
457: prompt_above = l_display_name(l_counter),
458: --Bug Fix : 5563482
459: --last_update_date = SYSDATE,