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_GLOBAL_VS_COMBO_DEFS

Line 818: FROM fem_global_vs_combo_defs

814: pv_progress := 'select fem_valueset_id for intercompany based on CCTR org dimension';
815: BEGIN
816: SELECT value_set_id
817: INTO pv_fem_vs_id
818: FROM fem_global_vs_combo_defs
819: WHERE global_vs_combo_id = pv_gvsc_id
820: AND dimension_id = pv_cctr_org_dim_id;
821:
822: SELECT value_set_id

Line 824: FROM fem_global_vs_combo_defs

820: AND dimension_id = pv_cctr_org_dim_id;
821:
822: SELECT value_set_id
823: INTO pv_com_vs_id
824: FROM fem_global_vs_combo_defs
825: WHERE global_vs_combo_id = pv_gvsc_id
826: AND dimension_id = pv_com_dim_id;
827:
828: SELECT value_set_id

Line 830: FROM fem_global_vs_combo_defs

826: AND dimension_id = pv_com_dim_id;
827:
828: SELECT value_set_id
829: INTO pv_cc_vs_id
830: FROM fem_global_vs_combo_defs
831: WHERE global_vs_combo_id = pv_gvsc_id
832: AND dimension_id = pv_cc_dim_id;
833:
834: EXCEPTION

Line 854: -- Register value set id in FEM_GLOBAL_VS_COMBO_DEFS for

850: app_exception.raise_exception;
851:
852: ELSE
853: --
854: -- Register value set id in FEM_GLOBAL_VS_COMBO_DEFS for
855: -- intercompany dimension
856: --
857: pv_progress := 'Update FEM_GLOBAL_VS_COMBO_DEFS for intercompany dimension';
858:

Line 857: pv_progress := 'Update FEM_GLOBAL_VS_COMBO_DEFS for intercompany dimension';

853: --
854: -- Register value set id in FEM_GLOBAL_VS_COMBO_DEFS for
855: -- intercompany dimension
856: --
857: pv_progress := 'Update FEM_GLOBAL_VS_COMBO_DEFS for intercompany dimension';
858:
859: UPDATE FEM_GLOBAL_VS_COMBO_DEFS
860: SET VALUE_SET_ID = pv_fem_vs_id
861: ,LAST_UPDATED_BY = pv_user_id

Line 859: UPDATE FEM_GLOBAL_VS_COMBO_DEFS

855: -- intercompany dimension
856: --
857: pv_progress := 'Update FEM_GLOBAL_VS_COMBO_DEFS for intercompany dimension';
858:
859: UPDATE FEM_GLOBAL_VS_COMBO_DEFS
860: SET VALUE_SET_ID = pv_fem_vs_id
861: ,LAST_UPDATED_BY = pv_user_id
862: ,LAST_UPDATE_DATE = SYSDATE
863: ,LAST_UPDATE_LOGIN = pv_login_id

Line 877: FROM FEM_GLOBAL_VS_COMBO_DEFS

873: THEN
874: BEGIN
875: SELECT VALUE_SET_ID
876: INTO v_global_defs_vs_id
877: FROM FEM_GLOBAL_VS_COMBO_DEFS
878: WHERE GLOBAL_VS_COMBO_ID = pv_gvsc_id
879: AND DIMENSION_ID = pv_dim_id;
880: EXCEPTION
881: WHEN NO_DATA_FOUND THEN

Line 885: ,p_msg_text => 'Unexpected error while getting value set from FEM_GLOBAL_VS_COMBO_DEFS');

881: WHEN NO_DATA_FOUND THEN
882: FEM_ENGINES_PKG.Tech_Message
883: ( p_severity => pc_log_level_error
884: ,p_module => pc_module_name||c_func_name
885: ,p_msg_text => 'Unexpected error while getting value set from FEM_GLOBAL_VS_COMBO_DEFS');
886: raise_application_error(-20001, fnd_message.get);
887: END;
888: IF v_global_defs_vs_id = -1
889: THEN

Line 890: pv_progress := 'Update FEM_GLOBAL_VS_COMBO_DEFS';

886: raise_application_error(-20001, fnd_message.get);
887: END;
888: IF v_global_defs_vs_id = -1
889: THEN
890: pv_progress := 'Update FEM_GLOBAL_VS_COMBO_DEFS';
891: UPDATE FEM_GLOBAL_VS_COMBO_DEFS
892: SET VALUE_SET_ID = pv_fem_vs_id
893: ,LAST_UPDATED_BY = pv_user_id
894: ,LAST_UPDATE_DATE = SYSDATE

Line 891: UPDATE FEM_GLOBAL_VS_COMBO_DEFS

887: END;
888: IF v_global_defs_vs_id = -1
889: THEN
890: pv_progress := 'Update FEM_GLOBAL_VS_COMBO_DEFS';
891: UPDATE FEM_GLOBAL_VS_COMBO_DEFS
892: SET VALUE_SET_ID = pv_fem_vs_id
893: ,LAST_UPDATED_BY = pv_user_id
894: ,LAST_UPDATE_DATE = SYSDATE
895: ,LAST_UPDATE_LOGIN = pv_login_id

Line 901: UPDATE FEM_GLOBAL_VS_COMBO_DEFS

897: AND DIMENSION_ID = pv_dim_id;
898:
899: IF pv_dim_varchar_label = 'NATURAL_ACCOUNT'
900: THEN
901: UPDATE FEM_GLOBAL_VS_COMBO_DEFS
902: SET VALUE_SET_ID = pv_fin_element_vs_id
903: ,LAST_UPDATED_BY = pv_user_id
904: ,LAST_UPDATE_DATE = SYSDATE
905: ,LAST_UPDATE_LOGIN = pv_login_id

Line 917: FROM fem_global_vs_combo_defs

913: IF pv_dim_varchar_label = 'INTERCOMPANY'
914: THEN
915: SELECT value_set_id
916: INTO pv_com_vs_id
917: FROM fem_global_vs_combo_defs
918: WHERE global_vs_combo_id = pv_gvsc_id
919: AND dimension_id = pv_com_dim_id;
920:
921: SELECT value_set_id

Line 923: FROM fem_global_vs_combo_defs

919: AND dimension_id = pv_com_dim_id;
920:
921: SELECT value_set_id
922: INTO pv_cc_vs_id
923: FROM fem_global_vs_combo_defs
924: WHERE global_vs_combo_id = pv_gvsc_id
925: AND dimension_id = pv_cc_dim_id;
926: END IF;
927:

Line 1026: pv_progress := 'Update FEM_GLOBAL_VS_COMBO_DEFS for company dim';

1022: --
1023: -- Bug fix 4190298
1024: -- Placed the update out of If statement as this was never done for SINGLESEG case
1025: --
1026: pv_progress := 'Update FEM_GLOBAL_VS_COMBO_DEFS for company dim';
1027:
1028: UPDATE FEM_GLOBAL_VS_COMBO_DEFS
1029: SET VALUE_SET_ID = pv_com_vs_id
1030: ,LAST_UPDATED_BY = pv_user_id

Line 1028: UPDATE FEM_GLOBAL_VS_COMBO_DEFS

1024: -- Placed the update out of If statement as this was never done for SINGLESEG case
1025: --
1026: pv_progress := 'Update FEM_GLOBAL_VS_COMBO_DEFS for company dim';
1027:
1028: UPDATE FEM_GLOBAL_VS_COMBO_DEFS
1029: SET VALUE_SET_ID = pv_com_vs_id
1030: ,LAST_UPDATED_BY = pv_user_id
1031: ,LAST_UPDATE_DATE = SYSDATE
1032: ,LAST_UPDATE_LOGIN = pv_login_id

Line 1127: pv_progress := 'Insert into FEM_GLOBAL_VS_COMBO_DEFS for cc dim';

1123: END IF;
1124:
1125: END IF;
1126:
1127: pv_progress := 'Insert into FEM_GLOBAL_VS_COMBO_DEFS for cc dim';
1128: UPDATE FEM_GLOBAL_VS_COMBO_DEFS
1129: SET VALUE_SET_ID = pv_cc_vs_id
1130: ,LAST_UPDATED_BY = pv_user_id
1131: ,LAST_UPDATE_DATE = SYSDATE

Line 1128: UPDATE FEM_GLOBAL_VS_COMBO_DEFS

1124:
1125: END IF;
1126:
1127: pv_progress := 'Insert into FEM_GLOBAL_VS_COMBO_DEFS for cc dim';
1128: UPDATE FEM_GLOBAL_VS_COMBO_DEFS
1129: SET VALUE_SET_ID = pv_cc_vs_id
1130: ,LAST_UPDATED_BY = pv_user_id
1131: ,LAST_UPDATE_DATE = SYSDATE
1132: ,LAST_UPDATE_LOGIN = pv_login_id

Line 1248: pv_progress := 'Update FEM_GLOBAL_VS_COMBO_DEFS for company dim';

1244: END IF; /* IF v_status = 0 */
1245: END IF; /* IF v_com_fnd_vs_id <> -1 */
1246: END IF; /* IF pv_com_vs_id = -1 */
1247:
1248: pv_progress := 'Update FEM_GLOBAL_VS_COMBO_DEFS for company dim';
1249:
1250: UPDATE FEM_GLOBAL_VS_COMBO_DEFS
1251: SET VALUE_SET_ID = pv_com_vs_id
1252: ,LAST_UPDATED_BY = pv_user_id

Line 1250: UPDATE FEM_GLOBAL_VS_COMBO_DEFS

1246: END IF; /* IF pv_com_vs_id = -1 */
1247:
1248: pv_progress := 'Update FEM_GLOBAL_VS_COMBO_DEFS for company dim';
1249:
1250: UPDATE FEM_GLOBAL_VS_COMBO_DEFS
1251: SET VALUE_SET_ID = pv_com_vs_id
1252: ,LAST_UPDATED_BY = pv_user_id
1253: ,LAST_UPDATE_DATE = SYSDATE
1254: ,LAST_UPDATE_LOGIN = pv_login_id

Line 1329: pv_progress := 'Insert into FEM_GLOBAL_VS_COMBO_DEFS for cc dim';

1325: END IF; /* IF v_status = 0 */
1326: END IF; /* IF v_cc_fnd_vs_id <> -1 */
1327: END IF; /* IF pv_cc_vs_id = -1 */
1328:
1329: pv_progress := 'Insert into FEM_GLOBAL_VS_COMBO_DEFS for cc dim';
1330: UPDATE FEM_GLOBAL_VS_COMBO_DEFS
1331: SET VALUE_SET_ID = pv_cc_vs_id
1332: ,LAST_UPDATED_BY = pv_user_id
1333: ,LAST_UPDATE_DATE = SYSDATE

Line 1330: UPDATE FEM_GLOBAL_VS_COMBO_DEFS

1326: END IF; /* IF v_cc_fnd_vs_id <> -1 */
1327: END IF; /* IF pv_cc_vs_id = -1 */
1328:
1329: pv_progress := 'Insert into FEM_GLOBAL_VS_COMBO_DEFS for cc dim';
1330: UPDATE FEM_GLOBAL_VS_COMBO_DEFS
1331: SET VALUE_SET_ID = pv_cc_vs_id
1332: ,LAST_UPDATED_BY = pv_user_id
1333: ,LAST_UPDATE_DATE = SYSDATE
1334: ,LAST_UPDATE_LOGIN = pv_login_id

Line 1346: ,p_msg_text => 'Before updating fem_global_vs_combo_defs with'

1342:
1343: FEM_ENGINES_PKG.Tech_Message
1344: ( p_severity => pc_log_level_event
1345: ,p_module => pc_module_name||c_func_name
1346: ,p_msg_text => 'Before updating fem_global_vs_combo_defs with'
1347: ||pv_fem_vs_id||' for dimension '||pv_dim_id);
1348:
1349: FEM_ENGINES_PKG.User_Message(
1350: p_app_name => 'FEM',

Line 2224: select 1 from fem_global_vs_combo_defs

2220: Cursor GVSCExistsForFemValueSet(c_gvsc_id Number,
2221: c_dim_id Number,
2222: c_val_set_id Number)
2223: IS
2224: select 1 from fem_global_vs_combo_defs
2225: where global_vs_combo_id <> c_gvsc_id
2226: and dimension_id = c_dim_id
2227: and value_set_id = c_val_set_id ;
2228:

Line 2313: FROM fem_global_vs_combo_defs

2309: IF (l_dim_mapping_Option_code = 'SINGLESEG' OR l_dim_mapping_Option_code = 'MULTISEG') THEN
2310:
2311: SELECT value_set_id
2312: INTO l_value_set_id
2313: FROM fem_global_vs_combo_defs
2314: WHERE global_vs_combo_Id = l_global_vs_combo_id
2315: and dimension_id = l_dim_id;
2316:
2317: FEM_ENGINES_PKG.Tech_Message

Line 2326: FROM fem_global_vs_combo_defs

2322: IF(l_dim_id = 8) THEN
2323:
2324: SELECT value_set_id
2325: INTO comp_val_set_id
2326: FROM fem_global_vs_combo_defs
2327: WHERE dimension_id =112
2328: AND global_vs_combo_Id = l_global_vs_combo_id;
2329:
2330: SELECT value_set_id

Line 2332: FROM fem_global_vs_combo_defs

2328: AND global_vs_combo_Id = l_global_vs_combo_id;
2329:
2330: SELECT value_set_id
2331: INTO cctr_val_set_id
2332: FROM fem_global_vs_combo_defs
2333: WHERE dimension_id =113
2334: AND global_vs_combo_Id = l_global_vs_combo_id;
2335: END IF;
2336:

Line 2508: -- Updating the fem_global_vs_combo_defs

2504: USING l_global_vs_combo_id;
2505:
2506: END IF;
2507:
2508: -- Updating the fem_global_vs_combo_defs
2509:
2510: FEM_ENGINES_PKG.Tech_Message
2511: (p_severity => pc_log_level_statement,
2512: p_module => pc_module_name || l_func_name,

Line 2513: p_msg_text => 'Updating fem_global_vs_combo_defs setting value_set_id to -1 ');

2509:
2510: FEM_ENGINES_PKG.Tech_Message
2511: (p_severity => pc_log_level_statement,
2512: p_module => pc_module_name || l_func_name,
2513: p_msg_text => 'Updating fem_global_vs_combo_defs setting value_set_id to -1 ');
2514:
2515: IF (l_dim_id = 8) THEN
2516: UPDATE fem_global_vs_combo_defs
2517: SET value_set_id = -1

Line 2516: UPDATE fem_global_vs_combo_defs

2512: p_module => pc_module_name || l_func_name,
2513: p_msg_text => 'Updating fem_global_vs_combo_defs setting value_set_id to -1 ');
2514:
2515: IF (l_dim_id = 8) THEN
2516: UPDATE fem_global_vs_combo_defs
2517: SET value_set_id = -1
2518: WHERE global_vs_combo_id = l_global_vs_combo_id
2519: AND dimension_id in (8,112,113);
2520: ELSE

Line 2521: UPDATE fem_global_vs_combo_defs

2517: SET value_set_id = -1
2518: WHERE global_vs_combo_id = l_global_vs_combo_id
2519: AND dimension_id in (8,112,113);
2520: ELSE
2521: UPDATE fem_global_vs_combo_defs
2522: SET value_set_id = -1
2523: WHERE global_vs_combo_id = l_global_vs_combo_id
2524: AND dimension_id = l_dim_id;
2525: END IF;