PACKAGE: APPS.PER_PERUSHIR_XMLP_PKG

Source

1 PACKAGE PER_PERUSHIR_XMLP_PKG AS
2 /* $Header: PERUSHIRS.pls 120.0 2007/12/28 07:01:07 srikrish noship $ */
3 
4   FLAG1 NUMBER := 0;
5 
6   FLAG2 NUMBER := 0;
7 
8   P_BUSINESS_GROUP_ID NUMBER;
9 
10   P_TAX_UNIT_ID NUMBER;
11 
12   P_REPORT_DATE VARCHAR2(32767);
13 
14   P_REPORT_DATE_T VARCHAR2(40);
15 
16   P_STATE_CODE VARCHAR2(40);
17 
18   P_WAITING_PERIOD NUMBER;
19 
20   P_MEDICAL_AVAIL VARCHAR2(4);
21 
22   P_CONC_REQUEST_ID NUMBER;
23 
24   P_REPORT_MODE VARCHAR2(1);
25 
26   C_BUSINESS_GROUP_NAME VARCHAR2(240);
27 
28   C_REPORT_SUBTITLE VARCHAR2(60);
29 
30   C_TAX_UNIT VARCHAR2(240);
31 
32   C_STATE_NAME VARCHAR2(60);
33 
34   C_MEDICAL_AVAIL VARCHAR2(4);
35 
36   C_END_OF_TIME DATE;
37 
38   FUNCTION BEFOREREPORT RETURN BOOLEAN;
39 
40   FUNCTION C_EMPLOYEE_ADDRESSFORMULA(PERSON_ID IN NUMBER) RETURN VARCHAR2;
41 
42   FUNCTION C_CONTACT_NAMEFORMULA(NEW_HIRE_CONTACT_ID IN VARCHAR2) RETURN VARCHAR2;
43 
44   FUNCTION C_SALARYFORMULA(ASSIGNMENT_ID IN NUMBER) RETURN NUMBER;
45 
46   FUNCTION AFTERREPORT RETURN BOOLEAN;
47 
48   FUNCTION G_TAX_UNIT_HEADERGROUPFILTER RETURN BOOLEAN;
49 
50   FUNCTION G_NEW_HIRESGROUPFILTER RETURN BOOLEAN;
51 
52   FUNCTION C_TAX_UNIT_ADDRESSFORMULA(LOCATION_ID IN NUMBER) RETURN VARCHAR2;
53 
54   PROCEDURE P_UPDATE_STATUS;
55 
56   FUNCTION C_CONTACT_TITLEFORMULA(NEW_HIRE_CONTACT_ID IN VARCHAR2) RETURN VARCHAR2;
57 
58   FUNCTION C_CONTACT_PHONEFORMULA(NEW_HIRE_CONTACT_ID IN VARCHAR2) RETURN VARCHAR2;
59 
60   FUNCTION BETWEENPAGE RETURN BOOLEAN;
61 
62   PROCEDURE P_OUTPUT_NEW_HIRE_NULL;
63 
64   FUNCTION AFTERPFORM RETURN BOOLEAN;
65 
66   FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
67 
68   FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
69 
70   FUNCTION C_TAX_UNIT_P RETURN VARCHAR2;
71 
72   FUNCTION C_STATE_NAME_P RETURN VARCHAR2;
73 
74   FUNCTION C_MEDICAL_AVAIL_P RETURN VARCHAR2;
75 
76   FUNCTION C_END_OF_TIME_P RETURN DATE;
77 
78   FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
79 
80 
81   FUNCTION END_OF_TIME RETURN DATE;
82 
83   FUNCTION GET_ORG_NAME(P_ORGANIZATION_ID IN NUMBER
84                        ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
85 
86   FUNCTION GET_STATE_NAME(P_STATE_CODE IN VARCHAR2) RETURN VARCHAR2;
87 
88 PROCEDURE GET_EMPLOYEE_ADDRESS(P_PERSON_ID IN NUMBER
89                                 ,P_ADDRESS OUT NOCOPY VARCHAR2);
90 PROCEDURE SET_LOCATION(PROCEDURE_NAME IN VARCHAR2
91                         ,STAGE IN NUMBER);
92  PROCEDURE TRACE(TRACE_DATA IN VARCHAR2);
93 
94  FUNCTION GET_SALARY(P_PAY_BASIS_ID IN NUMBER
95                      ,P_ASSIGNMENT_ID IN NUMBER) RETURN VARCHAR2;
96 
97 FUNCTION GET_SALARY(P_BUSINESS_GROUP_ID IN NUMBER
98                      ,P_ASSIGNMENT_ID IN NUMBER
99                      ,P_REPORT_DATE IN DATE) RETURN NUMBER;
100 
101 PROCEDURE GET_ADDRESS(P_LOCATION_ID IN NUMBER
102                        ,P_ADDRESS OUT NOCOPY VARCHAR2);
103 
104 END PER_PERUSHIR_XMLP_PKG;