APPS.PAY_LOAD_PARAMETERS SQL Statements

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

Line: 49

         select qualifier
           from pay_parameter_qualifiers ppq
          where ppq.qualifier = p_qualifier_name;

Line: 70

              UPDATE PAY_PARAMETER_QUALIFIERS SET
                   description       = p_description
                 , LAST_UPDATED_BY   = decode(p_owner,'SEED',1,0)
                 , LAST_UPDATE_DATE  = SYSDATE
                 , LAST_UPDATE_LOGIN = fnd_global.login_id
              WHERE qualifier        = l_qualifier ;

Line: 79

             hr_utility.trace('Inserting new qualifier : '||p_qualifier);

Line: 81

              INSERT INTO PAY_PARAMETER_QUALIFIERS (
                           qualifier
                         , description
                         ,LAST_UPDATED_BY
                         ,LAST_UPDATE_DATE
                         ,LAST_UPDATE_LOGIN
                         ,CREATION_DATE
                         ,CREATED_BY  )
              VALUES    ( p_qualifier
                         , p_description
                         , decode(p_owner,'SEED',1,0)
                         , SYSDATE
                         , fnd_global.login_id
                         , SYSDATE
                         , decode(p_owner,'SEED',1,0) );

Line: 124

         select pp.parameter_id
           from pay_parameters pp,
	        pay_parameter_definitions ppd,
		per_business_groups pbg
          where ppd.parameter_name = p_parameter_name
	    AND ppd.parameter_def_id = pp.parameter_def_id
	    AND pp.business_group_id = pbg.business_group_id(+)
            and nvl(pbg.name,'CORE') = nvl(p_bg_name,'CORE')
            and nvl(pp.legislation_code,'CORE') = nvl(p_leg_code,'CORE') ;

Line: 135

	  select ppd.parameter_def_id
	    from pay_parameter_definitions ppd
           where ppd.parameter_name = p_parameter_name;

Line: 155

              select business_group_id
                into l_business_group_id
                from per_business_groups
               where name = p_bg_name;

Line: 163

              UPDATE PAY_PARAMETERS SET
                   qualifier   = p_qualifier
                 , override_allowed      = p_override_allowed
                 ,LAST_UPDATED_BY     = decode(p_owner,'SEED',1,0)
                 ,LAST_UPDATE_DATE    = SYSDATE
                 ,LAST_UPDATE_LOGIN   = fnd_global.login_id
              WHERE parameter_id   = l_parameter_id ;

Line: 177

            hr_utility.trace('Before inserting, l_param_def_id : '||l_parameter_def_id);

Line: 179

              INSERT INTO PAY_PARAMETERS (
                           parameter_id
                         , parameter_def_id
                         , qualifier
			 , override_allowed
                         , business_group_id
                         , legislation_code
                         ,LAST_UPDATED_BY
                         ,LAST_UPDATE_DATE
                         ,LAST_UPDATE_LOGIN
                         ,CREATION_DATE
                         ,CREATED_BY  )
              VALUES    (
                         PAY_PARAMETERS_S.nextval
			 , l_parameter_def_id
                         , p_qualifier
                         , p_override_allowed
			 , l_business_group_id
                         , p_leg_code
                         , decode(p_owner,'SEED',1,0)
                         , SYSDATE
                         , fnd_global.login_id
                         , SYSDATE
                         , decode(p_owner,'SEED',1,0) );

Line: 228

	 select ppd.parameter_def_id
           from pay_parameter_definitions ppd
          where ppd.parameter_name = p_parameter_name;

Line: 248

              UPDATE PAY_PARAMETER_DEFINITIONS SET
	          description         = p_description
                 ,LAST_UPDATED_BY     = decode(p_owner,'SEED',1,0)
                 ,LAST_UPDATE_DATE    = SYSDATE
                 ,LAST_UPDATE_LOGIN   = fnd_global.login_id
              WHERE parameter_def_id   = l_parameter_def_id ;

Line: 257

	      UPDATE PAY_PARAMETER_DEFINITIONS_TL	 SET
                   name = p_parameter_name
		 , source_language    =  userenv('LANG')
		 , description        = p_description
                 ,LAST_UPDATED_BY     = decode(p_owner,'SEED',1,0)
                 ,LAST_UPDATE_DATE    = SYSDATE
                 ,LAST_UPDATE_LOGIN   = fnd_global.login_id
              WHERE parameter_def_id   = l_parameter_def_id ;

Line: 267

        hr_utility.trace('Inserting into pay_parameter_definitions... :'|| p_parameter_name);

Line: 269

              INSERT INTO PAY_PARAMETER_DEFINITIONS (
                           parameter_def_id
                         ,parameter_name
            			 ,description
                         ,LAST_UPDATED_BY
                         ,LAST_UPDATE_DATE
                         ,LAST_UPDATE_LOGIN
                         ,CREATION_DATE
                         ,CREATED_BY  )
              VALUES    (
                         PAY_PARAMETER_DEFINITIONS_S.nextval
                         ,p_parameter_name
			             , p_description
                         , decode(p_owner,'SEED',1,0)
                         , SYSDATE
                         , fnd_global.login_id
                         , SYSDATE
                         , decode(p_owner,'SEED',1,0));

Line: 290

              INSERT INTO PAY_PARAMETER_DEFINITIONS_TL (
                           parameter_def_id
                         , NAME
			 , LANGUAGE
			 , source_language
                         , description
                         ,LAST_UPDATED_BY
                         ,LAST_UPDATE_DATE
                         ,LAST_UPDATE_LOGIN
                         ,CREATION_DATE
                         ,CREATED_BY  )
                    select ppd.parameter_def_id
		         , p_parameter_name
			 , L.LANGUAGE_CODE
			 , userenv('LANG')
                         , p_description
                         , decode(p_owner,'SEED',1,0)
                         , SYSDATE
                         , fnd_global.login_id
                         , SYSDATE
                         , decode(p_owner,'SEED',1,0)
		      from FND_LANGUAGES L,
		           PAY_PARAMETER_DEFINITIONS PPD
		     where L.INSTALLED_FLAG in ('I', 'B')
		       and ppd.parameter_name = p_parameter_name
		       and not exists
                            (select NULL
                               from PAY_PARAMETER_DEFINITIONS_TL T
                              where T.NAME = p_parameter_name
                                and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 349

  UPDATE PAY_PARAMETER_DEFINITIONS_TL
    SET name = nvl(p_trans_param_name,p_parameter_name),
        last_update_date = SYSDATE,
        last_updated_by = decode(p_owner,'SEED',1,0),
        last_update_login = 0,
        source_language = userenv('LANG')
  WHERE userenv('LANG') IN (language,source_language)
    AND parameter_def_id in
        (select ppdt.parameter_def_id
           from pay_parameter_definitions_tl ppdt,
	        pay_parameter_definitions ppd
          where ppd.parameter_def_id = ppdt.parameter_def_id
	    AND ppd.parameter_name = p_parameter_name);