[Home] [Help]
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;