APPS.PER_PER_UPD dependencies on PER_ALL_PEOPLE_F

Line 67: from per_all_people_f

63: --
64: l_proc varchar2(72) := g_package||'dt_update_dml';
65: cursor c_person is
66: select *
67: from per_all_people_f
68: where person_id = p_rec.person_id
69: and p_effective_date
70: between effective_start_date
71: and effective_end_date;

Line 73: l_person per_all_people_f%rowtype;

69: and p_effective_date
70: between effective_start_date
71: and effective_end_date;
72: --
73: l_person per_all_people_f%rowtype;
74: --
75: --
76: Begin
77: hr_utility.set_location('Entering:'||l_proc, 5);

Line 87: (p_base_table_name => 'per_all_people_f',

83: -- version number.
84: --
85: p_rec.object_version_number :=
86: dt_api.get_object_version_number
87: (p_base_table_name => 'per_all_people_f',
88: p_base_key_column => 'person_id',
89: p_base_key_value => p_rec.person_id);
90: --
91: per_per_shd.g_api_dml := true; -- Set the api dml status

Line 103: -- Update the per_all_people_f Row

99: p_rec.per_information_category := null;
100: End if;
101: --bug#1942531 change ends */
102: --
103: -- Update the per_all_people_f Row
104: --
105: update per_all_people_f
106: set
107: person_id = p_rec.person_id,

Line 105: update per_all_people_f

101: --bug#1942531 change ends */
102: --
103: -- Update the per_all_people_f Row
104: --
105: update per_all_people_f
106: set
107: person_id = p_rec.person_id,
108: person_type_id = p_rec.person_type_id,
109: last_name = p_rec.last_name,

Line 486: from per_all_people_f

482: l_eed date;
483: --
484: cursor csr_rowid is
485: select rowid, effective_start_date, effective_end_date
486: from per_all_people_f
487: where person_id = p_rec.person_id
488: and p_effective_date between
489: effective_start_date and effective_end_date;
490: --

Line 493: from per_all_people_f

489: effective_start_date and effective_end_date;
490: --
491: cursor csr_rowid_u is
492: select rowid
493: from per_all_people_f
494: where person_id = p_rec.person_id
495: and p_effective_date -1 between
496: effective_start_date and effective_end_date;
497: --

Line 506: p_source_table_name => 'per_all_people_f',

502: -- Insert the comment text if comments exist
503: --
504: If (p_rec.comments is not null and p_rec.comment_id is null) then
505: hr_comm_api.ins(p_comment_id => p_rec.comment_id,
506: p_source_table_name => 'per_all_people_f',
507: p_comment_text => p_rec.comments);
508: -- Update the comments if they have changed
509: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
510: per_per_shd.g_old_rec.comments) then

Line 512: p_source_table_name => 'per_all_people_f',

508: -- Update the comments if they have changed
509: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
510: per_per_shd.g_old_rec.comments) then
511: hr_comm_api.upd(p_comment_id => p_rec.comment_id,
512: p_source_table_name => 'per_all_people_f',
513: p_comment_text => p_rec.comments);
514: End If;
515: --
516: dt_pre_update

Line 651: from per_all_people_f

647: l_proc varchar2(72) := g_package||'post_update';
648: --
649: cursor l_per_cur is
650: select *
651: from per_all_people_f
652: where person_id = p_rec.person_id
653: and effective_start_date = p_rec.effective_start_date
654: and effective_end_date = p_rec.effective_end_date;
655: l_per_rec per_all_people_f%rowtype;

Line 655: l_per_rec per_all_people_f%rowtype;

651: from per_all_people_f
652: where person_id = p_rec.person_id
653: and effective_start_date = p_rec.effective_start_date
654: and effective_end_date = p_rec.effective_end_date;
655: l_per_rec per_all_people_f%rowtype;
656: --
657: Begin
658: hr_utility.set_location('Entering:'||l_proc, 5);
659: --

Line 1113: (p_module_name => 'per_all_people_f'

1109: );
1110: exception
1111: when hr_api.cannot_find_prog_unit then
1112: hr_api.cannot_find_prog_unit_error
1113: (p_module_name => 'per_all_people_f'
1114: ,p_hook_type => 'AU'
1115: );
1116: end;
1117: -- End of API User Hook for post_update.