The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
FROM all_tab_columns tc
WHERE tc.table_name = 'BNE_INTEGRATORS_B'
AND tc.column_name = 'NEW_SESSION_FLAG'
AND tc.owner = l_oracle_schema;
' UPDATE bne_integrators_b ' ||
' SET new_session_flag = ''Y'' ' ||
' WHERE application_id = :1 ' ||
' AND integrator_code = :2; ' ||
' select FORM_NAME' ||
' from '||l_bne_value ||
' where FORM_NAME = '''||
p_form_name || '''';
' select APPLICATION_SHORT_NAME' ||
' from '||l_bne_value ||
' where APPLICATION_ID ='||
p_application_id;
' select USER_NAME' ||
' from '||l_bne_value ||
' where USER_NAME ='''||
p_integrator_user_name ||'''';
SELECT hr_adi_object_code_s.NEXTVAL
INTO l_object_num
FROM dual;
'SELECT integrator_code' ||
' FROM ' || l_bne_value ||
' WHERE integrator_code = ''' ||
l_object_code ||'_INTG'||
''' AND application_id = '
|| p_application_id;
'SELECT integrator_code' ||
' FROM ' || l_bne_value ||
' WHERE integrator_code = ''' ||
l_integrator_code ||
''' AND application_id = '
|| p_application_id;
'SELECT content_code ' ||
' FROM ' || l_bne_value ||
' WHERE integrator_code =''' ||
l_integrator_code ||
''' AND application_id = '|| p_application_id;
'SELECT count(*) ' ||
' FROM '|| l_bne_value ||
' WHERE content_code =''' ||
l_content_code ||''' AND ' ||
' application_id = '|| p_application_id;
'SELECT count(*) ' ||
' FROM ' || l_bne_value ||
' WHERE interface_code = ' ||
' (SELECT interface_code' ||
' FROM bne_interfaces_b' ||
' WHERE integrator_code = ''' ||
l_integrator_code ||
''' AND application_id = '||
p_application_id || ')';
' SELECT mapping_code'||
' FROM ' || l_bne_value ||
' WHERE mapping_code = ''' ||
l_mapping_code ||
''' AND application_id ='||
p_application_id;
'SELECT param_list_code ' ||
' FROM ' || l_bne_value ||
' WHERE content_code = ''' ||
l_content_code ||
''' AND application_id = '||
p_application_id;
' select APPLICATION_SHORT_NAME' ||
' from '||l_bne_value ||
' where APPLICATION_ID ='||
p_application_id;
' select USER_NAME' ||
' from '||l_bne_value ||
' where USER_NAME ='''||
p_integrator_user_name ||'''';
' select 1' ||
' from '||l_bne_value ||
' where A.OBJ# = B.OBJECT_ID' ||
' AND B.OBJECT_NAME = '''||P_API_PACKAGE_NAME ||
''' AND A.PROCEDURE$ = ''' ||P_API_PROCEDURE_NAME || '''';
SELECT hr_adi_object_code_s.NEXTVAL
INTO l_object_num
FROM dual;
'SELECT integrator_code' ||
' FROM ' || l_bne_value ||
' WHERE integrator_code = ''' ||
l_object_code ||'_INTG'||
''' AND application_id = '
|| p_application_id;
'SELECT integrator_code' ||
' FROM ' || l_bne_value ||
' WHERE integrator_code = '||
'(SELECT integrator_code '||
'FROM bne_integrators_b '||
'WHERE integrator_code =''' ||
l_integrator_code ||
''' AND application_id = ' ||
p_application_id||
') AND application_id ='||
p_application_id;
' SELECT interface_code '||
' FROM '|| l_bne_value ||
' WHERE interface_code = (' ||
' SELECT interface_code'||
' FROM bne_interfaces_b' ||
' WHERE interface_code = ''' ||
l_interface_code ||
''' AND application_id ='||
p_application_id ||
') AND application_id = '||
p_application_id;
' SELECT content_code'||
' FROM ' || l_bne_value ||
' WHERE content_code = ''' ||
l_content_code ||
''' AND application_id ='||
p_application_id;
PROCEDURE create_update_data
(p_application_id IN number
,p_integrator_user_name IN varchar2
,p_api_package_name IN varchar2
,p_api_procedure_name IN varchar2
,p_interface_user_name IN varchar2
,p_interface_param_name IN varchar2
,p_api_type IN varchar2
,p_api_return_type IN varchar2
,p_view_name IN varchar2
,p_form_name IN varchar2
,p_language IN varchar2
,p_user_id IN number) IS
--
-- Upload api (update-style api's)
--
TYPE CSR_TYP IS REF CURSOR;
' select APPLICATION_SHORT_NAME' ||
' from '||l_bne_value ||
' where APPLICATION_ID ='||
p_application_id;
' select FORM_NAME' ||
' from '||l_bne_value ||
' where FORM_NAME = '''||
p_form_name || '''';
' select USER_NAME' ||
' from '||l_bne_value ||
' where USER_NAME ='''||
p_integrator_user_name ||'''';
' select 1' ||
' from '||l_bne_value ||
' where A.OBJ# = B.OBJECT_ID' ||
' AND B.OBJECT_NAME = '''||P_API_PACKAGE_NAME ||
''' AND A.PROCEDURE$ = ''' ||P_API_PROCEDURE_NAME ||'''';
SELECT hr_adi_object_code_s.NEXTVAL
INTO l_object_num
FROM dual;
'SELECT integrator_code' ||
' FROM ' || l_bne_value ||
' WHERE integrator_code = ''' ||
l_object_code ||'_INTG'||
''' AND application_id = '
|| p_application_id;
'SELECT integrator_code' ||
' FROM ' || l_bne_value ||
' WHERE integrator_code = ''' ||
l_integrator_code ||
''' AND application_id = '
|| p_application_id;
'SELECT content_code ' ||
' FROM ' || l_bne_value ||
' WHERE integrator_code =''' ||
l_integrator_code ||
''' AND application_id = '|| p_application_id;
'SELECT count(*) ' ||
' FROM '|| l_bne_value ||
' WHERE content_code =''' ||
l_content_code ||''' AND ' ||
' application_id = '|| p_application_id;
'SELECT param_list_code ' ||
' FROM ' || l_bne_value ||
' WHERE content_code = ''' ||
l_content_code ||
''' AND application_id = '||
p_application_id;
' SELECT interface_code '||
' FROM '|| l_bne_value ||
' WHERE interface_code = (' ||
' SELECT interface_code'||
' FROM bne_interfaces_b' ||
' WHERE interface_code = ''' ||
l_interface_code ||
''' AND application_id ='||
p_application_id ||
') AND application_id = '||
p_application_id;
END create_update_data;
SELECT
fnd_global.user_id,
userenv('LANG')
INTO
l_user_id,
l_language
FROM
dual;
ELSIF (UPPER(p_metadata_type) = 'UPDATE')
THEN NULL;
create_update_data
(p_application_id => p_application_id
,p_integrator_user_name => p_integrator_user_name
,p_api_package_name => l_package_name
,p_api_procedure_name => l_procedure_name
,p_interface_user_name => p_interface_user_name
,p_interface_param_name => p_interface_param_name
,p_api_type => l_api_type
,p_api_return_type => l_api_return_type
,p_view_name => p_view_name
,p_form_name => l_form_name
,p_language => l_language
,p_user_id => l_user_id);
'SELECT b.integrator_code ' ||
' FROM bne_integrators_tl t ' ||
' , bne_integrators_b b ' ||
' WHERE t.application_id = ' || p_application_id ||
' AND t.user_name = ''' || p_intg_user_name || '''' ||
' AND t.integrator_code = b.integrator_code ' ||
' AND t.application_id = b.application_id ' ||
' AND t.integrator_code like ''GENERAL%'' ' ||
' AND b.enabled_flag = ''Y'' ';
'SELECT param_list_app_id, ' ||
' param_list_code, ' ||
' content_code ' ||
' FROM bne_contents_b ' ||
' WHERE integrator_app_id = '||p_application_id ||
' AND integrator_code = ''' ||l_integrator_code || ''' ';
' DELETE FROM bne_param_list_items ' ||
' WHERE application_id = :1 ' ||
' AND param_list_code = :2 ;' ||
' DELETE from bne_param_lists_tl ' ||
' WHERE application_id = :1 ' ||
' AND param_list_code = :2 ;' ||
' DELETE from bne_param_lists_b ' ||
' WHERE application_id = :1 ' ||
' AND param_list_code = :2 ;' ||
' UPDATE bne_contents_b ' ||
' SET param_list_app_id = 800 ' ||
' , param_list_code = ''HR_STANDARD'' ' ||
' , object_version_number = object_version_number + 1 ' ||
' WHERE integrator_app_id = :1 ' ||
' AND integrator_code = :2; ' ||
' DELETE FROM bne_stored_sql ' ||
' WHERE content_code = :1 ' ||
' AND application_id = :2; ' ||