DBA Data[Home] [Help]

APPS.FEM_DIM_MEMBER_LOADER_PKG dependencies on FEM_DIMENSION_UTIL_PKG

Line 8804: v_cal_period_id := fem_dimension_util_pkg.generate_member_id(

8800: EXCEPTION
8801: WHEN no_data_found THEN x_record_status := 'INVALID_CALPATTR_DIMGRP';
8802: END;
8803:
8804: v_cal_period_id := fem_dimension_util_pkg.generate_member_id(
8805: P_END_DATE => p_end_date
8806: ,P_PERIOD_NUM => p_cal_period_number
8807: ,P_CALENDAR_ID => v_calendar_id
8808: ,P_DIM_GRP_ID => v_dimension_group_id);

Line 11831: ',x_'||p_member_col||' => fem_dimension_util_pkg.generate_member_id('||

11827: x_insert_member_stmt :=
11828: 'DECLARE v_row_id VARCHAR2(1000); v_err_code NUMBER; x_num_msg NUMBER;'||
11829: 'BEGIN '||p_table_handler_name||'.INSERT_ROW'||
11830: '(x_rowid => v_row_id '||
11831: ',x_'||p_member_col||' => fem_dimension_util_pkg.generate_member_id('||
11832: ':b_end_date,:b_period_number,:b_calendar_id, :b_dimension_group_id,v_err_code,x_num_msg) '||
11833: ',x_dimension_group_id => :b_dimension_group_id '||
11834: ',x_calendar_id => :b_calendar_id '||
11835: ',x_enabled_flag => ''Y'' '||

Line 11877: 'fem_dimension_util_pkg.generate_member_id('||p_dimension_id||',v_err_code,x_num_msg)'||

11873: 'DECLARE v_row_id VARCHAR2(1000); v_err_code NUMBER; x_num_msg NUMBER; '||
11874: 'BEGIN '||p_table_handler_name||'.INSERT_ROW'||
11875: '(x_rowid => v_row_id'||
11876: ',x_'||p_member_col||' =>'||
11877: 'fem_dimension_util_pkg.generate_member_id('||p_dimension_id||',v_err_code,x_num_msg)'||
11878: ',x_value_set_id => :b_value_set_id '||
11879: ',x_dimension_group_id =>:b_dimension_group_id '||
11880: ',x_'||p_member_dc_col||' => :b_member_dc'||
11881: ',x_enabled_flag => ''Y'' '||

Line 11901: 'fem_dimension_util_pkg.generate_member_id('||p_dimension_id||',v_err_code,x_num_msg)'||

11897: 'DECLARE v_row_id VARCHAR2(1000); v_err_code NUMBER; x_num_msg NUMBER; '||
11898: 'BEGIN '||p_table_handler_name||'.INSERT_ROW'||
11899: '(x_rowid => v_row_id'||
11900: ',x_'||p_member_col||' =>'||
11901: 'fem_dimension_util_pkg.generate_member_id('||p_dimension_id||',v_err_code,x_num_msg)'||
11902: ',x_value_set_id => :b_value_set_id '||
11903: ',x_'||p_member_dc_col||' => :b_member_dc'||
11904: ',x_enabled_flag => ''Y'' '||
11905: ',x_personal_flag => ''N'' '||

Line 11923: 'fem_dimension_util_pkg.generate_member_id('||p_dimension_id||',v_err_code,x_num_msg)'||

11919: 'DECLARE v_row_id VARCHAR2(1000); v_err_code NUMBER; x_num_msg NUMBER; '||
11920: 'BEGIN '||p_table_handler_name||'.INSERT_ROW'||
11921: '(x_rowid => v_row_id'||
11922: ',x_'||p_member_col||' =>'||
11923: 'fem_dimension_util_pkg.generate_member_id('||p_dimension_id||',v_err_code,x_num_msg)'||
11924: ',x_dimension_group_id =>:b_dimension_group_id '||
11925: ',x_'||p_member_dc_col||' => :b_member_dc'||
11926: ',x_enabled_flag => ''Y'' '||
11927: ',x_personal_flag => ''N'' '||

Line 11945: 'fem_dimension_util_pkg.generate_member_id('||p_dimension_id||',v_err_code,x_num_msg)'||

11941: 'DECLARE v_row_id VARCHAR2(1000); v_err_code NUMBER; x_num_msg NUMBER; '||
11942: 'BEGIN '||p_table_handler_name||'.INSERT_ROW'||
11943: '(x_rowid => v_row_id'||
11944: ',x_'||p_member_col||' =>'||
11945: 'fem_dimension_util_pkg.generate_member_id('||p_dimension_id||',v_err_code,x_num_msg)'||
11946: ',x_'||p_member_dc_col||' => :b_member_dc'||
11947: ',x_enabled_flag => ''Y'' '||
11948: ',x_personal_flag => ''N'' '||
11949: ',x_read_only_flag => ''N'' '||