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.

[Home] [Help]

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.2 2006/06/27 12:24:26 bshukla noship $*/
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 283: insert into PER_QUALIFICATION_TYPES_TL

279: X_LAST_UPDATED_BY,
280: X_LAST_UPDATE_LOGIN
281: );
282:
283: insert into PER_QUALIFICATION_TYPES_TL
284: (
285: QUALIFICATION_TYPE_ID,
286: NAME,
287: LAST_UPDATE_DATE,

Line 308: from PER_QUALIFICATION_TYPES_TL T

304: from FND_LANGUAGES L
305: where L.INSTALLED_FLAG in ('I', 'B')
306: and not exists
307: (select NULL
308: from PER_QUALIFICATION_TYPES_TL T
309: where T.QUALIFICATION_TYPE_ID = X_QUALIFICATION_TYPE_ID
310: AND T.LANGUAGE = L.LANGUAGE_CODE);
311:
312: open c;

Line 402: update per_qualification_types

398:
399:
400: begin
401:
402: update per_qualification_types
403: set NAME = X_NAME,
404: CATEGORY = X_CATEGORY,
405: RANK = X_RANK,
406: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 480: update per_qualification_types_tl

476: if (sql%notfound) then
477: raise no_data_found;
478: end if;
479:
480: update per_qualification_types_tl
481: set NAME = X_USER_NAME,
482: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
483: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
484: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 604: from PER_QUALIFICATION_TYPES

600: -- Translate char last_update_date to date
601: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
602: select LAST_UPDATED_BY, LAST_UPDATE_DATE
603: into db_luby, db_ludate
604: from PER_QUALIFICATION_TYPES
605: where QUALIFICATION_TYPE_ID = X_QUALIFICATION_TYPE_ID;
606:
607: -- Test for customization and version
608: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 806: from PER_QUALIFICATION_TYPES_TL

802: -- Translate char last_update_date to date
803: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
804: select LAST_UPDATED_BY, LAST_UPDATE_DATE
805: into db_luby, db_ludate
806: from PER_QUALIFICATION_TYPES_TL
807: where QUALIFICATION_TYPE_ID = TO_NUMBER(X_QUALIFICATION_TYPE_ID)
808: and LANGUAGE=userenv('LANG');
809:
810: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 813: update per_qualification_types_tl

809:
810: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
811: db_ludate,X_CUSTOM_MODE)) then
812:
813: update per_qualification_types_tl
814: set NAME = X_USER_NAME,
815: LAST_UPDATE_DATE = db_ludate,
816: LAST_UPDATED_BY = db_luby,
817: LAST_UPDATE_LOGIN = 0,

Line 829: delete from PER_QUALIFICATION_TYPES_TL

825: X_QUALIFICATION_TYPE_ID IN NUMBER
826: ) is
827: begin
828:
829: delete from PER_QUALIFICATION_TYPES_TL
830: where qualification_type_id =X_QUALIFICATION_TYPE_ID;
831:
832: end delete_row;
833:

Line 837: -- process PER_QUALIFICATION_TYPES_TL table

833:
834: procedure ADD_LANGUAGE
835: is
836: begin
837: -- process PER_QUALIFICATION_TYPES_TL table
838: delete from PER_QUALIFICATION_TYPES_TL T
839: where not exists
840: (select NULL
841: from PER_QUALIFICATION_TYPES B

Line 838: delete from PER_QUALIFICATION_TYPES_TL T

834: procedure ADD_LANGUAGE
835: is
836: begin
837: -- process PER_QUALIFICATION_TYPES_TL table
838: delete from PER_QUALIFICATION_TYPES_TL T
839: where not exists
840: (select NULL
841: from PER_QUALIFICATION_TYPES B
842: where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID

Line 841: from PER_QUALIFICATION_TYPES B

837: -- process PER_QUALIFICATION_TYPES_TL table
838: delete from PER_QUALIFICATION_TYPES_TL T
839: where not exists
840: (select NULL
841: from PER_QUALIFICATION_TYPES B
842: where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID
843: );
844:
845: update PER_QUALIFICATION_TYPES_TL T set (

Line 845: update PER_QUALIFICATION_TYPES_TL T set (

841: from PER_QUALIFICATION_TYPES B
842: where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID
843: );
844:
845: update PER_QUALIFICATION_TYPES_TL T set (
846: NAME
847: ) = (select
848: B.NAME
849: from PER_QUALIFICATION_TYPES_TL B

Line 849: from PER_QUALIFICATION_TYPES_TL B

845: update PER_QUALIFICATION_TYPES_TL T set (
846: NAME
847: ) = (select
848: B.NAME
849: from PER_QUALIFICATION_TYPES_TL B
850: where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID
851: and B.LANGUAGE = T.SOURCE_LANG)
852: where (
853: T.QUALIFICATION_TYPE_ID,

Line 858: from PER_QUALIFICATION_TYPES_TL SUBB, PER_QUALIFICATION_TYPES_TL SUBT

854: T.LANGUAGE
855: ) in (select
856: SUBT.QUALIFICATION_TYPE_ID,
857: SUBT.LANGUAGE
858: from PER_QUALIFICATION_TYPES_TL SUBB, PER_QUALIFICATION_TYPES_TL SUBT
859: where SUBB.QUALIFICATION_TYPE_ID = SUBT.QUALIFICATION_TYPE_ID
860: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
861: and (SUBB.NAME <> SUBT.NAME
862: ));

Line 864: insert into PER_QUALIFICATION_TYPES_TL (

860: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
861: and (SUBB.NAME <> SUBT.NAME
862: ));
863:
864: insert into PER_QUALIFICATION_TYPES_TL (
865: QUALIFICATION_TYPE_ID,
866: NAME,
867: LAST_UPDATE_DATE,
868: LAST_UPDATED_BY,

Line 884: from PER_QUALIFICATION_TYPES_TL B, FND_LANGUAGES L

880: B.CREATED_BY,
881: B.CREATION_DATE,
882: L.LANGUAGE_CODE,
883: B.SOURCE_LANG
884: from PER_QUALIFICATION_TYPES_TL B, FND_LANGUAGES L
885: where L.INSTALLED_FLAG in ('I', 'B')
886: and B.LANGUAGE = userenv('LANG')
887: and not exists
888: (select NULL

Line 889: from PER_QUALIFICATION_TYPES_TL T

885: where L.INSTALLED_FLAG in ('I', 'B')
886: and B.LANGUAGE = userenv('LANG')
887: and not exists
888: (select NULL
889: from PER_QUALIFICATION_TYPES_TL T
890: where T.QUALIFICATION_TYPE_ID = B.QUALIFICATION_TYPE_ID
891: and T.LANGUAGE = L.LANGUAGE_CODE);
892:
893: end ADD_LANGUAGE;

Line 895: End per_qualification_types_pkg;

891: and T.LANGUAGE = L.LANGUAGE_CODE);
892:
893: end ADD_LANGUAGE;
894:
895: End per_qualification_types_pkg;