PACKAGE BODY: APPS.IGC_IGCPOYEE_XMLP_PKG

Source

1 PACKAGE BODY IGC_IGCPOYEE_XMLP_PKG AS
2 /* $Header: IGCPOYEEB.pls 120.0.12010000.1 2008/07/28 06:31:38 appldev ship $ */
3   FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4   BEGIN
5     P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
6     /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
7     RETURN (TRUE);
8   END BEFOREREPORT;
9 
10   FUNCTION AFTERREPORT RETURN BOOLEAN IS
11   BEGIN
12     /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
13     RETURN (TRUE);
14   END AFTERREPORT;
15 
16   FUNCTION CF_PROC_PHASEFORMULA RETURN CHAR IS
17     V_PROCESS_DESC VARCHAR2(30);
18   BEGIN
19     SELECT
20       MEANING
21     INTO V_PROCESS_DESC
22     FROM
23       FND_LOOKUPS
24     WHERE LOOKUP_TYPE = 'IGC_CC_PROCESS_PHASE'
25       AND LOOKUP_CODE = P_PROCESS_PHASE;
26     RETURN (V_PROCESS_DESC);
27   EXCEPTION
28     WHEN NO_DATA_FOUND THEN
29       RETURN (NULL);
30   END CF_PROC_PHASEFORMULA;
31 
32 END IGC_IGCPOYEE_XMLP_PKG;