APPS.SOA_GENERATE SQL Statements

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

Line: 157

 	select count(*) l_count
 	from fnd_irep_classes
 	where class_id = c_class_id;

Line: 162

        select class_name ,irep_name
        from fnd_irep_classes
        where class_id = c_class_id;

Line: 169

	select function_id
	from fnd_form_functions
	where irep_class_id = c_class_id ;

Line: 269

	select 	*
	from fnd_irep_classes_vl
	where class_id = c_base_class_id;

Line: 276

	select  *
	from fnd_form_functions_vl
	where function_id = c_base_function_id;

Line: 744

	select *
	from fnd_irep_classes
	where  class_name = c_class_name
	and class_type = c_entry_type
	for update ;

Line: 751

		select fnd_objects_s.nextval
		from dual;

Line: 778

			insert into fnd_irep_classes
			(
			CLASS_ID,
			CLASS_NAME,
			IREP_NAME,
			CREATED_BY,
			CREATION_DATE,
			LAST_UPDATED_BY,
			LAST_UPDATE_DATE,
			LAST_UPDATE_LOGIN,
			SECURITY_GROUP_ID,
			CLASS_TYPE,
			PRODUCT_CODE,
			IMPLEMENTATION_NAME,
			DEPLOYED_FLAG,
			GENERATED_FLAG,
			COMPATIBILITY_FLAG,
			ASSOC_CLASS_ID,
			SCOPE_TYPE,
			LIFECYCLE_MODE,
			SOURCE_FILE_PRODUCT,
			SOURCE_FILE_PATH,
			SOURCE_FILE_NAME,
			SOURCE_FILE_VERSION,
			DESCRIPTION,
			XML_DESCRIPTION,
			STANDARD_TYPE,
			STANDARD_VERSION,
			STANDARD_SPEC,
			LOAD_ERR,
			LOAD_ERR_MSGS,
			OPEN_INTERFACE_FLAG,
                        MAP_CODE
			)
			values
			(
			l_class_id,
			p_class_name,
			p_irep_name,
			1,
			sysdate,
			1,
			sysdate,
			0,
			0,
			p_entry_type,
			p_product_code,
			p_implementation_name,
			'N', -- p_deployed_flag,
			p_generated_flag,
			p_compatibility_flag,
			p_assoc_class_id,
			p_scope_type,
			p_lifecycle_mode,
			p_source_file_product,
			p_source_file_path,
			p_source_file_name,
			p_source_file_version,
			p_description,
			p_xml_description,
			p_standard_type,
			p_standard_version,
			p_standard_spec,
			p_load_err,
			p_load_err_msgs,
			p_open_interface_flag,
                        p_map_code
			);

Line: 860

			p_err_message := wf_core.translate('WF_WS_CLASS_INSERT')||SQLERRM;

Line: 866

		--Update the existing record

		begin
			update fnd_irep_classes
			set	irep_name = p_irep_name,
				last_updated_by = 0,
				last_update_date = sysdate,
				last_update_login = 0,
				security_group_id = p_security_group_id,
				class_type = p_class_type,
				product_code = p_product_code,
				implementation_name = p_implementation_name,
				deployed_flag = 'N', -- p_deployed_flag,
				generated_flag = p_generated_flag,
				compatibility_flag = p_compatibility_flag,
				assoc_class_id = p_assoc_class_id,
				scope_type = p_scope_type,
				lifecycle_mode = p_lifecycle_mode,
				source_file_product = p_source_file_product,
				source_file_path = p_source_file_path,
				source_file_name = p_source_file_name,
				source_file_version = p_source_file_version,
				description = p_description,
				xml_description = p_xml_description,
				standard_type = p_standard_type,
				standard_version = p_standard_version,
				standard_spec = p_standard_spec,
				load_err = p_load_err,
				load_err_msgs = p_load_err_msgs,
				open_interface_flag = p_open_interface_flag

			where current of c_derived_class;

Line: 911

			p_err_message := wf_core.translate('WF_WS_CLASS_UPDATE')||SQLERRM;

Line: 972

	select *
	from fnd_form_functions
	where  function_name = c_function_name
	and type = 'INTERFACE'
	for update;

Line: 979

	select fnd_form_functions_s.nextval
	from dual;

Line: 999

			insert into FND_FORM_FUNCTIONS
			(
			 FUNCTION_ID,
			 FUNCTION_NAME,
			 APPLICATION_ID,
			 FORM_ID,
			 PARAMETERS,
			 CREATION_DATE,
			 CREATED_BY,
			 LAST_UPDATE_DATE,
			 LAST_UPDATED_BY,
			 LAST_UPDATE_LOGIN,
			 TYPE,
			 WEB_HOST_NAME,
			 WEB_AGENT_NAME,
			 WEB_HTML_CALL,
			 WEB_ENCRYPT_PARAMETERS,
			 WEB_SECURED,
			 WEB_ICON,
			 OBJECT_ID,
			 REGION_APPLICATION_ID,
			 REGION_CODE,
			 MAINTENANCE_MODE_SUPPORT,
			 CONTEXT_DEPENDENCE,
			 JRAD_REF_PATH,
			 IREP_METHOD_NAME,
			 IREP_DESCRIPTION,
			 IREP_OVERLOAD_SEQUENCE,
			 IREP_SCOPE,
			 IREP_LIFECYCLE,
			 IREP_COMPATIBILITY,
			 IREP_INBOUND_XML_DESCRIPTION,
			 IREP_OUTBOUND_XML_DESCRIPTION,
			 IREP_SYNCHRO,
			 IREP_DIRECTION,
			 IREP_CLASS_ID,
			 IREP_ASSOC_FUNCTION_NAME
			)
			values
			(
			l_function_id,
			p_function_name,
			p_application_id,
			null,
			null,
			sysdate,
			0,
			sysdate,
			0,
			0,
			'INTERFACE',
			null,
			null,
			null,
			null,
			null,
			null,
			p_object_id,
			null,
			null,
			'NONE',
			'NONE',
			null,
			p_irep_method_name,
			p_irep_description,
			p_irep_overload_sequence,
			p_irep_scope,
			p_irep_lifecycle,
			p_irep_compatibility,
			p_irep_inbound_xml_desc,
			p_irep_outbound_xml_desc,
			p_irep_synchro,
			p_irep_direction,
			p_irep_class_id,
			p_irep_assoc_function_name
			);

Line: 1101

			p_err_message := 'Error in inserting to fnd_form_functions'||SQLERRM;

Line: 1108

		--Update the existing entry
		begin
			update fnd_form_functions
			set
				APPLICATION_ID = p_application_id,
				FORM_ID = p_form_id,
				PARAMETERS = p_parameters,
				CREATION_DATE = p_creation_date,
				CREATED_BY = p_created_by,
				LAST_UPDATE_DATE = sysdate,
				LAST_UPDATED_BY = 0,
				LAST_UPDATE_LOGIN = 0,
				TYPE = p_type,
				WEB_HOST_NAME = p_web_host_name,
				WEB_AGENT_NAME = p_web_agent_name,
				WEB_HTML_CALL = p_web_html_call,
				WEB_ENCRYPT_PARAMETERS = p_web_encrypt_parameters,
				WEB_SECURED = p_web_secured,
				WEB_ICON = p_web_icon,
				OBJECT_ID = p_object_id,
				REGION_APPLICATION_ID = p_region_application_id,
				REGION_CODE = p_region_code,
				MAINTENANCE_MODE_SUPPORT = p_maintenance_mode_support,
				CONTEXT_DEPENDENCE = p_context_dependence,
				JRAD_REF_PATH = p_jrad_ref_path,
				IREP_METHOD_NAME = p_irep_method_name,
				IREP_DESCRIPTION = p_irep_description,
				IREP_OVERLOAD_SEQUENCE = p_irep_overload_sequence,
				IREP_SCOPE = p_irep_scope,
				IREP_LIFECYCLE = p_irep_lifecycle,
				IREP_COMPATIBILITY = p_irep_compatibility,
				IREP_INBOUND_XML_DESCRIPTION = p_irep_inbound_xml_desc,
				IREP_OUTBOUND_XML_DESCRIPTION = p_irep_outbound_xml_desc,
				IREP_SYNCHRO = p_irep_synchro,
				IREP_DIRECTION = p_irep_direction,
				IREP_CLASS_ID =p_irep_class_id,
				IREP_ASSOC_FUNCTION_NAME = p_irep_assoc_function_name
			where current of c_derived_method;

Line: 1205

	select *
	from fnd_form_functions_tl
	where function_id = c_base_function_id;

Line: 1210

        select function_name
        from fnd_form_functions
        where function_id = c_function_id;

Line: 1275

	select *
	from fnd_form_functions_tl
	where  function_id = c_function_id
	and language = c_language
	for update ;

Line: 1284

        select function_name
        from fnd_form_functions
        where function_id = c_function_id;

Line: 1307

		insert into FND_FORM_FUNCTIONS_TL
		(
		LANGUAGE,
		FUNCTION_ID,
		USER_FUNCTION_NAME,
		CREATION_DATE,
		CREATED_BY,
		LAST_UPDATE_DATE,
		LAST_UPDATED_BY,
		LAST_UPDATE_LOGIN,
		DESCRIPTION,
		SOURCE_LANG
		)
		values
		(
		p_language,
		p_function_id,
		p_user_function_name,
		sysdate,
		0,
		sysdate,
		0,
		0,
		p_description,
		p_source_lang
		);

Line: 1336

		update fnd_form_functions_tl
		set 	user_function_name = p_user_function_name,
			description = p_description,
			source_lang = p_source_lang,
			last_update_date = sysdate,
			last_updated_by = 0,
			last_update_login = 0
		where current of c_function_language;

Line: 1381

	select *
	from fnd_irep_classes_tl
	where  class_id = c_class_id
	and language = c_language
	for update ;

Line: 1390

        select class_name
        from fnd_irep_classes
        where class_id = c_class_id;

Line: 1412

		insert into fnd_irep_classes_TL
		(
		CLASS_ID,
		LANGUAGE,
		SOURCE_LANG,
		DISPLAY_NAME,
		SHORT_DESCRIPTION,
		CREATED_BY,
		CREATION_DATE,
		LAST_UPDATED_BY,
		LAST_UPDATE_DATE,
		LAST_UPDATE_LOGIN,
		SECURITY_GROUP_ID
		)
		values
		(
		p_class_id,
		p_language,
		p_source_lang,
		p_display_name,
		p_short_description,
		0,
		sysdate,
		0,
		sysdate,
		0,
		0
		);

Line: 1443

		update fnd_irep_classes_tl
		set 	display_name = p_display_name,
			short_description = p_short_description,
			source_lang = p_source_lang,
			last_update_date = sysdate,
			last_updated_by = 0,
			last_update_login = 0,
			security_group_id = p_security_group_id
		where current of c_class_language;

Line: 1483

	select *
	from fnd_irep_classes_tl
	where class_id = c_base_class_id;

Line: 1490

        select class_name
        from fnd_irep_classes
        where class_id = c_class_id;

Line: 1645

        select map_id
        into i_map_id
        from ecx_mappings
        where map_code = p_map_code;

Line: 1651

        select root_element
        into p_root_element
        from  ecx_objects
        where map_id = i_map_id and
              (object_type = 'XML' or
               object_type = 'DTD');

Line: 1680

 	select count(*) l_count
 	from fnd_objects
 	where object_id = c_object_id;

Line: 1686

        select obj_name ,irep_name
        from fnd_objects
        where object_id = c_object_id;

Line: 1693

	select function_id
	from fnd_form_functions
	where irep_class_id = c_object_id ;

Line: 1798

	select 	*
	from fnd_objects_vl
	where object_id = c_base_object_id;

Line: 1805

	select  *
	from fnd_form_functions
	where function_id = c_base_function_id;

Line: 2041

	select 	*
	from fnd_objects
	where object_id = c_base_object_id;

Line: 2049

	select fnd_form_functions_s.nextval
	from dual;

Line: 2111

				insert into FND_FORM_FUNCTIONS
				(
				 FUNCTION_ID,
				 FUNCTION_NAME,
				 APPLICATION_ID,
				 FORM_ID,
				 PARAMETERS,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN,
				 TYPE,
				 WEB_HOST_NAME,
				 WEB_AGENT_NAME,
				 WEB_HTML_CALL,
				 WEB_ENCRYPT_PARAMETERS,
				 WEB_SECURED,
				 WEB_ICON,
				 OBJECT_ID,
				 REGION_APPLICATION_ID,
				 REGION_CODE,
				 MAINTENANCE_MODE_SUPPORT,
				 CONTEXT_DEPENDENCE,
				 JRAD_REF_PATH,
				 IREP_METHOD_NAME,
				 IREP_DESCRIPTION,
				 IREP_OVERLOAD_SEQUENCE,
				 IREP_SCOPE,
				 IREP_LIFECYCLE,
				 IREP_COMPATIBILITY,
				 IREP_INBOUND_XML_DESCRIPTION,
				 IREP_OUTBOUND_XML_DESCRIPTION,
				 IREP_SYNCHRO,
				 IREP_DIRECTION,
				 IREP_CLASS_ID,
				 IREP_ASSOC_FUNCTION_NAME
				)
				values
				(
				l_function_id,
				c_base_object_entry_rec.obj_name || ':' || p_function_name,
				null,
				null,
				null,
				sysdate,
				0,
				sysdate,
				0,
				0,
				'INTERFACE',
				null,
				null,
				null,
				null,
				null,
				null,
				null,
				null,
				null,
				'NONE',
				'NONE',
				null,
				p_function_name,
				p_function_name || ' Operation',
				1,
				c_base_object_entry_rec.irep_scope,
				c_base_object_entry_rec.irep_lifecycle,
				c_base_object_entry_rec.irep_compatibility,
				null,
				null,
				null,
				null,
				p_base_object_id,
				null
				);