PACKAGE: APPS.ONT_OEXOEITR_XMLP_PKG

Source

1 PACKAGE ONT_OEXOEITR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXOEITRS.pls 120.2.12020000.2 2013/03/05 06:31:52 adandu ship $ */
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   --Added the new lexical parameter to fix the bug 13649853
112   LP_MISS_NUM NUMBER := FND_API.G_MISS_NUM;
113 
114   FUNCTION BEFOREREPORT RETURN BOOLEAN;
115 
116   FUNCTION AFTERREPORT RETURN BOOLEAN;
117 
118   FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
119 
120   FUNCTION AFTERPFORM RETURN BOOLEAN;
121 
122   FUNCTION C_SET_LBLFORMULA RETURN VARCHAR2;
123 
124   FUNCTION RP_ORDER_CATEGORYFORMULA RETURN VARCHAR2;
125 
126   FUNCTION RP_LINE_CATEGORYFORMULA RETURN VARCHAR2;
127 
128   FUNCTION CF_UNIT1FORMULA(UNIT IN VARCHAR2) RETURN CHAR;
129 
130   FUNCTION CF_UNIT2FORMULA(UNIT2 IN VARCHAR2) RETURN CHAR;
131 
132   FUNCTION C_MASTER_ORGFORMULA RETURN NUMBER;
133 
134   FUNCTION CF_CHARGE_PERIODICITYFORMULA(CHARGE_PERIODICITY_CODE IN VARCHAR2) RETURN VARCHAR2;
135 
136   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
137 
138   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
139 
140   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
141 
142   FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
143 
144   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
145 
146   FUNCTION RP_ITEM_FLEX_LPROMPT_P RETURN VARCHAR2;
147 
148   FUNCTION RP_ITEM_FLEX_CODE_P RETURN VARCHAR2;
149 
150   FUNCTION RP_ITEM_FLEX_APROMPT_P RETURN VARCHAR2;
151 
152   FUNCTION RP_CUSTOMER_RANGE_P RETURN VARCHAR2;
153 
154   FUNCTION RP_TYPE_RANGE_P RETURN VARCHAR2;
155 
156   FUNCTION RP_ORDER_RANGE_P RETURN VARCHAR2;
157 
158   FUNCTION RP_ORDER_DATE_RANGE_P RETURN VARCHAR2;
159 
160   FUNCTION RP_ORDER_BY_P RETURN VARCHAR2;
161 
162   FUNCTION RP_OPENONLY_P RETURN VARCHAR2;
163 
164   FUNCTION RP_ITEM_RANGE_P RETURN VARCHAR2;
165 
166   FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
167 
168   FUNCTION RP_PRINT_DESCRIPTION_P RETURN VARCHAR2;
169 
170   FUNCTION CP_UNIT1_P RETURN VARCHAR2;
171 
172   FUNCTION CP_UNIT2_P RETURN VARCHAR2;
173 
174   FUNCTION F_1FORMATTRIGGER RETURN VARCHAR2;
175   function Item_dspFormula(
176   ITEM_IDENTIFIER_TYPE IN VARCHAR2,
177   C_MASTER_ORG IN NUMBER,
178   INVENTORY_ITEM_ID_T IN NUMBER,
179   ORDERED_ITEM_ID IN NUMBER,
180   ORDERED_ITEM IN VARCHAR2,
181   ORGANIZATION_ID_T in number,
182   INVENTORY_ITEM_ID_T1 in number
183   )
184   return Char;
185 
186 END ONT_OEXOEITR_XMLP_PKG;
187