APPS.PER_RI_MNG_CFG_PKG SQL Statements

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

Line: 4

PROCEDURE delete_configuration
(
	p_config_code 	 In Varchar2	,
	p_ovn		 In  Number	,
	p_msg 		 Out nocopy Varchar2
)


Is
cursor csr_config_info is
select CONFIG_INFORMATION_ID  , OBJECT_VERSION_NUMBER
from per_ri_config_information
where CONFIGURATION_CODE = p_config_code;

Line: 19

select location_id , OBJECT_VERSION_NUMBER
from per_ri_config_locations
where CONFIGURATION_CODE = p_config_code;

Line: 27

per_ri_config_information_api.DELETE_CONFIG_INFORMATION
(
P_VALIDATE                     => false,
P_CONFIG_INFORMATION_ID        => rec.CONFIG_INFORMATION_ID ,
P_OBJECT_VERSION_NUMBER        => rec.OBJECT_VERSION_NUMBER
);

Line: 39

per_ri_config_location_api.DELETE_LOCATION
(
P_VALIDATE                     => false,
P_LOCATION_ID          	       => rec.location_id ,
P_OBJECT_VERSION_NUMBER        => rec.OBJECT_VERSION_NUMBER
);

Line: 48

per_ri_configuration_api.DELETE_CONFIGURATION
(
 P_VALIDATE                     => false,
 P_CONFIGURATION_CODE           => p_config_code,
 P_OBJECT_VERSION_NUMBER        => p_ovn
);

Line: 60

End delete_configuration;

Line: 86

 select loc2.location_id
 from per_ri_config_locations loc1,per_ri_config_locations loc2
 where loc2.CONFIGURATION_CODE = p_configuration_code
 and  loc1.location_id = p_location_id
 and  loc2.location_code = loc1.location_code
 and loc1.location_id <> loc2.location_id;

Line: 96

select
 CONFIGURATION_CODE             ,
 CONFIGURATION_TYPE             ,
 CONFIGURATION_STATUS           ,
 CONFIGURATION_NAME             ,
 CONFIGURATION_DESCRIPTION      ,
 OBJECT_VERSION_NUMBER          ,
 LAST_UPDATE_DATE               ,
 LAST_UPDATED_BY                ,
 LAST_UPDATE_LOGIN              ,
 CREATED_BY                     ,
 CREATION_DATE
 from per_ri_configurations_vl
 where CONFIGURATION_CODE = p_config_code;

Line: 115

select CONFIG_INFORMATION_ID  ,
 CONFIG_SEQUENCE                ,
 CONFIG_INFORMATION_CATEGORY    ,
 CONFIG_INFORMATION1            ,
 CONFIG_INFORMATION2            ,
 CONFIG_INFORMATION3            ,
 CONFIG_INFORMATION4            ,
 CONFIG_INFORMATION5            ,
 CONFIG_INFORMATION6            ,
 CONFIG_INFORMATION7            ,
 CONFIG_INFORMATION8            ,
 CONFIG_INFORMATION9            ,
 CONFIG_INFORMATION10           ,
 CONFIG_INFORMATION11           ,
 CONFIG_INFORMATION12           ,
 CONFIG_INFORMATION13           ,
 CONFIG_INFORMATION14           ,
 CONFIG_INFORMATION15           ,
 CONFIG_INFORMATION16           ,
 CONFIG_INFORMATION17           ,
 CONFIG_INFORMATION18           ,
 CONFIG_INFORMATION19           ,
 CONFIG_INFORMATION20           ,
 CONFIG_INFORMATION21           ,
 CONFIG_INFORMATION22           ,
 CONFIG_INFORMATION23           ,
 CONFIG_INFORMATION24           ,
 CONFIG_INFORMATION25           ,
 CONFIG_INFORMATION26           ,
 CONFIG_INFORMATION27           ,
 CONFIG_INFORMATION28           ,
 CONFIG_INFORMATION29           ,
 CONFIG_INFORMATION30           ,
 LAST_UPDATE_DATE               ,
 LAST_UPDATED_BY                ,
 LAST_UPDATE_LOGIN              ,
 CREATED_BY                     ,
 CREATION_DATE
from per_ri_config_information
where CONFIGURATION_CODE = p_config_code;

Line: 158

select
 CONFIGURATION_CONTEXT          ,
 LOCATION_CODE                  ,
 DESCRIPTION                    ,
 STYLE                          ,
 ADDRESS_LINE_1                 ,
 ADDRESS_LINE_2                 ,
 ADDRESS_LINE_3                 ,
 TOWN_OR_CITY                   ,
 COUNTRY                        ,
 POSTAL_CODE                    ,
 REGION_1                       ,
 REGION_2                       ,
 REGION_3                       ,
 TELEPHONE_NUMBER_1             ,
 TELEPHONE_NUMBER_2             ,
 TELEPHONE_NUMBER_3             ,
 LOC_INFORMATION13              ,
 LOC_INFORMATION14              ,
 LOC_INFORMATION15              ,
 LOC_INFORMATION16              ,
 LOC_INFORMATION17              ,
 LOC_INFORMATION18              ,
 LOC_INFORMATION19              ,
 LOC_INFORMATION20              ,
 LAST_UPDATE_DATE               ,
 LAST_UPDATED_BY                ,
 LAST_UPDATE_LOGIN              ,
 CREATED_BY                     ,
 CREATION_DATE
 from per_ri_config_locations
where CONFIGURATION_CODE = p_config_code;

Line: 194

select 1
from per_ri_configurations_vl
where configuration_code = p_config_name;