eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_WEBADI_MEMBER_UTILS_PVT dependencies on BNE_INTERFACE_COLS_TL

Line 432: -- Inserting into BNE_INTERFACE_COLS and BNE_INTERFACE_COLS_TL

428: l_interface_cols_tbl().FND_MESSAGE_NAME :=
429: l_interface_cols_tbl().USER_HINT_FND_MESSAGE_NAME := ;
430: */
431: -----------------------------------------------------------------------------
432: -- Inserting into BNE_INTERFACE_COLS and BNE_INTERFACE_COLS_TL
433: -----------------------------------------------------------------------------
434: FOR i IN l_interface_cols_tbl.FIRST .. l_interface_cols_tbl.LAST
435: LOOP
436: INSERT INTO BNE_INTERFACE_COLS_B (

Line 525: INSERT INTO BNE_INTERFACE_COLS_TL (

521: l_login_id,
522: NULL
523: );
524:
525: INSERT INTO BNE_INTERFACE_COLS_TL (
526: CREATED_BY,
527: CREATION_DATE,
528: LAST_UPDATED_BY,
529: LAST_UPDATE_LOGIN,

Line 779: UPDATE BNE_INTERFACE_COLS_TL

775: IF (SQL%NOTFOUND) THEN
776: RAISE NO_DATA_FOUND;
777: END IF;
778:
779: UPDATE BNE_INTERFACE_COLS_TL
780: SET USER_HINT = NULL
781: , PROMPT_LEFT = del_rec.INTERFACE_COL_NAME
782: , USER_HELP_TEXT = NULL
783: , PROMPT_ABOVE = del_rec.INTERFACE_COL_NAME

Line 836: -- Delete records in BNE_INTERFACE_COLS_TL and insert the new records.

832: l_val_component_code := intf_rec.VAL_COMPONENT_CODE;
833: END LOOP;
834:
835: -----------------------------------------------------------------------
836: -- Delete records in BNE_INTERFACE_COLS_TL and insert the new records.
837: -----------------------------------------------------------------------
838: DELETE BNE_INTERFACE_COLS_TL
839: WHERE APPLICATION_ID = 274
840: AND INTERFACE_CODE = p_interface_code

Line 838: DELETE BNE_INTERFACE_COLS_TL

834:
835: -----------------------------------------------------------------------
836: -- Delete records in BNE_INTERFACE_COLS_TL and insert the new records.
837: -----------------------------------------------------------------------
838: DELETE BNE_INTERFACE_COLS_TL
839: WHERE APPLICATION_ID = 274
840: AND INTERFACE_CODE = p_interface_code
841: AND SEQUENCE_NUM = l_sequence_num;
842:

Line 843: INSERT INTO BNE_INTERFACE_COLS_TL

839: WHERE APPLICATION_ID = 274
840: AND INTERFACE_CODE = p_interface_code
841: AND SEQUENCE_NUM = l_sequence_num;
842:
843: INSERT INTO BNE_INTERFACE_COLS_TL
844: (
845: CREATED_BY,
846: CREATION_DATE,
847: LAST_UPDATED_BY,

Line 941: -- Upsert BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL table based on the

937: END LOOP;
938: END IF;
939:
940: -----------------------------------------------------------------------------
941: -- Upsert BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL table based on the
942: -- data populated in the g_changed_intf_col_tbl that is generated through
943: -- Populate_Dim_Attribute_Maps
944: -----------------------------------------------------------------------------
945:

Line 1003: -- Delete records in BNE_INTERFACE_COLS_TL and insert the new records.

999:
1000: IF (l_sequence_num is not null) THEN
1001:
1002: -----------------------------------------------------------------------
1003: -- Delete records in BNE_INTERFACE_COLS_TL and insert the new records.
1004: -----------------------------------------------------------------------
1005: DELETE BNE_INTERFACE_COLS_TL
1006: WHERE APPLICATION_ID = 274
1007: AND INTERFACE_CODE = p_interface_code

Line 1005: DELETE BNE_INTERFACE_COLS_TL

1001:
1002: -----------------------------------------------------------------------
1003: -- Delete records in BNE_INTERFACE_COLS_TL and insert the new records.
1004: -----------------------------------------------------------------------
1005: DELETE BNE_INTERFACE_COLS_TL
1006: WHERE APPLICATION_ID = 274
1007: AND INTERFACE_CODE = p_interface_code
1008: AND SEQUENCE_NUM = l_sequence_num;
1009:

Line 1010: INSERT INTO BNE_INTERFACE_COLS_TL

1006: WHERE APPLICATION_ID = 274
1007: AND INTERFACE_CODE = p_interface_code
1008: AND SEQUENCE_NUM = l_sequence_num;
1009:
1010: INSERT INTO BNE_INTERFACE_COLS_TL
1011: (
1012: CREATED_BY,
1013: CREATION_DATE,
1014: LAST_UPDATED_BY,

Line 1127: -- Insert records to both BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL

1123:
1124: ELSE
1125:
1126: ------------------------------------------------------------------------
1127: -- Insert records to both BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL
1128: ------------------------------------------------------------------------
1129: l_max_sequence_num := l_max_sequence_num + 1;
1130:
1131: INSERT INTO BNE_INTERFACE_COLS_B (

Line 1224: INSERT INTO BNE_INTERFACE_COLS_TL

1220: 'oracle.apps.fem.integrator.dimension.validators.FemAttributeNumericTypeValidator',
1221: NULL))
1222: );
1223:
1224: INSERT INTO BNE_INTERFACE_COLS_TL
1225: (
1226: CREATED_BY,
1227: CREATION_DATE,
1228: LAST_UPDATED_BY,

Line 1352: INSERT INTO BNE_INTERFACE_COLS_TL

1348: l_user_id,
1349: l_login_id
1350: );
1351:
1352: INSERT INTO BNE_INTERFACE_COLS_TL
1353: (
1354: CREATED_BY,
1355: CREATION_DATE,
1356: LAST_UPDATED_BY,

Line 6191: DELETE FROM bne_interface_cols_tl WHERE interface_code = dimintg_intfs_csr_rec.interface_code;

6187:
6188: FOR dimintg_intfs_csr_rec IN dimintg_intfs_csr
6189: LOOP
6190: DELETE FROM bne_interface_cols_b WHERE interface_code = dimintg_intfs_csr_rec.interface_code;
6191: DELETE FROM bne_interface_cols_tl WHERE interface_code = dimintg_intfs_csr_rec.interface_code;
6192: END LOOP;
6193:
6194: FEM_ENGINES_PKG.User_Message (
6195: p_app_name => 'FEM'