APPS.WF_WS_GEN SQL Statements

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

Line: 167

	select class_id,class_type
	from fnd_irep_classes
	where class_type = c_module_name ;

Line: 227

	select  class_id
	from fnd_irep_classes
	where irep_name = c_irep_class_name;

Line: 289

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

Line: 294

        select class_name ,irep_name
        from fnd_irep_classes
        where class_id = c_class_id;

Line: 301

	select function_id
	from fnd_form_functions
	where irep_class_id = c_class_id ;

Line: 399

	select 	*
	from fnd_irep_classes_vl
	where class_id = c_base_class_id;

Line: 406

	select  *
	from fnd_form_functions_vl
	where function_id = c_base_function_id;

Line: 869

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

Line: 876

		select fnd_objects_s.nextval
		from dual;

Line: 903

			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,
			0,
			sysdate,
			0,
			sysdate,
			0,
			0,
			'WEBSERVICEDOC',
			p_product_code,
			p_implementation_name,
			'Y', -- 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: 985

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

Line: 991

		--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 = 'Y', -- 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: 1036

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

Line: 1097

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

Line: 1104

	select fnd_form_functions_s.nextval
	from dual;

Line: 1124

			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: 1226

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

Line: 1233

		--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: 1331

	select *
	from fnd_form_functions_tl
	where function_id = c_base_function_id;

Line: 1336

        select function_name
        from fnd_form_functions
        where function_id = c_function_id;

Line: 1401

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

Line: 1410

        select function_name
        from fnd_form_functions
        where function_id = c_function_id;

Line: 1433

		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: 1462

		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: 1507

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

Line: 1516

        select class_name
        from fnd_irep_classes
        where class_id = c_class_id;

Line: 1538

		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: 1569

		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: 1609

	select *
	from fnd_irep_classes_tl
	where class_id = c_base_class_id;

Line: 1616

        select class_name
        from fnd_irep_classes
        where class_id = c_class_id;

Line: 1769

	select *
	from fnd_lookup_assignments
	where obj_name = 'FND_IREP_CLASSES'
	and lookup_type = 'BUSINESS_ENTITY'
	and instance_pk1_value = c_base_class_id;

Line: 1782

	select *
	from fnd_lookup_assignments
	where obj_name = 'FND_IREP_CLASSES'
	and lookup_type = 'BUSINESS_ENTITY'
	and instance_pk1_value = c_derived_class_id
	and lookup_code = c_lookup_code
	for update ;

Line: 1793

	select fnd_lookup_assignments_s.nextval assign_id
	from dual;

Line: 1799

        select class_name
        from fnd_irep_classes
        where class_id = c_class_id;

Line: 1827

			insert into fnd_lookup_assignments
			(
			 LOOKUP_ASSIGNMENT_ID,
			 LOOKUP_TYPE,
			 LOOKUP_CODE,
			 OBJ_NAME,
			 INSTANCE_PK1_VALUE,
			 INSTANCE_PK2_VALUE,
			 INSTANCE_PK3_VALUE,
			 INSTANCE_PK4_VALUE,
			 INSTANCE_PK5_VALUE,
			 DISPLAY_SEQUENCE,
			 CREATED_BY,
			 CREATION_DATE,
			 LAST_UPDATED_BY,
			 LAST_UPDATE_DATE,
			LAST_UPDATE_LOGIN
			)
			values
			(
			c3_rec.assign_id,
			c1_rec.lookup_type,
			c1_rec.lookup_code,
			c1_rec.obj_name,
			p_derived_class_id,
			null,
			null,
			null,
			null,
			null,
			1,
			sysdate,
			1,
			sysdate,
			0
			);

Line: 1869

			update fnd_lookup_assignments
			set  LAST_UPDATED_BY = 1,
			     last_update_date = sysdate,
			     last_update_login = 0
			where current of c2;

Line: 1905

	select *
	from fnd_irep_function_flavors
	where function_id = c_function_id
	for update;

Line: 1911

        select function_name
        from fnd_form_functions
        where function_id = c_function_id;

Line: 1924

		insert into FND_IREP_FUNCTION_FLAVORS
		(
		FUNCTION_ID,OVERLOAD_SEQ,
		SCOPE_TYPE,LIFECYCLE_MODE,DESCRIPTION,COMPATIBILITY_FLAG
		)
		values
		(
		p_function_id,1,
		'PUBLIC','ACTIVE',p_description,'S'
		);

Line: 1938

		update fnd_irep_function_FLAVORS
		set description = p_description,
		scope_type = p_scope_type
		where current of c1;

Line: 1980

        select map_id
        into i_map_id
        from ecx_mappings
        where map_code = p_map_code;

Line: 1986

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