PACKAGE: APPS.PER_AE_WAGE_PROTECTION_PKG

Source

1 package per_ae_wage_protection_pkg AUTHID CURRENT_USER as
2 /* $Header: peraewps.pkh 120.0 2010/07/05 04:55:05 appldev noship $ */
3 /*
4 ==============================================================================
5 
6 MODIFICATION HISTORY
7 Name           Date        Version Bug     Text
8 -------------- ----------- ------- ------- -----------------------------
9 BKeshary        27-May-2009   115.0   Initial Version
10 ==============================================================================
11 */
12 P_BUSINESS_GROUP_ID number;
13 P_EMPLOYER_ID  number;
14 P_MONTH varchar2(10);
15 P_YEAR varchar2(10);
16 P_NAME   varchar2(50);
17 P_TITLE  varchar2(50);
18 P_EMP_MINISTRY varchar2(50);
19 P_EMP_PAID number;
20 P_EMPS_NOT_PAID number;
21 P_EMP_IN_PAYROLL number;
22 P_AMT_PAID number;
23 
24 
25 function BEFOREREPORT return boolean;
26 function AFTERREPORT return boolean;
27 
28 function get_number_of_employees
29 (
30    p_month                  in varchar2,
31    p_year                   in varchar2,
32    p_employer_id            in number,
33    p_business_group_id      in per_all_assignments_f.business_group_id%type
34 
35 ) return NUMBER;
36 
37 
38 
39 FUNCTION get_number_of_emps_paid
40 (
41     p_month                  in varchar2,
42     p_year                   in varchar2,
43     p_employer_id            in number,
44     p_business_group_id      in per_all_assignments_f.business_group_id%type
45  ) RETURN NUMBER;
46 
47 FUNCTION get_total_amt_paid RETURN NUMBER;
48 
49 FUNCTION get_number_of_emps_not_paid return number;
50 
51 FUNCTION get_month
52 (
53   p_month in varchar2,
54   p_mon_number varchar2
55  ) return varchar2;
56 
57 end per_ae_wage_protection_pkg;