PACKAGE: APPS.ONT_OEXOEITR_XMLP_PKG

Source

1 PACKAGE ONT_OEXOEITR_XMLP_PKG AS
2 /* $Header: OEXOEITRS.pls 120.2 2008/05/05 09:05:54 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_SOB_ID NUMBER;
6 
7   P_OPENONLY VARCHAR2(30);
8 
9   P_ORDER_BY VARCHAR2(30);
10 
11   P_ORDER_NUM_LOW VARCHAR2(32767);
12 
13   P_ORDER_NUM_HIGH VARCHAR2(32767);
14 
15   P_CUSTOMER_NAME_LOW VARCHAR2(360);
16 
17   P_CUSTOMER_NAME_HIGH VARCHAR2(360);
18 
19   P_ITEM_FLEX_CODE VARCHAR2(32767);
20 
21   P_ORG_ID NUMBER;
22 
23   P_ORDER_DATE_LOW DATE;
24   P_ORDER_DATE_LOW_T VARCHAR2(60);
25 
26   P_ORDER_DATE_HIGH DATE;
27   P_ORDER_DATE_HIGH_T VARCHAR2(60);
28 
29   LP_ITEM_FLEX_CODE_HIGH VARCHAR2(600);
30 
31   LP_ITEM_FLEX_CODE_LOW VARCHAR2(600);
32 
33   LP_ORDER_NUM VARCHAR2(200):='  ';
34 
35   LP_ORDER_DATE VARCHAR2(200):='  ';
36 
37   LP_CUSTOMER_NAME VARCHAR2(200):='  ';
38 
39   P_PRINT_FLEX_OR_DESC VARCHAR2(32767);
40 
41   LP_OPENONLY VARCHAR2(1000):='  ';
42 
43   P_ITEM_STRUCTURE_NUM NUMBER;
44 
45   LP_ITEM VARCHAR2(1000):='  ';
46 
47   P_ITEM_LOW VARCHAR2(200);
48 
49   P_ITEM_HI VARCHAR2(200);
50 
51   P_PRINT_DESCRIPTION VARCHAR2(40);
52 
53   LP_ORDER_CATEGORY VARCHAR2(500):='  ';
54 
55   LP_LINE_CATEGORY VARCHAR2(500):='  ';
56 
57   P_ORDER_CATEGORY VARCHAR2(30);
58 
59   P_LINE_CATEGORY VARCHAR2(30);
60 
61   LP_ORDER_TYPE VARCHAR2(200):='  ';
62 
63   P_ORDER_TYPE_LOW VARCHAR2(30);
64 
65   P_ORDER_TYPE_HIGH VARCHAR2(30);
66 
67   P_ONE_TIME VARCHAR2(32767);
68 
69   L_ORDER_TYPE_LOW VARCHAR2(30);
70 
71   L_ORDER_TYPE_HIGH VARCHAR2(30);
72 
73   RP_REPORT_NAME VARCHAR2(240);
74 
75   RP_SUB_TITLE VARCHAR2(240);
76 
77   RP_COMPANY_NAME VARCHAR2(100);
78 
79   RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
80 
81   RP_DATA_FOUND VARCHAR2(300);
82 
83   RP_ITEM_FLEX_LPROMPT VARCHAR2(100);
84 
85   RP_ITEM_FLEX_CODE VARCHAR2(500) := 'SI.SEGMENT1';
86 
87   RP_ITEM_FLEX_APROMPT VARCHAR2(100);
88 
89   RP_CUSTOMER_RANGE VARCHAR2(255);
90 
91   RP_TYPE_RANGE VARCHAR2(255);
92 
93   RP_ORDER_RANGE VARCHAR2(255);
94 
95   RP_ORDER_DATE_RANGE VARCHAR2(255);
96 
97   RP_ORDER_BY VARCHAR2(80);
98 
99   RP_OPENONLY VARCHAR2(80);
100 
101   RP_ITEM_RANGE VARCHAR2(255);
102 
103   RP_ITEM_FLEX_ALL_SEG VARCHAR2(2000) := 'SI.SEGMENT1';
104 
105   RP_PRINT_DESCRIPTION VARCHAR2(100);
106 
107   CP_UNIT1 VARCHAR2(20);
108 
109   CP_UNIT2 VARCHAR2(20);
110 
111   FUNCTION BEFOREREPORT RETURN BOOLEAN;
112 
113   FUNCTION AFTERREPORT RETURN BOOLEAN;
114 
115   FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
116 
117   FUNCTION AFTERPFORM RETURN BOOLEAN;
118 
119   FUNCTION C_SET_LBLFORMULA RETURN VARCHAR2;
120 
121   FUNCTION RP_ORDER_CATEGORYFORMULA RETURN VARCHAR2;
122 
123   FUNCTION RP_LINE_CATEGORYFORMULA RETURN VARCHAR2;
124 
125   FUNCTION CF_UNIT1FORMULA(UNIT IN VARCHAR2) RETURN CHAR;
126 
127   FUNCTION CF_UNIT2FORMULA(UNIT2 IN VARCHAR2) RETURN CHAR;
128 
129   FUNCTION C_MASTER_ORGFORMULA RETURN NUMBER;
130 
131   FUNCTION CF_CHARGE_PERIODICITYFORMULA(CHARGE_PERIODICITY_CODE IN VARCHAR2) RETURN VARCHAR2;
132 
133   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
134 
135   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
136 
137   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
138 
139   FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
140 
141   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
142 
143   FUNCTION RP_ITEM_FLEX_LPROMPT_P RETURN VARCHAR2;
144 
145   FUNCTION RP_ITEM_FLEX_CODE_P RETURN VARCHAR2;
146 
147   FUNCTION RP_ITEM_FLEX_APROMPT_P RETURN VARCHAR2;
148 
149   FUNCTION RP_CUSTOMER_RANGE_P RETURN VARCHAR2;
150 
151   FUNCTION RP_TYPE_RANGE_P RETURN VARCHAR2;
152 
153   FUNCTION RP_ORDER_RANGE_P RETURN VARCHAR2;
154 
155   FUNCTION RP_ORDER_DATE_RANGE_P RETURN VARCHAR2;
156 
157   FUNCTION RP_ORDER_BY_P RETURN VARCHAR2;
158 
159   FUNCTION RP_OPENONLY_P RETURN VARCHAR2;
160 
161   FUNCTION RP_ITEM_RANGE_P RETURN VARCHAR2;
162 
163   FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
164 
165   FUNCTION RP_PRINT_DESCRIPTION_P RETURN VARCHAR2;
166 
167   FUNCTION CP_UNIT1_P RETURN VARCHAR2;
168 
169   FUNCTION CP_UNIT2_P RETURN VARCHAR2;
170 
171   FUNCTION F_1FORMATTRIGGER RETURN VARCHAR2;
172   function Item_dspFormula(
173   ITEM_IDENTIFIER_TYPE IN VARCHAR2,
174   C_MASTER_ORG IN NUMBER,
175   INVENTORY_ITEM_ID_T IN NUMBER,
176   ORDERED_ITEM_ID IN NUMBER,
177   ORDERED_ITEM IN VARCHAR2,
178   ORGANIZATION_ID_T in number,
179   INVENTORY_ITEM_ID_T1 in number
180   )
181   return Char;
182 
183 END ONT_OEXOEITR_XMLP_PKG;
184