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.ONT_OEXPRPRS_XMLP_PKG

Source


1 PACKAGE ONT_OEXPRPRS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXPRPRSS.pls 120.1 2007/12/25 07:33:21 npannamp noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4  F1 VARCHAR2(100);
5   P_SOB_ID NUMBER;
6   P_ORDER_AMOUNT_LOW NUMBER;
7   P_ORDER_AMOUNT_HIGH NUMBER;
8   P_ORDER_TYPE_HI VARCHAR2(100);
9   P_ORDER_BY VARCHAR2(30);
10   P_ORDER_NUM_LOW VARCHAR2(32767);
11   P_ORDER_NUM_HIGH VARCHAR2(32767);
12   P_CUSTOMER_NAME_HI VARCHAR2(360);
13   P_CUSTOMER_NUMBER_HI VARCHAR2(50);
14   P_ORGANIZATION_ID VARCHAR2(32767);
15   P_AGREEMENT NUMBER;
16   P_SALESREP_HI VARCHAR2(50);
17   P_OPEN_ORDERS_ONLY VARCHAR2(50);
18   P_ORDER_LIST_HIGH NUMBER;
19   P_ORDER_LIST_LOW NUMBER;
20   P_ORDER_DATE_LOW DATE;
21   P_ORDER_DATE_HIGH DATE;
22   LP_OPEN_ORDERS_ONLY VARCHAR2(500):='and 1=1';
23   LP_ORDER_LIST VARCHAR2(500):='and 1=1';
24   LP_ORDER_AMOUNT VARCHAR2(500):='and 1=1';
25   LP_ORDER_DATE VARCHAR2(500):='and 1=1';
26   LP_AGREEMENT VARCHAR2(5000):='and 1=1';
27   LP_ORDER_NUM VARCHAR2(500):='and 1=1';
28   LP_ORDER_TYPE VARCHAR2(500):='and 1=1';
29   LP_SALESREP VARCHAR2(500):='and 1=1';
30   LP_CUSTOMER_NUMBER VARCHAR2(500):='and 1=1';
31   LP_CUSTOMER_NAME VARCHAR2(500):='and 1=1';
32   LP_HAVING VARCHAR2(1200):=' ';
33   P_CUSTOMER_NAME_LO VARCHAR2(360);
34   P_CUSTOMER_NUMBER_LO VARCHAR2(50);
35   P_SALESREP_LO VARCHAR2(50);
36   P_ORDER_TYPE_LO VARCHAR2(100);
37   P_ORDER_CATEGORY VARCHAR2(30);
38   LP_ORDER_CATEGORY VARCHAR2(500):='and 1=1';
39   LP_SORT_BY VARCHAR2(100):=' ';
40   LP_LINE_CATEGORY VARCHAR2(500):='and 1=1';
41   P_LINE_CATEGORY VARCHAR2(30);
42   P_ONE_TIME VARCHAR2(32767);
43   L_ORDER_TYPE_LOW VARCHAR2(30);
44   L_ORDER_TYPE_HIGH VARCHAR2(30);
45   RP_REPORT_NAME VARCHAR2(240);
46   RP_SUB_TITLE VARCHAR2(80);
47   RP_COMPANY_NAME VARCHAR2(50);
48   RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
49   RP_DATA_FOUND VARCHAR2(300);
50   RP_ORDER_NUMBER_RANGE VARCHAR2(100);
51   RP_ORDER_LIST_RANGE VARCHAR2(100);
52   RP_ORDER_DATE_RANGE VARCHAR2(100);
53   RP_OPEN_ORDERS_ONLY VARCHAR2(80);
54   RP_ORDER_AMOUNT_RANGE VARCHAR2(100);
55   RP_AGREEMENT_NAME VARCHAR2(240);
56   RP_ORDER_TYPE_RANGE VARCHAR2(100);
57   RP_CUSTOMER_NUMBER_RANGE VARCHAR2(100);
58   RP_CUSTOMER_NAME_RANGE VARCHAR2(100);
59   RP_SALESREP_RANGE VARCHAR2(100);
60   RP_ORDER_CATEGORY VARCHAR2(100);
61   RP_LINE_CATEGORY VARCHAR2(100);
62   FUNCTION BEFOREREPORT RETURN BOOLEAN;
63   FUNCTION AFTERREPORT RETURN BOOLEAN;
64   FUNCTION AFTERPFORM RETURN BOOLEAN;
65   FUNCTION RP_ORDER_BYFORMULA RETURN VARCHAR2;
66   FUNCTION C_DISCOUNT_PRICEFORMULA(ORDER_AMOUNT IN NUMBER
67                                   ,ORDER_LIST IN NUMBER) RETURN NUMBER;
68   FUNCTION C_DATA_NOT_FOUNDFORMULA(CURRENCY2 IN VARCHAR2) RETURN NUMBER;
69   FUNCTION C_ORDER_AMOUNTFORMULA(ORDER_AMOUNT IN NUMBER
70                                 ,C_PRE IN NUMBER) RETURN NUMBER;
71   FUNCTION C_ORDER_LISTFORMULA(ORDER_LIST IN NUMBER
72                               ,C_PRE IN NUMBER) RETURN NUMBER;
73   FUNCTION C_DISCOUNT_PRICE_CUFORMULA(S_DISCOUNT_PRICE_CU IN NUMBER
74                                      ,C_PRE IN NUMBER) RETURN NUMBER;
75   FUNCTION C_ORDER_LIST_CUFORMULA(S_ORDER_LIST_CU IN NUMBER
76                                  ,C_PRE IN NUMBER) RETURN NUMBER;
77   FUNCTION C_ORDER_AMOUNT_CUFORMULA(S_ORDER_AMOUNT_CU IN NUMBER
78                                    ,C_PRE IN NUMBER) RETURN NUMBER;
79   FUNCTION C_DISCOUNT_PRICE_OTFORMULA(S_DISCOUNT_PRICE_OT IN NUMBER
80                                      ,C_PRE IN NUMBER) RETURN NUMBER;
81   FUNCTION C_ORDER_LIST_OTFORMULA(S_ORDER_LIST_OT IN NUMBER
82                                  ,C_PRE IN NUMBER) RETURN NUMBER;
83   FUNCTION C_ORDER_AMOUNT_OTFORMULA(S_ORDER_AMOUNT_OT IN NUMBER
84                                    ,C_PRE IN NUMBER) RETURN NUMBER;
85   FUNCTION C_DISCOUNT_PRCE_CFORMULA(S_DISCOUNT_PRICE_C IN NUMBER
86                                    ,C_PRE IN NUMBER) RETURN NUMBER;
87   FUNCTION C_ORDER_LIST_CFORMULA(S_ORDER_LIST_C IN NUMBER
88                                 ,C_PRE IN NUMBER) RETURN NUMBER;
89   FUNCTION C_ORDER_AMOUNT_CFORMULA(S_ORDER_AMOUNT_C IN NUMBER
90                                   ,C_PRE IN NUMBER) RETURN NUMBER;
91   FUNCTION CF_1FORMULA(CHARGE_PERIODICITY_CODE IN VARCHAR2) RETURN VARCHAR2;
92   FUNCTION CF_2FORMULA(S_ORDER_AMOUNT_P IN NUMBER
93                       ,C_PRE IN NUMBER) RETURN NUMBER;
94   FUNCTION C_DISCOUNT_PRICE_PFORMULA(S_DISCOUNT_PRICE_P IN NUMBER
95                                     ,C_PRE IN NUMBER) RETURN NUMBER;
96   FUNCTION C_ORDER_LIST_PFORMULA(S_ORDER_LIST_P IN NUMBER
97                                 ,C_PRE IN NUMBER) RETURN NUMBER;
98   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
99   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
100   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
101   FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
102   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
103   FUNCTION RP_ORDER_NUMBER_RANGE_P RETURN VARCHAR2;
104   FUNCTION RP_ORDER_LIST_RANGE_P RETURN VARCHAR2;
105   FUNCTION RP_ORDER_DATE_RANGE_P RETURN VARCHAR2;
106   FUNCTION RP_OPEN_ORDERS_ONLY_P RETURN VARCHAR2;
107   FUNCTION RP_ORDER_AMOUNT_RANGE_P RETURN VARCHAR2;
108   FUNCTION RP_AGREEMENT_NAME_P RETURN VARCHAR2;
109   FUNCTION RP_ORDER_TYPE_RANGE_P RETURN VARCHAR2;
110   FUNCTION RP_CUSTOMER_NUMBER_RANGE_P RETURN VARCHAR2;
111   FUNCTION RP_CUSTOMER_NAME_RANGE_P RETURN VARCHAR2;
112   FUNCTION RP_SALESREP_RANGE_P RETURN VARCHAR2;
113   FUNCTION RP_ORDER_CATEGORY_P RETURN VARCHAR2;
114   FUNCTION RP_LINE_CATEGORY_P RETURN VARCHAR2;
115 END ONT_OEXPRPRS_XMLP_PKG;
116