APPS.HR_DOCUMENT_TYPES_PKG dependencies on HR_DOCUMENT_TYPES_TL

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 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 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 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,