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.HR_PSF_INS dependencies on HR_ALL_POSITIONS_F

Line 90: from hr_all_positions_f t

86: --
87: Cursor C_Sel1 Is
88: select t.created_by,
89: t.creation_date
90: from hr_all_positions_f t
91: where t.position_id = p_rec.position_id
92: and t.effective_start_date =
93: hr_psf_shd.g_old_rec.effective_start_date
94: and t.effective_end_date = (p_validation_start_date - 1);

Line 97: l_created_by hr_all_positions_f.created_by%TYPE;

93: hr_psf_shd.g_old_rec.effective_start_date
94: and t.effective_end_date = (p_validation_start_date - 1);
95: --
96: l_proc varchar2(72) ;
97: l_created_by hr_all_positions_f.created_by%TYPE;
98: l_creation_date hr_all_positions_f.creation_date%TYPE;
99: l_last_update_date hr_all_positions_f.last_update_date%TYPE;
100: l_last_updated_by hr_all_positions_f.last_updated_by%TYPE;
101: l_last_update_login hr_all_positions_f.last_update_login%TYPE;

Line 98: l_creation_date hr_all_positions_f.creation_date%TYPE;

94: and t.effective_end_date = (p_validation_start_date - 1);
95: --
96: l_proc varchar2(72) ;
97: l_created_by hr_all_positions_f.created_by%TYPE;
98: l_creation_date hr_all_positions_f.creation_date%TYPE;
99: l_last_update_date hr_all_positions_f.last_update_date%TYPE;
100: l_last_updated_by hr_all_positions_f.last_updated_by%TYPE;
101: l_last_update_login hr_all_positions_f.last_update_login%TYPE;
102: --

Line 99: l_last_update_date hr_all_positions_f.last_update_date%TYPE;

95: --
96: l_proc varchar2(72) ;
97: l_created_by hr_all_positions_f.created_by%TYPE;
98: l_creation_date hr_all_positions_f.creation_date%TYPE;
99: l_last_update_date hr_all_positions_f.last_update_date%TYPE;
100: l_last_updated_by hr_all_positions_f.last_updated_by%TYPE;
101: l_last_update_login hr_all_positions_f.last_update_login%TYPE;
102: --
103: Begin

Line 100: l_last_updated_by hr_all_positions_f.last_updated_by%TYPE;

96: l_proc varchar2(72) ;
97: l_created_by hr_all_positions_f.created_by%TYPE;
98: l_creation_date hr_all_positions_f.creation_date%TYPE;
99: l_last_update_date hr_all_positions_f.last_update_date%TYPE;
100: l_last_updated_by hr_all_positions_f.last_updated_by%TYPE;
101: l_last_update_login hr_all_positions_f.last_update_login%TYPE;
102: --
103: Begin
104: if g_debug then

Line 101: l_last_update_login hr_all_positions_f.last_update_login%TYPE;

97: l_created_by hr_all_positions_f.created_by%TYPE;
98: l_creation_date hr_all_positions_f.creation_date%TYPE;
99: l_last_update_date hr_all_positions_f.last_update_date%TYPE;
100: l_last_updated_by hr_all_positions_f.last_updated_by%TYPE;
101: l_last_update_login hr_all_positions_f.last_update_login%TYPE;
102: --
103: Begin
104: if g_debug then
105: l_proc := g_package||'dt_insert_dml';

Line 113: (p_base_table_name => 'hr_all_positions_f',

109: -- Get the object version number for the insert
110: --
111: p_rec.object_version_number :=
112: dt_api.get_object_version_number
113: (p_base_table_name => 'hr_all_positions_f',
114: p_base_key_column => 'position_id',
115: p_base_key_value => p_rec.position_id);
116: --
117: -- Set the effective start and end dates to the corresponding

Line 156: -- Insert the row into: hr_all_positions_f

152: l_last_update_login := fnd_global.login_id;
153: End If;
154: --
155: --
156: -- Insert the row into: hr_all_positions_f
157: --
158: insert into hr_all_positions_f
159: ( position_id,
160: effective_start_date,

Line 158: insert into hr_all_positions_f

154: --
155: --
156: -- Insert the row into: hr_all_positions_f
157: --
158: insert into hr_all_positions_f
159: ( position_id,
160: effective_start_date,
161: effective_end_date,
162: availability_status_id,

Line 530: cursor C_Sel1 is select hr_all_positions_f_s.nextval from sys.dual;

526: p_validation_end_date in date) is
527: --
528: l_proc varchar2(72);
529: --
530: cursor C_Sel1 is select hr_all_positions_f_s.nextval from sys.dual;
531: --
532: --
533: Begin
534: if g_debug then

Line 814: p_base_table_name => 'hr_all_positions_f',

810: --
811: dt_api.validate_dt_mode
812: (p_effective_date => p_effective_date,
813: p_datetrack_mode => p_datetrack_mode,
814: p_base_table_name => 'hr_all_positions_f',
815: p_base_key_column => 'position_id',
816: p_base_key_value => p_rec.position_id,
817: p_parent_table_name1 => 'hr_all_positions_f',
818: p_parent_key_column1 => 'successor_position_id',

Line 817: p_parent_table_name1 => 'hr_all_positions_f',

813: p_datetrack_mode => p_datetrack_mode,
814: p_base_table_name => 'hr_all_positions_f',
815: p_base_key_column => 'position_id',
816: p_base_key_value => p_rec.position_id,
817: p_parent_table_name1 => 'hr_all_positions_f',
818: p_parent_key_column1 => 'successor_position_id',
819: p_parent_key_value1 => p_rec.position_id,
820: p_parent_table_name2 => 'hr_all_positions_f',
821: p_parent_key_column2 => 'supervisor_position_id',

Line 820: p_parent_table_name2 => 'hr_all_positions_f',

816: p_base_key_value => p_rec.position_id,
817: p_parent_table_name1 => 'hr_all_positions_f',
818: p_parent_key_column1 => 'successor_position_id',
819: p_parent_key_value1 => p_rec.position_id,
820: p_parent_table_name2 => 'hr_all_positions_f',
821: p_parent_key_column2 => 'supervisor_position_id',
822: p_parent_key_value2 => p_rec.position_id,
823: p_parent_table_name3 => 'hr_all_positions_f',
824: p_parent_key_column3 => 'relief_position_id',

Line 823: p_parent_table_name3 => 'hr_all_positions_f',

819: p_parent_key_value1 => p_rec.position_id,
820: p_parent_table_name2 => 'hr_all_positions_f',
821: p_parent_key_column2 => 'supervisor_position_id',
822: p_parent_key_value2 => p_rec.position_id,
823: p_parent_table_name3 => 'hr_all_positions_f',
824: p_parent_key_column3 => 'relief_position_id',
825: p_parent_key_value3 => p_rec.position_id,
826: /* p_parent_table_name4 => 'hr_all_positions_f',
827: p_parent_key_column4 => 'position_id',

Line 826: /* p_parent_table_name4 => 'hr_all_positions_f',

822: p_parent_key_value2 => p_rec.position_id,
823: p_parent_table_name3 => 'hr_all_positions_f',
824: p_parent_key_column3 => 'relief_position_id',
825: p_parent_key_value3 => p_rec.position_id,
826: /* p_parent_table_name4 => 'hr_all_positions_f',
827: p_parent_key_column4 => 'position_id',
828: p_parent_key_value4 => p_rec.position_id,
829: */
830: p_enforce_foreign_locking => true,