CREATE OR REPLACE PACKAGE DA."BEC_PYE_PKG" AS TYPE chararray IS TABLE OF VARCHAR2 (255) INDEX BY BINARY_INTEGER; -- Weekly payroll change: p_text is not used. PROCEDURE bec_wkpr_actchg ( p_text IN VARCHAR2, fromdate IN DATE, todate IN DATE ); -- Bi-Weekly payroll change: p_text is not used. PROCEDURE bec_biwkpr_actchg ( p_text IN VARCHAR2, fromdate IN DATE, todate IN DATE ); PROCEDURE bec_truckallowance_actchg ( p_text IN VARCHAR2, fromdate IN DATE, todate IN DATE ); PROCEDURE bec_mondept_actchg ( p_text IN VARCHAR2, todate IN DATE, YEAR IN NUMBER, fromperiod IN NUMBER, toperiod IN NUMBER ); FUNCTION bec_salary_amt ( in_comp_code IN da.pyemppayhist.phy_comp_code%TYPE, in_emp_no IN da.pyemppayhist.phy_emp_no%TYPE, in_year IN da.pyemppayhist.phy_ppr_year%TYPE, in_period IN da.pyemppayhist.phy_ppr_period%TYPE, in_prn_code IN da.pyemppayhist.phy_prn_code%TYPE) RETURN da.pyemppayhist.phy_pay_amount%TYPE; PROCEDURE bec_manhour_email( in_year IN NUMBER ); PROCEDURE bec_emptimecard_email( in_year IN NUMBER, in_period IN NUMBER ); PROCEDURE bec_over80hr_email( in_year IN NUMBER, in_period IN NUMBER ); PROCEDURE bec_laborcost_email( from_date IN date, to_date IN date ); PROCEDURE bec_laborcostx_email( from_date IN date, to_date IN date ); PROCEDURE bec_laborcost2_email( from_date IN date, to_date IN date ); -- Employees who did not enter PTO on a given date: p_text is not used. PROCEDURE bec_empnopto_xls ( p_text IN VARCHAR2, fromdate IN DATE, todate IN DATE ); PROCEDURE bec_payrollaudit_email( in_bwyear IN NUMBER, in_bwstartpp IN NUMBER, in_bwendpp IN NUMBER, in_wkyear IN NUMBER, in_wkstartpp IN NUMBER, in_wkendpp IN NUMBER ); PROCEDURE bec_payrollaudit_emailx( in_bwyear IN NUMBER, in_bwstartpp IN NUMBER, in_bwendpp IN NUMBER, in_wkyear IN NUMBER, in_wkstartpp IN NUMBER, in_wkendpp IN NUMBER ); PROCEDURE bec_payrollwages_email( in_bwyear IN NUMBER, in_bwstartpp IN NUMBER, in_bwendpp IN NUMBER, in_wkyear IN NUMBER, in_wkstartpp IN NUMBER, in_wkendpp IN NUMBER ); PROCEDURE bec_vitality_eligibility_file; PROCEDURE etime_correction_email( in_year IN NUMBER, in_period IN NUMBER ); PROCEDURE bec_vitality_update_file( in_list IN NUMBER ); PROCEDURE bec_empdeptchg_file( empyear IN NUMBER, empperiod IN NUMBER ); PROCEDURE bec_manhourbtw_email( start_date IN VARCHAR2, end_date IN VARCHAR2, parameter IN VARCHAR2 ); PROCEDURE bec_manhourbtwjob_email( start_date IN VARCHAR2, end_date IN VARCHAR2, parameter IN VARCHAR2 ); PROCEDURE bec_neghrs_email( in_year IN NUMBER, in_period IN NUMBER ); FUNCTION bec_last_paid ( in_emp_no IN VARCHAR2 ) RETURN VARCHAR2; PROCEDURE bec_design_burden_reimb( in_year IN NUMBER, in_period IN NUMBER ); PROCEDURE bec_salary_planning( in_year IN NUMBER, in_version IN VARCHAR2); PROCEDURE bec_safety_hours( in_from_date IN DATE, in_to_date IN DATE, in_type IN VARCHAR2, in_sc IN VARCHAR2, in_vendor IN VARCHAR2); PROCEDURE bec_hdhp_email( in_year IN NUMBER, in_period IN NUMBER); PROCEDURE bec_colorado_wage_rpt; PROCEDURE bec_texas_wage_rpt; PROCEDURE bec_increase_hist( in_year IN NUMBER); PROCEDURE BEC_TIMECARD; PROCEDURE bec_bonusaccrual_actchg ( p_text IN VARCHAR2, fromdate IN DATE, todate IN DATE ); END; /