APPS.FEM_INTG_DIM_RULE_ENG_PKG dependencies on FEM_INTG_OGL_CCID_MAP

Line 1370: ,p_msg_text => 'Before locking fem_intg_ogl_ccid_map');

1366:
1367: FEM_ENGINES_PKG.Tech_Message
1368: ( p_severity => pc_log_level_event
1369: ,p_module => pc_module_name||c_func_name
1370: ,p_msg_text => 'Before locking fem_intg_ogl_ccid_map');
1371:
1372: -- Bug fix 4301926
1373: LOCK TABLE FEM_INTG_OGL_CCID_MAP IN EXCLUSIVE MODE;
1374:

Line 1373: LOCK TABLE FEM_INTG_OGL_CCID_MAP IN EXCLUSIVE MODE;

1369: ,p_module => pc_module_name||c_func_name
1370: ,p_msg_text => 'Before locking fem_intg_ogl_ccid_map');
1371:
1372: -- Bug fix 4301926
1373: LOCK TABLE FEM_INTG_OGL_CCID_MAP IN EXCLUSIVE MODE;
1374:
1375: -- Get max_id of place holder records
1376:
1377: SELECT NVL(MAX(CODE_COMBINATION_ID),-1)

Line 1379: FROM FEM_INTG_OGL_CCID_MAP

1375: -- Get max_id of place holder records
1376:
1377: SELECT NVL(MAX(CODE_COMBINATION_ID),-1)
1378: INTO v_max_ccid_in_map_table
1379: FROM FEM_INTG_OGL_CCID_MAP
1380: WHERE GLOBAL_VS_COMBO_ID = pv_gvsc_id;
1381:
1382:
1383: --Get max_id of records in CCID table

Line 1550: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_INTG_OGL_CCID_MAP');

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');
1554: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_COST_CENTERS_TL');

Line 1563: 'FEM_INTG_OGL_CCID_MAP',

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',
1567: 'FEM_COST_CENTERS_TL',

Line 1726: INSERT INTO FEM_INTG_OGL_CCID_MAP(

1722: p_value1 => pc_module_name||c_func_name,
1723: p_token2 => 'TIME',
1724: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
1725:
1726: INSERT INTO FEM_INTG_OGL_CCID_MAP(
1727: CODE_COMBINATION_ID,
1728: GLOBAL_VS_COMBO_ID,
1729: COMPANY_COST_CENTER_ORG_ID,
1730: NATURAL_ACCOUNT_ID,

Line 1797: ,p_value1 => 'FEM_INTG_OGL_CCID_MAP'

1793: ,p_module => pc_module_name||c_func_name
1794: ,p_app_name => 'FEM'
1795: ,p_msg_name => 'FEM_GL_POST_216'
1796: ,p_token1 => 'TABLE'
1797: ,p_value1 => 'FEM_INTG_OGL_CCID_MAP'
1798: ,p_token2 => 'NUM'
1799: ,p_value2 => x_rows_processed);
1800:
1801: FEM_ENGINES_PKG.Tech_Message

Line 2471: -- Updating the FEM_INTG_OGL_CCID_MAP

2467: p_msg_name => 'FEM_INTG_DIM_RULE_POST_02',
2468: p_token1 => 'DIM_RULE_OBJ_ID',
2469: p_value1 => p_dim_rule_obj_id);
2470:
2471: -- Updating the FEM_INTG_OGL_CCID_MAP
2472:
2473: IF (l_dim_id <> 29) THEN
2474:
2475: FEM_ENGINES_PKG.Tech_Message

Line 2478: p_msg_text => 'Updating FEM_INTG_OGL_CCID_MAP setting ' || l_memb_col_name || ' to -1');

2474:
2475: FEM_ENGINES_PKG.Tech_Message
2476: (p_severity => pc_log_level_statement,
2477: p_module => pc_module_name || l_func_name,
2478: p_msg_text => 'Updating FEM_INTG_OGL_CCID_MAP setting ' || l_memb_col_name || ' to -1');
2479:
2480: temp_stmt:= 'UPDATE fem_intg_ogl_ccid_map
2481: SET ' || l_memb_col_name ||' =-1 ' ;
2482:

Line 2480: temp_stmt:= 'UPDATE fem_intg_ogl_ccid_map

2476: (p_severity => pc_log_level_statement,
2477: p_module => pc_module_name || l_func_name,
2478: p_msg_text => 'Updating FEM_INTG_OGL_CCID_MAP setting ' || l_memb_col_name || ' to -1');
2479:
2480: temp_stmt:= 'UPDATE fem_intg_ogl_ccid_map
2481: SET ' || l_memb_col_name ||' =-1 ' ;
2482:
2483: IF (l_dim_id = 8) THEN
2484: temp_stmt := temp_stmt || ' ,INTERCOMPANY_ID=-1 ';