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.1 2011/04/28 09:57:06 sidsaxen ship $ */
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 119: p_entity_name=> 'HR_DOCUMENT_TYPES_TL',

115: -- Added the following code as a part of Zero Downtime Patching Project.
116: -- Code Starts Here.
117: --
118: per_ric_pkg.Chk_integrity (
119: p_entity_name=> 'HR_DOCUMENT_TYPES_TL',
120: p_ref_entity=> 'HR_DOCUMENT_TYPES',
121: p_ref_column_name=>'DOCUMENT_TYPE_ID',
122: p_ref_col_value_number=>X_DOCUMENT_TYPE_ID,
123: p_ref_col_value_varchar=>NULL,

Line 120: p_ref_entity=> 'HR_DOCUMENT_TYPES',

116: -- Code Starts Here.
117: --
118: per_ric_pkg.Chk_integrity (
119: p_entity_name=> 'HR_DOCUMENT_TYPES_TL',
120: p_ref_entity=> 'HR_DOCUMENT_TYPES',
121: p_ref_column_name=>'DOCUMENT_TYPE_ID',
122: p_ref_col_value_number=>X_DOCUMENT_TYPE_ID,
123: p_ref_col_value_varchar=>NULL,
124: p_ref_col_value_date=>NULL,

Line 130: insert into HR_DOCUMENT_TYPES_TL (

126: --
127: -- Code Ends Here
128: --
129:
130: insert into HR_DOCUMENT_TYPES_TL (
131: DOCUMENT_TYPE_ID,
132: DOCUMENT_TYPE,
133: DESCRIPTION,
134: CREATED_BY,

Line 156: from HR_DOCUMENT_TYPES_TL T

152: from FND_LANGUAGES L
153: where L.INSTALLED_FLAG in ('I', 'B')
154: and not exists
155: (select NULL
156: from HR_DOCUMENT_TYPES_TL T
157: where T.DOCUMENT_TYPE_ID = X_DOCUMENT_TYPE_ID
158: and T.LANGUAGE = L.LANGUAGE_CODE);
159:
160: end INSERT_ROW;

Line 180: update HR_DOCUMENT_TYPES set

176: X_LAST_UPDATED_BY in NUMBER,
177: X_LAST_UPDATE_LOGIN in NUMBER
178: ) is
179: begin
180: update HR_DOCUMENT_TYPES set
181: CATEGORY_CODE = X_CATEGORY_CODE,
182: SUB_CATEGORY_CODE = X_SUB_CATEGORY_CODE,
183: ACTIVE_INACTIVE_FLAG = X_ACTIVE_INACTIVE_FLAG,
184: MULTIPLE_OCCURENCES_FLAG = X_MULTIPLE_OCCURENCES_FLAG,

Line 198: update HR_DOCUMENT_TYPES_TL set

194: if (sql%notfound) then
195: raise no_data_found;
196: end if;
197:
198: update HR_DOCUMENT_TYPES_TL set
199: DOCUMENT_TYPE = X_DOCUMENT_TYPE,
200: DESCRIPTION = X_DESCRIPTION,
201: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
202: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 218: delete from HR_DOCUMENT_TYPES_TL

214: procedure DELETE_ROW (
215: X_DOCUMENT_TYPE_ID in NUMBER
216: ) is
217: begin
218: delete from HR_DOCUMENT_TYPES_TL
219: where DOCUMENT_TYPE_ID = X_DOCUMENT_TYPE_ID;
220:
221: if (sql%notfound) then
222: raise no_data_found;

Line 230: p_entity_name=> 'HR_DOCUMENT_TYPES',

226: -- Added the following code as a part of Zero Downtime Patching Project.
227: -- Code Starts Here.
228: --
229: per_ric_pkg.Chk_integrity (
230: p_entity_name=> 'HR_DOCUMENT_TYPES',
231: p_ref_entity=> 'HR_DOCUMENT_TYPES_TL',
232: p_ref_column_name=>'DOCUMENT_TYPE_ID',
233: p_ref_col_value_number=>X_DOCUMENT_TYPE_ID,
234: p_ref_col_value_varchar=>NULL,

Line 231: p_ref_entity=> 'HR_DOCUMENT_TYPES_TL',

227: -- Code Starts Here.
228: --
229: per_ric_pkg.Chk_integrity (
230: p_entity_name=> 'HR_DOCUMENT_TYPES',
231: p_ref_entity=> 'HR_DOCUMENT_TYPES_TL',
232: p_ref_column_name=>'DOCUMENT_TYPE_ID',
233: p_ref_col_value_number=>X_DOCUMENT_TYPE_ID,
234: p_ref_col_value_varchar=>NULL,
235: p_ref_col_value_date=>NULL,

Line 241: delete from HR_DOCUMENT_TYPES

237: --
238: -- Code Ends Here
239: --
240:
241: delete from HR_DOCUMENT_TYPES
242: where DOCUMENT_TYPE_ID = X_DOCUMENT_TYPE_ID;
243: if (sql%notfound) then
244: raise no_data_found;
245: end if;

Line 251: delete from HR_DOCUMENT_TYPES_TL T

247: --
248: procedure ADD_LANGUAGE
249: is
250: begin
251: delete from HR_DOCUMENT_TYPES_TL T
252: where not exists
253: (select NULL
254: from HR_DOCUMENT_TYPES B
255: where B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID

Line 254: from HR_DOCUMENT_TYPES B

250: begin
251: delete from HR_DOCUMENT_TYPES_TL T
252: where not exists
253: (select NULL
254: from HR_DOCUMENT_TYPES B
255: where B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID
256: );
257:
258: update HR_DOCUMENT_TYPES_TL T set (

Line 258: update HR_DOCUMENT_TYPES_TL T set (

254: from HR_DOCUMENT_TYPES B
255: where B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID
256: );
257:
258: update HR_DOCUMENT_TYPES_TL T set (
259: DOCUMENT_TYPE
260: ) = (select
261: B.DOCUMENT_TYPE
262: from HR_DOCUMENT_TYPES_TL B

Line 262: from HR_DOCUMENT_TYPES_TL B

258: update HR_DOCUMENT_TYPES_TL T set (
259: DOCUMENT_TYPE
260: ) = (select
261: B.DOCUMENT_TYPE
262: from HR_DOCUMENT_TYPES_TL B
263: where B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID
264: and B.LANGUAGE = T.SOURCE_LANGUAGE)
265: where (
266: T.DOCUMENT_TYPE_ID,

Line 271: from HR_DOCUMENT_TYPES_TL SUBB, HR_DOCUMENT_TYPES_TL SUBT

267: T.LANGUAGE
268: ) in (select
269: SUBT.DOCUMENT_TYPE_ID,
270: SUBT.LANGUAGE
271: from HR_DOCUMENT_TYPES_TL SUBB, HR_DOCUMENT_TYPES_TL SUBT
272: where SUBB.DOCUMENT_TYPE_ID = SUBT.DOCUMENT_TYPE_ID
273: and SUBB.LANGUAGE = SUBT.SOURCE_LANGUAGE
274: and (SUBB.DOCUMENT_TYPE <> SUBT.DOCUMENT_TYPE
275: ));

Line 277: insert into HR_DOCUMENT_TYPES_TL (

273: and SUBB.LANGUAGE = SUBT.SOURCE_LANGUAGE
274: and (SUBB.DOCUMENT_TYPE <> SUBT.DOCUMENT_TYPE
275: ));
276:
277: insert into HR_DOCUMENT_TYPES_TL (
278: DOCUMENT_TYPE_ID,
279: DOCUMENT_TYPE,
280: DESCRIPTION,
281: CREATED_BY,

Line 299: from HR_DOCUMENT_TYPES_TL B, FND_LANGUAGES L

295: B.LAST_UPDATE_DATE,
296: B.LAST_UPDATE_LOGIN,
297: L.LANGUAGE_CODE,
298: B.SOURCE_LANGUAGE
299: from HR_DOCUMENT_TYPES_TL B, FND_LANGUAGES L
300: where L.INSTALLED_FLAG in ('I', 'B')
301: and B.LANGUAGE = userenv('LANG')
302: and not exists
303: (select NULL

Line 304: from HR_DOCUMENT_TYPES_TL T

300: where L.INSTALLED_FLAG in ('I', 'B')
301: and B.LANGUAGE = userenv('LANG')
302: and not exists
303: (select NULL
304: from HR_DOCUMENT_TYPES_TL T
305: where T.DOCUMENT_TYPE_ID = B.DOCUMENT_TYPE_ID
306: and T.LANGUAGE = L.LANGUAGE_CODE);
307: end ADD_LANGUAGE;
308:

Line 419: update HR_DOCUMENT_TYPES_TL

415: X_LAST_UPDATED_BY,
416: X_LAST_UPDATE_LOGIN
417: );
418: --
419: update HR_DOCUMENT_TYPES_TL
420: set DOCUMENT_TYPE = X_DOCUMENT_TYPE,
421: DESCRIPTION = X_DESCRIPTION,
422: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
423: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 431: end HR_DOCUMENT_TYPES_PKG;

427: and userenv('LANG') in (LANGUAGE,SOURCE_LANGUAGE);
428:
429: end TRANSLATE_ROW;
430: --
431: end HR_DOCUMENT_TYPES_PKG;