PACKAGE: APPS.HXC_HXCMISTC_XMLP_PKG

Source

1 PACKAGE HXC_HXCMISTC_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: HXCMISTCS.pls 120.1 2011/11/16 12:02:43 pnshukla ship $ */
3   P_SORT_OPTION1 VARCHAR2(80);
4 
5    P_SORT_OPTION2 VARCHAR2(80);
6 
7    P_SORT_OPTION3 VARCHAR2(80);
8 
9    P_SORT_OPTION4 VARCHAR2(80);
10 
11    P_SORT1_LABEL VARCHAR2(100);
12 
13    P_SORT2_LABEL VARCHAR2(100);
14 
15    P_SORT3_LABEL VARCHAR2(100);
16 
17    P_SORT4_LABEL VARCHAR2(100);
18 
19    COL_1 VARCHAR2(100) := 'hxc_tpd_end.get_org_name(paf.organization_id)';
20 
21    COL_2 VARCHAR2(100) := 'hxc_tpd_end.get_locn_name(paf.location_id)';
22 
23    COL_3 VARCHAR2(80) := 'hxc_tpd_end.get_payroll_name(paf.payroll_id) ';
24 
25    COL_4 VARCHAR2(240) := 'ppf.full_name';
26 
27    P_ORGANIZATION VARCHAR2(240);
28 
29    P_DATE_TO DATE;
30 
31    P_DATE_FROM DATE;
32 
33    P_APPLICATION VARCHAR2(30);
34 
35    P_DEFINE_MISSING VARCHAR2(80);
36 
37    P_SELECT_CONDITION VARCHAR2(240);
38 
39    P_BUSINESS_GROUP_ID NUMBER;
40 
41    P_LOCATION VARCHAR2(80);
42 
43    P_PAYROLL_ASSIGNMENT_SET VARCHAR2(80);
44 
45    P_PAYROLL VARCHAR2(40);
46 
47    P_PERSON_NAME VARCHAR2(80);
48 
49    P_PERSON_NUMBER NUMBER;
50 
51    P_SUPERVISOR VARCHAR2(40);
52 
53    P_SELECT_CONDITION2 VARCHAR2(700);
54 
55    P_DEFINE_LABEL VARCHAR2(80);
56 
57    P_APPLICATION_LABEL VARCHAR2(80);
58 
59    P_PERSON_NAME_LABEL VARCHAR2(80);
60 
61    P_PERSON_NUMBER_LABEL VARCHAR2(80);
62 
63    P_LOCATION_LABEL VARCHAR2(80);
64 
65    P_ORGANIZATION_LABEL VARCHAR2(240);
66 
67    P_PAYROLL_LABEL VARCHAR2(80);
68 
69    P_ASSIGNMENT_SET_LABEL VARCHAR2(80);
70 
71    P_SUPERVISOR_LABEL VARCHAR2(80);
72 
73    P_SELECT_CONDITION3 VARCHAR2(40);
74 
75    P_DEBUG VARCHAR2(32767);
76 
77    P_CONC_REQUEST_ID NUMBER;
78 
79    P_PERSON_TYPE VARCHAR2(32767);
80 
81    PERSON_TYPE1 VARCHAR2(1000);
82 
83    PERSON_TYPE2 VARCHAR2(1000);
84 
85    ASSIGNMENT_TYPE1 VARCHAR2(1000);
86 
87    P_ASSIGNMENT_TYPE VARCHAR2(1000);
88 
89    P_VENDOR_ID VARCHAR2(40);
90 
91    P_VENDOR_LABEL VARCHAR2(100);
92 
93    P_PERSON_TYPE_LABEL VARCHAR2(80);
94 
95    P_ASSIGNMENT_TYPE_LABEL VARCHAR2(80);
96 
97    PERSON_TYPE3 VARCHAR2(1000);
98 
99    status_condition  VARCHAR2(40);
100 
101    opt_hint2  VARCHAR2(400);
102 
103    org_condition  VARCHAR2(100);
104 
105    org_condition2  VARCHAR2(100);
106 
107    opt_hint  VARCHAR2(400);
108 
109    payroll_condition2  VARCHAR2(100);
110 
111    payroll_condition  VARCHAR2(100);
112 
113    locn_condition VARCHAR2(200);
114 
115    locn_condition2 VARCHAR2(200);
116 
117    sup_condition VARCHAR2(40);
118 
119    sup_condition2 VARCHAR2(40);
120 
121    person_condition VARCHAR2(40);
122 
123    per_no_condition VARCHAR2(40);
124 
125 
126    FUNCTION AFTERPFORM RETURN BOOLEAN;
127 
128    FUNCTION CF_APPLICATIONFORMULA RETURN CHAR;
129 
130    PROCEDURE SORT_OPTION(L_SORT_OPTION IN VARCHAR2
131                         ,L_SORT_BY OUT NOCOPY VARCHAR2
132                         ,L_SORT_LABEL OUT NOCOPY VARCHAR2);
133 
134    FUNCTION CF_RESOURCE_PREFFORMULA(PERSON_ID1 IN NUMBER) RETURN CHAR;
135 
136    FUNCTION G_START_TIMEGROUPFILTER(APPROVAL_STATUS IN VARCHAR2
137                                    ,P_COUNT IN NUMBER
138                                    ,RESOURCE_ID1 IN NUMBER) RETURN BOOLEAN;
139 
140    FUNCTION G_ROWNUMGROUPFILTER(START_TIME1 IN DATE) RETURN BOOLEAN;
141 
142    FUNCTION BEFOREREPORT RETURN BOOLEAN;
143 
144    FUNCTION AFTERREPORT RETURN BOOLEAN;
145 
146 
147 
148 END HXC_HXCMISTC_XMLP_PKG;