APPS.PAY_LOAD_PARAMETERS dependencies on PAY_PARAMETER_DEFINITIONS_TL

Line 257: UPDATE PAY_PARAMETER_DEFINITIONS_TL SET

253: WHERE parameter_def_id = l_parameter_def_id ;
254:
255: ----
256:
257: UPDATE PAY_PARAMETER_DEFINITIONS_TL SET
258: name = p_parameter_name
259: , source_language = userenv('LANG')
260: , description = p_description
261: ,LAST_UPDATED_BY = decode(p_owner,'SEED',1,0)

Line 290: INSERT INTO PAY_PARAMETER_DEFINITIONS_TL (

286: , decode(p_owner,'SEED',1,0));
287:
288: ---
289:
290: INSERT INTO PAY_PARAMETER_DEFINITIONS_TL (
291: parameter_def_id
292: , NAME
293: , LANGUAGE
294: , source_language

Line 317: from PAY_PARAMETER_DEFINITIONS_TL T

313: where L.INSTALLED_FLAG in ('I', 'B')
314: and ppd.parameter_name = p_parameter_name
315: and not exists
316: (select NULL
317: from PAY_PARAMETER_DEFINITIONS_TL T
318: where T.NAME = p_parameter_name
319: and T.LANGUAGE = L.LANGUAGE_CODE);
320:
321: end if;

Line 337: -- PAY_PARAMETER_DEFINITIONS_TL

333: -- ----------------------------------------------------------------------------
334: --
335: -- Description:
336: -- Procedure used to translate the seeded parameter definitions for the table
337: -- PAY_PARAMETER_DEFINITIONS_TL
338: --
339: -- ----------------------------------------------------------------------------
340: procedure TRANSLATE_ROW
341: ( p_parameter_name in VARCHAR2

Line 349: UPDATE PAY_PARAMETER_DEFINITIONS_TL

345: ,p_description in varchar2
346: ,p_owner IN varchar2
347: ) is
348: begin
349: UPDATE PAY_PARAMETER_DEFINITIONS_TL
350: SET name = nvl(p_trans_param_name,p_parameter_name),
351: last_update_date = SYSDATE,
352: last_updated_by = decode(p_owner,'SEED',1,0),
353: last_update_login = 0,

Line 358: from pay_parameter_definitions_tl ppdt,

354: source_language = userenv('LANG')
355: WHERE userenv('LANG') IN (language,source_language)
356: AND parameter_def_id in
357: (select ppdt.parameter_def_id
358: from pay_parameter_definitions_tl ppdt,
359: pay_parameter_definitions ppd
360: where ppd.parameter_def_id = ppdt.parameter_def_id
361: AND ppd.parameter_name = p_parameter_name);
362: if (sql%notfound) then