APPS.PER_JBT_SHD dependencies on PER_JOBS

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

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

48: job_id
49: ,language
50: ,source_lang
51: ,name
52: from per_jobs_tl
53: where job_id = p_job_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from per_jobs_tl

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

Line 164: fnd_message.set_token('TABLE_NAME', 'per_jobs_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_jobs_tl');
165: fnd_message.raise_error;
166: End lck;
167: --
168: -- ----------------------------------------------------------------------------

Line 188: from per_jobs job

184: , l.language_code
185: , jbt.source_lang
186: , l.nls_language
187: , jbt.name
188: from per_jobs job
189: , per_job_definitions jb
190: , per_jobs_tl jbt
191: , fnd_languages l
192: where job.job_definition_id = jb.job_definition_id

Line 190: , per_jobs_tl jbt

186: , l.nls_language
187: , jbt.name
188: from per_jobs job
189: , per_job_definitions jb
190: , per_jobs_tl jbt
191: , fnd_languages l
192: where job.job_definition_id = jb.job_definition_id
193: and job.job_id = jbt.job_id
194: and jbt.language = userenv('LANG')

Line 197: from per_jobs_tl t

193: and job.job_id = jbt.job_id
194: and jbt.language = userenv('LANG')
195: and l.installed_flag in ('I', 'B')
196: and not exists (select null
197: from per_jobs_tl t
198: where t.job_id = jbt.job_id
199: and t.language = l.language_code)
200: order by l.language_code;
201: --

Line 212: delete from PER_JOBS_TL T

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

Line 215: from PER_JOBS B

211: --
212: delete from PER_JOBS_TL T
213: where not exists
214: (select NULL
215: from PER_JOBS B
216: where B.JOB_ID = T.JOB_ID
217: );
218: --
219: --

Line 235: insert into per_jobs_tl (

231: l_current_nls_language := l_jobs_tl.nls_language;
232:
233: End if;
234: --
235: insert into per_jobs_tl (
236: job_id
237: , name
238: , created_by
239: , creation_date