APPS.PER_GDT_SHD dependencies on PER_GRADES_TL

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PER_GRADES_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 52: from per_grades_tl

48: grade_id
49: ,language
50: ,source_lang
51: ,name
52: from per_grades_tl
53: where grade_id = p_grade_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from per_grades_tl

114: grade_id
115: ,language
116: ,source_lang
117: ,name
118: from per_grades_tl
119: where grade_id = p_grade_id
120: and language = p_language
121: for update nowait;
122: --

Line 164: fnd_message.set_token('TABLE_NAME', 'per_grades_tl');

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

Line 191: , per_grades_tl gdt

187: , l.nls_language
188: , gdt.name
189: from per_grades grd
190: , per_grade_definitions gd
191: , per_grades_tl gdt
192: , fnd_languages l
193: where grd.grade_definition_id = gd.grade_definition_id
194: and grd.grade_id = gdt.grade_id
195: and gdt.language = userenv('LANG')

Line 198: from per_grades_tl t

194: and grd.grade_id = gdt.grade_id
195: and gdt.language = userenv('LANG')
196: and l.installed_flag in ('I', 'B')
197: and not exists (select null
198: from per_grades_tl t
199: where t.grade_id = gdt.grade_id
200: and t.language = l.language_code)
201: order by l.language_code;
202: --

Line 213: delete from PER_GRADES_TL T

209: Begin
210: --
211: hr_utility.set_location('Entering:'||l_proc, 5);
212: --
213: delete from PER_GRADES_TL T
214: where not exists
215: (select NULL
216: from PER_GRADES B
217: where B.GRADE_ID = T.GRADE_ID

Line 236: insert into per_grades_tl (

232: l_current_nls_language := l_grades_tl.nls_language;
233:
234: End if;
235: --
236: insert into per_grades_tl (
237: grade_id
238: , name
239: , created_by
240: , creation_date