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.HR_DOCUMENT_TYPES_PKG dependencies on HR_DOCUMENT_TYPES

Line 1: package body HR_DOCUMENT_TYPES_PKG as

1: package body HR_DOCUMENT_TYPES_PKG as
2: /* $Header: perditlct.pkb 120.0 2005/06/24 07:52:30 appldev noship $ */
3: --
4: procedure KEY_TO_IDS (
5: X_SYSTEM_DOCUMENT_TYPE in VARCHAR2,

Line 15: from HR_DOCUMENT_TYPES HDT

11: X_SYS_DOC_TYPE in VARCHAR2,
12: X_LEG_CODE in VARCHAR2
13: ) is
14: select HDT.DOCUMENT_TYPE_ID
15: from HR_DOCUMENT_TYPES HDT
16: where HDT.SYSTEM_DOCUMENT_TYPE = X_SYS_DOC_TYPE
17: and ((X_LEG_CODE is NULL and HDT.LEGISLATION_CODE is NULL)
18: or
19: (X_LEG_CODE = HDT.LEGISLATION_CODE));

Line 22: select HR_DOCUMENT_TYPES_S.nextval

18: or
19: (X_LEG_CODE = HDT.LEGISLATION_CODE));
20: --
21: cursor CSR_SEQUENCE is
22: select HR_DOCUMENT_TYPES_S.nextval
23: from dual;
24: --
25: begin
26: open CSR_DOCUMENT_TYPE (X_SYSTEM_DOCUMENT_TYPE,X_LEGISLATION_CODE);

Line 79: insert into HR_DOCUMENT_TYPES (

75: X_LAST_UPDATE_LOGIN in NUMBER
76: ) is
77: begin
78: --
79: insert into HR_DOCUMENT_TYPES (
80: DOCUMENT_TYPE_ID,
81: SYSTEM_DOCUMENT_TYPE,
82: CATEGORY_CODE,
83: SUB_CATEGORY_CODE,

Line 113: insert into HR_DOCUMENT_TYPES_TL (

109: X_LAST_UPDATED_BY,
110: X_LAST_UPDATE_LOGIN
111: );
112: --
113: insert into HR_DOCUMENT_TYPES_TL (
114: DOCUMENT_TYPE_ID,
115: DOCUMENT_TYPE,
116: DESCRIPTION,
117: CREATED_BY,

Line 139: from HR_DOCUMENT_TYPES_TL T

135: from FND_LANGUAGES L
136: where L.INSTALLED_FLAG in ('I', 'B')
137: and not exists
138: (select NULL
139: from HR_DOCUMENT_TYPES_TL T
140: where T.DOCUMENT_TYPE_ID = X_DOCUMENT_TYPE_ID
141: and T.LANGUAGE = L.LANGUAGE_CODE);
142:
143: end INSERT_ROW;

Line 163: update HR_DOCUMENT_TYPES set

159: X_LAST_UPDATED_BY in NUMBER,
160: X_LAST_UPDATE_LOGIN in NUMBER
161: ) is
162: begin
163: update HR_DOCUMENT_TYPES set
164: CATEGORY_CODE = X_CATEGORY_CODE,
165: SUB_CATEGORY_CODE = X_SUB_CATEGORY_CODE,
166: ACTIVE_INACTIVE_FLAG = X_ACTIVE_INACTIVE_FLAG,
167: MULTIPLE_OCCURENCES_FLAG = X_MULTIPLE_OCCURENCES_FLAG,

Line 181: update HR_DOCUMENT_TYPES_TL set

177: if (sql%notfound) then
178: raise no_data_found;
179: end if;
180:
181: update HR_DOCUMENT_TYPES_TL set
182: DOCUMENT_TYPE = X_DOCUMENT_TYPE,
183: DESCRIPTION = X_DESCRIPTION,
184: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
185: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 201: delete from HR_DOCUMENT_TYPES_TL

197: procedure DELETE_ROW (
198: X_DOCUMENT_TYPE_ID in NUMBER
199: ) is
200: begin
201: delete from HR_DOCUMENT_TYPES_TL
202: where DOCUMENT_TYPE_ID = X_DOCUMENT_TYPE_ID;
203:
204: if (sql%notfound) then
205: raise no_data_found;

Line 208: delete from HR_DOCUMENT_TYPES

204: if (sql%notfound) then
205: raise no_data_found;
206: end if;
207:
208: delete from HR_DOCUMENT_TYPES
209: where DOCUMENT_TYPE_ID = X_DOCUMENT_TYPE_ID;
210: if (sql%notfound) then
211: raise no_data_found;
212: end if;

Line 218: delete from HR_DOCUMENT_TYPES_TL T

214: --
215: procedure ADD_LANGUAGE
216: is
217: begin
218: delete from HR_DOCUMENT_TYPES_TL T
219: where not exists
220: (select NULL
221: from HR_DOCUMENT_TYPES B
222: where B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID

Line 221: from HR_DOCUMENT_TYPES B

217: begin
218: delete from HR_DOCUMENT_TYPES_TL T
219: where not exists
220: (select NULL
221: from HR_DOCUMENT_TYPES B
222: where B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID
223: );
224:
225: update HR_DOCUMENT_TYPES_TL T set (

Line 225: update HR_DOCUMENT_TYPES_TL T set (

221: from HR_DOCUMENT_TYPES B
222: where B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID
223: );
224:
225: update HR_DOCUMENT_TYPES_TL T set (
226: DOCUMENT_TYPE
227: ) = (select
228: B.DOCUMENT_TYPE
229: from HR_DOCUMENT_TYPES_TL B

Line 229: from HR_DOCUMENT_TYPES_TL B

225: update HR_DOCUMENT_TYPES_TL T set (
226: DOCUMENT_TYPE
227: ) = (select
228: B.DOCUMENT_TYPE
229: from HR_DOCUMENT_TYPES_TL B
230: where B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID
231: and B.LANGUAGE = T.SOURCE_LANGUAGE)
232: where (
233: T.DOCUMENT_TYPE_ID,

Line 238: from HR_DOCUMENT_TYPES_TL SUBB, HR_DOCUMENT_TYPES_TL SUBT

234: T.LANGUAGE
235: ) in (select
236: SUBT.DOCUMENT_TYPE_ID,
237: SUBT.LANGUAGE
238: from HR_DOCUMENT_TYPES_TL SUBB, HR_DOCUMENT_TYPES_TL SUBT
239: where SUBB.DOCUMENT_TYPE_ID = SUBT.DOCUMENT_TYPE_ID
240: and SUBB.LANGUAGE = SUBT.SOURCE_LANGUAGE
241: and (SUBB.DOCUMENT_TYPE <> SUBT.DOCUMENT_TYPE
242: ));

Line 244: insert into HR_DOCUMENT_TYPES_TL (

240: and SUBB.LANGUAGE = SUBT.SOURCE_LANGUAGE
241: and (SUBB.DOCUMENT_TYPE <> SUBT.DOCUMENT_TYPE
242: ));
243:
244: insert into HR_DOCUMENT_TYPES_TL (
245: DOCUMENT_TYPE_ID,
246: DOCUMENT_TYPE,
247: DESCRIPTION,
248: CREATED_BY,

Line 266: from HR_DOCUMENT_TYPES_TL B, FND_LANGUAGES L

262: B.LAST_UPDATE_DATE,
263: B.LAST_UPDATE_LOGIN,
264: L.LANGUAGE_CODE,
265: B.SOURCE_LANGUAGE
266: from HR_DOCUMENT_TYPES_TL B, FND_LANGUAGES L
267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL

Line 271: from HR_DOCUMENT_TYPES_TL T

267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL
271: from HR_DOCUMENT_TYPES_TL T
272: where T.DOCUMENT_TYPE_ID = B.DOCUMENT_TYPE_ID
273: and T.LANGUAGE = L.LANGUAGE_CODE);
274: end ADD_LANGUAGE;
275:

Line 386: update HR_DOCUMENT_TYPES_TL

382: X_LAST_UPDATED_BY,
383: X_LAST_UPDATE_LOGIN
384: );
385: --
386: update HR_DOCUMENT_TYPES_TL
387: set DOCUMENT_TYPE = X_DOCUMENT_TYPE,
388: DESCRIPTION = X_DESCRIPTION,
389: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
390: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 398: end HR_DOCUMENT_TYPES_PKG;

394: and userenv('LANG') in (LANGUAGE,SOURCE_LANGUAGE);
395:
396: end TRANSLATE_ROW;
397: --
398: end HR_DOCUMENT_TYPES_PKG;