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.PER_QUALIFICATION_TYPES_PKG dependencies on PER_QUALIFICATION_TYPES

Line 1: package body per_qualification_types_pkg as

1: package body per_qualification_types_pkg as
2: /* $Header: pequatyp.pkb 120.3 2011/04/28 10:11:15 sidsaxen ship $*/
3:
4: procedure OWNER_TO_WHO (
5: X_OWNER in VARCHAR2,

Line 31: from per_qualification_types

27: X_QUALIFICATION_TYPE_ID OUT NOCOPY NUMBER
28: ) IS
29: Cursor csr_qualification_type is
30: select QUALIFICATION_TYPE_ID
31: from per_qualification_types
32: where name = X_NAME;
33: Cursor csr_sequence is
34: select per_qualification_types_s.nextval
35: from dual;

Line 34: select per_qualification_types_s.nextval

30: select QUALIFICATION_TYPE_ID
31: from per_qualification_types
32: where name = X_NAME;
33: Cursor csr_sequence is
34: select per_qualification_types_s.nextval
35: from dual;
36: begin
37: open csr_qualification_type;
38: fetch csr_qualification_type into X_QUALIFICATION_TYPE_ID;

Line 126: from PER_QUALIFICATION_TYPES

122: ) is
123:
124: Cursor C is
125: select rowid
126: from PER_QUALIFICATION_TYPES
127: where QUALIFICATION_TYPE_ID = X_QUALIFICATION_TYPE_ID;
128:
129:
130: begin

Line 132: insert into PER_QUALIFICATION_TYPES

128:
129:
130: begin
131:
132: insert into PER_QUALIFICATION_TYPES
133: (
134: QUALIFICATION_TYPE_ID,
135: NAME,
136: CATEGORY,

Line 288: p_entity_name=>'PER_QUALIFICATION_TYPES_TL',

284: -- Added the following code as a part of Zero Downtime Patching Project.
285: -- Code Starts Here.
286: --
287: per_ric_pkg.Chk_integrity (
288: p_entity_name=>'PER_QUALIFICATION_TYPES_TL',
289: p_ref_entity=>'PER_QUALIFICATION_TYPES',
290: p_ref_column_name=>'QUALIFICATION_TYPE_ID',
291: p_ref_col_value_number=>X_QUALIFICATION_TYPE_ID,
292: p_ref_col_value_varchar=>NULL,

Line 289: p_ref_entity=>'PER_QUALIFICATION_TYPES',

285: -- Code Starts Here.
286: --
287: per_ric_pkg.Chk_integrity (
288: p_entity_name=>'PER_QUALIFICATION_TYPES_TL',
289: p_ref_entity=>'PER_QUALIFICATION_TYPES',
290: p_ref_column_name=>'QUALIFICATION_TYPE_ID',
291: p_ref_col_value_number=>X_QUALIFICATION_TYPE_ID,
292: p_ref_col_value_varchar=>NULL,
293: p_ref_col_value_date=>NULL,

Line 299: insert into PER_QUALIFICATION_TYPES_TL

295: --
296: -- Code Ends Here
297: --
298:
299: insert into PER_QUALIFICATION_TYPES_TL
300: (
301: QUALIFICATION_TYPE_ID,
302: NAME,
303: LAST_UPDATE_DATE,

Line 324: from PER_QUALIFICATION_TYPES_TL T

320: from FND_LANGUAGES L
321: where L.INSTALLED_FLAG in ('I', 'B')
322: and not exists
323: (select NULL
324: from PER_QUALIFICATION_TYPES_TL T
325: where T.QUALIFICATION_TYPE_ID = X_QUALIFICATION_TYPE_ID
326: AND T.LANGUAGE = L.LANGUAGE_CODE);
327:
328: open c;

Line 418: update per_qualification_types

414:
415:
416: begin
417:
418: update per_qualification_types
419: set NAME = X_NAME,
420: CATEGORY = X_CATEGORY,
421: RANK = X_RANK,
422: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 496: update per_qualification_types_tl

492: if (sql%notfound) then
493: raise no_data_found;
494: end if;
495:
496: update per_qualification_types_tl
497: set NAME = X_USER_NAME,
498: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
499: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
500: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 620: from PER_QUALIFICATION_TYPES

616: -- Translate char last_update_date to date
617: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
618: select LAST_UPDATED_BY, LAST_UPDATE_DATE
619: into db_luby, db_ludate
620: from PER_QUALIFICATION_TYPES
621: where QUALIFICATION_TYPE_ID = X_QUALIFICATION_TYPE_ID;
622:
623: -- Test for customization and version
624: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 822: from PER_QUALIFICATION_TYPES_TL

818: -- Translate char last_update_date to date
819: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
820: select LAST_UPDATED_BY, LAST_UPDATE_DATE
821: into db_luby, db_ludate
822: from PER_QUALIFICATION_TYPES_TL
823: where QUALIFICATION_TYPE_ID = TO_NUMBER(X_QUALIFICATION_TYPE_ID)
824: and LANGUAGE=userenv('LANG');
825:
826: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 829: update per_qualification_types_tl

825:
826: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
827: db_ludate,X_CUSTOM_MODE)) then
828:
829: update per_qualification_types_tl
830: set NAME = X_USER_NAME,
831: LAST_UPDATE_DATE = db_ludate,
832: LAST_UPDATED_BY = db_luby,
833: LAST_UPDATE_LOGIN = 0,

Line 845: delete from PER_QUALIFICATION_TYPES_TL

841: X_QUALIFICATION_TYPE_ID IN NUMBER
842: ) is
843: begin
844:
845: delete from PER_QUALIFICATION_TYPES_TL
846: where qualification_type_id =X_QUALIFICATION_TYPE_ID;
847:
848: end delete_row;
849:

Line 853: -- process PER_QUALIFICATION_TYPES_TL table

849:
850: procedure ADD_LANGUAGE
851: is
852: begin
853: -- process PER_QUALIFICATION_TYPES_TL table
854: delete from PER_QUALIFICATION_TYPES_TL T
855: where not exists
856: (select NULL
857: from PER_QUALIFICATION_TYPES B

Line 854: delete from PER_QUALIFICATION_TYPES_TL T

850: procedure ADD_LANGUAGE
851: is
852: begin
853: -- process PER_QUALIFICATION_TYPES_TL table
854: delete from PER_QUALIFICATION_TYPES_TL T
855: where not exists
856: (select NULL
857: from PER_QUALIFICATION_TYPES B
858: where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID

Line 857: from PER_QUALIFICATION_TYPES B

853: -- process PER_QUALIFICATION_TYPES_TL table
854: delete from PER_QUALIFICATION_TYPES_TL T
855: where not exists
856: (select NULL
857: from PER_QUALIFICATION_TYPES B
858: where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID
859: );
860:
861: update PER_QUALIFICATION_TYPES_TL T set (

Line 861: update PER_QUALIFICATION_TYPES_TL T set (

857: from PER_QUALIFICATION_TYPES B
858: where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID
859: );
860:
861: update PER_QUALIFICATION_TYPES_TL T set (
862: NAME
863: ) = (select
864: B.NAME
865: from PER_QUALIFICATION_TYPES_TL B

Line 865: from PER_QUALIFICATION_TYPES_TL B

861: update PER_QUALIFICATION_TYPES_TL T set (
862: NAME
863: ) = (select
864: B.NAME
865: from PER_QUALIFICATION_TYPES_TL B
866: where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID
867: and B.LANGUAGE = T.SOURCE_LANG)
868: where (
869: T.QUALIFICATION_TYPE_ID,

Line 874: from PER_QUALIFICATION_TYPES_TL SUBB, PER_QUALIFICATION_TYPES_TL SUBT

870: T.LANGUAGE
871: ) in (select
872: SUBT.QUALIFICATION_TYPE_ID,
873: SUBT.LANGUAGE
874: from PER_QUALIFICATION_TYPES_TL SUBB, PER_QUALIFICATION_TYPES_TL SUBT
875: where SUBB.QUALIFICATION_TYPE_ID = SUBT.QUALIFICATION_TYPE_ID
876: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
877: and (SUBB.NAME <> SUBT.NAME
878: ));

Line 880: insert into PER_QUALIFICATION_TYPES_TL (

876: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
877: and (SUBB.NAME <> SUBT.NAME
878: ));
879:
880: insert into PER_QUALIFICATION_TYPES_TL (
881: QUALIFICATION_TYPE_ID,
882: NAME,
883: LAST_UPDATE_DATE,
884: LAST_UPDATED_BY,

Line 900: from PER_QUALIFICATION_TYPES_TL B, FND_LANGUAGES L

896: B.CREATED_BY,
897: B.CREATION_DATE,
898: L.LANGUAGE_CODE,
899: B.SOURCE_LANG
900: from PER_QUALIFICATION_TYPES_TL B, FND_LANGUAGES L
901: where L.INSTALLED_FLAG in ('I', 'B')
902: and B.LANGUAGE = userenv('LANG')
903: and not exists
904: (select NULL

Line 905: from PER_QUALIFICATION_TYPES_TL T

901: where L.INSTALLED_FLAG in ('I', 'B')
902: and B.LANGUAGE = userenv('LANG')
903: and not exists
904: (select NULL
905: from PER_QUALIFICATION_TYPES_TL T
906: where T.QUALIFICATION_TYPE_ID = B.QUALIFICATION_TYPE_ID
907: and T.LANGUAGE = L.LANGUAGE_CODE);
908:
909: end ADD_LANGUAGE;

Line 911: End per_qualification_types_pkg;

907: and T.LANGUAGE = L.LANGUAGE_CODE);
908:
909: end ADD_LANGUAGE;
910:
911: End per_qualification_types_pkg;