APPS.HXC_ALIAS_TYPES_CHKS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

l_select_nid varchar2(32000);

Line: 9

l_select_wid varchar2(32000);

Line: 15

fnd_flex_val_api.get_table_vset_select
(
 P_VALUE_SET_ID => p_id
 ,p_inc_id_col => 'N'
 , p_inc_meaning_col => 'N'
 ,X_SELECT => l_select_nid
 ,X_MAPPING_CODE => p_X_mapping_code
 ,X_SUCCESS => p_X_success);

Line: 23

fnd_flex_val_api.get_table_vset_select
(
 P_VALUE_SET_ID => p_id
 , p_inc_meaning_col => 'N'
 ,X_SELECT => l_select_wid
 ,X_MAPPING_CODE => p_X_mapping_code
 ,X_SUCCESS => p_X_success);

Line: 31

if (l_select_nid = l_select_wid ) then
raise invalid_sql;

Line: 35

fnd_flex_val_api.GET_TABLE_VSET_SELECT
(
 P_VALUE_SET_ID    => p_id
,P_VALUE_SET_NAME  => p_name
,p_inc_addtl_quickpick_cols => 'Y'
 ,X_SELECT    => p_X_SELECT_WC
 ,X_MAPPING_CODE   => p_X_MAPPING_CODE
 ,X_SUCCESS         => p_X_SUCCESS
);

Line: 48

fnd_flex_val_api.GET_TABLE_VSET_SELECT
(
 P_VALUE_SET_ID    => p_id
,P_VALUE_SET_NAME  => p_name
,X_SELECT    => p_X_SELECT_NC
 ,X_MAPPING_CODE   => p_X_MAPPING_CODE
 ,X_SUCCESS        => p_X_SUCCESS
);

Line: 61

  dbms_sql.parse( c , p_X_SELECT_WC,dbms_sql.native);--dbms_sql.native) ;

Line: 65

P_SQL_WC:=p_X_SELECT_WC;

Line: 66

P_SQL_NC:=p_X_SELECT_NC;

Line: 84

l_select_nid varchar2(32000);

Line: 85

l_select_wid varchar2(32000);

Line: 90

fnd_flex_val_api.get_table_vset_select
(
 P_VALUE_SET_ID => p_id
 ,p_inc_id_col => 'N'
 , p_inc_meaning_col => 'N'
 ,X_SELECT => l_select_nid
 ,X_MAPPING_CODE => p_X_mapping_code
,X_SUCCESS => p_X_success);

Line: 103

fnd_flex_val_api.get_table_vset_select
(
 P_VALUE_SET_ID => p_id
 , p_inc_meaning_col => 'N'
 ,X_SELECT => l_select_wid
 ,X_MAPPING_CODE => p_X_mapping_code
 ,X_SUCCESS => p_X_success);

Line: 117

P_SQL_WC := l_select_wid;

Line: 118

P_SQL_NC := l_select_nid;