1 PACKAGE PER_PERUSHRM_XMLP_PKG AS
2 /* $Header: PERUSHRMS.pls 120.0 2007/12/28 07:02:09 srikrish noship $ */
3 P_BUSINESS_GROUP_ID number;
4 P_TAX_UNIT_ID number;
5 P_REPORT_DATE varchar2(32767);
6 P_STATE_CODE varchar2(40);
7 P_CONC_REQUEST_ID number;
8 P_AUDIT_REPORT varchar2(32767);
9 P_MULTI_STATE varchar2(32767);
10 P_MULTI_STATE_1 varchar2(32767);
11 P_REPORT_MODE varchar2(1);
12 CP_pre_tax_unit_id number;
13 C_BUSINESS_GROUP_NAME varchar2(240);
14 C_REPORT_SUBTITLE varchar2(60);
15 C_TAX_UNIT varchar2(240);
16 C_STATE_NAME varchar2(60);
17 C_MEDICAL_AVAIL varchar2(4);
18 C_END_OF_TIME date;
19 C_STATE_COUNT number;
20 C_OLD_STATE varchar2(20);
21 C_no_of_newhire number;
22 C_no_of_gre number;
23 C_no_of_multi_state number;
24 C_Fatal_error_flag number;
25 C_a03_header_flag number;
26 function BeforeReport return boolean ;
27 function c_employee_addressformula(person_id in number) return varchar2 ;
28 function c_salaryformula(assignment_id in number) return number ;
29 function AfterReport (CS_NO_OF_NEW_HIRE in number)return boolean ;
30 function G_new_hiresGroupFilter return boolean ;
31 function BetweenPage return boolean ;
32 function CF_new_hireFormula (SUI_COMPANY_STATE_ID in varchar2,DATE_START in date,FEDERAL_ID in varchar2
33 ,NATIONAL_IDENTIFIER in varchar2,MIDDLE_NAME in varchar2,gre_location_id in number,HIRE_STATE in varchar2
34 ,person_id in number,LAST_NAME in varchar2,FIRST_NAME in varchar2,DATE_OF_BIRTH in date,
35 TAX_UNIT_NAME in varchar2,FULL_MIDDLE_NAME in varchar2,SIT_COMPANY_STATE_ID in varchar2,
36 c_contact_name in varchar2,c_contact_phone in varchar2)return Number ;
37 PROCEDURE char_set_init
38 (
39 p_character_set in varchar2
40 ) ;
41 --procedure new_hire_record ;
42 procedure new_hire_record(person_id in number,NATIONAL_IDENTIFIER in varchar2,FIRST_NAME in varchar2,
43 MIDDLE_NAME in varchar2,LAST_NAME in varchar2,DATE_START in date,FULL_MIDDLE_NAME in varchar2,
44 gre_location_id in number,DATE_OF_BIRTH in date,HIRE_STATE in varchar2,FEDERAL_ID in number,
45 SUI_COMPANY_STATE_ID in varchar2,TAX_UNIT_NAME in varchar2,c_contact_phone in number,
46 c_contact_name in varchar2,SIT_COMPANY_STATE_ID in varchar2) ;
47 PROCEDURE TOTAL_RECORD ;
48 procedure a01_header_record(TAX_UNIT_ID in number,federal_id in varchar2) ;
49 --procedure a01_header_record ;
50 --procedure a01_total_record ;
51 procedure a01_total_record(CS_NO_OF_NEW_HIRE in number);
52 PROCEDURE A03_HEADER_RECORD ;
53 PROCEDURE P_MAG_UPDATE_STATUS ;
54 function CF_GREFormula (FEDERAL_ID in varchar2,gre_location_id in number,TAX_UNIT_ID in number,
55 TAX_UNIT_NAME in varchar2,SIT_COMPANY_STATE_ID in varchar2)return Number ;
56 function c_contact_nameformula(new_hire_contact_id in varchar2) return varchar2 ;
57 function c_contact_phoneformula(new_hire_contact_id in varchar2) return varchar2 ;
58 function c_contact_titleformula(new_hire_contact_id in varchar2) return varchar2 ;
59 function c_tax_unit_addressformula(location_id in number) return varchar2 ;
60 --procedure gre_record(federal_id in varchar2,TAX_UNIT_ID in number) ;
61 procedure gre_record(gre_location_id in number, federal_id in varchar2,TAX_UNIT_ID in number,
62 SIT_COMPANY_STATE_ID in varchar2, TAX_UNIT_NAME in varchar2) ;
63 PROCEDURE P_OUTPUT_NEW_HIRE_NULL ;
64 Function CP_pre_tax_unit_id_p return number;
65 Function C_BUSINESS_GROUP_NAME_p return varchar2;
66 Function C_REPORT_SUBTITLE_p return varchar2;
67 Function C_TAX_UNIT_p return varchar2;
68 Function C_STATE_NAME_p return varchar2;
69 Function C_MEDICAL_AVAIL_p return varchar2;
70 Function C_END_OF_TIME_p return date;
71 Function C_STATE_COUNT_p return number;
72 Function C_OLD_STATE_p return varchar2;
73 Function C_no_of_newhire_p return number;
74 Function C_no_of_gre_p return number;
75 Function C_no_of_multi_state_p return number;
76 Function C_Fatal_error_flag_p return number;
77 Function C_a03_header_flag_p return number;
78 END PER_PERUSHRM_XMLP_PKG;