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_PER_INS dependencies on PER_ALL_PEOPLE_F

Line 92: from per_all_people_f t

88: --
89: Cursor C_Sel1 Is
90: select t.created_by,
91: t.creation_date
92: from per_all_people_f t
93: where t.person_id = p_rec.person_id
94: and t.effective_start_date =
95: per_per_shd.g_old_rec.effective_start_date
96: and t.effective_end_date = (p_validation_start_date - 1);

Line 99: l_created_by per_all_people_f.created_by%TYPE;

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

Line 100: l_creation_date per_all_people_f.creation_date%TYPE;

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

Line 101: l_last_update_date per_all_people_f.last_update_date%TYPE;

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

Line 102: l_last_updated_by per_all_people_f.last_updated_by%TYPE;

98: l_proc varchar2(72) := g_package||'dt_insert_dml';
99: l_created_by per_all_people_f.created_by%TYPE;
100: l_creation_date per_all_people_f.creation_date%TYPE;
101: l_last_update_date per_all_people_f.last_update_date%TYPE;
102: l_last_updated_by per_all_people_f.last_updated_by%TYPE;
103: l_last_update_login per_all_people_f.last_update_login%TYPE;
104: --
105: cursor c1 is
106: select *

Line 103: l_last_update_login per_all_people_f.last_update_login%TYPE;

99: l_created_by per_all_people_f.created_by%TYPE;
100: l_creation_date per_all_people_f.creation_date%TYPE;
101: l_last_update_date per_all_people_f.last_update_date%TYPE;
102: l_last_updated_by per_all_people_f.last_updated_by%TYPE;
103: l_last_update_login per_all_people_f.last_update_login%TYPE;
104: --
105: cursor c1 is
106: select *
107: from per_all_people_f

Line 107: from per_all_people_f

103: l_last_update_login per_all_people_f.last_update_login%TYPE;
104: --
105: cursor c1 is
106: select *
107: from per_all_people_f
108: where person_id = p_rec.person_id
109: and p_effective_date
110: between effective_start_date
111: and effective_end_date;

Line 113: l_person per_all_people_f%rowtype;

109: and p_effective_date
110: between effective_start_date
111: and effective_end_date;
112: --
113: l_person per_all_people_f%rowtype;
114: --
115: Begin
116: hr_utility.set_location('Entering:'||l_proc, 5);
117: --

Line 122: (p_base_table_name => 'per_all_people_f',

118: -- Get the object version number for the insert
119: --
120: p_rec.object_version_number :=
121: dt_api.get_object_version_number
122: (p_base_table_name => 'per_all_people_f',
123: p_base_key_column => 'person_id',
124: p_base_key_value => p_rec.person_id);
125: --
126: -- Set the effective start and end dates to the corresponding

Line 164: -- Insert the row into: per_all_people_f

160: End If;
161: --
162: per_per_shd.g_api_dml := true; -- Set the api dml status
163: --
164: -- Insert the row into: per_all_people_f
165: --
166: insert into per_all_people_f
167: ( person_id,
168: effective_start_date,

Line 166: insert into per_all_people_f

162: per_per_shd.g_api_dml := true; -- Set the api dml status
163: --
164: -- Insert the row into: per_all_people_f
165: --
166: insert into per_all_people_f
167: ( person_id,
168: effective_start_date,
169: effective_end_date,
170: business_group_id,

Line 501: update per_all_people_f

497: -- Now assign the resulting party id back to the record.
498: --
499: -- WWBUG 2450297.
500: --
501: update per_all_people_f
502: set party_id = l_person.party_id
503: where person_id = p_rec.person_id;
504: --
505: End of comment for tca unmerge

Line 611: from per_all_people_f

607: Cursor C_Sel1 is select per_people_s.nextval from sys.dual;
608: --
609: Cursor C_Sel2 is
610: Select null
611: from per_all_people_f
612: where person_id =
613: per_per_ins.g_person_id_i;
614: --
615: Begin

Line 634: fnd_message.set_token('TABLE_NAME','PER_ALL_PEOPLE_F');

630: --
631: -- The primary key values are already in use.
632: --
633: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
634: fnd_message.set_token('TABLE_NAME','PER_ALL_PEOPLE_F');
635: fnd_message.raise_error;
636: End If;
637: Close C_Sel2;
638: --

Line 656: p_source_table_name => 'per_all_people_f',

652: --
653: If (p_rec.comments is not null) then
654: hr_utility.set_location(l_proc,7);
655: hr_comm_api.ins(p_comment_id => p_rec.comment_id,
656: p_source_table_name => 'per_all_people_f',
657: p_comment_text => p_rec.comments);
658: End If;
659: hr_utility.set_location(' Leaving:'||l_proc, 10);
660: --

Line 709: from per_all_people_f

705: l_proc varchar2(72) := g_package||'post_insert';
706: --
707: cursor l_per_cur is
708: select *
709: from per_all_people_f
710: where person_id = p_rec.person_id
711: and effective_start_date = p_rec.effective_start_date
712: and effective_end_date = p_rec.effective_end_date;
713: l_per_rec per_all_people_f%rowtype;

Line 713: l_per_rec per_all_people_f%rowtype;

709: from per_all_people_f
710: where person_id = p_rec.person_id
711: and effective_start_date = p_rec.effective_start_date
712: and effective_end_date = p_rec.effective_end_date;
713: l_per_rec per_all_people_f%rowtype;
714: --
715: Begin
716: hr_utility.set_location('Entering:'||l_proc, 5);
717: --

Line 930: (p_module_name => 'per_all_people_f'

926: );
927: exception
928: when hr_api.cannot_find_prog_unit then
929: hr_api.cannot_find_prog_unit_error
930: (p_module_name => 'per_all_people_f'
931: ,p_hook_type => 'AI'
932: );
933: end;
934: -- End of API User Hook for post_insert.

Line 1048: from per_all_people_f

1044: l_orig_hire_warning boolean;
1045: --
1046: cursor c1 is
1047: select *
1048: from per_all_people_f
1049: where party_id = p_rec.party_id
1050: and p_effective_date
1051: between effective_start_date
1052: and effective_end_date;