APPS.PFT_PROFCAL_RGNCNT_PUB dependencies on FEM_REGION_INFO

Line 18: g_fem_region_info CONSTANT VARCHAR2(30) := 'FEM_REGION_INFO';

14:
15: --Constants for output table names being registered with fem_pl_pkg
16: -- API register_table method.
17: g_fem_customer_profit CONSTANT VARCHAR2(30) := 'FEM_CUSTOMER_PROFIT';
18: g_fem_region_info CONSTANT VARCHAR2(30) := 'FEM_REGION_INFO';
19:
20: --constant for sql_stmt_type
21: g_insert CONSTANT VARCHAR2(30) := 'INSERT';
22:

Line 374: FROM fem_region_info

370:
371: -- Region Counting has to be done only once for a level
372: SELECT COUNT( dimension_group_id )
373: INTO l_dim_grp_id
374: FROM fem_region_info
375: WHERE dimension_group_id = p_customer_level
376: AND ledger_id = p_ledger_id
377: AND cal_period_id = p_cal_period_id
378: AND dataset_code = p_output_dataset_code;

Line 438: ,p_tbl_name => 'FEM_REGION_INFO'

434: ,p_login_id => l_login_id
435: ,p_rule_obj_id => p_rule_obj_id
436: ,p_exe_step => 'RGN_CNT'
437: ,p_exe_status_code => g_exec_status_error_rerun
438: ,p_tbl_name => 'FEM_REGION_INFO'
439: ,p_num_rows => l_num_rows_loaded);
440:
441: RAISE e_process_single_rule_error;
442: END;

Line 472: ,p_tbl_name => 'FEM_REGION_INFO'

468: ,p_login_id => l_login_id
469: ,p_rule_obj_id => p_rule_obj_id
470: ,p_exe_step => 'RGN_CNT'
471: ,p_exe_status_code => g_exec_status_error_rerun
472: ,p_tbl_name => 'FEM_REGION_INFO'
473: ,p_num_rows => l_num_rows_loaded);
474:
475: RAISE e_process_single_rule_error;
476: END;

Line 489: ,p_tbl_name => 'FEM_REGION_INFO'

485: ,p_login_id => l_login_id
486: ,p_rule_obj_id => p_rule_obj_id
487: ,p_exe_step => 'RGN_CNT'
488: ,p_exe_status_code => g_exec_status_success
489: ,p_tbl_name => 'FEM_REGION_INFO'
490: ,p_num_rows => l_num_rows_loaded);
491: -- commit the work
492: COMMIT;
493:

Line 824: ,p_tbl_name => g_fem_region_info

820: ,p_user_id => p_user_id
821: ,p_login_id => p_login_id
822: ,p_rule_obj_id => p_rule_obj_id
823: ,p_num_output_rows => p_num_rows
824: ,p_tbl_name => g_fem_region_info
825: ,p_stmt_type => g_insert );
826:
827: -----------------------------------------------------------------------
828: -- Call FEM_PL_PKG.update_num_of_input_rows();

Line 912: l_insert_head_stmt := ' INSERT INTO FEM_REGION_INFO ( ' ||

908: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
909: ,p_module => G_BLOCK||'.'||l_api_name
910: ,p_msg_text => 'BEGIN');
911:
912: l_insert_head_stmt := ' INSERT INTO FEM_REGION_INFO ( ' ||
913: ' CAL_PERIOD_ID, ' ||
914: ' DATASET_CODE, ' ||
915: ' DIMENSION_GROUP_ID, ' ||
916: ' SOURCE_SYSTEM_CODE, ' ||

Line 1173: l_insert_head_stmt := ' INSERT INTO FEM_REGION_INFO ( ' ||

1169: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1170: ,p_module => G_BLOCK||'.'||l_api_name
1171: ,p_msg_text => 'BEGIN');
1172:
1173: l_insert_head_stmt := ' INSERT INTO FEM_REGION_INFO ( ' ||
1174: ' CAL_PERIOD_ID, ' ||
1175: ' DATASET_CODE, ' ||
1176: ' DIMENSION_GROUP_ID, ' ||
1177: ' SOURCE_SYSTEM_CODE, ' ||