APPS.HR_DTT_SHD dependencies on HR_DOCUMENT_TYPES_TL

Line 21: If (p_constraint_name = 'HR_DOCUMENT_TYPES_TL_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'HR_DOCUMENT_TYPES_TL_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 53: from hr_document_types_tl

49: ,language
50: ,source_language
51: ,document_type
52: ,description
53: from hr_document_types_tl
54: where document_type_id = p_document_type_id
55: and language = p_language;
56: --
57: l_fct_ret boolean;

Line 120: from hr_document_types_tl

116: ,language
117: ,source_language
118: ,document_type
119: ,description
120: from hr_document_types_tl
121: where document_type_id = p_document_type_id
122: and language = p_language
123: for update nowait;
124: --

Line 166: fnd_message.set_token('TABLE_NAME', 'hr_document_types_tl');

162: -- The object is locked therefore we need to supply a meaningful
163: -- error message.
164: --
165: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
166: fnd_message.set_token('TABLE_NAME', 'hr_document_types_tl');
167: fnd_message.raise_error;
168: End lck;
169: --
170: -- ----------------------------------------------------------------------------

Line 176: delete from HR_DOCUMENT_TYPES_TL T

172: -- ----------------------------------------------------------------------------
173: procedure ADD_LANGUAGE
174: is
175: begin
176: delete from HR_DOCUMENT_TYPES_TL T
177: where not exists
178: (select NULL
179: from HR_DOCUMENT_TYPES B
180: where B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID

Line 183: update HR_DOCUMENT_TYPES_TL T set (

179: from HR_DOCUMENT_TYPES B
180: where B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID
181: );
182:
183: update HR_DOCUMENT_TYPES_TL T set (
184: DOCUMENT_TYPE,
185: DESCRIPTION
186: ) = (select
187: B.DOCUMENT_TYPE,

Line 189: from HR_DOCUMENT_TYPES_TL B

185: DESCRIPTION
186: ) = (select
187: B.DOCUMENT_TYPE,
188: B.DESCRIPTION
189: from HR_DOCUMENT_TYPES_TL B
190: where B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID
191: and B.LANGUAGE = T.SOURCE_LANGUAGE)
192: where (
193: T.DOCUMENT_TYPE_ID,

Line 198: from HR_DOCUMENT_TYPES_TL SUBB, HR_DOCUMENT_TYPES_TL SUBT

194: T.LANGUAGE
195: ) in (select
196: SUBT.DOCUMENT_TYPE_ID,
197: SUBT.LANGUAGE
198: from HR_DOCUMENT_TYPES_TL SUBB, HR_DOCUMENT_TYPES_TL SUBT
199: where SUBB.DOCUMENT_TYPE_ID = SUBT.DOCUMENT_TYPE_ID
200: and SUBB.LANGUAGE = SUBT.SOURCE_LANGUAGE
201: and (SUBB.DOCUMENT_TYPE <> SUBT.DOCUMENT_TYPE
202: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 207: insert into HR_DOCUMENT_TYPES_TL (

203: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
204: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
205: ));
206:
207: insert into HR_DOCUMENT_TYPES_TL (
208: DOCUMENT_TYPE_ID,
209: DOCUMENT_TYPE,
210: DESCRIPTION,
211: LAST_UPDATE_DATE,

Line 229: from HR_DOCUMENT_TYPES_TL B, FND_LANGUAGES L

225: B.CREATED_BY,
226: B.CREATION_DATE,
227: L.LANGUAGE_CODE,
228: B.SOURCE_LANGUAGE
229: from HR_DOCUMENT_TYPES_TL B, FND_LANGUAGES L
230: where L.INSTALLED_FLAG in ('I', 'B')
231: and B.LANGUAGE = userenv('LANG')
232: and not exists
233: (select NULL

Line 234: from HR_DOCUMENT_TYPES_TL T

230: where L.INSTALLED_FLAG in ('I', 'B')
231: and B.LANGUAGE = userenv('LANG')
232: and not exists
233: (select NULL
234: from HR_DOCUMENT_TYPES_TL T
235: where T.DOCUMENT_TYPE_ID = B.DOCUMENT_TYPE_ID
236: and T.LANGUAGE = L.LANGUAGE_CODE);
237: end ADD_LANGUAGE;
238: --