1 PACKAGE IGI_IGISLSSA_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGISLSSAS.pls 120.0.12010000.1 2008/07/29 08:59:41 appldev ship $ */
3 P_PROCESS_NAME VARCHAR2(40);
4
5 P_GROUP_NAME VARCHAR2(40);
6
7 P_TABLE_NAME VARCHAR2(40);
8 P_PROCESS_NAME_T VARCHAR2(40);
9
10 P_GROUP_NAME_T VARCHAR2(40);
11
12 P_TABLE_NAME_T VARCHAR2(40);
13
14 P_CONC_REQUEST_ID NUMBER;
15
16 CP_GRP_NAME VARCHAR2(30);
17
18 CP_PRC_NAME VARCHAR2(30);
19
20 CP_TAB_NAME VARCHAR2(30);
21
22 FUNCTION AFTERREPORT RETURN BOOLEAN;
23
24 FUNCTION CF_1FORMULA(GRP_FOR_TAB_NAME IN VARCHAR2) RETURN NUMBER;
25
26 FUNCTION CF_2FORMULA(GRP_FOR_PRC_NAME IN VARCHAR2) RETURN NUMBER;
27
28 FUNCTION CF_3FORMULA(PRC_FOR_TAB_NAME IN VARCHAR2) RETURN NUMBER;
29
30 FUNCTION BEFOREREPORT RETURN BOOLEAN;
31
32 FUNCTION CP_GRP_NAME_P RETURN VARCHAR2;
33
34 FUNCTION CP_PRC_NAME_P RETURN VARCHAR2;
35
36 FUNCTION CP_TAB_NAME_P RETURN VARCHAR2;
37
38 FUNCTION F_GTAB_DT_ENABLED_AU1FORMATTRI(GRP_TABLE_ENABLED IN DATE,GRP_TABLE_DISABLED IN DATE,GRP_TABLE_REMOVED IN DATE
39 ,GTAB_DT_ENABLED_AU IN DATE,GTAB_DT_DISABLED_AU IN DATE,GTAB_DT_REMOVED_AU IN DATE) RETURN VARCHAR;
40
41 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 ;
42
43 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;
44 END IGI_IGISLSSA_XMLP_PKG;