PACKAGE: APPS.ONT_OEXOEUBD_XMLP_PKG

Source

1 PACKAGE ONT_OEXOEUBD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXOEUBDS.pls 120.1 2007/12/25 07:27:10 npannamp noship $ */
3   P_CONC_REQUEST_ID NUMBER;
4 
5   P_SOB_ID NUMBER;
6 
7   P_ORDER_BY VARCHAR2(30);
8 
9   P_CREATED_BY_LOW VARCHAR2(240);
10 
11   P_ITEM_FLEX_CODE VARCHAR2(32767);
12 
13   P_ORGANIZATION_ID VARCHAR2(32767);
14   P_ORGANIZATION_ID_V VARCHAR2(32767);
15 
16   P_ORDER_DATE_LOW DATE;
17   P_ORDER_DATE_LOW_V VARCHAR2(40);
18 
19   P_ORDER_DATE_HIGH DATE;
20   P_ORDER_DATE_HIGH_V VARCHAR2(40);
21 
22   --LP_CREATED_BY VARCHAR2(500);
23   LP_CREATED_BY VARCHAR2(500):=' ';
24 
25   --LP_ORDER_BY VARCHAR2(500);
26   LP_ORDER_BY VARCHAR2(500):=' ';
27 
28   --LP_ORDER_DATE VARCHAR2(500);
29   LP_ORDER_DATE VARCHAR2(500):=' ';
30 
31   P_CREATED_BY_HIGH VARCHAR2(240);
32 
33   LP_ORDER_DATE_RANGE VARCHAR2(500);
34 
35   LP_CREATED_BY_RANGE VARCHAR2(500);
36 
37   LP_ORDER_BY_MEAN VARCHAR2(100);
38 
39   P_ITEM_STRUCTURE_NUM NUMBER;
40 
41   P_PRINT_DESCRIPTION VARCHAR2(32767);
42 
43   LP_ORDER_CATEGORY VARCHAR2(500);
44 
45   LP_LINE_CATEGORY VARCHAR2(500);
46 
47   P_ORDER_CATEGORY VARCHAR2(30);
48 
49   P_LINE_CATEGORY VARCHAR2(30);
50 
51   --LP_ORDER_TYPE VARCHAR2(1000);
52   LP_ORDER_TYPE VARCHAR2(1000):=' ';
53 
54   --LP_MANAGER VARCHAR2(1000);
55   LP_MANAGER VARCHAR2(1000):=' ';
56 
57   P_ORDER_TYPE_LOW VARCHAR2(240);
58 
59   P_ORDER_TYPE_HIGH VARCHAR2(240);
60 
61   P_MANAGER_LOW VARCHAR2(1000);
62 
63   P_MANAGER_HIGH VARCHAR2(1000);
64 
65   LP_ORDER_TYPE_RANGE VARCHAR2(500);
66 
67   LP_MANAGER_RANGE VARCHAR2(500);
68 
69   P_USE_FUNCTIONAL_CURRENCY VARCHAR2(32767);
70 
71   P_ONE_TIME VARCHAR2(32767);
72 
73   L_ORDER_TYPE_LOW VARCHAR2(30);
74 
75   L_ORDER_TYPE_HIGH VARCHAR2(30);
76 
77   L_USE_FUNCTIONAL_CURRENCY VARCHAR2(30);
78 
79   RP_REPORT_NAME VARCHAR2(240);
80   --added as fix
81   F_Periodicity VARCHAR2(240);
82 
83   RP_SUB_TITLE VARCHAR2(240);
84 
85   RP_COMPANY_NAME VARCHAR2(100);
86 
87   RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
88 
89   RP_DATA_FOUND VARCHAR2(300);
90 
91   RP_ITEM_FLEX_ALL_SEG VARCHAR2(2000) := 'MSI.SEGMENT1';
92 
93   RP_PRINT_DESCRIPTION VARCHAR2(100);
94 
95   RP_C_EXT_TOTAL_ROUNDED NUMBER;
96 
97   RP_C_RECUR_CHARGE_ROUNDED NUMBER;
98 
99   FUNCTION AFTERREPORT RETURN BOOLEAN;
100 
101   FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
102 
103   FUNCTION AFTERPFORM RETURN BOOLEAN;
104 
105   FUNCTION RP_ORDER_CATEGORYFORMULA RETURN VARCHAR2;
106 
107   FUNCTION RP_LINE_CATEGORYFORMULA RETURN VARCHAR2;
108 
109   FUNCTION C_LINE_AMTFORMULA(TRANSACTIONAL_CURR_CODE IN VARCHAR2
110                             ,LINE_AMT IN NUMBER
111                             ,CONVERSION_TYPE_CODE IN VARCHAR2
112                             ,ORDERED_DATE IN DATE
113                             ,CONVERSION_RATE IN NUMBER) RETURN NUMBER;
114 
115   FUNCTION C_PRECISIONFORMULA(TRANSACTIONAL_CURR_CODE IN VARCHAR2) RETURN NUMBER;
116 
117   FUNCTION C_RECUR_CHARGESFORMULA(CHARGE_PERIODICITY_CODE IN VARCHAR2) RETURN CHAR;
118 
119   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
120 
121   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
122 
123   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
124 
125   FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
126 
127   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
128 
129   FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
130 
131   FUNCTION RP_PRINT_DESCRIPTION_P RETURN VARCHAR2;
132 
133   FUNCTION RP_C_EXT_TOTAL_ROUNDED_P RETURN NUMBER;
134 
135   FUNCTION RP_C_RECUR_CHARGE_ROUNDED_P RETURN NUMBER;
136   function BeforeReport return boolean;
137 
138 END ONT_OEXOEUBD_XMLP_PKG;
139