eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.INV_INVTRDST_XMLP_PKG

Source


1 PACKAGE INV_INVTRDST_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVTRDSTS.pls 120.2.12020000.2 2012/08/15 10:20:52 rgangara ship $ */
3   P_SOURCE_TYPE_ID NUMBER;
4   P_STRUCT_NUM VARCHAR2(15);
5   P_CONC_REQUEST_ID NUMBER := 0;
6   P_ITEM_FLEX VARCHAR2(2000);
7   P_ACCT_FLEX VARCHAR2(2000);
8   P_DATE_LO VARCHAR2(22);
9   P_DATE_HI VARCHAR2(22);
10   CP_DATE_LO VARCHAR2(30);
11   CP_DATE_HI VARCHAR2(30);
12   P_DATE_LO_1 VARCHAR2(30);
13   P_DATE_HI_1 VARCHAR2(30);
14   P_ORG_ID NUMBER;
15   P_WHERE_ACCT VARCHAR2(2000);
16   P_ACCT_LO VARCHAR2(900);
17   P_SOURCE_LO VARCHAR2(900);
18   P_SOURCE_HI VARCHAR2(900);
19   P_SOURCE_WHERE VARCHAR2(2000);
20   P_ACCT_HI VARCHAR2(900);
21   P_SORT_ID NUMBER;
22   P_TXN_TYPE_ID NUMBER;
23   P_GL_BATCH_ID NUMBER;
24   P_WHERE_ITEM VARCHAR2(2000);
25   P_ITEM_LO VARCHAR2(900);
26   P_ITEM_HI VARCHAR2(900);
27   P_SUBINV_LO VARCHAR2(40);
28   P_VALUE_LO NUMBER;
29   P_VALUE_HI NUMBER;
30   P_SUBINV_HI VARCHAR2(40);
31   P_CBO_FLAG VARCHAR2(40);
32   P_ACCT_STRUCT_NUM NUMBER;
33   P_CAT_HI VARCHAR2(900);
34   P_CAT_LO VARCHAR2(900);
35   P_REASON_ID NUMBER;
36   P_WHERE_CAT VARCHAR2(2000);
37   P_CAT_SET_ID NUMBER;
38   P_SO_FLEX VARCHAR2(2000);
39   P_ALIAS_FLEX VARCHAR2(2000);
40   P_GL_FLEX VARCHAR2(2000);
41   P_TYPE_OPTION NUMBER;
42   P_CAT_STRUCT_NUM VARCHAR2(15);
43   P_ITEM_SORT VARCHAR2(900);
44   P_ACCT_SORT VARCHAR2(900);
45   P_QTY_PRECISION NUMBER;
46   P_TRACE_FLAG NUMBER;
47   P_DATE_RANGE VARCHAR2(200);
48   P_CURRENCY_CODE VARCHAR2(15);
49   P_EXCHANGE_RATE NUMBER;
50   P_EXCHANGE_RATE_CHAR VARCHAR2(38);
51   P_SOURCE_TYPE VARCHAR2(1000) := ' and 1 = 1 ';
52   P_TXN_TYPE VARCHAR2(100) := ' and 1 = 1 ';
53   P_GL_BATCH VARCHAR2(100) := ' and 1 = 1 ';
54   FORMAT_MASK varchar2(100);
55   FUNCTION C_SOURCE_TYPE_NAMEFORMULA RETURN VARCHAR2;
56   FUNCTION BEFOREREPORT RETURN BOOLEAN;
57   FUNCTION AFTERREPORT RETURN BOOLEAN;
58   FUNCTION C_ACCT_PAD0FORMULA(C_ACCT_PAD0 IN VARCHAR2) RETURN VARCHAR2;
59   FUNCTION C_ACCT_PAD1FORMULA(C_ACCT_PAD1 IN VARCHAR2) RETURN VARCHAR2;
60   FUNCTION C_ACCT_PAD2FORMULA(C_ACCT_PAD2 IN VARCHAR2) RETURN VARCHAR2;
61   FUNCTION C_ACCT_PAD3FORMULA(C_ACCT_PAD3 IN VARCHAR2) RETURN VARCHAR2;
62   FUNCTION C_ACCT_PAD4FORMULA(C_ACCT_PAD4 IN VARCHAR2) RETURN VARCHAR2;
63   FUNCTION C_ITEM_PAD1FORMULA(C_ITEM_PAD1 IN VARCHAR2) RETURN VARCHAR2;
64   FUNCTION C_ITEM_PAD2FORMULA(C_ITEM_PAD2 IN VARCHAR2) RETURN VARCHAR2;
65   FUNCTION WHERE_SUBINV RETURN VARCHAR2;
66   FUNCTION WHERE_VALUE RETURN VARCHAR2;
67   FUNCTION C_WHERE_REASONFORMULA RETURN VARCHAR2;
68   FUNCTION C_FROM_CATFORMULA RETURN VARCHAR2;
69   FUNCTION C_WHERE_CATFORMULA RETURN VARCHAR2;
70   FUNCTION C_CAT_SET_NAMEFORMULA RETURN VARCHAR2;
71   FUNCTION C_TXN_TYPE_NAMEFORMULA RETURN VARCHAR2;
72   FUNCTION C_REASON_NAMEFORMULA RETURN VARCHAR2;
73   FUNCTION C_TYPE_OPTIONFORMULA RETURN VARCHAR2;
74   FUNCTION C_FROM_TYPEFORMULA RETURN VARCHAR2;
75   FUNCTION C_WHERE_TYPEFORMULA RETURN VARCHAR2;
76   FUNCTION C_CURRENCY_CODEFORMULA(R_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
77   FUNCTION AFTERPFORM RETURN BOOLEAN;
78   FUNCTION C_DATE_WHEREFORMULA RETURN VARCHAR2;
79   FUNCTION C_SOURCE_FROMFORMULA RETURN VARCHAR2;
80   FUNCTION C_ACCT_VALUE0_RFORMULA(C_ACCT_VALUE0 IN NUMBER
81                                  ,C_EXT_PREC IN NUMBER) RETURN NUMBER;
82   FUNCTION VALUE_RFORMULA(VALUE IN NUMBER
83                          ,C_EXT_PREC IN NUMBER) RETURN NUMBER;
84   FUNCTION C_REPORT_VALUE_RFORMULA(C_REPORT_VALUE IN NUMBER
85                                   ,C_EXT_PREC IN NUMBER) RETURN NUMBER;
86   FUNCTION C_ACCT_VALUE1_RFORMULA(C_ACCT_VALUE1 IN NUMBER
87                                  ,C_EXT_PREC IN NUMBER) RETURN NUMBER;
88   FUNCTION C_ACCT_VALUE3_RFORMULA(C_ACCT_VALUE3 IN NUMBER
89                                  ,C_EXT_PREC IN NUMBER) RETURN NUMBER;
90   FUNCTION C_ITEM_VALUE2_RFORMULA(C_ITEM_VALUE2 IN NUMBER
91                                  ,C_EXT_PREC IN NUMBER) RETURN NUMBER;
92   FUNCTION C_SUBINV_VALUE4_RFORMULA(C_SUBINV_VALUE4 IN NUMBER
93                                    ,C_EXT_PREC IN NUMBER) RETURN NUMBER;
94   FUNCTION C_REPORT_VALUE1_RFORMULA(C_REPORT_VALUE1 IN NUMBER
95                                    ,C_EXT_PREC IN NUMBER) RETURN NUMBER;
96   FUNCTION C_REPORT_VALUE2_RFORMULA(C_REPORT_VALUE2 IN NUMBER
97                                    ,C_EXT_PREC IN NUMBER) RETURN NUMBER;
98   FUNCTION C_REPORT_VALUE3_RFORMULA(C_REPORT_VALUE3 IN NUMBER
99                                    ,C_EXT_PREC IN NUMBER) RETURN NUMBER;
100   FUNCTION C_REPORT_VALUE4_RFORMULA(C_REPORT_VALUE4 IN NUMBER
101                                    ,C_EXT_PREC IN NUMBER) RETURN NUMBER;
102   FUNCTION BEFOREPFORM RETURN BOOLEAN;
103   FUNCTION C_P_SOURCE_WHERE_FOMULA RETURN CHAR;
104   FUNCTION C_SOURCE_WHERE_SOFORMULA RETURN CHAR;
105   FUNCTION C_SOURCE_WHERE_GLFORMULA RETURN CHAR;
106   FUNCTION C_SOURCE_WHERE_ALIASFORMULA RETURN CHAR;
107   FUNCTION C_SOURCE_WHERE_NOFORMULA RETURN CHAR;
108   function C_sourceFormula(Source in varchar2, Type_id in number) return VARCHAR2;
109   function C_source1Formula(Source1 in varchar2, Type_id1 in number) return VARCHAR2;
110   function C_source2Formula(Source2 in varchar2, Type_id2 in number) return VARCHAR2;
111   function C_source3Formula(Source3 in varchar2, Type_id3 in number) return VARCHAR2;
112   function C_source4Formula(Source4 in varchar2, Type_id4 in number) return VARCHAR2;
113 END INV_INVTRDST_XMLP_PKG;
114