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_UPGRADE_LEGISLATIONS_PKG dependencies on PAY_UPGRADE_LEGISLATIONS

Line 1: PACKAGE BODY PAY_UPGRADE_LEGISLATIONS_PKG AS

1: PACKAGE BODY PAY_UPGRADE_LEGISLATIONS_PKG AS
2: /* $Header: pypul01t.pkb 115.0 2003/11/21 03:07 tvankayl noship $ */
3:
4: g_package varchar2(33) := ' pay_upgrade_legislations_pkg.';
5:

Line 4: g_package varchar2(33) := ' pay_upgrade_legislations_pkg.';

1: PACKAGE BODY PAY_UPGRADE_LEGISLATIONS_PKG AS
2: /* $Header: pypul01t.pkb 115.0 2003/11/21 03:07 tvankayl noship $ */
3:
4: g_package varchar2(33) := ' pay_upgrade_legislations_pkg.';
5:
6: PROCEDURE chk_unique ( p_upgrade_definition_id in number
7: , p_legislation_code in varchar2
8: ) is

Line 11: select null from pay_upgrade_legislations

7: , p_legislation_code in varchar2
8: ) is
9: --
10: cursor csr_unique is
11: select null from pay_upgrade_legislations
12: where upgrade_definition_id = p_upgrade_definition_id
13: and legislation_code = p_legislation_code ;
14: --
15: l_proc varchar2(72) := g_package||'chk_unique';

Line 174: select null from PAY_UPGRADE_LEGISLATIONS

170: l_exists varchar2(1);
171: l_proc varchar2(100) := g_package || 'Insert_Row';
172:
173: cursor csr_exists is
174: select null from PAY_UPGRADE_LEGISLATIONS
175: where upgrade_definition_id = p_upgrade_definition_id
176: and legislation_code = p_legislation_code;
177: --
178: BEGIN

Line 204: insert into PAY_UPGRADE_LEGISLATIONS (

200:
201: chk_unique( p_upgrade_definition_id, p_legislation_code );
202:
203:
204: insert into PAY_UPGRADE_LEGISLATIONS (
205: UPGRADE_DEFINITION_ID,
206: LEGISLATION_CODE,
207: CREATION_DATE,
208: CREATED_BY,

Line 242: from PAY_UPGRADE_LEGISLATIONS

238: ) is
239: --
240: cursor csr_lck is
241: select null
242: from PAY_UPGRADE_LEGISLATIONS
243: where UPGRADE_DEFINITION_ID = P_UPGRADE_DEFINITION_ID
244: and LEGISLATION_CODE = P_LEGISLATION_CODE
245: for update of UPGRADE_DEFINITION_ID nowait;
246: --

Line 289: delete from PAY_UPGRADE_LEGISLATIONS

285: chk_mandatory_arg( p_legislation_code, 'LEGISLATION_CODE' );
286:
287: chk_delete ( p_upgrade_definition_id , p_legislation_code );
288:
289: delete from PAY_UPGRADE_LEGISLATIONS
290: where UPGRADE_DEFINITION_ID = P_UPGRADE_DEFINITION_ID
291: and LEGISLATION_CODE = P_LEGISLATION_CODE ;
292:
293: if (sql%notfound) then

Line 308: l_upgrade_definition_id PAY_UPGRADE_LEGISLATIONS.UPGRADE_DEFINITION_ID%TYPE;

304: , P_OWNER in VARCHAR2
305: ) is
306: --
307: l_proc varchar2(100) := g_package || 'Load_Row';
308: l_upgrade_definition_id PAY_UPGRADE_LEGISLATIONS.UPGRADE_DEFINITION_ID%TYPE;
309:
310: l_sysdate date := sysdate;
311: l_created_by PAY_UPGRADE_LEGISLATIONS.CREATED_BY%TYPE;
312: l_creation_date PAY_UPGRADE_LEGISLATIONS.CREATION_DATE%TYPE;

Line 311: l_created_by PAY_UPGRADE_LEGISLATIONS.CREATED_BY%TYPE;

307: l_proc varchar2(100) := g_package || 'Load_Row';
308: l_upgrade_definition_id PAY_UPGRADE_LEGISLATIONS.UPGRADE_DEFINITION_ID%TYPE;
309:
310: l_sysdate date := sysdate;
311: l_created_by PAY_UPGRADE_LEGISLATIONS.CREATED_BY%TYPE;
312: l_creation_date PAY_UPGRADE_LEGISLATIONS.CREATION_DATE%TYPE;
313: l_last_updated_by PAY_UPGRADE_LEGISLATIONS.LAST_UPDATED_BY%TYPE;
314: l_last_update_login PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_LOGIN%TYPE;
315: l_last_update_date PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_DATE%TYPE;

Line 312: l_creation_date PAY_UPGRADE_LEGISLATIONS.CREATION_DATE%TYPE;

308: l_upgrade_definition_id PAY_UPGRADE_LEGISLATIONS.UPGRADE_DEFINITION_ID%TYPE;
309:
310: l_sysdate date := sysdate;
311: l_created_by PAY_UPGRADE_LEGISLATIONS.CREATED_BY%TYPE;
312: l_creation_date PAY_UPGRADE_LEGISLATIONS.CREATION_DATE%TYPE;
313: l_last_updated_by PAY_UPGRADE_LEGISLATIONS.LAST_UPDATED_BY%TYPE;
314: l_last_update_login PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_LOGIN%TYPE;
315: l_last_update_date PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_DATE%TYPE;
316:

Line 313: l_last_updated_by PAY_UPGRADE_LEGISLATIONS.LAST_UPDATED_BY%TYPE;

309:
310: l_sysdate date := sysdate;
311: l_created_by PAY_UPGRADE_LEGISLATIONS.CREATED_BY%TYPE;
312: l_creation_date PAY_UPGRADE_LEGISLATIONS.CREATION_DATE%TYPE;
313: l_last_updated_by PAY_UPGRADE_LEGISLATIONS.LAST_UPDATED_BY%TYPE;
314: l_last_update_login PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_LOGIN%TYPE;
315: l_last_update_date PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_DATE%TYPE;
316:
317: cursor csr_existing is

Line 314: l_last_update_login PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_LOGIN%TYPE;

310: l_sysdate date := sysdate;
311: l_created_by PAY_UPGRADE_LEGISLATIONS.CREATED_BY%TYPE;
312: l_creation_date PAY_UPGRADE_LEGISLATIONS.CREATION_DATE%TYPE;
313: l_last_updated_by PAY_UPGRADE_LEGISLATIONS.LAST_UPDATED_BY%TYPE;
314: l_last_update_login PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_LOGIN%TYPE;
315: l_last_update_date PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_DATE%TYPE;
316:
317: cursor csr_existing is
318: select pul.upgrade_definition_id

Line 315: l_last_update_date PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_DATE%TYPE;

311: l_created_by PAY_UPGRADE_LEGISLATIONS.CREATED_BY%TYPE;
312: l_creation_date PAY_UPGRADE_LEGISLATIONS.CREATION_DATE%TYPE;
313: l_last_updated_by PAY_UPGRADE_LEGISLATIONS.LAST_UPDATED_BY%TYPE;
314: l_last_update_login PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_LOGIN%TYPE;
315: l_last_update_date PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_DATE%TYPE;
316:
317: cursor csr_existing is
318: select pul.upgrade_definition_id
319: from pay_upgrade_definitions pud, pay_upgrade_legislations pul

Line 319: from pay_upgrade_definitions pud, pay_upgrade_legislations pul

315: l_last_update_date PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_DATE%TYPE;
316:
317: cursor csr_existing is
318: select pul.upgrade_definition_id
319: from pay_upgrade_definitions pud, pay_upgrade_legislations pul
320: where upper(pud.short_name) = upper(p_short_name)
321: and pud.upgrade_definition_id = pul.upgrade_definition_id
322: and pul.legislation_code = p_legislation_code;
323:

Line 396: END PAY_UPGRADE_LEGISLATIONS_PKG;

392: hr_utility.set_location('Leaving:'|| l_proc, 20);
393: --
394: END Load_Row;
395:
396: END PAY_UPGRADE_LEGISLATIONS_PKG;
397: