[Home] [Help]
9: g_usr_date_fmt varchar2(20) := fnd_profile.value('ICX_DATE_FORMAT_MASK');
10: g_usr_day_time_fmt varchar(40) := g_usr_date_fmt|| ' HH24:MI:SS';
11:
12: --2793140 change starts
13: --cursor to fetch the absence row from per_absence_attendances
14: CURSOR gc_get_absence_row (p_absence_attendance_id in number) IS
15: SELECT paa.absence_attendance_type_id
16: ,paa.business_group_id
17: ,paa.person_id
83: ,paa.abs_information27
84: ,paa.abs_information28
85: ,paa.abs_information29
86: ,paa.abs_information30
87: FROM per_absence_attendances paa
88: WHERE paa.absence_attendance_id = p_absence_attendance_id;
89:
90: --2793140 change ends
91: /*
4540: ,p_login_person_id in number
4541: ,p_review_proc_call in varchar2
4542: ,p_effective_date in date
4543: ,p_date_notification in date
4544: ,p_absence_attendance_id in per_absence_attendances.absence_attendance_id%type
4545: ,p_object_version_number in out nocopy number
4546: ,p_date_start in date default null
4547: ,p_time_start in varchar2 default null
4548: ,p_date_end in date default null
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;
4636: l_login_person_id number;
4657: l_leave_data_changed boolean := false ; --2793140
4658:
4659: cursor csr_abs_attendances is
4660: select *
4661: from per_absence_attendances paa
4662: where paa.absence_attendance_id = p_absence_attendance_id ;
4663:
4664: BEGIN
4665: --
5532: ,p_effective_date in date
5533: --2713296 changes start
5534: ,p_person_id in number
5535: ,p_business_group_id in number
5536: ,p_absence_attendance_id in per_absence_attendances.absence_attendance_id%type
5537: ,p_object_version_number in number
5538: ,p_save_mode in varchar2 default null
5539: --2713296 changes end
5540: ,p_absence_attendance_type_id in number --2966372
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 ;
5628: l_transaction_id number;
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 ;
5628: l_transaction_id number;
5629: l_transaction_step_id number;
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 ;
5628: l_transaction_id number;
5629: l_transaction_step_id number;
5630: l_login_person_id number;
7243:
7244: l_proc varchar2(72) := g_package||'process_api';
7245: l_validate boolean;
7246: l_effective_date date;
7247: l_absence_rec per_absence_attendances%rowtype;
7248: l_activity_name varchar2(30);
7249: l_leave_status varchar2(30);
7250: l_business_group_id number;
7251: l_absence_attendance_id number;
7670: ||===========================================================================
7671: */
7672: procedure get_abs_from_tt(
7673: p_transaction_step_id in number
7674: ,p_absence_rec out nocopy per_absence_attendances%rowtype
7675: ) is
7676:
7677: l_proc varchar2(72) := g_package||'get_abs_from_tt';
7678: --
8058: ||===========================================================================
8059: */
8060: procedure get_rtn_from_tt(
8061: p_transaction_step_id in number
8062: ,p_absence_rec out nocopy per_absence_attendances%rowtype
8063: ) is
8064:
8065: --
8066: l_proc varchar2(72) := g_package||'get_rtn_from_tt';
8429: ||===========================================================================
8430: */
8431: procedure get_upd_from_tt(
8432: p_transaction_step_id in number
8433: ,p_absence_rec out nocopy per_absence_attendances%rowtype
8434: ) is
8435:
8436: --
8437: l_proc varchar2(72) := g_package||'get_upd_from_tt';
9730: ||---------------------------------------------------------------------------
9731: ||
9732: || Description:
9733: || This procedure will delete absence record from
9734: || per_absence_attendances
9735: ||
9736: || Access Status:
9737: || Public.
9738: ||
9747: l_ovn number;
9748: --
9749: cursor csr_get_ovn_abs_attendances is
9750: select object_version_number
9751: from per_absence_attendances paa
9752: where paa.absence_attendance_id = p_absence_attendance_id ;
9753: --
9754: BEGIN
9755: