PACKAGE: APPS.GME_GMEBCHTK_XMLP_PKG

Source

1 PACKAGE GME_GMEBCHTK_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: GMEBCHTKS.pls 120.1 2010/05/12 09:44:37 apmishra ship $ */
3   P_ORGN VARCHAR2(6);
4   --
5   -- Bug 9705739
6   -- Defined the batch number variables as number for
7   -- proper range selection.
8   --
9   --FROM_BATCH_NO VARCHAR2(32);
10   FROM_BATCH_NO number;
11   --TO_BATCH_NO VARCHAR2(32);
12   TO_BATCH_NO number;
13   FROM_START_DATE DATE;
14   FROM_START_DATE_1 varchar2(11);
15   FROM_START_DATE1 varchar2(20);
16   TO_START_DATE DATE;
17   TO_START_DATE_1 varchar2(11);
18  TO_START_DATE1 varchar2(20);
19   SORT_BY VARCHAR2(80);
20   NONBLOCKSQL VARCHAR2(5);
21   P_CONC_REQUEST_ID NUMBER := 0;
22   P_ORG_ID NUMBER;
23   FUNCTION RANGECF1FORMULA RETURN VARCHAR2;
24   FUNCTION RANGECF2FORMULA RETURN VARCHAR2;
25   FUNCTION ORDCFFORMULA RETURN VARCHAR2;
26   FUNCTION FLAGCFFORMULA(TEXTCODE2 IN NUMBER) RETURN NUMBER;
27   FUNCTION AFTERPFORM RETURN BOOLEAN;
28   FUNCTION BEFOREREPORT RETURN BOOLEAN;
29   FUNCTION TYPE_DESCCFFORMULA(MEANING IN VARCHAR2) RETURN VARCHAR2;
30   FUNCTION SORTRETCFFORMULA RETURN VARCHAR2;
31   PROCEDURE HEADER;
32   FUNCTION AFTERREPORT RETURN BOOLEAN;
33   FUNCTION CF_CONTEXT_ORGFORMULA RETURN VARCHAR2;
34   FUNCTION CF_SUBINV_LABELFORMULA(LINE_TYPE IN NUMBER) RETURN CHAR;
35   P_ROWS NUMBER(10);
36   CNTTEXT NUMBER(10);
37   function R_batchFormatTrigger(batch_no1 VARCHAR2) return varchar2;
38 END GME_GMEBCHTK_XMLP_PKG;
39