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_INTG_DIM_RULE_ENG_PKG dependencies on FEM_INTG_AOL_VALSET_MAP

Line 692: FROM FEM_INTG_AOL_VALSET_MAP

688: BEGIN
689: pv_progress := 'select fem_vs_id from AOL valuse set map';
690: SELECT fem_value_set_id
691: INTO pv_fem_vs_id
692: FROM FEM_INTG_AOL_VALSET_MAP
693: WHERE DIMENSION_ID = pv_dim_id
694: AND NVL(SEGMENT1_VALUE_SET_ID,-99) = pv_mapped_segs(1).vs_id
695: AND NVL(SEGMENT2_VALUE_SET_ID,-99) = pv_mapped_segs(2).vs_id
696: AND NVL(SEGMENT3_VALUE_SET_ID,-99) = pv_mapped_segs(3).vs_id

Line 711: INSERT INTO FEM_INTG_AOL_VALSET_MAP(

707: FROM DUAL;
708:
709: pv_progress := 'insert fem vs into aol mapping table';
710:
711: INSERT INTO FEM_INTG_AOL_VALSET_MAP(
712: FEM_VALUE_SET_ID,
713: DIMENSION_ID,
714: SEGMENT1_VALUE_SET_ID,
715: SEGMENT2_VALUE_SET_ID,

Line 764: from FEM_INTG_AOL_VALSET_MAP: '||sqlerrm);

760: FEM_ENGINES_PKG.Tech_Message
761: ( p_severity => pc_log_level_error
762: ,p_module => pc_module_name||c_func_name
763: ,p_msg_text => 'Following error during selecting fem VSID
764: from FEM_INTG_AOL_VALSET_MAP: '||sqlerrm);
765: raise_application_error(-20001, fnd_message.get);
766: END;
767:
768: IF(pv_dim_id = 8) THEN

Line 947: FROM FEM_INTG_AOL_VALSET_MAP

943: pv_progress := 'select fem_vs_id from AOL valuse set map for com vsid';
944: BEGIN
945: SELECT fem_value_set_id
946: INTO pv_com_vs_id
947: FROM FEM_INTG_AOL_VALSET_MAP
948: WHERE DIMENSION_ID = pv_com_dim_id
949: AND NVL(SEGMENT1_VALUE_SET_ID,-99) = pv_mapped_segs(1).vs_id
950: AND NVL(SEGMENT2_VALUE_SET_ID,-99) = -99
951: AND NVL(SEGMENT3_VALUE_SET_ID,-99) = -99

Line 958: pv_progress := 'unexpected error whiel selecting pv_com_vs_id from FEM_INTG_AOL_VALSET_MAP: ' ||sqlerrm;

954: EXCEPTION
955: WHEN NO_DATA_FOUND THEN
956: pv_com_vs_id := -1;
957: WHEN OTHERS THEN
958: pv_progress := 'unexpected error whiel selecting pv_com_vs_id from FEM_INTG_AOL_VALSET_MAP: ' ||sqlerrm;
959: raise_application_error(-20001, fnd_message.get);
960: END;
961:
962: IF pv_com_vs_id = -1

Line 973: INSERT INTO FEM_INTG_AOL_VALSET_MAP

969: SELECT FEM_VALUE_SETS_B_S.nextval
970: INTO pv_com_vs_id
971: FROM DUAL;
972:
973: INSERT INTO FEM_INTG_AOL_VALSET_MAP
974: (
975: FEM_VALUE_SET_ID,
976: DIMENSION_ID,
977: SEGMENT1_VALUE_SET_ID,

Line 1050: FROM FEM_INTG_AOL_VALSET_MAP

1046: END IF;
1047: BEGIN
1048: SELECT fem_value_set_id
1049: INTO pv_cc_vs_id
1050: FROM FEM_INTG_AOL_VALSET_MAP
1051: WHERE DIMENSION_ID = pv_cc_dim_id
1052: AND NVL(SEGMENT1_VALUE_SET_ID,-99) = v_temp_vs_id
1053: AND NVL(SEGMENT2_VALUE_SET_ID,-99) = -99
1054: AND NVL(SEGMENT3_VALUE_SET_ID,-99) = -99

Line 1062: from FEM_INTG_AOL_VALSET_MAP: ' ||sqlerrm;

1058: WHEN NO_DATA_FOUND THEN
1059: pv_cc_vs_id := -1;
1060: WHEN OTHERS THEN
1061: pv_progress := 'unexpected error while selecting pv_cc_vs_id
1062: from FEM_INTG_AOL_VALSET_MAP: ' ||sqlerrm;
1063: raise_application_error(-20001, fnd_message.get);
1064: END;
1065:
1066: IF pv_cc_vs_id = -1

Line 1076: INSERT INTO FEM_INTG_AOL_VALSET_MAP

1072: FROM DUAL;
1073:
1074: pv_progress := 'insert newly created cc vset into aol mapping table';
1075:
1076: INSERT INTO FEM_INTG_AOL_VALSET_MAP
1077: (
1078: FEM_VALUE_SET_ID,
1079: DIMENSION_ID,
1080: SEGMENT1_VALUE_SET_ID,

Line 1150: FROM FEM_INTG_AOL_VALSET_MAP

1146:
1147: BEGIN
1148: SELECT fem_value_set_id
1149: INTO pv_com_vs_id
1150: FROM FEM_INTG_AOL_VALSET_MAP
1151: WHERE DIMENSION_ID = pv_com_dim_id
1152: AND NVL(SEGMENT1_VALUE_SET_ID,-99) = v_com_fnd_vs_id
1153: AND NVL(SEGMENT2_VALUE_SET_ID,-99) = -99
1154: AND NVL(SEGMENT3_VALUE_SET_ID,-99) = -99

Line 1165: FROM FEM_INTG_AOL_VALSET_MAP

1161:
1162: BEGIN
1163: SELECT fem_value_set_id
1164: INTO pv_cc_vs_id
1165: FROM FEM_INTG_AOL_VALSET_MAP
1166: WHERE DIMENSION_ID = pv_cc_dim_id
1167: AND NVL(SEGMENT1_VALUE_SET_ID,-99) = v_cc_fnd_vs_id
1168: AND NVL(SEGMENT2_VALUE_SET_ID,-99) = -99
1169: AND NVL(SEGMENT3_VALUE_SET_ID,-99) = -99

Line 1196: INSERT INTO FEM_INTG_AOL_VALSET_MAP

1192: INTO pv_com_vs_id
1193: FROM DUAL;
1194: END IF;
1195:
1196: INSERT INTO FEM_INTG_AOL_VALSET_MAP
1197: (
1198: FEM_VALUE_SET_ID,
1199: DIMENSION_ID,
1200: SEGMENT1_VALUE_SET_ID,

Line 1277: INSERT INTO FEM_INTG_AOL_VALSET_MAP

1273: INTO pv_cc_vs_id
1274: FROM DUAL;
1275: END IF;
1276:
1277: INSERT INTO FEM_INTG_AOL_VALSET_MAP
1278: (
1279: FEM_VALUE_SET_ID,
1280: DIMENSION_ID,
1281: SEGMENT1_VALUE_SET_ID,

Line 1549: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_INTG_AOL_VALSET_MAP');

1545: ( p_msg_text => 'Before Gathering statistics for FEM');
1546:
1547: -- fnd_stats.gather_schema_statistics('FEM', null, null, null, null);
1548: -- Bug 5084804
1549: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_INTG_AOL_VALSET_MAP');
1550: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_INTG_OGL_CCID_MAP');
1551: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_COMPANIES_B');
1552: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_COMPANIES_TL');
1553: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_COST_CENTERS_B');

Line 1562: from all_indexes where table_name in('FEM_INTG_AOL_VALSET_MAP',

1558: fnd_stats.GATHER_TABLE_STATS('FEM', pv_attr_table_name);
1559:
1560: select INDEX_NAME BULK COLLECT
1561: INTO pv_index_name
1562: from all_indexes where table_name in('FEM_INTG_AOL_VALSET_MAP',
1563: 'FEM_INTG_OGL_CCID_MAP',
1564: 'FEM_COMPANIES_B',
1565: 'FEM_COMPANIES_TL',
1566: 'FEM_COST_CENTERS_B',

Line 2696: -- remove row from fem_intg_aol_valset_map

2692: END IF;
2693:
2694: END IF;
2695:
2696: -- remove row from fem_intg_aol_valset_map
2697: FEM_ENGINES_PKG.Tech_Message
2698: (p_severity => pc_log_level_statement,
2699: p_module => pc_module_name || l_func_name ,
2700: p_msg_text => 'removing row from fem_intg_aol_valset_map');

Line 2700: p_msg_text => 'removing row from fem_intg_aol_valset_map');

2696: -- remove row from fem_intg_aol_valset_map
2697: FEM_ENGINES_PKG.Tech_Message
2698: (p_severity => pc_log_level_statement,
2699: p_module => pc_module_name || l_func_name ,
2700: p_msg_text => 'removing row from fem_intg_aol_valset_map');
2701:
2702: delete from fem_intg_aol_valset_map where fem_value_set_id = l_value_set_id;
2703:
2704: ELSE

Line 2702: delete from fem_intg_aol_valset_map where fem_value_set_id = l_value_set_id;

2698: (p_severity => pc_log_level_statement,
2699: p_module => pc_module_name || l_func_name ,
2700: p_msg_text => 'removing row from fem_intg_aol_valset_map');
2701:
2702: delete from fem_intg_aol_valset_map where fem_value_set_id = l_value_set_id;
2703:
2704: ELSE
2705: IF(l_gvsc_exist_flag) THEN
2706: x_errbuf:= FND_MESSAGE.Get_String('FEM', 'FEM_INTG_DIM_RULE_POST_03');