PACKAGE: APPS.PAY_NZ_CEC_REPORT_PKG

Source

1 PACKAGE pay_nz_cec_report_pkg AUTHID CURRENT_USER AS
2 /* $Header: pynzcecetc.pkh 120.0.12010000.2 2009/01/30 06:00:44 pmatamsr noship $*/
3 
4 P_REGISTERED_EMPLOYER_ID Number;
5 P_ASSIGNMENT_ID Number;
6 P_START_DATE Date;
7 P_END_DATE Date;
8 P_REGISTERED_EMP_NAME varchar2(250);
9 PER_BUSINESS_GROUP_ID Number(20);
10   --------------------------------------------------------------------
11   -- This function is used to calculate Sum of balance values between
12   -- Start Date and End Date Parameters for a defined balance id .
13   -- This function gets called from PAYNZCECETC.xml
14   --------------------------------------------------------------------
15 
16  Function PAY_NZ_GET_BAL_VALUE(p_assignment_id IN per_assignments_f.assignment_id%type,
17                                p_def_bal_id IN pay_defined_balances.defined_balance_id%type,
18                                p_start_date IN date,
19                                p_end_date IN date)
20   return number;
21 
22 /* Bug 7688345 - This function is used to check whether the report End Date parameter
23  * value is prior or after '01-Apr-2009' and accordingly a flag value is returned.*/
24 
25  function PAY_NZ_GET_RPT_FLAG (p_end_date IN date)
26  return char;
27 
28 END pay_nz_cec_report_pkg;