PACKAGE BODY: APPS.IGI_IGILGCCR_XMLP_PKG

Source

1 PACKAGE BODY IGI_IGILGCCR_XMLP_PKG AS
2 /* $Header: IGILGCCRB.pls 120.0.12010000.1 2008/07/29 08:58:58 appldev ship $ */
3   FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4   BEGIN
5     P_ORDERBY_T := NVL(P_ORDERBY,'1');
6     CP_SELECT := ' , hr1.name';
7     CP_FROM := ', HR_OPERATING_UNITS HR1 ';
8     CP_WHERE := 'AND (hr1.organization_id  = nvl(gc.org_id,-1))
9                 		  AND hr1.name BETWEEN NVL(' || '''' || P_ORG_NAME_LOW || '''' || ',hr1.name)
10                 		  AND NVL(' || '''' || P_ORG_NAME_HIGH || '''' || ',hr1.name) ';
11     IF P_RUN_AOL = 'Y' THEN
12       P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
13       NULL;
14     END IF;
15     RETURN (TRUE);
16   END BEFOREREPORT;
17 
18   FUNCTION MULTI_ORG RETURN BOOLEAN IS
19     L_ORG_ID NUMBER;
20   BEGIN
21     SELECT
22       ORG_ID
23     INTO L_ORG_ID
24     FROM
25       IGI_GCC_INST_OPTIONS_ALL
26     WHERE ROWNUM = 1;
27     RETURN (TRUE);
28   EXCEPTION
29     WHEN NO_DATA_FOUND THEN
30       P_NO_DATA := 'FALSE';
31       RETURN (FALSE);
32   END MULTI_ORG;
33 
34   FUNCTION AFTERREPORT RETURN BOOLEAN IS
35   BEGIN
36     IF P_RUN_AOL = 'Y' THEN
37       P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
38       NULL;
39     END IF;
40     NULL;
41     RETURN (TRUE);
42   END AFTERREPORT;
43 
44   FUNCTION BETWEENPAGE RETURN BOOLEAN IS
45   BEGIN
46     RETURN (TRUE);
47   END BETWEENPAGE;
48 
49   FUNCTION BEFOREPFORM RETURN BOOLEAN IS
50   BEGIN
51     RETURN (TRUE);
52   END BEFOREPFORM;
53 
54   FUNCTION AFTERPFORM RETURN BOOLEAN IS
55   BEGIN
56     RETURN (TRUE);
57   END AFTERPFORM;
58 
59   FUNCTION CP_WHERE_P RETURN VARCHAR2 IS
60   BEGIN
61     RETURN CP_WHERE;
62   END CP_WHERE_P;
63 
64   FUNCTION CP_FROM_P RETURN VARCHAR2 IS
65   BEGIN
66     RETURN CP_FROM;
67   END CP_FROM_P;
68 
69   FUNCTION CP_SELECT_P RETURN VARCHAR2 IS
70   BEGIN
71     RETURN CP_SELECT;
72   END CP_SELECT_P;
73 
74 END IGI_IGILGCCR_XMLP_PKG;