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_DEFINITIONS_PKG dependencies on PAY_UPGRADE_DEFINITIONS

Line 1: PACKAGE BODY PAY_UPGRADE_DEFINITIONS_PKG AS

1: PACKAGE BODY PAY_UPGRADE_DEFINITIONS_PKG AS
2: /* $Header: pypud01t.pkb 120.1.12020000.2 2012/07/05 02:31:11 amnaraya ship $ */
3:
4: g_package varchar2(33) := ' pay_upgrade_definitions_pkg.';
5:

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

1: PACKAGE BODY PAY_UPGRADE_DEFINITIONS_PKG AS
2: /* $Header: pypud01t.pkb 120.1.12020000.2 2012/07/05 02:31:11 amnaraya ship $ */
3:
4: g_package varchar2(33) := ' pay_upgrade_definitions_pkg.';
5:
6: PROCEDURE chk_short_name ( p_short_name in varchar2 ) is
7: --
8: cursor csr_unique_name is

Line 9: select null from pay_upgrade_definitions

5:
6: PROCEDURE chk_short_name ( p_short_name in varchar2 ) is
7: --
8: cursor csr_unique_name is
9: select null from pay_upgrade_definitions
10: where upper(short_name) = upper(p_short_name);
11: --
12: l_proc varchar2(72) := g_package||'chk_short_name';
13: l_exists varchar2(1);

Line 168: l_upgrade_definition_id PAY_UPGRADE_DEFINITIONS.UPGRADE_DEFINITION_ID%TYPE;

164: ,P_CREATION_DATE in DATE
165: ,P_UPGRADE_DEFINITION_ID out nocopy NUMBER
166: ) is
167: --
168: l_upgrade_definition_id PAY_UPGRADE_DEFINITIONS.UPGRADE_DEFINITION_ID%TYPE;
169: l_exists varchar2(1);
170: l_proc varchar2(100) := g_package || 'Insert_Row';
171:
172: cursor csr_exists is

Line 173: select null from PAY_UPGRADE_DEFINITIONS

169: l_exists varchar2(1);
170: l_proc varchar2(100) := g_package || 'Insert_Row';
171:
172: cursor csr_exists is
173: select null from PAY_UPGRADE_DEFINITIONS
174: where upgrade_definition_id = l_upgrade_definition_id;
175:
176: cursor csr_nextseq is
177: select pay_upgrade_definitions_s.nextval from dual;

Line 177: select pay_upgrade_definitions_s.nextval from dual;

173: select null from PAY_UPGRADE_DEFINITIONS
174: where upgrade_definition_id = l_upgrade_definition_id;
175:
176: cursor csr_nextseq is
177: select pay_upgrade_definitions_s.nextval from dual;
178: --
179: BEGIN
180: --
181: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 252: insert into PAY_UPGRADE_DEFINITIONS (

248: fetch csr_nextseq into l_upgrade_definition_id;
249: close csr_nextseq;
250:
251:
252: insert into PAY_UPGRADE_DEFINITIONS (
253: UPGRADE_DEFINITION_ID,
254: SHORT_NAME,
255: NAME,
256: DESCRIPTION,

Line 299: insert into PAY_UPGRADE_DEFINITIONS_TL (

295: p_last_update_date,
296: p_last_updated_by,
297: p_last_update_login );
298:
299: insert into PAY_UPGRADE_DEFINITIONS_TL (
300: UPGRADE_DEFINITION_ID,
301: LANGUAGE,
302: SOURCE_LANG,
303: NAME,

Line 327: from PAY_UPGRADE_DEFINITIONS_TL T

323: from FND_LANGUAGES L
324: where L.INSTALLED_FLAG in ('I', 'B')
325: and not exists
326: (select NULL
327: from PAY_UPGRADE_DEFINITIONS_TL T
328: where T.UPGRADE_DEFINITION_ID = l_UPGRADE_DEFINITION_ID
329: and T.LANGUAGE = L.LANGUAGE_CODE);
330:
331:

Line 391: update PAY_UPGRADE_DEFINITIONS set

387:
388: chk_lookup( 'PAY_GEN_FAILURE_POINT', p_failure_point, 'FAILURE_POINT' );
389:
390:
391: update PAY_UPGRADE_DEFINITIONS set
392: description = p_description,
393: criticality = p_criticality,
394: failure_point = p_failure_point,
395: upgrade_procedure = p_upgrade_procedure,

Line 410: update PAY_UPGRADE_DEFINITIONS_TL set

406: if (sql%notfound) then
407: raise no_data_found;
408: end if;
409:
410: update PAY_UPGRADE_DEFINITIONS_TL set
411: description = p_description,
412: additional_info = p_additional_info,
413: last_update_date = p_last_update_date,
414: last_updated_by = p_last_updated_by,

Line 458: from PAY_UPGRADE_DEFINITIONS

454: THREADING_LEVEL,
455: DESCRIPTION,
456: UPGRADE_METHOD,
457: QUALIFYING_PROCEDURE
458: from PAY_UPGRADE_DEFINITIONS
459: where UPGRADE_DEFINITION_ID = P_UPGRADE_DEFINITION_ID
460: for update of UPGRADE_DEFINITION_ID nowait;
461: --
462: cursor csr_lck_tl is

Line 467: from PAY_UPGRADE_DEFINITIONS_TL

463: select
464: NAME,
465: DESCRIPTION,
466: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
467: from PAY_UPGRADE_DEFINITIONS_TL
468: where UPGRADE_DEFINITION_ID = P_UPGRADE_DEFINITION_ID
469: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
470: for update of UPGRADE_DEFINITION_ID nowait;
471: --

Line 548: delete from PAY_UPGRADE_DEFINITIONS_TL

544:
545: delete from PAY_UPGRADE_LEGISLATIONS
546: where UPGRADE_DEFINITION_ID = P_UPGRADE_DEFINITION_ID;
547:
548: delete from PAY_UPGRADE_DEFINITIONS_TL
549: where UPGRADE_DEFINITION_ID = P_UPGRADE_DEFINITION_ID;
550:
551: if (sql%notfound) then
552: raise no_data_found;

Line 555: delete from PAY_UPGRADE_DEFINITIONS

551: if (sql%notfound) then
552: raise no_data_found;
553: end if;
554:
555: delete from PAY_UPGRADE_DEFINITIONS
556: where UPGRADE_DEFINITION_ID = P_UPGRADE_DEFINITION_ID;
557:
558: if (sql%notfound) then
559: raise no_data_found;

Line 570: delete from PAY_UPGRADE_DEFINITIONS_TL T

566: procedure ADD_LANGUAGE
567: is
568: BEGIN
569: --
570: delete from PAY_UPGRADE_DEFINITIONS_TL T
571: where not exists
572: (select NULL
573: from PAY_UPGRADE_DEFINITIONS B
574: where B.UPGRADE_DEFINITION_ID = T.UPGRADE_DEFINITION_ID

Line 573: from PAY_UPGRADE_DEFINITIONS B

569: --
570: delete from PAY_UPGRADE_DEFINITIONS_TL T
571: where not exists
572: (select NULL
573: from PAY_UPGRADE_DEFINITIONS B
574: where B.UPGRADE_DEFINITION_ID = T.UPGRADE_DEFINITION_ID
575: );
576:
577: update PAY_UPGRADE_DEFINITIONS_TL T set (

Line 577: update PAY_UPGRADE_DEFINITIONS_TL T set (

573: from PAY_UPGRADE_DEFINITIONS B
574: where B.UPGRADE_DEFINITION_ID = T.UPGRADE_DEFINITION_ID
575: );
576:
577: update PAY_UPGRADE_DEFINITIONS_TL T set (
578: NAME,
579: DESCRIPTION
580: ) = (select
581: B.NAME,

Line 583: from PAY_UPGRADE_DEFINITIONS_TL B

579: DESCRIPTION
580: ) = (select
581: B.NAME,
582: B.DESCRIPTION
583: from PAY_UPGRADE_DEFINITIONS_TL B
584: where B.UPGRADE_DEFINITION_ID = T.UPGRADE_DEFINITION_ID
585: and B.LANGUAGE = T.SOURCE_LANG)
586: where (
587: T.UPGRADE_DEFINITION_ID,

Line 592: from PAY_UPGRADE_DEFINITIONS_TL SUBB, PAY_UPGRADE_DEFINITIONS_TL SUBT

588: T.LANGUAGE
589: ) in (select
590: SUBT.UPGRADE_DEFINITION_ID,
591: SUBT.LANGUAGE
592: from PAY_UPGRADE_DEFINITIONS_TL SUBB, PAY_UPGRADE_DEFINITIONS_TL SUBT
593: where SUBB.UPGRADE_DEFINITION_ID = SUBT.UPGRADE_DEFINITION_ID
594: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
595: and (SUBB.NAME <> SUBT.NAME
596: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 599: insert into PAY_UPGRADE_DEFINITIONS_TL (

595: and (SUBB.NAME <> SUBT.NAME
596: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
597: ));
598:
599: insert into PAY_UPGRADE_DEFINITIONS_TL (
600: DESCRIPTION,
601: LAST_UPDATE_DATE,
602: LAST_UPDATED_BY,
603: LAST_UPDATE_LOGIN,

Line 621: from PAY_UPGRADE_DEFINITIONS_TL B, FND_LANGUAGES L

617: B.UPGRADE_DEFINITION_ID,
618: B.NAME,
619: L.LANGUAGE_CODE,
620: B.SOURCE_LANG
621: from PAY_UPGRADE_DEFINITIONS_TL B, FND_LANGUAGES L
622: where L.INSTALLED_FLAG in ('I', 'B')
623: and B.LANGUAGE = userenv('LANG')
624: and not exists
625: (select NULL

Line 626: from PAY_UPGRADE_DEFINITIONS_TL T

622: where L.INSTALLED_FLAG in ('I', 'B')
623: and B.LANGUAGE = userenv('LANG')
624: and not exists
625: (select NULL
626: from PAY_UPGRADE_DEFINITIONS_TL T
627: where T.UPGRADE_DEFINITION_ID = B.UPGRADE_DEFINITION_ID
628: and T.LANGUAGE = L.LANGUAGE_CODE);
629: --
630: END ADD_LANGUAGE;

Line 653: l_upgrade_definition_id PAY_UPGRADE_DEFINITIONS.UPGRADE_DEFINITION_ID%TYPE;

649: , P_OWNER in VARCHAR2
650: ) is
651: --
652: l_proc varchar2(100) := g_package || 'Load_Row';
653: l_upgrade_definition_id PAY_UPGRADE_DEFINITIONS.UPGRADE_DEFINITION_ID%TYPE;
654:
655: l_sysdate date := sysdate;
656: l_created_by PAY_UPGRADE_DEFINITIONS.CREATED_BY%TYPE;
657: l_creation_date PAY_UPGRADE_DEFINITIONS.CREATION_DATE%TYPE;

Line 656: l_created_by PAY_UPGRADE_DEFINITIONS.CREATED_BY%TYPE;

652: l_proc varchar2(100) := g_package || 'Load_Row';
653: l_upgrade_definition_id PAY_UPGRADE_DEFINITIONS.UPGRADE_DEFINITION_ID%TYPE;
654:
655: l_sysdate date := sysdate;
656: l_created_by PAY_UPGRADE_DEFINITIONS.CREATED_BY%TYPE;
657: l_creation_date PAY_UPGRADE_DEFINITIONS.CREATION_DATE%TYPE;
658: l_last_updated_by PAY_UPGRADE_DEFINITIONS.LAST_UPDATED_BY%TYPE;
659: l_last_update_login PAY_UPGRADE_DEFINITIONS.LAST_UPDATE_LOGIN%TYPE;
660: l_last_update_date PAY_UPGRADE_DEFINITIONS.LAST_UPDATE_DATE%TYPE;

Line 657: l_creation_date PAY_UPGRADE_DEFINITIONS.CREATION_DATE%TYPE;

653: l_upgrade_definition_id PAY_UPGRADE_DEFINITIONS.UPGRADE_DEFINITION_ID%TYPE;
654:
655: l_sysdate date := sysdate;
656: l_created_by PAY_UPGRADE_DEFINITIONS.CREATED_BY%TYPE;
657: l_creation_date PAY_UPGRADE_DEFINITIONS.CREATION_DATE%TYPE;
658: l_last_updated_by PAY_UPGRADE_DEFINITIONS.LAST_UPDATED_BY%TYPE;
659: l_last_update_login PAY_UPGRADE_DEFINITIONS.LAST_UPDATE_LOGIN%TYPE;
660: l_last_update_date PAY_UPGRADE_DEFINITIONS.LAST_UPDATE_DATE%TYPE;
661:

Line 658: l_last_updated_by PAY_UPGRADE_DEFINITIONS.LAST_UPDATED_BY%TYPE;

654:
655: l_sysdate date := sysdate;
656: l_created_by PAY_UPGRADE_DEFINITIONS.CREATED_BY%TYPE;
657: l_creation_date PAY_UPGRADE_DEFINITIONS.CREATION_DATE%TYPE;
658: l_last_updated_by PAY_UPGRADE_DEFINITIONS.LAST_UPDATED_BY%TYPE;
659: l_last_update_login PAY_UPGRADE_DEFINITIONS.LAST_UPDATE_LOGIN%TYPE;
660: l_last_update_date PAY_UPGRADE_DEFINITIONS.LAST_UPDATE_DATE%TYPE;
661:
662: cursor csr_existing is

Line 659: l_last_update_login PAY_UPGRADE_DEFINITIONS.LAST_UPDATE_LOGIN%TYPE;

655: l_sysdate date := sysdate;
656: l_created_by PAY_UPGRADE_DEFINITIONS.CREATED_BY%TYPE;
657: l_creation_date PAY_UPGRADE_DEFINITIONS.CREATION_DATE%TYPE;
658: l_last_updated_by PAY_UPGRADE_DEFINITIONS.LAST_UPDATED_BY%TYPE;
659: l_last_update_login PAY_UPGRADE_DEFINITIONS.LAST_UPDATE_LOGIN%TYPE;
660: l_last_update_date PAY_UPGRADE_DEFINITIONS.LAST_UPDATE_DATE%TYPE;
661:
662: cursor csr_existing is
663: select upgrade_definition_id

Line 660: l_last_update_date PAY_UPGRADE_DEFINITIONS.LAST_UPDATE_DATE%TYPE;

656: l_created_by PAY_UPGRADE_DEFINITIONS.CREATED_BY%TYPE;
657: l_creation_date PAY_UPGRADE_DEFINITIONS.CREATION_DATE%TYPE;
658: l_last_updated_by PAY_UPGRADE_DEFINITIONS.LAST_UPDATED_BY%TYPE;
659: l_last_update_login PAY_UPGRADE_DEFINITIONS.LAST_UPDATE_LOGIN%TYPE;
660: l_last_update_date PAY_UPGRADE_DEFINITIONS.LAST_UPDATE_DATE%TYPE;
661:
662: cursor csr_existing is
663: select upgrade_definition_id
664: from pay_upgrade_definitions

Line 664: from pay_upgrade_definitions

660: l_last_update_date PAY_UPGRADE_DEFINITIONS.LAST_UPDATE_DATE%TYPE;
661:
662: cursor csr_existing is
663: select upgrade_definition_id
664: from pay_upgrade_definitions
665: where upper(short_name) = upper(p_short_name) ;
666:
667: CURSOR C_APPL IS
668: select application_id

Line 672: l_appl_id PAY_UPGRADE_DEFINITIONS.OWNER_APPLICATION_ID%type;

668: select application_id
669: from fnd_application
670: where upper(application_short_name) = upper(P_OWNER_APPL_SHORT_NAME);
671:
672: l_appl_id PAY_UPGRADE_DEFINITIONS.OWNER_APPLICATION_ID%type;
673: --
674: BEGIN
675: --
676: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 803: UPDATE pay_upgrade_definitions_tl

799: l_last_update_login := fnd_global.login_id;
800: l_last_update_date := sysdate;
801: --
802:
803: UPDATE pay_upgrade_definitions_tl
804: SET name = nvl(p_name,name),
805: description = nvl(p_description,description),
806: additional_info = nvl(p_additional_info, additional_info),
807: last_update_date = l_last_update_date,

Line 814: FROM pay_upgrade_definitions pud

810: source_lang = userenv('LANG')
811: WHERE userenv('LANG') IN (language,source_lang)
812: AND upgrade_definition_id in
813: (SELECT pud.upgrade_definition_id
814: FROM pay_upgrade_definitions pud
815: WHERE upper(p_short_name) = upper(pud.short_name) );
816:
817: hr_utility.set_location('Leaving:'|| l_proc, 20);
818: --

Line 821: END PAY_UPGRADE_DEFINITIONS_PKG;

817: hr_utility.set_location('Leaving:'|| l_proc, 20);
818: --
819: END Translate_Row;
820:
821: END PAY_UPGRADE_DEFINITIONS_PKG;
822: