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_ASG_INS dependencies on PER_ALL_ASSIGNMENTS_F

Line 91: from per_all_assignments_f asg

87: --
88: Cursor C_Sel1 Is
89: select asg.created_by,
90: asg.creation_date
91: from per_all_assignments_f asg
92: where asg.assignment_id = p_rec.assignment_id
93: and asg.effective_start_date =
94: per_asg_shd.g_old_rec.effective_start_date
95: and asg.effective_end_date = (p_validation_start_date - 1);

Line 98: l_created_by per_all_assignments_f.created_by%TYPE;

94: per_asg_shd.g_old_rec.effective_start_date
95: and asg.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by per_all_assignments_f.created_by%TYPE;
99: l_creation_date per_all_assignments_f.creation_date%TYPE;
100: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
101: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
102: l_last_update_login per_all_assignments_f.last_update_login%TYPE;

Line 99: l_creation_date per_all_assignments_f.creation_date%TYPE;

95: and asg.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by per_all_assignments_f.created_by%TYPE;
99: l_creation_date per_all_assignments_f.creation_date%TYPE;
100: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
101: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
102: l_last_update_login per_all_assignments_f.last_update_login%TYPE;
103: --

Line 100: l_last_update_date per_all_assignments_f.last_update_date%TYPE;

96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by per_all_assignments_f.created_by%TYPE;
99: l_creation_date per_all_assignments_f.creation_date%TYPE;
100: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
101: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
102: l_last_update_login per_all_assignments_f.last_update_login%TYPE;
103: --
104: Begin

Line 101: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;

97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by per_all_assignments_f.created_by%TYPE;
99: l_creation_date per_all_assignments_f.creation_date%TYPE;
100: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
101: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
102: l_last_update_login per_all_assignments_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);

Line 102: l_last_update_login per_all_assignments_f.last_update_login%TYPE;

98: l_created_by per_all_assignments_f.created_by%TYPE;
99: l_creation_date per_all_assignments_f.creation_date%TYPE;
100: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
101: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
102: l_last_update_login per_all_assignments_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --

Line 111: (p_base_table_name => 'per_all_assignments_f',

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

Line 153: -- Insert the row into: per_all_assignments_f

149: End If;
150: --
151: per_asg_shd.g_api_dml := true; -- Set the api dml status
152: --
153: -- Insert the row into: per_all_assignments_f
154: --
155: insert into per_all_assignments_f
156: ( assignment_id,
157: effective_start_date,

Line 155: insert into per_all_assignments_f

151: per_asg_shd.g_api_dml := true; -- Set the api dml status
152: --
153: -- Insert the row into: per_all_assignments_f
154: --
155: insert into per_all_assignments_f
156: ( assignment_id,
157: effective_start_date,
158: effective_end_date,
159: business_group_id,

Line 489: from per_all_assignments_f

485: Cursor C_Sel1 is select per_assignments_s.nextval from sys.dual;
486: --
487: Cursor C_Sel2 is
488: Select null
489: from per_all_assignments_f
490: where assignment_id =
491: per_asg_ins.g_assignment_id_i;
492: --
493: Begin

Line 510: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');

506: --
507: -- Bug 2661569
508: -- Changed the calls to hr_utility package.
509: hr_utility.set_message(800, 'PER_289391_KEY_ALREADY_USED');
510: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
511: hr_utility.raise_error;
512: End If;
513: Close C_Sel2;
514: --

Line 536: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',

532: -- Insert the comment text if comments exist
533: --
534: If (p_rec.comment_text is not null) then
535: hr_comm_api.ins(p_comment_id => p_rec.comment_id,
536: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',
537: p_comment_text => p_rec.comment_text);
538: End If;
539: hr_utility.set_location(l_proc, 20);
540: End If;

Line 723: from per_all_assignments_f

719: vendor_site_id,
720: po_header_id,
721: po_line_id,
722: projected_assignment_end
723: from per_all_assignments_f
724: where assignment_id = p_rec.assignment_id
725: and p_effective_date - 1 between effective_start_date
726: and effective_end_date;
727:

Line 730: from per_all_assignments_f

726: and effective_end_date;
727:
728: cursor c_asg_rowid is
729: select rowid
730: from per_all_assignments_f
731: where assignment_id = p_rec.assignment_id
732: and p_effective_date between effective_start_date
733: and effective_end_date;
734:

Line 943: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'

939: ,p_projected_assignment_end => p_rec.projected_assignment_end);
940: exception
941: when hr_api.cannot_find_prog_unit then
942: hr_api.cannot_find_prog_unit_error
943: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'
944: ,p_hook_type => 'AI'
945: );
946: end;
947: -- End of API User Hook for post_insert.

Line 1163: p_base_table_name => 'per_all_assignments_f',

1159:
1160: dt_api.validate_dt_mode
1161: (p_effective_date => p_effective_date,
1162: p_datetrack_mode => p_datetrack_mode,
1163: p_base_table_name => 'per_all_assignments_f',
1164: p_base_key_column => 'assignment_id',
1165: p_base_key_value => p_rec.assignment_id,
1166: p_parent_table_name1 => 'per_all_people_f',
1167: p_parent_key_column1 => 'person_id',