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.HR_PERSON_ABSENCE_API dependencies on PER_ABSENCE_ATTENDANCES

Line 103: from per_absence_attendances

99: ,abs_information30
100: ,absence_case_id
101: ,batch_id
102: ,object_version_number
103: from per_absence_attendances
104: where absence_attendance_id = p_absence_attendance_id;
105: --
106: l_absence_rec per_abs_shd.g_rec_type;
107: l_proc varchar2(72) := g_package||'populate_ben_absence_rec';

Line 1112: from per_absence_attendances abs

1108: select abs.date_start, abs.date_end,
1109: abs.DATE_PROJECTED_START,abs.DATE_PROJECTED_END,
1110: abs.TIME_START , abs.TIME_END,
1111: abs.TIME_PROJECTED_START ,abs.TIME_PROJECTED_END
1112: from per_absence_attendances abs
1113: where abs.absence_attendance_id = p_absence_attendance_id;
1114:
1115: cursor c_get_absence_details is
1116: select abs.person_id,

Line 1120: from per_absence_attendances abs

1116: select abs.person_id,
1117: abs.absence_attendance_type_id,
1118: abs.date_start,
1119: abs.date_end
1120: from per_absence_attendances abs
1121: where abs.absence_attendance_id = p_absence_attendance_id;
1122:
1123:
1124: cursor c_get_person_id is

Line 1126: from per_absence_attendances abs

1122:
1123:
1124: cursor c_get_person_id is
1125: select abs.person_id
1126: from per_absence_attendances abs
1127: where abs.absence_attendance_id = p_absence_attendance_id;
1128:
1129: l_csrperson_id number;
1130: l_retvalue varchar2(10);

Line 1206: from per_absence_attendances where ABSENCE_ATTENDANCE_ID = p_absence_attendance_id);

1202: cursor csr_get_abstype is
1203: select HOURS_OR_DAYS,INPUT_VALUE_ID
1204: from per_absence_attendance_types
1205: where absence_attendance_type_id= (select absence_attendance_type_id
1206: from per_absence_attendances where ABSENCE_ATTENDANCE_ID = p_absence_attendance_id);
1207:
1208:
1209:
1210: l_chk_datestart date;

Line 2276: from per_absence_attendances

2272: ) is
2273:
2274: CURSOR get_person_info IS
2275: select person_id
2276: from per_absence_attendances
2277: where ABSENCE_ATTENDANCE_ID = p_absence_attendance_id ;
2278: --
2279: -- Declare cursors and local variables
2280: --

Line 2299: from per_absence_attendances

2295: /*Fix for Bug # 13922178. Adjust the occurrence after the delete*/
2296: cursor c_occurrence is
2297: select business_group_id,
2298: absence_attendance_type_id,person_id,occurrence
2299: from per_absence_attendances
2300: where absence_attendance_id = p_absence_attendance_id;
2301:
2302: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE;
2303: l_person_id per_absence_attendances.person_id%TYPE;

Line 2302: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE;

2298: absence_attendance_type_id,person_id,occurrence
2299: from per_absence_attendances
2300: where absence_attendance_id = p_absence_attendance_id;
2301:
2302: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE;
2303: l_person_id per_absence_attendances.person_id%TYPE;
2304: l_business_group_id per_absence_attendances.business_group_id%TYPE;
2305: l_occurrence per_absence_attendances.occurrence%TYPE;
2306:

Line 2303: l_person_id per_absence_attendances.person_id%TYPE;

2299: from per_absence_attendances
2300: where absence_attendance_id = p_absence_attendance_id;
2301:
2302: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE;
2303: l_person_id per_absence_attendances.person_id%TYPE;
2304: l_business_group_id per_absence_attendances.business_group_id%TYPE;
2305: l_occurrence per_absence_attendances.occurrence%TYPE;
2306:
2307: --

Line 2304: l_business_group_id per_absence_attendances.business_group_id%TYPE;

2300: where absence_attendance_id = p_absence_attendance_id;
2301:
2302: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE;
2303: l_person_id per_absence_attendances.person_id%TYPE;
2304: l_business_group_id per_absence_attendances.business_group_id%TYPE;
2305: l_occurrence per_absence_attendances.occurrence%TYPE;
2306:
2307: --
2308:

Line 2305: l_occurrence per_absence_attendances.occurrence%TYPE;

2301:
2302: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE;
2303: l_person_id per_absence_attendances.person_id%TYPE;
2304: l_business_group_id per_absence_attendances.business_group_id%TYPE;
2305: l_occurrence per_absence_attendances.occurrence%TYPE;
2306:
2307: --
2308:
2309: cursor csr_get_absdates is

Line 2312: from per_absence_attendances

2308:
2309: cursor csr_get_absdates is
2310: select nvl(date_start,DATE_PROJECTED_START) , nvl(date_end,DATE_PROJECTED_END)
2311:
2312: from per_absence_attendances
2313: where ABSENCE_ATTENDANCE_ID = p_absence_attendance_id ;
2314: --
2315: l_chk_datestart date;
2316: l_chk_dateend date;

Line 2433: update per_absence_attendances set occurrence = occurrence - 1

2429:
2430:
2431: /*Fix for Bug # 13922178. Adjust the occurrence after the delete*/
2432: hr_utility.set_location(l_proc, 52);
2433: update per_absence_attendances set occurrence = occurrence - 1
2434: where business_group_id = l_business_group_id
2435: and absence_attendance_type_id = l_absence_attendance_type_id
2436: and person_id = l_person_id
2437: and occurrence > l_occurrence;

Line 2550: from per_absence_attendances aba,

2546: (p_absence_attendance_id in number) return boolean is
2547:
2548: cursor c_linked_to_element is
2549: select abt.input_value_id
2550: from per_absence_attendances aba,
2551: per_absence_attendance_types abt
2552: where aba.absence_attendance_id = p_absence_attendance_id
2553: and aba.absence_attendance_type_id = abt.absence_attendance_type_id;
2554:

Line 2601: from per_absence_attendances abs

2597: cursor c_get_absence_element is
2598: select distinct pee.element_entry_id
2599: ,pee.effective_start_date
2600: ,pee.effective_end_date
2601: from per_absence_attendances abs
2602: ,per_all_assignments_f asg
2603: ,per_absence_attendance_types abt
2604: ,pay_input_values_f piv
2605: ,pay_element_types_f pet

Line 2702: from per_absence_attendances aba,

2698: abt.increasing_or_decreasing_flag,
2699: abt.input_value_id,
2700: pet.element_type_id,
2701: pet.processing_type
2702: from per_absence_attendances aba,
2703: per_absence_attendance_types abt,
2704: pay_input_values_f piv,
2705: pay_element_types_f pet
2706: where aba.absence_attendance_id = p_absence_attendance_id

Line 2713: l_absence_hours per_absence_attendances.absence_hours%TYPE;

2709: and piv.element_type_id = pet.element_type_id;
2710:
2711:
2712: l_proc varchar2(72) := g_package||'get_element_details';
2713: l_absence_hours per_absence_attendances.absence_hours%TYPE;
2714: l_absence_days per_absence_attendances.absence_days%TYPE;
2715: l_hours_or_days per_absence_attendance_types.hours_or_days%TYPE;
2716: l_processing_type pay_element_types_f.processing_type%TYPE;
2717: l_inc_or_dec_flag per_absence_attendance_types.increasing_or_decreasing_flag%TYPE;

Line 2714: l_absence_days per_absence_attendances.absence_days%TYPE;

2710:
2711:
2712: l_proc varchar2(72) := g_package||'get_element_details';
2713: l_absence_hours per_absence_attendances.absence_hours%TYPE;
2714: l_absence_days per_absence_attendances.absence_days%TYPE;
2715: l_hours_or_days per_absence_attendance_types.hours_or_days%TYPE;
2716: l_processing_type pay_element_types_f.processing_type%TYPE;
2717: l_inc_or_dec_flag per_absence_attendance_types.increasing_or_decreasing_flag%TYPE;
2718:

Line 3208: and hat.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES'

3204: pay_element_types_f pet
3205: where
3206: hat.SELECTED_PERSON_ID = p_person_id
3207: --hat.creator_person_id = 125
3208: and hat.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES'
3209: and hrtsteps.TRANSACTION_ID= hat.TRANSACTION_ID
3210: and hat.STATUS not in ('W','S','N','D','AC') -- bug9554066
3211: AND hr_person_absence_swi.getstartdate(hat.transaction_id) is NOT NULL
3212: AND hr_person_absence_swi.getenddate(hat.transaction_id) is NOT NULL

Line 3238: from per_absence_attendances aba,

3234: aba.program_application_id,
3235: nvl(aba.ABSENCE_DAYS,aba.ABSENCE_HOURS) DURATION,
3236: decode (aba.date_start,'','N','Y') CONFIRMED_FLAG
3237:
3238: from per_absence_attendances aba,
3239: per_absence_attendance_types abt,
3240: pay_input_values_f piv,
3241: pay_element_types_f pet
3242: where aba.person_id = p_person_id

Line 3256: and hat.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES'

3252: HR_API_TRANSACTION_STEPS hrtsteps
3253: where
3254: hat.SELECTED_PERSON_ID = p_person_id
3255: --hat.creator_person_id = 125
3256: and hat.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES'
3257: and hrtsteps.TRANSACTION_ID= hat.TRANSACTION_ID
3258: and hat.STATUS not in ('W','S','N','D','AC') -- BUG 9554066
3259: AND hr_person_absence_swi.getstartdate(hat.transaction_id) is NOT NULL
3260: AND hr_person_absence_swi.getenddate(hat.transaction_id) is NOT NULL

Line 3365: from per_absence_attendances

3361: /*
3362:
3363: if l_hours_or_days ='H' and (l_time_start is null or l_time_end is null ) then
3364: select time_start , time_end into l_time_start , l_time_end
3365: from per_absence_attendances
3366: where person_id=p_person_id
3367: and date_start = l_start_date
3368: and date_end = l_end_date;
3369: end if;

Line 3729: from per_absence_attendances

3725: nvl(TIME_END,TIME_PROJECTED_END) timeend,
3726: ABSENCE_ATTENDANCE_TYPE_ID,
3727: OBJECT_VERSION_NUMBER
3728: INTO l_core_dstart ,l_core_dend, l_core_tstart, l_core_tend, l_core_abs_attendance_id , l_core_ovn
3729: from per_absence_attendances
3730: where ABSENCE_ATTENDANCE_ID = l_absence_attendance_id;
3731: if g_debug then
3732: hr_utility.set_location('after sql stmt',220);
3733: end if;

Line 4069: from per_absence_attendances

4065: if l_hours_or_days ='H' then
4066:
4067: if (l_time_start is null ) then
4068: select nvl(TIME_START,TIME_PROJECTED_START)into l_time_start
4069: from per_absence_attendances
4070: where ABSENCE_ATTENDANCE_ID = l_absence_attendance_id;
4071: end if;
4072:
4073: if ( l_time_end is null ) then

Line 4075: from per_absence_attendances

4071: end if;
4072:
4073: if ( l_time_end is null ) then
4074: select nvl(TIME_END,TIME_PROJECTED_END) into l_time_end
4075: from per_absence_attendances
4076: where ABSENCE_ATTENDANCE_ID = l_absence_attendance_id;
4077:
4078: end if;
4079: