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 150: l_name hr_all_positions_f_tl.name%type;

146: l_dummy varchar2(10);
147: l_start_date date;
148: l_expiration_date date;
149: cnt number;
150: l_name hr_all_positions_f_tl.name%type;
151: --
152: l_action varchar2(30) := p_action;
153: l_eff_start_date date;
154: l_date_chk varchar2(10);

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

172: p_effective_end_date);
173:
174: if ((l_action = 'INSERT' and l_date_chk = 'CURRENT') or l_action is null or (l_action = 'UPDATE' and l_date_chk = 'CURRENT'))
175: then
176: select count(*) into cnt from hr_all_positions_f where position_id = l_position_id and availability_status_id = 1;
177: if cnt = 0 then
178: select hr_general.effective_date into l_expiration_date from dual;
179:
180: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);

Line 199: into l_start_date, l_expiration_date from hr_all_positions_f

195: p_expiration_date => l_expiration_date);
196: elsif ((l_action = 'INSERT' and l_date_chk = 'CURRENT') or (l_action = 'UPDATE' and l_date_chk = 'CURRENT'))
197: then
198: select min(effective_start_date), max(effective_end_date)
199: into l_start_date, l_expiration_date from hr_all_positions_f
200: where position_id = l_position_id and availability_status_id = 1;
201:
202: begin
203: select name into l_name from hr_all_positions_f_tl where position_id = l_position_id and language = userenv('LANG');

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

199: into l_start_date, l_expiration_date from hr_all_positions_f
200: where position_id = l_position_id and availability_status_id = 1;
201:
202: begin
203: select name into l_name from hr_all_positions_f_tl where position_id = l_position_id and language = userenv('LANG');
204: exception when others then
205: null;
206: end;
207:

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

275: l_proc := g_package||'constraint_error';
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: end if;
278: --
279: If (p_constraint_name = 'HR_ALL_POSITIONS_F_FK11') Then
280: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE', l_proc);
282: hr_utility.set_message_token('STEP','5');
283: hr_utility.raise_error;

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

280: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE', l_proc);
282: hr_utility.set_message_token('STEP','5');
283: hr_utility.raise_error;
284: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
285: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
286: hr_utility.set_message_token('PROCEDURE', l_proc);
287: hr_utility.set_message_token('STEP','10');
288: hr_utility.raise_error;

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

285: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
286: hr_utility.set_message_token('PROCEDURE', l_proc);
287: hr_utility.set_message_token('STEP','10');
288: hr_utility.raise_error;
289: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
290: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
291: hr_utility.set_message_token('PROCEDURE', l_proc);
292: hr_utility.set_message_token('STEP','15');
293: hr_utility.raise_error;

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

290: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
291: hr_utility.set_message_token('PROCEDURE', l_proc);
292: hr_utility.set_message_token('STEP','15');
293: hr_utility.raise_error;
294: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
295: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE', l_proc);
297: hr_utility.set_message_token('STEP','20');
298: hr_utility.raise_error;

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

295: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE', l_proc);
297: hr_utility.set_message_token('STEP','20');
298: hr_utility.raise_error;
299: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
300: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
301: hr_utility.set_message_token('PROCEDURE', l_proc);
302: hr_utility.set_message_token('STEP','25');
303: hr_utility.raise_error;

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

300: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
301: hr_utility.set_message_token('PROCEDURE', l_proc);
302: hr_utility.set_message_token('STEP','25');
303: hr_utility.raise_error;
304: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
305: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE', l_proc);
307: hr_utility.set_message_token('STEP','30');
308: hr_utility.raise_error;

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

305: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE', l_proc);
307: hr_utility.set_message_token('STEP','30');
308: hr_utility.raise_error;
309: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
310: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
311: hr_utility.set_message_token('PROCEDURE', l_proc);
312: hr_utility.set_message_token('STEP','35');
313: hr_utility.raise_error;

Line 538: from hr_all_positions_f

534: program_id,
535: program_update_date,
536: object_version_number,
537: null
538: from hr_all_positions_f
539: where position_id = p_position_id
540: and p_effective_date
541: between effective_start_date and effective_end_date;
542: --

Line 626: from hr_all_positions_f t

622: Cursor C_Sel1 Is
623: select t.supervisor_position_id,
624: t.successor_position_id,
625: t.relief_position_id
626: from hr_all_positions_f t
627: where t.position_id = p_base_key_value
628: and p_effective_date
629: between t.effective_start_date and t.effective_end_date;
630: --

Line 654: p_base_table_name => 'hr_all_positions_f',

650: -- Call the corresponding datetrack api
651: --
652: dt_api.find_dt_del_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_parent_table_name1 => 'hr_all_positions_f',
658: p_parent_key_column1 => 'supervisor_position_id', --fix for bug# 10141151

Line 657: p_parent_table_name1 => 'hr_all_positions_f',

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_parent_table_name1 => 'hr_all_positions_f',
658: p_parent_key_column1 => 'supervisor_position_id', --fix for bug# 10141151
659: p_parent_key_value1 => l_parent_key_value1,
660: p_parent_table_name2 => 'hr_all_positions_f',
661: p_parent_key_column2 => 'successor_position_id', --fix for bug# 10141151

Line 660: p_parent_table_name2 => 'hr_all_positions_f',

656: p_base_key_value => p_base_key_value,
657: p_parent_table_name1 => 'hr_all_positions_f',
658: p_parent_key_column1 => 'supervisor_position_id', --fix for bug# 10141151
659: p_parent_key_value1 => l_parent_key_value1,
660: p_parent_table_name2 => 'hr_all_positions_f',
661: p_parent_key_column2 => 'successor_position_id', --fix for bug# 10141151
662: p_parent_key_value2 => l_parent_key_value2,
663: p_parent_table_name3 => 'hr_all_positions_f',
664: p_parent_key_column3 => 'relief_position_id', --fix for bug# 10141151

Line 663: p_parent_table_name3 => 'hr_all_positions_f',

659: p_parent_key_value1 => l_parent_key_value1,
660: p_parent_table_name2 => 'hr_all_positions_f',
661: p_parent_key_column2 => 'successor_position_id', --fix for bug# 10141151
662: p_parent_key_value2 => l_parent_key_value2,
663: p_parent_table_name3 => 'hr_all_positions_f',
664: p_parent_key_column3 => 'relief_position_id', --fix for bug# 10141151
665: p_parent_key_value3 => l_parent_key_value3,
666: p_zap => p_zap,
667: p_delete => p_delete,

Line 702: p_base_table_name => 'hr_all_positions_f',

698: -- Call the corresponding datetrack api
699: --
700: dt_api.find_dt_upd_modes
701: (p_effective_date => p_effective_date,
702: p_base_table_name => 'hr_all_positions_f',
703: p_base_key_column => 'position_id',
704: p_base_key_value => p_base_key_value,
705: p_correction => p_correction,
706: p_update => p_update,

Line 742: (p_base_table_name => 'hr_all_positions_f',

738: -- version number.
739: --
740: l_object_version_number :=
741: dt_api.get_object_version_number
742: (p_base_table_name => 'hr_all_positions_f',
743: p_base_key_column => 'position_id',
744: p_base_key_value => p_base_key_value);
745: --
746: if g_debug then

Line 753: update hr_all_positions_f t

749: --
750: -- Update the specified datetrack row setting the effective
751: -- end date to the specified new effective end date.
752: --
753: update hr_all_positions_f t
754: set t.effective_end_date = p_new_effective_end_date,
755: t.object_version_number = l_object_version_number
756: where t.position_id = p_base_key_value
757: and p_effective_date

Line 924: from hr_all_positions_f

920: program_id,
921: program_update_date,
922: object_version_number,
923: null
924: from hr_all_positions_f
925: where position_id = p_position_id
926: and p_effective_date
927: between effective_start_date and effective_end_date
928: for update nowait;

Line 1000: p_base_table_name => 'hr_all_positions_f',

996:
997: dt_api.validate_dt_mode
998: (p_effective_date => p_effective_date,
999: p_datetrack_mode => p_datetrack_mode,
1000: p_base_table_name => 'hr_all_positions_f',
1001: p_base_key_column => 'position_id',
1002: p_base_key_value => p_position_id,
1003: p_parent_table_name1 => 'hr_all_positions_f',
1004: p_parent_key_column1 => 'successor_position_id',

Line 1003: p_parent_table_name1 => 'hr_all_positions_f',

999: p_datetrack_mode => p_datetrack_mode,
1000: p_base_table_name => 'hr_all_positions_f',
1001: p_base_key_column => 'position_id',
1002: p_base_key_value => p_position_id,
1003: p_parent_table_name1 => 'hr_all_positions_f',
1004: p_parent_key_column1 => 'successor_position_id',
1005: p_parent_key_value1 => g_old_rec.successor_position_id,
1006: p_parent_table_name2 => 'hr_all_positions_f',
1007: p_parent_key_column2 => 'relief_position_id',

Line 1006: p_parent_table_name2 => 'hr_all_positions_f',

1002: p_base_key_value => p_position_id,
1003: p_parent_table_name1 => 'hr_all_positions_f',
1004: p_parent_key_column1 => 'successor_position_id',
1005: p_parent_key_value1 => g_old_rec.successor_position_id,
1006: p_parent_table_name2 => 'hr_all_positions_f',
1007: p_parent_key_column2 => 'relief_position_id',
1008: p_parent_key_value2 => g_old_rec.relief_position_id,
1009: p_parent_table_name3 => 'hr_all_positions_f',
1010: p_parent_key_column3 => 'supervisor_position_id',

Line 1009: p_parent_table_name3 => 'hr_all_positions_f',

1005: p_parent_key_value1 => g_old_rec.successor_position_id,
1006: p_parent_table_name2 => 'hr_all_positions_f',
1007: p_parent_key_column2 => 'relief_position_id',
1008: p_parent_key_value2 => g_old_rec.relief_position_id,
1009: p_parent_table_name3 => 'hr_all_positions_f',
1010: p_parent_key_column3 => 'supervisor_position_id',
1011: p_parent_key_value3 => g_old_rec.supervisor_position_id,
1012: /*
1013: p_child_table_name3 => 'hr_all_positions_f',

Line 1013: p_child_table_name3 => 'hr_all_positions_f',

1009: p_parent_table_name3 => 'hr_all_positions_f',
1010: p_parent_key_column3 => 'supervisor_position_id',
1011: p_parent_key_value3 => g_old_rec.supervisor_position_id,
1012: /*
1013: p_child_table_name3 => 'hr_all_positions_f',
1014: p_child_key_column3 => 'position_id',
1015: p_child_table_name4 => 'hr_all_positions_f',
1016: p_child_key_column4 => 'position_id',
1017: */

Line 1015: p_child_table_name4 => 'hr_all_positions_f',

1011: p_parent_key_value3 => g_old_rec.supervisor_position_id,
1012: /*
1013: p_child_table_name3 => 'hr_all_positions_f',
1014: p_child_key_column3 => 'position_id',
1015: p_child_table_name4 => 'hr_all_positions_f',
1016: p_child_key_column4 => 'position_id',
1017: */
1018: p_enforce_foreign_locking => true,
1019: p_validation_start_date => l_validation_start_date,

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

1047: -- The object is locked therefore we need to supply a meaningful
1048: -- error message.
1049: --
1050: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
1051: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1052: hr_utility.raise_error;
1053: When l_object_invalid then
1054: --
1055: -- The object doesn't exist or is invalid

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

1054: --
1055: -- The object doesn't exist or is invalid
1056: --
1057: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
1058: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1059: hr_utility.raise_error;
1060: End lck;
1061: --
1062: -- ----------------------------------------------------------------------------