APPS.GCS_WEBADI_PKG dependencies on BNE_INTERFACE_COLS_B

Line 346: TYPE l_interface_code_tbl_type IS TABLE OF BNE_INTERFACE_COLS_B.INTERFACE_CODE%TYPE INDEX BY BINARY_INTEGER;

342:
343: -- start bugfix: 5496678 - IF we have a record with all these parameters, bulk
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:

Line 347: TYPE l_sequence_num_tbl_type IS TABLE OF BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE INDEX BY BINARY_INTEGER;

343: -- start bugfix: 5496678 - IF we have a record with all these parameters, bulk
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;

Line 429: bne_interface_cols_b bicb,

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
433: AND ftcb.table_name = ftctl.table_name

Line 490: -- update bne_interface_cols_b table for visible dimensions

486: 'INTERCOMPANY_NAME',
487: 'FEM_CCTR_ORGS_TL'
488: FROM dual);
489:
490: -- update bne_interface_cols_b table for visible dimensions
491: -- first hide all dimension columns
492: -- Bug fix 3809676: limit interface_col_name not to include "TRIALBALANCE_SEQ_NUM"
493: UPDATE bne_interface_cols_b
494: SET display_flag = 'N',

Line 493: UPDATE bne_interface_cols_b

489:
490: -- update bne_interface_cols_b table for visible dimensions
491: -- first hide all dimension columns
492: -- Bug fix 3809676: limit interface_col_name not to include "TRIALBALANCE_SEQ_NUM"
493: UPDATE bne_interface_cols_b
494: SET display_flag = 'N',
495: not_null_flag = 'N',
496: required_flag = 'N',
497: --Bug Fix : 5563482

Line 511: UPDATE bne_interface_cols_b

507: 'USER_DIM2_ID', 'USER_DIM3_ID', 'USER_DIM4_ID', 'USER_DIM5_ID',
508: 'USER_DIM6_ID', 'USER_DIM7_ID', 'USER_DIM8_ID', 'USER_DIM9_ID',
509: 'USER_DIM10_ID');
510:
511: UPDATE bne_interface_cols_b
512: SET display_flag = 'N',
513: not_null_flag = 'N',
514: required_flag = 'N',
515: --Bug Fix : 5563482

Line 531: UPDATE bne_interface_cols_b

527: --Ensure the column is required for FEM
528: IF (gcs_utility_pkg.Get_Fem_Dim_Required(l_index_column_name) = 'Y' and
529: l_index_column_name <> 'ENTITY_ID') THEN
530: -- then set the user-chosen dimensions as visible and not-null
531: UPDATE bne_interface_cols_b
532: SET display_flag = 'Y',
533: not_null_flag = 'Y',
534: required_flag = 'Y',
535: --Bug Fix : 5563482

Line 562: UPDATE bne_interface_cols_b

558: g_non_ds_req_dimensions(g_non_ds_cnt) := l_index_column_name;
559:
560:
561: -- then set the user-chosen dimensions as visible and not-null
562: UPDATE bne_interface_cols_b
563: SET display_flag = 'Y',
564: not_null_flag = 'Y',
565: required_flag = 'Y',
566: --Bug Fix : 5563482

Line 639: UPDATE bne_interface_cols_b

635: l_hrate_drm_dimensions(l_hrate_drm_cnt) := l_index_column_name;
636:
637:
638: -- then set the user-chosen dimensions as visible and not-null
639: UPDATE bne_interface_cols_b
640: SET display_flag = 'Y',
641: not_null_flag = 'Y',
642: required_flag = 'Y',
643: last_update_login = l_login_id

Line 764: FROM bne_interface_cols_b

760: l_user_id,
761: l_login_id,
762: --Bug Fix : 5563482
763: LAST_UPDATE_DATE
764: FROM bne_interface_cols_b
765: WHERE interface_col_name = g_non_ds_req_dimensions(i)
766: AND interface_code IN
767: ('GCS_AD_ENTRY_LINE_INTF', 'GCS_AD_TB_INTF',
768: 'GCS_HRATE_RE_INTF' ); -- HRates Enhancement

Line 801: FROM bne_interface_cols_b

797: CREATION_DATE,
798: l_user_id,
799: l_login_id,
800: LAST_UPDATE_DATE
801: FROM bne_interface_cols_b
802: WHERE interface_col_name = l_hrate_drm_dimensions(i)
803: AND interface_code = 'GCS_HRATE_INTF' ;
804: END IF;
805: