DBA Data[Home] [Help]

APPS.HR_LOA_SS dependencies on PER_ALL_PEOPLE_F

Line 1390: lv_creator_person_id per_all_people_f.person_id%TYPE;

1386: lv_activity_name wf_item_activity_statuses_v.activity_name%TYPE;
1387: ln_trans_step_rows number default 0;
1388: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
1389: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
1390: lv_creator_person_id per_all_people_f.person_id%TYPE;
1391:
1392:
1393: BEGIN
1394:

Line 1608: lv_creator_person_id per_all_people_f.person_id%TYPE;

1604:
1605: ) IS
1606:
1607: l_proc varchar2(72) := g_package||'write_transaction';
1608: lv_creator_person_id per_all_people_f.person_id%TYPE;
1609:
1610: BEGIN
1611:
1612: hr_utility.set_location(' Entering:' || l_proc,5);

Line 3782: l_creator_person_id per_all_people_f.person_id%TYPE;

3778: ,p_page_error_num out nocopy varchar2
3779: ) IS
3780:
3781: l_proc varchar2(72) := g_package||'process_save';
3782: l_creator_person_id per_all_people_f.person_id%TYPE;
3783: l_validate boolean;
3784: l_transaction_id number;
3785: l_absence_days number;
3786: l_absence_hours number;

Line 4631: l_creator_person_id per_all_people_f.person_id%TYPE;

4627: ,p_page_error_num out nocopy varchar2
4628: ) IS
4629:
4630: l_proc varchar2(72) := g_package||'process_update_save';
4631: l_creator_person_id per_all_people_f.person_id%TYPE;
4632: l_absence_rec per_absence_attendances%rowtype;
4633: l_validate boolean ;
4634: l_transaction_id number;
4635: l_transaction_step_id number;

Line 5623: l_creator_person_id per_all_people_f.person_id%TYPE;

5619: --2713296 changes end
5620: ) IS
5621:
5622: l_proc varchar2(72) := g_package||'process_updae_txn_save';
5623: l_creator_person_id per_all_people_f.person_id%TYPE;
5624: l_absence_rec per_absence_attendances%rowtype;
5625: l_absence_days per_absence_attendances.absence_days%TYPE;
5626: l_absence_hours per_absence_attendances.absence_hours%TYPE;
5627: l_validate boolean ;

Line 6448: l_creator_person_id per_all_people_f.person_id%TYPE;

6444: ,p_page_error_num out nocopy varchar2
6445: ) IS
6446:
6447: l_proc varchar2(72) := g_package||'process_txn_save';
6448: l_creator_person_id per_all_people_f.person_id%TYPE;
6449: l_validate boolean;
6450: l_transaction_id number;
6451: l_absence_days number;
6452: l_absence_hours number;