PACKAGE BODY: APPS.IGI_IGISLSST_XMLP_PKG

Source

1 PACKAGE BODY IGI_IGISLSST_XMLP_PKG AS
2 /* $Header: IGISLSSTB.pls 120.0.12010000.1 2008/07/29 08:59:45 appldev ship $ */
3   FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4   BEGIN
5     P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
6     P_OWNER_T := nvl(P_OWNER,'%');
7     P_TABLE_NAME_T := nvl(P_TABLE_NAME,'%');
8     RETURN (TRUE);
9   END BEFOREREPORT;
10 
11   FUNCTION AFTERREPORT RETURN BOOLEAN IS
12   BEGIN
13     null;
14     RETURN (TRUE);
15   END AFTERREPORT;
16 
17   FUNCTION CF_1FORMULA(OWNER IN VARCHAR2) RETURN NUMBER IS
18   BEGIN
19     CP_OWNER := OWNER;
20     RETURN (1);
21   END CF_1FORMULA;
22 
23   FUNCTION CP_OWNER_P RETURN VARCHAR2 IS
24   BEGIN
25     RETURN CP_OWNER;
26   END CP_OWNER_P;
27 
28 FUNCTION F_DATE_ENABLED1FORMATTRIGGER(DATE_DISABLED2 IN DATE,DATE_ENABLED2 IN DATE,DATE_REMOVED2 IN DATE,DATE_DISABLED_AU IN DATE,DATE_ENABLED_AU IN DATE,DATE_REMOVED_AU IN DATE) RETURN VARCHAR2 IS
29 P_DATE     DATE := SYSDATE;
30 
31 BEGIN
32 
33   IF  NVL(DATE_DISABLED2, P_DATE) =  NVL(DATE_DISABLED_AU, P_DATE)
34   AND NVL(DATE_ENABLED2,P_DATE) = NVL(DATE_ENABLED_AU, P_DATE)
35   AND NVL(DATE_REMOVED2, P_DATE) = NVL(DATE_REMOVED_AU, P_DATE)
36   THEN
37      RETURN ('N');
38   ELSE
39      RETURN ('Y');
40   END IF;
41 
42 END;
43 
44 
45 END IGI_IGISLSST_XMLP_PKG;