eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_LOAD_PARAMETERS dependencies on PAY_PARAMETER_DEFINITIONS

Line 126: pay_parameter_definitions ppd,

122:
123: cursor pp_exits(p_parameter_name varchar2) is
124: select pp.parameter_id
125: from pay_parameters pp,
126: pay_parameter_definitions ppd,
127: per_business_groups pbg
128: where ppd.parameter_name = p_parameter_name
129: AND ppd.parameter_def_id = pp.parameter_def_id
130: AND pp.business_group_id = pbg.business_group_id(+)

Line 136: from pay_parameter_definitions ppd

132: and nvl(pp.legislation_code,'CORE') = nvl(p_leg_code,'CORE') ;
133:
134: cursor get_param_def_id( p_parameter_name in varchar2) is
135: select ppd.parameter_def_id
136: from pay_parameter_definitions ppd
137: where ppd.parameter_name = p_parameter_name;
138: --
139: found boolean;
140: l_parameter_id number;

Line 218: -- Procedure used to upload seed data for the table PAY_PARAMETER_DEFINITIONS

214: -- |-----------------------< load_parameter_definitions >----------------------|
215: -- ----------------------------------------------------------------------------
216: --
217: -- Description:
218: -- Procedure used to upload seed data for the table PAY_PARAMETER_DEFINITIONS
219: --
220: -- ----------------------------------------------------------------------------
221: procedure load_parameter_definitions
222: ( p_parameter_name in varchar2

Line 229: from pay_parameter_definitions ppd

225: ) AS
226:
227: cursor ppd_exists( p_parameter_name varchar2 ) is
228: select ppd.parameter_def_id
229: from pay_parameter_definitions ppd
230: where ppd.parameter_name = p_parameter_name;
231: --
232: found boolean;
233: l_parameter_def_id number;

Line 248: UPDATE PAY_PARAMETER_DEFINITIONS SET

244: hr_utility.trace('After getrec, l_parameter_def_id: '||l_parameter_def_id);
245: --
246: if(found = TRUE) then
247:
248: UPDATE PAY_PARAMETER_DEFINITIONS SET
249: description = p_description
250: ,LAST_UPDATED_BY = decode(p_owner,'SEED',1,0)
251: ,LAST_UPDATE_DATE = SYSDATE
252: ,LAST_UPDATE_LOGIN = fnd_global.login_id

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 267: hr_utility.trace('Inserting into pay_parameter_definitions... :'|| p_parameter_name);

263: ,LAST_UPDATE_LOGIN = fnd_global.login_id
264: WHERE parameter_def_id = l_parameter_def_id ;
265:
266: else
267: hr_utility.trace('Inserting into pay_parameter_definitions... :'|| p_parameter_name);
268:
269: INSERT INTO PAY_PARAMETER_DEFINITIONS (
270: parameter_def_id
271: ,parameter_name

Line 269: INSERT INTO PAY_PARAMETER_DEFINITIONS (

265:
266: else
267: hr_utility.trace('Inserting into pay_parameter_definitions... :'|| p_parameter_name);
268:
269: INSERT INTO PAY_PARAMETER_DEFINITIONS (
270: parameter_def_id
271: ,parameter_name
272: ,description
273: ,LAST_UPDATED_BY

Line 279: PAY_PARAMETER_DEFINITIONS_S.nextval

275: ,LAST_UPDATE_LOGIN
276: ,CREATION_DATE
277: ,CREATED_BY )
278: VALUES (
279: PAY_PARAMETER_DEFINITIONS_S.nextval
280: ,p_parameter_name
281: , p_description
282: , decode(p_owner,'SEED',1,0)
283: , SYSDATE

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 312: PAY_PARAMETER_DEFINITIONS PPD

308: , fnd_global.login_id
309: , SYSDATE
310: , decode(p_owner,'SEED',1,0)
311: from FND_LANGUAGES L,
312: PAY_PARAMETER_DEFINITIONS PPD
313: where L.INSTALLED_FLAG in ('I', 'B')
314: and ppd.parameter_name = p_parameter_name
315: and not exists
316: (select NULL

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

Line 359: pay_parameter_definitions ppd

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
363: null;