DBA Data[Home] [Help]

PACKAGE: APPS.IGI_IGILGCCR_XMLP_PKG

Source


1 PACKAGE IGI_IGILGCCR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGILGCCRS.pls 120.0.12010000.1 2008/07/29 08:58:59 appldev ship $ */
3   P_ORG_NAME_HIGH VARCHAR2(240);
4 
5   P_OPT_NAME_HIGH VARCHAR2(5);
6 
7   P_ORDERBY VARCHAR2(32767);
8   P_ORDERBY_T VARCHAR2(32767) ;
9 
10   P_OPT_NAME_LOW VARCHAR2(5);
11 
12   P_ORG_NAME_LOW VARCHAR2(240);
13 
14   P_NO_DATA VARCHAR2(8);
15 
16   P_DEBUG VARCHAR2(1);
17 
18   P_RUN_AOL VARCHAR2(1);
19 
20   P_CONC_REQUEST_ID NUMBER;
21 
22   CP_WHERE VARCHAR2(1000) := 'and hr1.organization_id = nvl(gc.org_id,-1)';
23 
24   CP_FROM VARCHAR2(200) := ', hr_operating_units hr1';
25 
26   CP_SELECT VARCHAR2(200) := ', hr1.name';
27 
28   FUNCTION BEFOREREPORT RETURN BOOLEAN;
29 
30   FUNCTION MULTI_ORG RETURN BOOLEAN;
31 
32   FUNCTION AFTERREPORT RETURN BOOLEAN;
33 
34   FUNCTION BETWEENPAGE RETURN BOOLEAN;
35 
36   FUNCTION BEFOREPFORM RETURN BOOLEAN;
37 
38   FUNCTION AFTERPFORM RETURN BOOLEAN;
39 
40   FUNCTION CP_WHERE_P RETURN VARCHAR2;
41 
42   FUNCTION CP_FROM_P RETURN VARCHAR2;
43 
44   FUNCTION CP_SELECT_P RETURN VARCHAR2;
45 
46 END IGI_IGILGCCR_XMLP_PKG;