[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select decode(ari1.ATTRIBUTE_CODE,null,'NULL',ari1.ATTRIBUTE_CODE),
ari2.DISPLAY_SEQUENCE
from AK_REGION_ITEMS_VL ari1, AK_REGION_ITEMS_VL ari2
where ari1.REGION_APPLICATION_ID(+) = c_region_app_id
and ari1.REGION_CODE(+) = c_region_code
and ari1.LOV_REGION_APPLICATION_ID(+) = lov_reg_id
and ari1.LOV_REGION_CODE(+) = lov_reg
and ari1.LOV_FOREIGN_KEY_NAME(+) = lov_f_key_name
and (ari1.REGION_DEFAULTING_API_PKG is null
or ari1.REGION_DEFAULTING_API_PKG <> 'JS')
and ari2.REGION_APPLICATION_ID = lov_reg_id
and ari2.REGION_CODE = lov_reg
and ari2.ATTRIBUTE_CODE = ari1.LOV_ATTRIBUTE_CODE(+)
order by ari2.DISPLAY_SEQUENCE;
select ari1.REGION_DEFAULTING_API_PROC, ari2.DISPLAY_SEQUENCE
from AK_REGION_ITEMS_VL ari1, AK_REGION_ITEMS_VL ari2
where ari1.REGION_APPLICATION_ID = c_region_app_id
and ari1.REGION_CODE = c_region_code
and ari1.LOV_REGION_APPLICATION_ID = lov_reg_id
and ari1.LOV_REGION_CODE = lov_reg
and ari1.LOV_FOREIGN_KEY_NAME = lov_f_key_name
and ari1.REGION_DEFAULTING_API_PROC is not null
and ari2.REGION_APPLICATION_ID = lov_reg_id
and ari2.REGION_CODE = lov_reg
and ari2.ATTRIBUTE_CODE = ari1.LOV_ATTRIBUTE_CODE
order by ari1.DISPLAY_SEQUENCE;
select attribute_label_long into LOV_title
from ak_region_items_vl
where region_application_id = c_region_app_id
and region_code = c_region_code
and attribute_application_id = c_attribute_app_id
and attribute_code = c_attribute_code;
select LOV_FOREIGN_KEY_NAME, LOV_REGION_APPLICATION_ID, LOV_REGION_CODE
into temp_LOV_foreign_key_name, temp_LOV_region_id, temp_LOV_region
from AK_REGION_ITEMS
where REGION_APPLICATION_ID = c_region_app_id
and REGION_CODE = c_region_code
and ATTRIBUTE_APPLICATION_ID = c_attribute_app_id
and ATTRIBUTE_CODE = c_attribute_code;
select substr(temp_text,12,512) into err_mesg from dual;
select d.COLUMN_NAME
from AK_ATTRIBUTES a,
AK_REGION_ITEMS_VL b,
AK_REGIONS c,
AK_OBJECT_ATTRIBUTES d
where b.REGION_APPLICATION_ID = p_LOV_region_id
and b.REGION_CODE = p_LOV_region
and b.NODE_QUERY_FLAG = 'Y'
and b.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID
and b.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
and b.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
and b.REGION_CODE = c.REGION_CODE
and c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
and d.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID
and d.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
and d.ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID
and d.ATTRIBUTE_CODE = a.ATTRIBUTE_CODE
order by b.DISPLAY_SEQUENCE;
p_update in boolean,
p_target in varchar2,
p_list_count in boolean,
P_OBJECT_DISP_NAME in varchar2) is
l_target varchar2(240);
select d.COLUMN_NAME,b.ATTRIBUTE_LABEL_LONG,
substr(a.DATA_TYPE,1,1)
from AK_ATTRIBUTES a,
AK_REGION_ITEMS_VL b,
AK_REGIONS c,
AK_OBJECT_ATTRIBUTES d
where b.REGION_APPLICATION_ID = p_LOV_region_id
and b.REGION_CODE = p_LOV_region
and b.NODE_QUERY_FLAG = 'Y'
and b.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID
and b.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
and b.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
and b.REGION_CODE = c.REGION_CODE
and c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
and d.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID
and d.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
and d.ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID
and d.ATTRIBUTE_CODE = a.ATTRIBUTE_CODE
order by b.DISPLAY_SEQUENCE;
select icx_custom_call
into l_icx_custom_call
from ak_regions
where REGION_APPLICATION_ID = p_LOV_region_id
and REGION_CODE = p_LOV_region;
parent.LOVValues.document.LOVValues.a_1.value = document.LOVHeader.a_1.options[document.LOVHeader.a_1.selectedIndex].value
parent.LOVValues.document.LOVValues.c_1.value = document.LOVHeader.c_1.options[document.LOVHeader.c_1.selectedIndex].value
parent.LOVValues.document.LOVValues.i_1.value = document.LOVHeader.i_1.value
} else {
parent.LOVValues.document.LOVValues.x.value = 1
parent.LOVValues.document.LOVValues.start_row.value = 1
parent.LOVValues.document.LOVValues.p_end_row.value = ""
parent.LOVValues.document.LOVValues.a_1.value = document.LOVHeader.a_1.value
parent.LOVValues.document.LOVValues.c_1.value = document.LOVHeader.c_1.options[document.LOVHeader.c_1.selectedIndex].value
parent.LOVValues.document.LOVValues.i_1.value = document.LOVHeader.i_1.value}');
htp.p('parent.LOVValues.document.LOVValues.a_2.value = document.LOVHeader.a_2.options[document.LOVHeader.a_2.selectedIndex].value
parent.LOVValues.document.LOVValues.c_2.value = document.LOVHeader.c_2.options[document.LOVHeader.c_2.selectedIndex].value
parent.LOVValues.document.LOVValues.i_2.value = document.LOVHeader.i_2.value
parent.LOVValues.document.LOVValues.a_3.value = document.LOVHeader.a_3.options[document.LOVHeader.a_3.selectedIndex].value
parent.LOVValues.document.LOVValues.c_3.value = document.LOVHeader.c_3.options[document.LOVHeader.c_3.selectedIndex].value
parent.LOVValues.document.LOVValues.i_3.value = document.LOVHeader.i_3.value
parent.LOVValues.document.LOVValues.a_4.value = document.LOVHeader.a_4.options[document.LOVHeader.a_4.selectedIndex].value
parent.LOVValues.document.LOVValues.c_4.value = document.LOVHeader.c_4.options[document.LOVHeader.c_4.selectedIndex].value
parent.LOVValues.document.LOVValues.i_4.value = document.LOVHeader.i_4.value
parent.LOVValues.document.LOVValues.a_5.value = document.LOVHeader.a_5.options[document.LOVHeader.a_5.selectedIndex].value
parent.LOVValues.document.LOVValues.c_5.value = document.LOVHeader.c_5.options[document.LOVHeader.c_5.selectedIndex].value
parent.LOVValues.document.LOVValues.i_5.value = document.LOVHeader.i_5.value');
select count(*)
into l_query_attr_cnt
from AK_ATTRIBUTES a,
AK_REGION_ITEMS_VL b,
AK_REGIONS c,
AK_OBJECT_ATTRIBUTES d
where b.REGION_APPLICATION_ID = p_LOV_region_id
and b.REGION_CODE = p_LOV_region
and b.NODE_QUERY_FLAG = 'Y'
and b.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID
and b.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
and b.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
and b.REGION_CODE = c.REGION_CODE
and c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
and d.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID
and d.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
and d.ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID
and d.ATTRIBUTE_CODE = a.ATTRIBUTE_CODE;
l_attributes2 := htf.formSelectOption('','','VALUE=""');
temp_text := htf.formSelectOption(temp_attribute,'SELECTED','VALUE="'||temp_type||temp_column||'"');
l_attributes2 := l_attributes2||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');
temp_text := temp_text||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');
l_attributes2 := l_attributes2||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');
temp_text := temp_text||htf.formSelectClose;
l_attributes2 := l_attributes2||htf.formSelectClose;
htp.tableData(htf.formSelectOpen('a_1')||temp_text);
l_conditions2 := htf.formSelectOption('','SELECTED','VALUE=""');
temp_text := temp_text||htf.formSelectOption(l_lookup_meanings(i),'SELECTED','VALUE="'||l_lookup_codes(i)||'"');
l_conditions2 := l_conditions2||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"');
temp_text := temp_text||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"');
l_conditions2 := l_conditions2||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"');
temp_text := temp_text||htf.formSelectClose;
l_conditions2 := l_conditions2||htf.formSelectClose;
htp.tableData(htf.formSelectOpen('c_1')||temp_text);
l_display_line := ''||htf.formSelectOpen('a_'||i)||
l_attributes2||htf.formSelectClose||' '||
''||htf.formSelectOpen('c_'||i)||
l_conditions2||htf.formSelectClose||' '||
''||htf.formText('i_'||i,20)||'
select substr(temp_text,12,512) into err_mesg from dual;
select ATTRIBUTE_CODE, LOV_ATTRIBUTE_CODE
from AK_REGION_ITEMS_VL
where REGION_APPLICATION_ID = p_region_app_id
and REGION_CODE = p_region_code
and LOV_REGION_APPLICATION_ID = p_LOV_region_id
and LOV_REGION_CODE = p_LOV_region
and LOV_FOREIGN_KEY_NAME = p_LOV_foreign_key_name
order by DISPLAY_SEQUENCE;
select ATTRIBUTE_CODE, LOV_ATTRIBUTE_CODE, REGION_DEFAULTING_API_PROC
from AK_REGION_ITEMS_VL
where REGION_APPLICATION_ID = p_region_app_id
and REGION_CODE = p_region_code
and LOV_REGION_APPLICATION_ID = p_LOV_region_id
and LOV_REGION_CODE = p_LOV_region
and LOV_FOREIGN_KEY_NAME = p_LOV_foreign_key_name
and REGION_DEFAULTING_API_PROC is not null
order by DISPLAY_SEQUENCE;
select d.COLUMN_NAME
from AK_ATTRIBUTES a,
AK_REGION_ITEMS_VL b,
AK_REGIONS c,
AK_OBJECT_ATTRIBUTES d
where b.REGION_APPLICATION_ID = p_LOV_region_id
and b.REGION_CODE = p_LOV_region
and b.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID
and b.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
and b.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
and b.REGION_CODE = c.REGION_CODE
and c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
and d.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID
and d.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
and d.ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID
and d.ATTRIBUTE_CODE = a.ATTRIBUTE_CODE
order by b.DISPLAY_SEQUENCE;
select QUERY_SET, MAX_ROWS
into l_query_size, l_max_rows
from ICX_PARAMETERS;
select substr(a.DATA_TYPE,1,1)||d.COLUMN_NAME
into temp_a_1
from AK_ATTRIBUTES a,
AK_REGION_ITEMS_VL b,
AK_REGIONS c,
AK_OBJECT_ATTRIBUTES d
where b.REGION_APPLICATION_ID = p_LOV_region_id
and b.REGION_CODE = p_LOV_region
and b.NODE_QUERY_FLAG = 'Y'
and b.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID
and b.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
and b.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
and b.REGION_CODE = c.REGION_CODE
and c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
and d.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID
and d.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
and d.ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID
and d.ATTRIBUTE_CODE = a.ATTRIBUTE_CODE
and b.DISPLAY_SEQUENCE = (
select min(e.DISPLAY_SEQUENCE)
from AK_REGION_ITEMS_VL e
where e.REGION_APPLICATION_ID = p_LOV_region_id
and e.REGION_CODE = p_LOV_region);
select QUERY_SET into l_query_size
from ICX_PARAMETERS;
p_update => FALSE,
p_target => '',
P_LIST_COUNT => TRUE,
P_OBJECT_DISP_NAME => ak_query_pkg.g_items_table(1).attribute_label_long);
p_update => FALSE,
p_target => '',
P_LIST_COUNT => FALSE,
P_OBJECT_DISP_NAME => ak_query_pkg.g_items_table(1).attribute_label_long);
select attribute_label_long into l_attribute_name
from ak_region_items_vl
where region_application_id = p_region_app_id
and region_code = p_region_code
and attribute_application_id = p_attribute_app_id
and attribute_code = p_attribute_code;
select substr(temp_text,12,512) into err_mesg from dual;
cursor items is -- removed select for ari.attribute_code since we didnt use it. mputman 1574527
select arit.attribute_label_long
from ak_region_items_tl arit,
ak_region_items ari
where
arit.region_application_id = ari.region_application_id
and arit.region_code = ari.region_code
and arit.attribute_application_id = ari.attribute_application_id
and arit.attribute_code = ari.attribute_code
and arit.language = userenv('LANG')
and ari.region_application_id = p_region_application_id
and ari.region_code = p_region_code
order by display_sequence;
select a.ATTRIBUTE_LABEL_LONG,a.ATTRIBUTE_CODE
from AK_REGION_ITEMS_TL a,
AK_REGION_ITEMS b,
FND_LANGUAGES c
where b.REGION_APPLICATION_ID = p_region_application_id
and b.REGION_CODE = p_region_code
and b.ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID
and b.ATTRIBUTE_CODE = a.ATTRIBUTE_CODE
and a.LANGUAGE = c.LANGUAGE_CODE
and c.INSTALLED_FLAG = 'B'
order by b.DISPLAY_SEQUENCE;
select NAME
into p_title
from AK_REGIONS_VL
where REGION_APPLICATION_ID = p_region_application_id
and REGION_CODE = p_region_code;
select NAME
into p_title
from AK_REGIONS_TL a,
FND_LANGUAGES b
where REGION_APPLICATION_ID = p_region_application_id
and REGION_CODE = p_region_code
and a.LANGUAGE = b.LANGUAGE_CODE
and b.INSTALLED_FLAG = 'B' ;
select ATTRIBUTE_LABEL_LONG
into l_prompt
from AK_REGION_ITEMS_VL
where REGION_APPLICATION_ID = p_region_application_id
and REGION_CODE = p_region_code
and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
and ATTRIBUTE_CODE = p_attribute_code;
select ATTRIBUTE_LABEL_LONG
into l_prompt
from AK_REGION_ITEMS_TL a,
FND_LANGUAGES b
where REGION_APPLICATION_ID = p_region_application_id
and REGION_CODE = p_region_code
and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
and ATTRIBUTE_CODE = p_attribute_code
and a.LANGUAGE = b.LANGUAGE_CODE
and b.INSTALLED_FLAG = 'B' ;
select LOOKUP_CODE,MEANING
from FND_LOOKUPS
where LOOKUP_TYPE = p_lookup_type
and ENABLED_FLAG = 'Y'
and sysdate >= nvl(START_DATE_ACTIVE,sysdate)
and sysdate <= nvl(END_DATE_ACTIVE,sysdate)
order by LOOKUP_CODE;
select MEANING
from FND_LOOKUPS
where LOOKUP_TYPE = p_lookup_type
and LOOKUP_CODE = p_lookup_code;
select COLOR_VALUE
from ICX_COLORS
where NAME = v_color;
select msi.concatenated_segments
into ret_val
from mtl_system_items_kfv msi
where rowid = ri;
select mc.concatenated_segments
into ret_val
from mtl_categories_kfv mc
where category_id = cat_id;