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_B

Line 436: INSERT INTO BNE_INTERFACE_COLS_B (

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 (
437: INTERFACE_COL_TYPE,
438: INTERFACE_COL_NAME,
439: ENABLED_FLAG,
440: REQUIRED_FLAG,

Line 626: l_max_sequence_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;

622: l_login_id NUMBER := NVL(Fnd_Global.Login_Id, 0);
623: l_index NUMBER ;
624:
625: l_updated_flag VARCHAR2(1) := 'N';
626: l_max_sequence_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;
627: l_sequence_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;
628: l_val_component_code BNE_INTERFACE_COLS_B.VAL_COMPONENT_CODE%TYPE;
629:
630: TYPE l_sequence_num_tbl_typ IS TABLE OF

Line 627: l_sequence_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;

623: l_index NUMBER ;
624:
625: l_updated_flag VARCHAR2(1) := 'N';
626: l_max_sequence_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;
627: l_sequence_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;
628: l_val_component_code BNE_INTERFACE_COLS_B.VAL_COMPONENT_CODE%TYPE;
629:
630: TYPE l_sequence_num_tbl_typ IS TABLE OF
631: BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE INDEX BY BINARY_INTEGER;

Line 628: l_val_component_code BNE_INTERFACE_COLS_B.VAL_COMPONENT_CODE%TYPE;

624:
625: l_updated_flag VARCHAR2(1) := 'N';
626: l_max_sequence_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;
627: l_sequence_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;
628: l_val_component_code BNE_INTERFACE_COLS_B.VAL_COMPONENT_CODE%TYPE;
629:
630: TYPE l_sequence_num_tbl_typ IS TABLE OF
631: BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE INDEX BY BINARY_INTEGER;
632:

Line 631: BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE INDEX BY BINARY_INTEGER;

627: l_sequence_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;
628: l_val_component_code BNE_INTERFACE_COLS_B.VAL_COMPONENT_CODE%TYPE;
629:
630: TYPE l_sequence_num_tbl_typ IS TABLE OF
631: BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE INDEX BY BINARY_INTEGER;
632:
633: TYPE l_data_type_tbl_typ IS TABLE OF
634: FEM_WEBADI_DIM_ATTR_MAPS.DATA_TYPE%TYPE INDEX BY BINARY_INTEGER;
635:

Line 738: , BNE_INTERFACE_COLS_B I

734: (
735: SELECT I.SEQUENCE_NUM
736: , I.INTERFACE_COL_NAME
737: FROM BNE_LAYOUT_COLS L
738: , BNE_INTERFACE_COLS_B I
739: WHERE L.APPLICATION_ID = 274
740: AND L.INTERFACE_APP_ID = 274
741: AND L.INTERFACE_CODE = p_interface_code
742: AND I.APPLICATION_ID = L.INTERFACE_APP_ID

Line 760: UPDATE BNE_INTERFACE_COLS_B

756: IF (x_updated_flag = 'N') THEN
757: x_updated_flag := 'Y';
758: END IF;
759:
760: UPDATE BNE_INTERFACE_COLS_B
761: SET VAL_TYPE = NULL
762: , VAL_OBJ_NAME = NULL
763: , VAL_COMPONENT_APP_ID = NULL
764: , VAL_COMPONENT_CODE = NULL

Line 825: FROM BNE_INTERFACE_COLS_B

821:
822: FOR intf_rec IN (
823: SELECT SEQUENCE_NUM
824: , VAL_COMPONENT_CODE
825: FROM BNE_INTERFACE_COLS_B
826: WHERE APPLICATION_ID = 274
827: AND INTERFACE_CODE = p_interface_code
828: AND INTERFACE_COL_NAME = dt_changed_rec.INTERFACE_COL
829: )

Line 898: UPDATE BNE_INTERFACE_COLS_B

894: AND M.LANGUAGE_CODE (+)= L.LANGUAGE_CODE;
895:
896: IF (dt_changed_rec.DATA_TYPE = 'DIMENSION') THEN
897:
898: UPDATE BNE_INTERFACE_COLS_B
899: SET VAL_TYPE = 'JAVA'
900: , VAL_OBJ_NAME = 'oracle.apps.fem.integrator.dimension.validators.FemAttributeValidator'
901: , VAL_COMPONENT_APP_ID = 274
902: , VAL_COMPONENT_CODE = 'FEM_ATTRIBUTE'

Line 915: UPDATE BNE_INTERFACE_COLS_B

911: RAISE NO_DATA_FOUND;
912: END IF;
913:
914: ELSE
915: UPDATE BNE_INTERFACE_COLS_B
916: SET VAL_TYPE = NULL
917: , VAL_OBJ_NAME = NULL
918: , VAL_COMPONENT_APP_ID = NULL
919: , VAL_COMPONENT_CODE = NULL

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 953: FROM BNE_INTERFACE_COLS_B

949: -- before.
950:
951: SELECT MAX(SEQUENCE_NUM)
952: INTO l_max_sequence_num
953: FROM BNE_INTERFACE_COLS_B
954: WHERE APPLICATION_ID = 274
955: AND INTERFACE_CODE = p_interface_code;
956:
957: IF (g_changed_intf_col_tbl.COUNT > 0) THEN

Line 961: FROM BNE_INTERFACE_COLS_B

957: IF (g_changed_intf_col_tbl.COUNT > 0) THEN
958:
959: SELECT MAX(SEQUENCE_NUM)
960: INTO l_max_sequence_num
961: FROM BNE_INTERFACE_COLS_B
962: WHERE APPLICATION_ID = 274
963: AND INTERFACE_CODE = p_interface_code;
964:
965: IF (x_updated_flag = 'N') THEN

Line 990: FROM BNE_INTERFACE_COLS_B

986:
987: FOR intf_rec IN (
988: SELECT SEQUENCE_NUM
989: , VAL_COMPONENT_CODE
990: FROM BNE_INTERFACE_COLS_B
991: WHERE APPLICATION_ID = 274
992: AND INTERFACE_CODE = p_interface_code
993: AND INTERFACE_COL_NAME = changed_rec.INTERFACE_COL
994: )

Line 1064: -- Update BNE_INTERFACE_COLS_B when required

1060: DECODE(changed_rec.ATTRIBUTE_REQUIRED_FLAG, 'Y', 'FEM_ADI_USER_HINT_DATE_REQ', 'FEM_ADI_USER_HINT_DATE'), NULL))))
1061: AND M.LANGUAGE_CODE (+)= L.LANGUAGE_CODE;
1062:
1063: ---------------------------------------------------------------------
1064: -- Update BNE_INTERFACE_COLS_B when required
1065: ---------------------------------------------------------------------
1066:
1067: IF (changed_rec.DATA_TYPE = 'DIMENSION' AND
1068: (l_val_component_code IS NULL OR

Line 1071: UPDATE BNE_INTERFACE_COLS_B

1067: IF (changed_rec.DATA_TYPE = 'DIMENSION' AND
1068: (l_val_component_code IS NULL OR
1069: l_val_component_code <> 'FEM_ATTRIBUTE')) THEN
1070:
1071: UPDATE BNE_INTERFACE_COLS_B
1072: SET VAL_TYPE = 'JAVA'
1073: , VAL_OBJ_NAME = 'oracle.apps.fem.integrator.dimension.validators.FemAttributeValidator'
1074: , VAL_COMPONENT_APP_ID = 274
1075: , VAL_COMPONENT_CODE = 'FEM_ATTRIBUTE'

Line 1087: UPDATE BNE_INTERFACE_COLS_B

1083: AND SEQUENCE_NUM = l_sequence_num;
1084:
1085: ELSIF (changed_rec.DATA_TYPE <> 'DIMENSION' AND l_val_component_code = 'FEM_ATTRIBUTE') THEN
1086:
1087: UPDATE BNE_INTERFACE_COLS_B
1088: SET VAL_TYPE = NULL
1089: , VAL_OBJ_NAME = NULL
1090: , VAL_COMPONENT_APP_ID = NULL
1091: , VAL_COMPONENT_CODE = NULL

Line 1109: UPDATE BNE_INTERFACE_COLS_B

1105:
1106: ELSE
1107: -- Need to update the segment and group name because they are not
1108: -- previously set.
1109: UPDATE BNE_INTERFACE_COLS_B
1110: SET SEGMENT_NUMBER = 100 + ((UPLOAD_PARAM_LIST_ITEM_NUM -8) * 10)
1111: , GROUP_NAME = 'MEMBER_GROUP_VALIDATOR'
1112: , VARIABLE_DATA_TYPE_CLASS =
1113: DECODE(changed_rec.DATA_TYPE, 'DATE',

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 1131: INSERT INTO BNE_INTERFACE_COLS_B (

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 (
1132: INTERFACE_COL_TYPE,
1133: INTERFACE_COL_NAME,
1134: ENABLED_FLAG,
1135: REQUIRED_FLAG,

Line 1294: FROM BNE_INTERFACE_COLS_B

1290: FROM TABLE(CAST(l_attr_intf_col_name_tbl AS FND_TABLE_OF_VARCHAR2_30)) REF
1291: WHERE NOT EXISTS
1292: (
1293: SELECT INTERFACE_COL_NAME
1294: FROM BNE_INTERFACE_COLS_B
1295: WHERE APPLICATION_ID = 274
1296: AND INTERFACE_CODE = p_interface_code
1297: AND INTERFACE_COL_NAME = REF.column_value
1298: ))

Line 1303: INSERT INTO BNE_INTERFACE_COLS_B (

1299: LOOP
1300:
1301: l_max_sequence_num := l_max_sequence_num + 1;
1302:
1303: INSERT INTO BNE_INTERFACE_COLS_B (
1304: INTERFACE_COL_TYPE,
1305: INTERFACE_COL_NAME,
1306: ENABLED_FLAG,
1307: REQUIRED_FLAG,

Line 1925: FROM BNE_INTERFACE_COLS_B I

1921: AND INTERFACE_CODE = p_interface_code
1922: AND INTERFACE_SEQ_NUM IN
1923: (
1924: SELECT SEQUENCE_NUM
1925: FROM BNE_INTERFACE_COLS_B I
1926: WHERE I.APPLICATION_ID = 274
1927: AND I.INTERFACE_CODE = p_interface_code
1928: AND I.INTERFACE_COL_NAME IN (
1929: SELECT column_value

Line 1947: FROM BNE_INTERFACE_COLS_B IC

1943: , DECODE (INTERFACE_COL_NAME, 'P_DIMENSION_VARCHAR_LABEL', 'CONSTANT','P_LEDGER_ID','SQL',
1944: NULL) AS DEFAULT_TYPE
1945: , DECODE (INTERFACE_COL_NAME, 'P_DIMENSION_VARCHAR_LABEL', p_dimension_varchar_label,'P_LEDGER_ID',l_default_ledger_query,
1946: NULL) AS DEFAULT_VALUE /* Bug#5533480 */
1947: FROM BNE_INTERFACE_COLS_B IC
1948: WHERE APPLICATION_ID = 274
1949: AND INTERFACE_CODE = p_interface_code
1950: AND INTERFACE_COL_NAME IN (
1951: SELECT column_value

Line 2031: FROM BNE_INTERFACE_COLS_B I

2027: AND INTERFACE_CODE = p_interface_code
2028: AND INTERFACE_SEQ_NUM IN
2029: (
2030: SELECT SEQUENCE_NUM
2031: FROM BNE_INTERFACE_COLS_B I
2032: WHERE I.APPLICATION_ID = 274
2033: AND I.INTERFACE_CODE = p_interface_code
2034: AND I.INTERFACE_COL_NAME IN (
2035: SELECT column_value

Line 2050: FROM BNE_INTERFACE_COLS_B I

2046: WHERE APPLICATION_ID = 274
2047: AND INTERFACE_CODE = p_interface_code
2048: AND INTERFACE_SEQ_NUM IN
2049: ( SELECT I.SEQUENCE_NUM
2050: FROM BNE_INTERFACE_COLS_B I
2051: WHERE I.APPLICATION_ID = INTERFACE_APP_ID
2052: AND I.INTERFACE_CODE = INTERFACE_CODE
2053: AND I.INTERFACE_COL_NAME LIKE 'P_ATTRIBUTE%'
2054: AND NOT EXISTS

Line 2075: FROM BNE_INTERFACE_COLS_B I

2071: AND INTERFACE_CODE = p_interface_code
2072: AND INTERFACE_SEQ_NUM NOT IN
2073: (
2074: SELECT SEQUENCE_NUM
2075: FROM BNE_INTERFACE_COLS_B I
2076: WHERE I.APPLICATION_ID = 274
2077: AND I.INTERFACE_CODE = p_interface_code
2078: AND (I.INTERFACE_COL_NAME IN (
2079: SELECT column_value

Line 2139: FROM BNE_INTERFACE_COLS_B IC

2135: , SYSDATE
2136: , l_user_id
2137: , l_login_id
2138: , SYSDATE
2139: FROM BNE_INTERFACE_COLS_B IC
2140: WHERE APPLICATION_ID = 274
2141: AND IC.INTERFACE_CODE = p_interface_code
2142: AND ( ( p_group_use_code = 'NOT_SUPPORTED'
2143: AND NOT IC.INTERFACE_COL_NAME =

Line 2170: AND INTERFACE_SEQ_NUM = (SELECT SEQUENCE_NUM FROM BNE_INTERFACE_COLS_B WHERE INTERFACE_CODE = p_interface_code

2166:
2167: --Bug#6474936:Delete Member Display Code layout col for Calendar period
2168: IF(p_dimension_varchar_label = 'CAL_PERIOD') THEN
2169: DELETE FROM BNE_LAYOUT_COLS WHERE LAYOUT_CODE = l_layout_code AND INTERFACE_CODE = p_interface_code
2170: AND INTERFACE_SEQ_NUM = (SELECT SEQUENCE_NUM FROM BNE_INTERFACE_COLS_B WHERE INTERFACE_CODE = p_interface_code
2171: AND INTERFACE_COL_NAME = 'P_MEMBER_DISPLAY_CODE');
2172: END IF;
2173:
2174: -- Inser the attribute interface columns

Line 2219: FROM BNE_INTERFACE_COLS_B IC

2215: , SYSDATE
2216: , l_user_id
2217: , l_login_id
2218: , SYSDATE
2219: FROM BNE_INTERFACE_COLS_B IC
2220: WHERE APPLICATION_ID = 274
2221: AND IC.INTERFACE_CODE = p_interface_code
2222: AND EXISTS
2223: ( SELECT 1

Line 6190: DELETE FROM bne_interface_cols_b WHERE interface_code = dimintg_intfs_csr_rec.interface_code;

6186: ,p_msg_text => 'Deleting interface cols');
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 (