APPS.PAY_UPGRADE_PARAMETERS_PKG SQL Statements

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

Line: 28

PROCEDURE Insert_Row (
	 P_UPG_DEF_SHORT_NAME      in            VARCHAR2
	,P_PARAMETER_NAME	   in		 VARCHAR2
	,P_PARAMETER_VALUE         in            VARCHAR2
	,P_last_update_date        in            DATE
	,P_LAST_UPDATED_BY         in            NUMBER
	,P_LAST_UPDATE_LOGIN       in            NUMBER
	,P_CREATED_BY              in            NUMBER
	,P_CREATION_DATE           in            DATE

) is
--
l_upgrade_definition_id PAY_UPGRADE_DEFINITIONS.UPGRADE_DEFINITION_ID%TYPE;

Line: 42

l_proc   varchar2(100) := g_package || 'Insert_Row';

Line: 45

	select  upgrade_definition_id
      from   pay_upgrade_definitions
	      where  upper(short_name) = upper(p_upg_def_short_name);

Line: 71

  insert into PAY_UPGRADE_PARAMETERS (
	UPGRADE_DEFINITION_ID,
	PARAMETER_NAME,
	PARAMETER_VALUE,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	CREATED_BY,
	CREATION_DATE
	) values (
	l_upgrade_definition_id,
	p_parameter_name,
	p_parameter_value,
	p_last_update_date,
	p_last_updated_by,
	p_last_update_login,
	p_created_by,
	p_creation_date);

Line: 92

END Insert_Row;

Line: 94

PROCEDURE Update_Row (
	  P_UPGRADE_DEFINITION_ID  in            NUMBER
        , P_PARAMETER_NAME         in            VARCHAR2
	, P_PARAMETER_VALUE        in            VARCHAR2
	, P_LAST_UPDATE_DATE       in            DATE
	, P_LAST_UPDATED_BY        in            NUMBER
	, P_LAST_UPDATE_LOGIN      in            NUMBER
) is
--
l_exists varchar2(1);

Line: 104

l_proc   varchar2(100) := g_package || 'Update_Row';

Line: 117

     update PAY_UPGRADE_PARAMETERS set
            parameter_value = p_parameter_value,
	    last_update_date= p_last_update_date,
	    last_updated_by = p_last_updated_by,
	    last_update_login = p_last_update_login
	 where upgrade_definition_id = p_upgrade_definition_id
	 and parameter_name = p_parameter_name;

Line: 131

END Update_Row;

Line: 146

l_last_updated_by    PAY_UPGRADE_PARAMETERS.LAST_UPDATED_BY%TYPE;

Line: 147

l_last_update_login  PAY_UPGRADE_PARAMETERS.LAST_UPDATE_LOGIN%TYPE;

Line: 148

l_last_update_date   PAY_UPGRADE_PARAMETERS.LAST_UPDATE_DATE%TYPE;

Line: 152

   select  upgrade_definition_id
      from   pay_upgrade_definitions
	      where  upper(short_name) = upper(p_short_name) ;

Line: 157

   select  null
	from   pay_upgrade_parameters
	      where  UPGRADE_DEFINITION_ID = p_def_id
	      and PARAMETER_NAME = P_PARAMETER_NAME;

Line: 185

  l_last_update_date  := l_sysdate;

Line: 186

  l_last_updated_by   := fnd_global.user_id;

Line: 187

  l_last_update_login := fnd_global.login_id;

Line: 206

     Update_Row (
	  P_UPGRADE_DEFINITION_ID  =>  l_upgrade_def_id
         ,P_PARAMETER_NAME         =>  p_parameter_name
         ,P_PARAMETER_VALUE        =>  p_parameter_value
	 ,P_LAST_UPDATE_DATE       =>  l_last_update_date
	 ,P_LAST_UPDATED_BY        =>  l_last_updated_by
	 ,P_LAST_UPDATE_LOGIN      =>  l_last_update_login
       );

Line: 220

     Insert_Row (
         P_UPG_DEF_SHORT_NAME      =>  p_short_name
       , P_PARAMETER_NAME	   =>  p_parameter_name
       , P_PARAMETER_VALUE         =>  p_parameter_value
       , P_LAST_UPDATE_DATE        =>  l_last_update_date
       , P_LAST_UPDATED_BY         =>  l_last_updated_by
       , P_LAST_UPDATE_LOGIN       =>  l_last_update_login
       , P_CREATED_BY              =>  l_created_by
       , P_CREATION_DATE           =>  l_creation_date
       );