PACKAGE: APPS.PER_PERUSHIR_XMLP_PKG

Source

1 PACKAGE PER_PERUSHIR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PERUSHIRS.pls 120.0.12020000.3 2013/02/20 06:39:43 agarai ship $ */
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(20); --bug 14532612 , increased size from 4 to 20
35 
36   C_END_OF_TIME DATE;
37 
38   C_END_OF_TIME_V VARCHAR2(100); --bug 16304382
39 
40   FUNCTION BEFOREREPORT RETURN BOOLEAN;
41 
42   FUNCTION C_EMPLOYEE_ADDRESSFORMULA(PERSON_ID IN NUMBER) RETURN VARCHAR2;
43 
44   FUNCTION C_CONTACT_NAMEFORMULA(NEW_HIRE_CONTACT_ID IN VARCHAR2) RETURN VARCHAR2;
45 
46   FUNCTION C_SALARYFORMULA(ASSIGNMENT_ID IN NUMBER) RETURN NUMBER;
47 
48   FUNCTION AFTERREPORT RETURN BOOLEAN;
49 
50   FUNCTION G_TAX_UNIT_HEADERGROUPFILTER RETURN BOOLEAN;
51 
52   FUNCTION G_NEW_HIRESGROUPFILTER RETURN BOOLEAN;
53 
54   FUNCTION C_TAX_UNIT_ADDRESSFORMULA(LOCATION_ID IN NUMBER) RETURN VARCHAR2;
55 
56   PROCEDURE P_UPDATE_STATUS;
57 
58   FUNCTION C_CONTACT_TITLEFORMULA(NEW_HIRE_CONTACT_ID IN VARCHAR2) RETURN VARCHAR2;
59 
60   FUNCTION C_CONTACT_PHONEFORMULA(NEW_HIRE_CONTACT_ID IN VARCHAR2) RETURN VARCHAR2;
61 
62   FUNCTION BETWEENPAGE RETURN BOOLEAN;
63 
64   PROCEDURE P_OUTPUT_NEW_HIRE_NULL;
65 
66   FUNCTION AFTERPFORM RETURN BOOLEAN;
67 
68   FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
69 
70   FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
71 
72   FUNCTION C_TAX_UNIT_P RETURN VARCHAR2;
73 
74   FUNCTION C_STATE_NAME_P RETURN VARCHAR2;
75 
76   FUNCTION C_MEDICAL_AVAIL_P RETURN VARCHAR2;
77 
78   FUNCTION C_END_OF_TIME_P RETURN VARCHAR2; --Changed the return type to VARCHAR2, bug 16304382
79 
80   FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
81 
82 
83   FUNCTION END_OF_TIME RETURN DATE;
84 
85   FUNCTION GET_ORG_NAME(P_ORGANIZATION_ID IN NUMBER
86                        ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
87 
88   FUNCTION GET_STATE_NAME(P_STATE_CODE IN VARCHAR2) RETURN VARCHAR2;
89 
90 PROCEDURE GET_EMPLOYEE_ADDRESS(P_PERSON_ID IN NUMBER
91                                 ,P_ADDRESS OUT NOCOPY VARCHAR2);
92 PROCEDURE SET_LOCATION(PROCEDURE_NAME IN VARCHAR2
93                         ,STAGE IN NUMBER);
94  PROCEDURE TRACE(TRACE_DATA IN VARCHAR2);
95 
96  FUNCTION GET_SALARY(P_PAY_BASIS_ID IN NUMBER
97                      ,P_ASSIGNMENT_ID IN NUMBER) RETURN VARCHAR2;
98 
99 FUNCTION GET_SALARY(P_BUSINESS_GROUP_ID IN NUMBER
100                      ,P_ASSIGNMENT_ID IN NUMBER
101                      ,P_REPORT_DATE IN DATE) RETURN NUMBER;
102 
103 PROCEDURE GET_ADDRESS(P_LOCATION_ID IN NUMBER
104                        ,P_ADDRESS OUT NOCOPY VARCHAR2);
105 
106 END PER_PERUSHIR_XMLP_PKG;