1 PACKAGE BODY IGI_IGISLSSA_XMLP_PKG AS
2 /* $Header: IGISLSSAB.pls 120.0.12010000.1 2008/07/29 08:59:40 appldev ship $ */
3 FUNCTION AFTERREPORT RETURN BOOLEAN IS
4 BEGIN
5 RETURN (TRUE);
6 END AFTERREPORT;
7
8 FUNCTION CF_1FORMULA(GRP_FOR_TAB_NAME IN VARCHAR2) RETURN NUMBER IS
9 BEGIN
10 CP_GRP_NAME := GRP_FOR_TAB_NAME;
11 RETURN (1);
12 END CF_1FORMULA;
13
14 FUNCTION CF_2FORMULA(GRP_FOR_PRC_NAME IN VARCHAR2) RETURN NUMBER IS
15 BEGIN
16 CP_PRC_NAME := GRP_FOR_PRC_NAME;
17 RETURN (1);
18 END CF_2FORMULA;
19
20 FUNCTION CF_3FORMULA(PRC_FOR_TAB_NAME IN VARCHAR2) RETURN NUMBER IS
21 BEGIN
22 CP_TAB_NAME := PRC_FOR_TAB_NAME;
23 RETURN (1);
24 END CF_3FORMULA;
25
26 FUNCTION BEFOREREPORT RETURN BOOLEAN IS
27 BEGIN
28 P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
29
30 P_PROCESS_NAME_T := nvl(P_PROCESS_NAME,'%');
31 P_GROUP_NAME_T := nvl(P_GROUP_NAME,'%');
32 P_TABLE_NAME_T := nvl(P_TABLE_NAME,'%');
33
34
35
36 RETURN (TRUE);
37 END BEFOREREPORT;
38
39 FUNCTION CP_GRP_NAME_P RETURN VARCHAR2 IS
40 BEGIN
41 RETURN CP_GRP_NAME;
42 END CP_GRP_NAME_P;
43
44 FUNCTION CP_PRC_NAME_P RETURN VARCHAR2 IS
45 BEGIN
46 RETURN CP_PRC_NAME;
47 END CP_PRC_NAME_P;
48
49 FUNCTION CP_TAB_NAME_P RETURN VARCHAR2 IS
50 BEGIN
51 RETURN CP_TAB_NAME;
52 END CP_TAB_NAME_P;
53
54 FUNCTION F_GTAB_DT_ENABLED_AU1FORMATTRI(GRP_TABLE_ENABLED IN DATE,GRP_TABLE_DISABLED IN DATE,GRP_TABLE_REMOVED IN DATE
55 ,GTAB_DT_ENABLED_AU IN DATE,GTAB_DT_DISABLED_AU IN DATE,GTAB_DT_REMOVED_AU IN DATE) RETURN VARCHAR IS
56 P_DATE DATE := SYSDATE;
57 BEGIN
58 IF NVL(GRP_TABLE_ENABLED,P_DATE) = NVL(GTAB_DT_ENABLED_AU, P_DATE)
59 AND NVL(GRP_TABLE_DISABLED,P_DATE) = NVL(GTAB_DT_DISABLED_AU, P_DATE)
60 AND NVL(GRP_TABLE_REMOVED,P_DATE) = NVL(GTAB_DT_REMOVED_AU,P_DATE)
61 THEN
62 RETURN ('N');
63 ELSE
64 RETURN ('Y');
65 END IF;
66 END;
67
68 FUNCTION F_GPRC_DT_ENABLED_AU1FORMATTRI(GRP_PRC_ENABLED IN DATE,GRP_PRC_DISABLED IN DATE,GRP_PRC_REMOVED IN DATE,GPRC_DT_ENABLED_AU IN DATE,GPRC_DT_DISABLED_AU IN DATE,GPRC_DT_REMOVED_AU IN DATE) RETURN VARCHAR IS
69 P_DATE DATE := SYSDATE;
70 BEGIN
71 IF NVL(GRP_PRC_ENABLED,P_DATE) = NVL(GPRC_DT_ENABLED_AU,P_DATE)
72 AND NVL(GRP_PRC_DISABLED,P_DATE) = NVL(GPRC_DT_DISABLED_AU,P_DATE)
73 AND NVL(GRP_PRC_REMOVED,P_DATE) = NVL(GPRC_DT_REMOVED_AU,P_DATE)
74 THEN
75 RETURN ('N');
76 ELSE
77 RETURN ('Y');
78 END IF;
79 END;
80
81 FUNCTION F_PTAB_DT_ENABLED_AU1FORMATTRI(PRC_TABLE_ENABLED IN DATE,PRC_TABLE_DISABLED IN DATE,PRC_TABLE_REMOVED IN DATE,PTAB_DT_ENABLED_AU IN DATE,PTAB_DT_DISABLED_AU IN DATE,PTAB_DT_REMOVED_AU IN DATE) RETURN VARCHAR IS
82 P_DATE DATE := SYSDATE;
83 BEGIN
84 IF NVL(PRC_TABLE_ENABLED,P_DATE) = NVL(PTAB_DT_ENABLED_AU,P_DATE)
85 AND NVL(PRC_TABLE_DISABLED,P_DATE)= NVL(PTAB_DT_DISABLED_AU,P_DATE)
86 AND NVL(PRC_TABLE_REMOVED,P_DATE) = NVL(PTAB_DT_REMOVED_AU,P_DATE)
87 THEN
88 RETURN ('N');
89 ELSE
90 RETURN ('Y');
91 END IF;
92 END;
93
94
95 END IGI_IGISLSSA_XMLP_PKG;