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_ABSENCE_ATTENDANCES_PKG dependencies on PER_ABSENCE_ATTENDANCES_PKG

Line 1: package body PER_ABSENCE_ATTENDANCES_PKG as

1: package body PER_ABSENCE_ATTENDANCES_PKG as
2: /* $Header: peaba01t.pkb 120.5.12020000.2 2012/07/05 00:25:27 amnaraya ship $ */
3:
4: /* Date Name Release Description
5: ---- ---- ------- -----------

Line 26: hardcoded 'PER_ABSENCE_ATTENDANCES_PKG';

22: not be delivered until SSP delivery. These
23: commented out bits should be uncommented at that
24: time.
25: 13-OCT-95 J Thuringer Replaced 'PACKAGE_NAME' variable by
26: hardcoded 'PER_ABSENCE_ATTENDANCES_PKG';
27: removed error checking code from end of script
28: 17-OCT-95 F Assadi Added a new function get_anuual_bal to work
29: out the absence taken from the year.
30: is_emp_entitled function was added. This

Line 123: 115.26 06-NOV-2003 3156665 kjagadee Modified per_absence_attendances_pkg.get_defaults

119: 115.24 23-JUL-2003 2829746 ablinko amendments for SAP/SPP
120: 115.25 25-Aug-2003 3111653 skota added to_number() for explicit
121: conversion. Seems implicit conversion
122: is not taking place in 10G
123: 115.26 06-NOV-2003 3156665 kjagadee Modified per_absence_attendances_pkg.get_defaults
124: procedure to calculate the drfault hours in a day
125: as 24 hours.
126: 115.27 29-JAN-2004 3387265 smparame Modified inti_form procedure.
127: upper(formula_type_name) is changed to formula

Line 146: g_package varchar2(33) := ' per_absence_attendances_pkg.';

142: 120.0.12000000.6 05-Jan-2011 13486124 npannamp Added check for Adjusted Service date in procedure
143: chk_apl_empl_continuity.
144: -------+------------+---------+----------+------------------------------------------------
145: */
146: g_package varchar2(33) := ' per_absence_attendances_pkg.';
147: -- Global package name
148:
149: --
150: ------------------------------------------------------------------------------

Line 1068: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

1064: --
1065: Exception
1066: When hr_api.check_integrity_violated Then
1067: -- A check constraint has been violated
1068: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1069: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1070: When hr_api.parent_integrity_violated Then
1071: -- Parent integrity has been violated
1072: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

Line 1072: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

1068: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1069: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1070: When hr_api.parent_integrity_violated Then
1071: -- Parent integrity has been violated
1072: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1073: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1074: When hr_api.unique_integrity_violated Then
1075: -- Unique integrity has been violated
1076: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

Line 1076: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

1072: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1073: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1074: When hr_api.unique_integrity_violated Then
1075: -- Unique integrity has been violated
1076: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1077: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1078: When Others Then
1079: Raise;
1080: END Insert_Row;

Line 1802: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

1798: --
1799: Exception
1800: When hr_api.check_integrity_violated Then
1801: -- A check constraint has been violated
1802: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1803: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1804: When hr_api.parent_integrity_violated Then
1805: -- Parent integrity has been violated
1806: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

Line 1806: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

1802: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1803: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1804: When hr_api.parent_integrity_violated Then
1805: -- Parent integrity has been violated
1806: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1807: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1808: When hr_api.unique_integrity_violated Then
1809: -- Unique integrity has been violated
1810: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

Line 1810: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

1806: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1807: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1808: When hr_api.unique_integrity_violated Then
1809: -- Unique integrity has been violated
1810: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1811: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1812: When Others Then
1813: Raise;
1814: END Update_Row;

Line 1910: hr_utility.set_location('per_absence_attendances_pkg.b_check_auth_de',1);

1906: and pp.current_employee_flag = 'Y';
1907: --
1908: begin
1909: --
1910: hr_utility.set_location('per_absence_attendances_pkg.b_check_auth_de',1);
1911: --
1912: open c1;
1913: --
1914: fetch c1 into l_exists;

Line 1956: hr_utility.set_location('per_absence_attendances_pkg.b_check_rep_de',1);

1952: and pp.current_employee_flag = 'Y';
1953: --
1954: begin
1955: --
1956: hr_utility.set_location('per_absence_attendances_pkg.b_check_rep_de',1);
1957: --
1958: open c3;
1959: --
1960: fetch c3 into l_exists;

Line 1988: hr_utility.set_location('per_absence_attendances_pkg.b_check_for_termination',1);

1984: and p.person_id = p_rep_per;
1985: --
1986: begin
1987: --
1988: hr_utility.set_location('per_absence_attendances_pkg.b_check_for_termination',1);
1989: --
1990: open c2;
1991: --
1992: l_ret_val := c2%found;

Line 2026: hr_utility.set_location('per_absence_attendances_pkg.chk_rep_req',1);

2022: and pp.replacement_required_flag = 'Y';
2023: --
2024: begin
2025: --
2026: hr_utility.set_location('per_absence_attendances_pkg.chk_rep_req',1);
2027: --
2028: open c4;
2029: fetch c4 into l_exists;
2030: --

Line 2061: hr_utility.set_location('per_absence_attendances_pkg.chk_type',1);

2057: or p_dend is null);
2058: --
2059: begin
2060: --
2061: hr_utility.set_location('per_absence_attendances_pkg.chk_type',1);
2062: --
2063: open c5;
2064: --
2065: fetch c5 into l_exists;

Line 2095: hr_utility.set_location('per_absence_attendances_pkg.chk_proj',1);

2091: or p_proj_end is null);
2092: --
2093: begin
2094: --
2095: hr_utility.set_location('per_absence_attendances_pkg.chk_proj',1);
2096: --
2097: open c6;
2098: --
2099: fetch c6 into l_exists;

Line 2136: hr_utility.set_location('per_absence_attendances_pkg.chkab1',1);

2132: and t.date_end = p_dstart -1;
2133: --
2134: begin
2135: --
2136: hr_utility.set_location('per_absence_attendances_pkg.chkab1',1);
2137: --
2138: open c7;
2139: fetch c7 into l_exists;
2140: --

Line 2195: hr_utility.set_location('per_absence_attendances_pkg.chkab2',1);

2191: or (t.date_start between p_dstart and nvl(p_dend,p_eot)));
2192: --
2193: begin
2194: --
2195: hr_utility.set_location('per_absence_attendances_pkg.chkab2',1);
2196: --
2197: open c8;
2198: --
2199: fetch c8 into l_exists;

Line 2208: hr_utility.set_location('per_absence_attendances_pkg.chkab2',2);

2204: END IF;
2205: --
2206: close c8;
2207: --
2208: hr_utility.set_location('per_absence_attendances_pkg.chkab2',2);
2209: --
2210: open c9;
2211: --
2212: fetch c9 into l_exists2;

Line 2250: hr_utility.set_location('per_absence_attendances_pkg.chkab3',1);

2246: or (t.date_start between p_dstart and nvl(p_dend,p_eot)));
2247: --
2248: begin
2249: --
2250: hr_utility.set_location('per_absence_attendances_pkg.chkab3',1);
2251: --
2252: open c10;
2253: fetch c10 into l_exists;
2254: --

Line 2298: hr_utility.set_location('per_absence_attendances_pkg.b_elmnt_entry_dets',1);

2294: and p_sdstart between t.start_date and t.end_date;
2295: --
2296: begin
2297: --
2298: hr_utility.set_location('per_absence_attendances_pkg.b_elmnt_entry_dets',1);
2299: --
2300: open c11;
2301: --
2302: fetch c11 into p_e_entry_id,

Line 2324: hr_utility.set_location('per_absence_attendances_pkg.b_get_category',1);

2320: and lookup_code = p_abcat;
2321: --
2322: begin
2323: --
2324: hr_utility.set_location('per_absence_attendances_pkg.b_get_category',1);
2325: --
2326: open c12;
2327: --
2328: fetch c12 into p_mean;

Line 2356: hr_utility.set_location('per_absence_attendances_pkg.get_defaults',1);

2352: from sys.dual;
2353: --
2354: begin
2355: --
2356: hr_utility.set_location('per_absence_attendances_pkg.get_defaults',1);
2357: --
2358: open c14;
2359: --
2360: fetch c14 into l_hrs_def,

Line 2442: hr_utility.set_location('per_absence_attendances_pkg.get_ele_det1',1);

2438: and p_sess between lu1.effective_start_date and lu1.effective_end_date));
2439: --
2440: begin
2441: --
2442: hr_utility.set_location('per_absence_attendances_pkg.get_ele_det1',1);
2443: --
2444: open c15;
2445: --
2446: fetch c15 into p_ass_id,

Line 2475: hr_utility.set_location('per_absence_attendances_pkg.get_ele_det2',1);

2471: and pettl.language = userenv('LANG');
2472: --
2473: begin
2474: --
2475: hr_utility.set_location('per_absence_attendances_pkg.get_ele_det2',1);
2476: --
2477: open c16;
2478: --
2479: fetch c16 into p_dele_name;

Line 2503: hr_utility.set_location('per_absence_attendances_pkg.get_period_dates',1);

2499: and p_dstart between start_date and end_date;
2500: --
2501: begin
2502: --
2503: hr_utility.set_location('per_absence_attendances_pkg.get_period_dates',1);
2504: --
2505: open c18;
2506: --
2507: fetch c18 into p_prd_start,

Line 2537: hr_utility.set_location('per_absence_attendances_pkg.get_run_tot',1);

2533: and primary_flag = 'Y';
2534: --
2535: begin
2536: --
2537: hr_utility.set_location('per_absence_attendances_pkg.get_run_tot',1);
2538: --
2539: open c19;
2540: --
2541: fetch c19 into p_db_itm;

Line 2545: hr_utility.set_location('per_absence_attendances_pkg.get_run_tot',2);

2541: fetch c19 into p_db_itm;
2542: --
2543: close c19;
2544: --
2545: hr_utility.set_location('per_absence_attendances_pkg.get_run_tot',2);
2546: --
2547: open c20;
2548: --
2549: fetch c20 into p_ass_id;

Line 2590: hr_utility.set_location('per_absence_attendances_pkg.get_annual_bal',1);

2586: l_balance NUMBER := 0;
2587: --
2588: begin
2589: --
2590: hr_utility.set_location('per_absence_attendances_pkg.get_annual_bal',1);
2591: --
2592: open c19;
2593: --
2594: fetch c19 into l_balance;

Line 2656: hr_utility.set_location('per_absence_attendances_pkg.check_entitlement',1);

2652:
2653: --
2654: begin
2655: --
2656: hr_utility.set_location('per_absence_attendances_pkg.check_entitlement',1);
2657: --
2658: if p_days_requested is null and p_days_requested is null then
2659: --
2660: return true;

Line 2726: hr_utility.set_location('per_absence_attendances_pkg.init_form',1);

2722: and date_start <= p_sess;
2723: --
2724: begin
2725: --
2726: hr_utility.set_location('per_absence_attendances_pkg.init_form',1);
2727: --
2728: open c21;
2729: --
2730: fetch c21 into p_form_type;

Line 2734: hr_utility.set_location('per_absence_attendances_pkg.init_form',2);

2730: fetch c21 into p_form_type;
2731: --
2732: close c21;
2733: --
2734: hr_utility.set_location('per_absence_attendances_pkg.init_form',2);
2735: --
2736: open c21b;
2737: --
2738: fetch c21b into p_dstart,

Line 2758: hr_utility.set_location('per_absence_attendances_pkg.ins_ok',1);

2754: and payroll_id is not null;
2755: --
2756: begin
2757: --
2758: hr_utility.set_location('per_absence_attendances_pkg.ins_ok',1);
2759: --
2760: open c22;
2761: --
2762: fetch c22 into p_test;

Line 2783: hr_utility.set_location('per_absence_attendances_pkg.get_occur',1);

2779: and person_id = p_per_id;
2780: --
2781: begin
2782: --
2783: hr_utility.set_location('per_absence_attendances_pkg.get_occur',1);
2784: --
2785: open c23;
2786: --
2787: fetch c23 into p_occur;

Line 2810: hr_utility.set_location('per_absence_attendances_pkg.chk_serv_period',1);

2806: pos.date_start AND nvl(pos.actual_termination_date,hr_general.end_of_time);
2807: --
2808: begin
2809: --
2810: hr_utility.set_location('per_absence_attendances_pkg.chk_serv_period',1);
2811: --
2812: open chk_periods;
2813: --
2814: l_ret_val := chk_periods%found;

Line 2877: hr_utility.set_location('per_absence_attendances_pkg.get_due_date',1);

2873: where h.maternity_id = p_maternity_id;
2874: c1_rec c1%ROWTYPE;
2875: BEGIN
2876: open c1;
2877: hr_utility.set_location('per_absence_attendances_pkg.get_due_date',1);
2878: fetch c1 into c1_rec;
2879: close c1;
2880: return(c1_rec.due_date);
2881: END get_due_date;

Line 2908: hr_utility.set_location('per_absence_attendances_pkg.get_due_date_2',1);

2904: and nvl(h.leave_type,'MA') = p_leave_type;
2905:
2906:
2907: BEGIN
2908: hr_utility.set_location('per_absence_attendances_pkg.get_due_date_2',1);
2909: counter:= 0;
2910: for c1_rec in c1 LOOP
2911: p_smp_due_date := c1_rec.due_date;
2912: counter := counter + 1;

Line 2949: hr_utility.set_location('per_absence_attendances_pkg.check_val_abs_start',1);

2945: --
2946: maternity csr_maternity%ROWTYPE;
2947: --
2948: BEGIN
2949: hr_utility.set_location('per_absence_attendances_pkg.check_val_abs_start',1);
2950: --
2951: -- This functionality only applies to Oracle SSP users
2952: if not ssp_ssp_pkg.ssp_is_installed then
2953: return;

Line 3008: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',1);

3004: maternity csr_maternity%ROWTYPE;
3005: l_dummy period_of_service%ROWTYPE;
3006: --
3007: BEGIN
3008: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',1);
3009: --
3010: -- This functionality only applies to Oracle SSP users
3011: if not ssp_ssp_pkg.ssp_is_installed then
3012: return;

Line 3018: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',2);

3014: --
3015:
3016: if p_maternity_id is not null then
3017: --
3018: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',2);
3019: open csr_maternity;
3020: fetch csr_maternity into maternity;
3021: if csr_maternity%found then
3022: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',3);

Line 3022: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',3);

3018: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',2);
3019: open csr_maternity;
3020: fetch csr_maternity into maternity;
3021: if csr_maternity%found then
3022: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',3);
3023: open period_of_service(maternity.person_id, maternity.continous_emp_date);
3024: fetch period_of_service into l_dummy;
3025:
3026: if period_of_service%notfound then

Line 3027: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',4);

3023: open period_of_service(maternity.person_id, maternity.continous_emp_date);
3024: fetch period_of_service into l_dummy;
3025:
3026: if period_of_service%notfound then
3027: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',4);
3028: close period_of_service;
3029: fnd_message.set_name('SSP', 'SSP_36810_APL_CONTINOUS_EMPL');
3030: fnd_message.raise_error;
3031: end if;

Line 3057: hr_utility.set_location('per_absence_attendances_pkg.chk_related_maernity',1);

3053: from ssp_maternities h
3054: where h.person_id = p_person_id;
3055: c1_rec c1%ROWTYPE;
3056: BEGIN
3057: hr_utility.set_location('per_absence_attendances_pkg.chk_related_maernity',1);
3058: open c1;
3059: fetch c1 into c1_rec;
3060: if c1%NOTFOUND then
3061: fnd_message.set_name('SSP','SSP_36073_PREG_RELATED_ILLNESS');

Line 3088: hr_utility.set_location('per_absence_attendances_pkg.chk_evd_before_del',1);

3084: where h.absence_attendance_id = p_absence_attendance_id
3085: and h.medical_type = p_medical_type;
3086: c1_rec c1%ROWTYPE;
3087: BEGIN
3088: hr_utility.set_location('per_absence_attendances_pkg.chk_evd_before_del',1);
3089: open c1;
3090: fetch c1 into c1_rec;
3091: if c1%FOUND then
3092: fnd_message.set_name('SSP','SSP_35033_ATTACHED_SICK_NOTE');

Line 3118: ('per_absence_attendances_pkg.late_abs_notification',1);

3114: l_element_details ssp_SMP_pkg.csr_SMP_element_details%rowtype;
3115:
3116: BEGIN
3117: hr_utility.set_location
3118: ('per_absence_attendances_pkg.late_abs_notification',1);
3119: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date,
3120: p_element_name);
3121: fetch ssp_SMP_pkg.csr_SMP_element_details into l_element_details;
3122: close ssp_SMP_pkg.csr_SMP_element_details;

Line 3134: end PER_ABSENCE_ATTENDANCES_PKG;

3130: return(FALSE);
3131: end if;
3132: END late_abs_notification;
3133:
3134: end PER_ABSENCE_ATTENDANCES_PKG;