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_SHD dependencies on HR_ALL_POSITIONS_F

Line 37: from hr_all_positions_f

33: p_job_id out nocopy number,
34: p_organization_id out nocopy number
35: ) is
36: cursor c1 is select job_id, organization_id
37: from hr_all_positions_f
38: where position_id = p_position_id
39: and p_effective_date
40: between effective_start_date
41: and effective_end_date;

Line 59: from per_shared_types sht, hr_all_positions_f psf

55: p_effective_date date) return varchar2 is
56: --
57: cursor csr_lookup is
58: select system_type_cd
59: from per_shared_types sht, hr_all_positions_f psf
60: where shared_type_id = psf.availability_status_id
61: and psf.position_id = p_position_id
62: and p_effective_date between psf.effective_start_date and psf.effective_end_date;
63: --

Line 142: l_name hr_all_positions_f_tl.name%type;

138: l_dummy varchar2(10);
139: l_start_date date;
140: l_expiration_date date;
141: cnt number;
142: l_name hr_all_positions_f_tl.name%type;
143: --
144: begin
145: --
146: g_debug := hr_utility.debug_enabled;

Line 152: select count(*) into cnt from hr_all_positions_f where position_id = l_position_id and availability_status_id = 1;

148: l_proc := g_package||'MY_SYNC_ROUTINE';
149: hr_utility.set_location('Before calling WF_SYNC package:'||l_proc, 30);
150: end if;
151:
152: select count(*) into cnt from hr_all_positions_f where position_id = l_position_id and availability_status_id = 1;
153: if cnt = 0 then
154: select hr_general.effective_date into l_expiration_date from dual;
155:
156: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);

Line 174: into l_start_date, l_expiration_date from hr_all_positions_f

170: p_attributes => l_plist,
171: p_expiration_date => l_expiration_date);
172: else
173: select min(effective_start_date), max(effective_end_date)
174: into l_start_date, l_expiration_date from hr_all_positions_f
175: where position_id = l_position_id and availability_status_id = 1;
176:
177: begin
178: select name into l_name from hr_all_positions_f_tl where position_id = l_position_id and language = userenv('LANG');

Line 178: select name into l_name from hr_all_positions_f_tl where position_id = l_position_id and language = userenv('LANG');

174: into l_start_date, l_expiration_date from hr_all_positions_f
175: where position_id = l_position_id and availability_status_id = 1;
176:
177: begin
178: select name into l_name from hr_all_positions_f_tl where position_id = l_position_id and language = userenv('LANG');
179: exception when others then
180: null;
181: end;
182:

Line 231: If (p_constraint_name = 'HR_ALL_POSITIONS_F_FK11') Then

227: l_proc := g_package||'constraint_error';
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: end if;
230: --
231: If (p_constraint_name = 'HR_ALL_POSITIONS_F_FK11') Then
232: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE', l_proc);
234: hr_utility.set_message_token('STEP','5');
235: hr_utility.raise_error;

Line 236: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then

232: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE', l_proc);
234: hr_utility.set_message_token('STEP','5');
235: hr_utility.raise_error;
236: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
237: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE', l_proc);
239: hr_utility.set_message_token('STEP','10');
240: hr_utility.raise_error;

Line 241: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then

237: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE', l_proc);
239: hr_utility.set_message_token('STEP','10');
240: hr_utility.raise_error;
241: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
242: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;

Line 246: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then

242: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
247: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
248: hr_utility.set_message_token('PROCEDURE', l_proc);
249: hr_utility.set_message_token('STEP','20');
250: hr_utility.raise_error;

Line 251: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then

247: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
248: hr_utility.set_message_token('PROCEDURE', l_proc);
249: hr_utility.set_message_token('STEP','20');
250: hr_utility.raise_error;
251: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
252: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE', l_proc);
254: hr_utility.set_message_token('STEP','25');
255: hr_utility.raise_error;

Line 256: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then

252: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE', l_proc);
254: hr_utility.set_message_token('STEP','25');
255: hr_utility.raise_error;
256: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
257: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
258: hr_utility.set_message_token('PROCEDURE', l_proc);
259: hr_utility.set_message_token('STEP','30');
260: hr_utility.raise_error;

Line 261: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then

257: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
258: hr_utility.set_message_token('PROCEDURE', l_proc);
259: hr_utility.set_message_token('STEP','30');
260: hr_utility.raise_error;
261: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
262: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
263: hr_utility.set_message_token('PROCEDURE', l_proc);
264: hr_utility.set_message_token('STEP','35');
265: hr_utility.raise_error;

Line 490: from hr_all_positions_f

486: program_id,
487: program_update_date,
488: object_version_number,
489: null
490: from hr_all_positions_f
491: where position_id = p_position_id
492: and p_effective_date
493: between effective_start_date and effective_end_date;
494: --

Line 578: from hr_all_positions_f t

574: Cursor C_Sel1 Is
575: select t.supervisor_position_id,
576: t.successor_position_id,
577: t.relief_position_id
578: from hr_all_positions_f t
579: where t.position_id = p_base_key_value
580: and p_effective_date
581: between t.effective_start_date and t.effective_end_date;
582: --

Line 606: p_base_table_name => 'hr_all_positions_f',

602: -- Call the corresponding datetrack api
603: --
604: dt_api.find_dt_del_modes
605: (p_effective_date => p_effective_date,
606: p_base_table_name => 'hr_all_positions_f',
607: p_base_key_column => 'position_id',
608: p_base_key_value => p_base_key_value,
609: p_parent_table_name1 => 'hr_all_positions_f',
610: p_parent_key_column1 => 'successor_position_id',

Line 609: p_parent_table_name1 => 'hr_all_positions_f',

605: (p_effective_date => p_effective_date,
606: p_base_table_name => 'hr_all_positions_f',
607: p_base_key_column => 'position_id',
608: p_base_key_value => p_base_key_value,
609: p_parent_table_name1 => 'hr_all_positions_f',
610: p_parent_key_column1 => 'successor_position_id',
611: p_parent_key_value1 => l_parent_key_value1,
612: p_parent_table_name2 => 'hr_all_positions_f',
613: p_parent_key_column2 => 'relief_position_id',

Line 612: p_parent_table_name2 => 'hr_all_positions_f',

608: p_base_key_value => p_base_key_value,
609: p_parent_table_name1 => 'hr_all_positions_f',
610: p_parent_key_column1 => 'successor_position_id',
611: p_parent_key_value1 => l_parent_key_value1,
612: p_parent_table_name2 => 'hr_all_positions_f',
613: p_parent_key_column2 => 'relief_position_id',
614: p_parent_key_value2 => l_parent_key_value2,
615: p_parent_table_name3 => 'hr_all_positions_f',
616: p_parent_key_column3 => 'supervisor_position_id',

Line 615: p_parent_table_name3 => 'hr_all_positions_f',

611: p_parent_key_value1 => l_parent_key_value1,
612: p_parent_table_name2 => 'hr_all_positions_f',
613: p_parent_key_column2 => 'relief_position_id',
614: p_parent_key_value2 => l_parent_key_value2,
615: p_parent_table_name3 => 'hr_all_positions_f',
616: p_parent_key_column3 => 'supervisor_position_id',
617: p_parent_key_value3 => l_parent_key_value3,
618: p_zap => p_zap,
619: p_delete => p_delete,

Line 654: p_base_table_name => 'hr_all_positions_f',

650: -- Call the corresponding datetrack api
651: --
652: dt_api.find_dt_upd_modes
653: (p_effective_date => p_effective_date,
654: p_base_table_name => 'hr_all_positions_f',
655: p_base_key_column => 'position_id',
656: p_base_key_value => p_base_key_value,
657: p_correction => p_correction,
658: p_update => p_update,

Line 694: (p_base_table_name => 'hr_all_positions_f',

690: -- version number.
691: --
692: l_object_version_number :=
693: dt_api.get_object_version_number
694: (p_base_table_name => 'hr_all_positions_f',
695: p_base_key_column => 'position_id',
696: p_base_key_value => p_base_key_value);
697: --
698: if g_debug then

Line 705: update hr_all_positions_f t

701: --
702: -- Update the specified datetrack row setting the effective
703: -- end date to the specified new effective end date.
704: --
705: update hr_all_positions_f t
706: set t.effective_end_date = p_new_effective_end_date,
707: t.object_version_number = l_object_version_number
708: where t.position_id = p_base_key_value
709: and p_effective_date

Line 876: from hr_all_positions_f

872: program_id,
873: program_update_date,
874: object_version_number,
875: null
876: from hr_all_positions_f
877: where position_id = p_position_id
878: and p_effective_date
879: between effective_start_date and effective_end_date
880: for update nowait;

Line 952: p_base_table_name => 'hr_all_positions_f',

948:
949: dt_api.validate_dt_mode
950: (p_effective_date => p_effective_date,
951: p_datetrack_mode => p_datetrack_mode,
952: p_base_table_name => 'hr_all_positions_f',
953: p_base_key_column => 'position_id',
954: p_base_key_value => p_position_id,
955: p_parent_table_name1 => 'hr_all_positions_f',
956: p_parent_key_column1 => 'successor_position_id',

Line 955: p_parent_table_name1 => 'hr_all_positions_f',

951: p_datetrack_mode => p_datetrack_mode,
952: p_base_table_name => 'hr_all_positions_f',
953: p_base_key_column => 'position_id',
954: p_base_key_value => p_position_id,
955: p_parent_table_name1 => 'hr_all_positions_f',
956: p_parent_key_column1 => 'successor_position_id',
957: p_parent_key_value1 => g_old_rec.successor_position_id,
958: p_parent_table_name2 => 'hr_all_positions_f',
959: p_parent_key_column2 => 'relief_position_id',

Line 958: p_parent_table_name2 => 'hr_all_positions_f',

954: p_base_key_value => p_position_id,
955: p_parent_table_name1 => 'hr_all_positions_f',
956: p_parent_key_column1 => 'successor_position_id',
957: p_parent_key_value1 => g_old_rec.successor_position_id,
958: p_parent_table_name2 => 'hr_all_positions_f',
959: p_parent_key_column2 => 'relief_position_id',
960: p_parent_key_value2 => g_old_rec.relief_position_id,
961: p_parent_table_name3 => 'hr_all_positions_f',
962: p_parent_key_column3 => 'supervisor_position_id',

Line 961: p_parent_table_name3 => 'hr_all_positions_f',

957: p_parent_key_value1 => g_old_rec.successor_position_id,
958: p_parent_table_name2 => 'hr_all_positions_f',
959: p_parent_key_column2 => 'relief_position_id',
960: p_parent_key_value2 => g_old_rec.relief_position_id,
961: p_parent_table_name3 => 'hr_all_positions_f',
962: p_parent_key_column3 => 'supervisor_position_id',
963: p_parent_key_value3 => g_old_rec.supervisor_position_id,
964: /*
965: p_child_table_name3 => 'hr_all_positions_f',

Line 965: p_child_table_name3 => 'hr_all_positions_f',

961: p_parent_table_name3 => 'hr_all_positions_f',
962: p_parent_key_column3 => 'supervisor_position_id',
963: p_parent_key_value3 => g_old_rec.supervisor_position_id,
964: /*
965: p_child_table_name3 => 'hr_all_positions_f',
966: p_child_key_column3 => 'position_id',
967: p_child_table_name4 => 'hr_all_positions_f',
968: p_child_key_column4 => 'position_id',
969: */

Line 967: p_child_table_name4 => 'hr_all_positions_f',

963: p_parent_key_value3 => g_old_rec.supervisor_position_id,
964: /*
965: p_child_table_name3 => 'hr_all_positions_f',
966: p_child_key_column3 => 'position_id',
967: p_child_table_name4 => 'hr_all_positions_f',
968: p_child_key_column4 => 'position_id',
969: */
970: p_enforce_foreign_locking => true,
971: p_validation_start_date => l_validation_start_date,

Line 1003: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');

999: -- The object is locked therefore we need to supply a meaningful
1000: -- error message.
1001: --
1002: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
1003: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1004: hr_utility.raise_error;
1005: When l_object_invalid then
1006: --
1007: -- The object doesn't exist or is invalid

Line 1010: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');

1006: --
1007: -- The object doesn't exist or is invalid
1008: --
1009: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
1010: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1011: hr_utility.raise_error;
1012: End lck;
1013: --
1014: -- ----------------------------------------------------------------------------