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.PER_PCL_SHD dependencies on PER_CAGR_ENTITLEMENT_LINES_F

Line 227: If (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK1') Then

223: l_proc varchar2(72) := g_package||'constraint_error';
224: --
225: Begin
226: --
227: If (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK1') Then
228: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
229: fnd_message.set_token('PROCEDURE', l_proc);
230: fnd_message.set_token('STEP','5');
231: fnd_message.raise_error;

Line 232: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK2') Then

228: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
229: fnd_message.set_token('PROCEDURE', l_proc);
230: fnd_message.set_token('STEP','5');
231: fnd_message.raise_error;
232: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK2') Then
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','10');
236: fnd_message.raise_error;

Line 281: from per_cagr_entitlement_lines_f

277: ,oipl_id
278: ,object_version_number
279: ,grade_spine_id
280: ,eligy_prfl_id
281: from per_cagr_entitlement_lines_f
282: where cagr_entitlement_line_id = p_cagr_entitlement_line_id
283: and p_effective_date
284: between effective_start_date and effective_end_date;
285: --

Line 357: ,p_base_table_name => 'per_cagr_entitlement_lines_f'

353: -- Call the corresponding datetrack api
354: --
355: dt_api.find_dt_upd_modes
356: (p_effective_date => p_effective_date
357: ,p_base_table_name => 'per_cagr_entitlement_lines_f'
358: ,p_base_key_column => 'cagr_entitlement_line_id'
359: ,p_base_key_value => p_base_key_value
360: ,p_correction => p_correction
361: ,p_update => p_update

Line 394: from per_cagr_entitlement_lines_f t

390: t.grade_spine_id
391: ,t.step_id
392: ,t.from_step_id
393: ,t.to_step_id
394: from per_cagr_entitlement_lines_f t
395: where t.cagr_entitlement_line_id = p_base_key_value
396: and p_effective_date
397: between t.effective_start_date and t.effective_end_date;
398: --

Line 420: ,p_base_table_name => 'per_cagr_entitlement_lines_f'

416: -- Call the corresponding datetrack api
417: --
418: dt_api.find_dt_del_modes
419: (p_effective_date => p_effective_date
420: ,p_base_table_name => 'per_cagr_entitlement_lines_f'
421: ,p_base_key_column => 'cagr_entitlement_line_id'
422: ,p_base_key_value => p_base_key_value
423: ,p_parent_table_name1 => 'per_grade_spines_f'
424: ,p_parent_key_column1 => 'grade_spine_id'

Line 467: (p_base_table_name => 'per_cagr_entitlement_lines_f'

463: -- version number.
464: --
465: l_object_version_number :=
466: dt_api.get_object_version_number
467: (p_base_table_name => 'per_cagr_entitlement_lines_f'
468: ,p_base_key_column => 'cagr_entitlement_line_id'
469: ,p_base_key_value => p_base_key_value
470: );
471: --

Line 478: update per_cagr_entitlement_lines_f t

474: --
475: -- Update the specified datetrack row setting the effective
476: -- end date to the specified new effective end date.
477: --
478: update per_cagr_entitlement_lines_f t
479: set t.effective_end_date = p_new_effective_end_date
480: , t.object_version_number = l_object_version_number
481: where t.cagr_entitlement_line_id = p_base_key_value
482: and p_effective_date

Line 530: from per_cagr_entitlement_lines_f

526: ,oipl_id
527: ,object_version_number
528: ,grade_spine_id
529: ,eligy_prfl_id
530: from per_cagr_entitlement_lines_f
531: where cagr_entitlement_line_id = p_cagr_entitlement_line_id
532: and p_effective_date
533: between effective_start_date and effective_end_date
534: for update nowait;

Line 593: ,p_base_table_name => 'per_cagr_entitlement_lines_f'

589: --
590: dt_api.validate_dt_mode
591: (p_effective_date => p_effective_date
592: ,p_datetrack_mode => p_datetrack_mode
593: ,p_base_table_name => 'per_cagr_entitlement_lines_f'
594: ,p_base_key_column => 'cagr_entitlement_line_id'
595: ,p_base_key_value => p_cagr_entitlement_line_id
596: ,p_parent_table_name1 => 'per_grade_spines_f'
597: ,p_parent_key_column1 => 'grade_spine_id'

Line 640: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlement_lines_f');

636: -- The object is locked therefore we need to supply a meaningful
637: -- error message.
638: --
639: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
640: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlement_lines_f');
641: fnd_message.raise_error;
642: End lck;
643: --
644: -- ----------------------------------------------------------------------------