PACKAGE: APPS.INV_INVTRACS_XMLP_PKG

Source

1 PACKAGE INV_INVTRACS_XMLP_PKG AS
2 /* $Header: INVTRACSS.pls 120.2 2008/01/08 06:33:52 dwkrishn noship $ */
3   P_GL_BATCH_ID NUMBER;
4   P_ACCT_HI VARCHAR2(900);
5   P_ACCT_LO VARCHAR2(900);
6   P_SORT_ID NUMBER;
7   P_ORG_ID NUMBER;
8   P_FROM_DATE VARCHAR2(40);
9   P_FROM_DATE_T VARCHAR2(40);
10   P_FROM_DATE_DSP VARCHAR2(40);
11   P_TO_DATE VARCHAR2(40);
12   P_TO_DATE_T VARCHAR2(40);
13   P_TO_DATE_DSP VARCHAR2(40);
14   P_WHERE_ACCT VARCHAR2(2000):='1=1';
15   P_STRUCT_NUM NUMBER;
16   P_ACCT_FLEX VARCHAR2(2000):='GCC.SEGMENT1||''\n''||GCC.SEGMENT2||''\n''||GCC.SEGMENT3||''\n''||GCC.SEGMENT4||''\n''||GCC.SEGMENT5||''\n''||GCC.SEGMENT6||''\n''||GCC.SEGMENT7||''\n''||GCC.SEGMENT8||''\n''||GCC.SEGMENT9||''\n''||GCC.SEGMENT10||''\n''||
17   GCC.SEGMENT11||''\n''||GCC.SEGMENT12||''\n''||GCC.SEGMENT13||''\n''||GCC.SEGMENT14||''\n''||GCC.SEGMENT15||''\n''||GCC.SEGMENT16||''\n''||GCC.SEGMENT17||''\n''||GCC.SEGMENT18||''\n''||GCC.SEGMENT19||''\n''||GCC.SEGMENT20';
18   P_ITEM_FLEX VARCHAR2(2000) := '(MSI.SEGMENT1||''\n''||MSI.SEGMENT2||''\n''||MSI.SEGMENT3||''\n''||MSI.SEGMENT4||''\n''||MSI.SEGMENT5||''\n''||MSI.SEGMENT6||''\n''||MSI.SEGMENT7||''\n''||MSI.SEGMENT8||''\n''||MSI.SEGMENT9||''\n''||
19   MSI.SEGMENT10||''\n''||MSI.SEGMENT11||''\n''||MSI.SEGMENT12||''\n''||MSI.SEGMENT13||''\n''||MSI.SEGMENT14||''\n''||MSI.SEGMENT15||''\n''||MSI.SEGMENT16||''\n''||MSI.SEGMENT17||''\n''||MSI.SEGMENT18||''\n''||MSI.SEGMENT19||''\n''||MSI.SEGMENT20)';
20   P_CONC_REQUEST_ID NUMBER := 0;
21   P_GL_STRUCT_NUM NUMBER;
22   P_DATE_RANGE VARCHAR2(200);
23   FUNCTION SORT_COLFORMULA RETURN VARCHAR2;
24   FUNCTION GET_DEBIT(NET_ACTIVITY IN NUMBER) RETURN NUMBER;
25   FUNCTION GET_CREDIT(NET_ACTIVITY IN NUMBER) RETURN NUMBER;
26   FUNCTION BEFOREREPORT RETURN BOOLEAN;
27   FUNCTION AFTERREPORT RETURN BOOLEAN;
28   FUNCTION C_CURRENCY_CODEFORMULA(R_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
29   FUNCTION C_GL_BATCH_WHEREFORMULA RETURN VARCHAR2;
30   FUNCTION C_GL_BATCH_FROMFORMULA RETURN VARCHAR2;
31   FUNCTION C_TYPE_FROMFORMULA RETURN VARCHAR2;
32   FUNCTION C_TYPE_WHEREFORMULA RETURN VARCHAR2;
33   FUNCTION C_ITEM_FROMFORMULA RETURN VARCHAR2;
34   FUNCTION C_ITEM_WHEREFORMULA RETURN VARCHAR2;
35   FUNCTION C_BATCH_DESCFORMULA RETURN VARCHAR2;
36   FUNCTION C_ACCT_PADFORMULA(C_ACCT_PAD IN VARCHAR2) RETURN VARCHAR2;
37   FUNCTION C_SORT_PADFORMULA(C_SORT_PAD IN VARCHAR2
38                             ,SORT_OPTION IN VARCHAR2) RETURN VARCHAR2;
39   FUNCTION C_DATE_WHEREFORMULA RETURN VARCHAR2;
40   FUNCTION C_BATCH_SELFORMULA RETURN VARCHAR2;
41   FUNCTION AFTERPFORM RETURN BOOLEAN;
42   FUNCTION BETWEENPAGE RETURN BOOLEAN;
43 END INV_INVTRACS_XMLP_PKG;
44 
45 
46