PACKAGE: APPS.ONT_OEXCRDIS_XMLP_PKG

Source

1 PACKAGE ONT_OEXCRDIS_XMLP_PKG AS
2 /* $Header: OEXCRDISS.pls 120.2 2008/05/05 10:12:46 dwkrishn noship $ */
3   P_ORG_ID VARCHAR2(40);
4 
5   P_ORDER_NUM_LOW VARCHAR2(32767);
6 
7   P_ORDER_NUM_HIGH VARCHAR2(32767);
8 
9   LP_ORDER_NUM_LOW VARCHAR2(128);
10 
11   LP_ORDER_NUM_HIGH VARCHAR2(128);
12 
13   P_PUR_ORDER_NUM_LOW VARCHAR2(32767);
14 
15   P_PUR_ORDER_NUM_HIGH VARCHAR2(32767);
16 
17   P_REQUISITION_NUM_LOW VARCHAR2(32767);
18 
19   P_REQUISITION_NUM_HIGH VARCHAR2(32767);
20 
21   LP_PUR_ORDER_NUM_LOW VARCHAR2(128);
22 
23   LP_PUR_ORDER_NUM_HIGH VARCHAR2(128);
24 
25   LP_REQUISITION_NUM_LOW VARCHAR2(128);
26 
27   LP_REQUISITION_NUM_HIGH VARCHAR2(128);
28 
29   LP_CUSTOMER_NAME_LOW VARCHAR2(500);
30 
31   LP_CUSTOMER_NAME_HIGH VARCHAR2(500);
32 
33   P_CUSTOMER_NAME_LOW VARCHAR2(360);
34 
35   P_CUSTOMER_NAME_HIGH VARCHAR2(360);
36 
37   LP_ORDER_TYPE VARCHAR2(128);
38 
39   LP_ORDER_CATEGORY VARCHAR2(128);
40 
41   P_ORDER_CATEGORY VARCHAR2(30);
42 
43   P_ORDER_TYPE VARCHAR2(30);
44 
45   P_ORDER_BY VARCHAR2(40);
46 
47   LP_ITEM VARCHAR2(2400):= ' ';
48 
49   LP_ITEM1 VARCHAR2(2400):= ' and ';
50 
51   P_ITEM_FLEX_CODE VARCHAR2(32767);
52 
53   P_ITEM_DISPLAY VARCHAR2(1);
54 
55   P_ITEM_STRUCTURE_NUM NUMBER;
56 
57   P_CONC_REQUEST_ID NUMBER := 0;
58 
59   P_SOB_ID NUMBER;
60 
61   P_ORDER_DATE_LOW DATE;
62 
63   P_ORDER_DATE_HIGH DATE;
64 
65   LP_ORDER_DATE_LOW VARCHAR2(128);
66 
67   LP_ORDER_DATE_HIGH VARCHAR2(128);
68 
69   P_OPEN_ORDER_ONLY VARCHAR2(1);
70 
71   LP_OPEN_ORDER_ONLY VARCHAR2(128);
72 
73   P_PRINT_DESCRIPTION VARCHAR2(40);
74 
75   LP_CUSTOMER_NUMBER_LOW VARCHAR2(50);
76 
77   LP_CUSTOMER_NUMBER_HIGH VARCHAR2(500);
78 
79   P_CUSTOMER_NUMBER_LOW VARCHAR2(30);
80 
81   P_CUSTOMER_NUMBER_HIGH VARCHAR2(30);
82 
83   LP_ORDER_TYPE_LOW VARCHAR2(40);
84 
85   LP_ORDER_TYPE_HIGH VARCHAR2(40);
86 
87   LP_RECEIPT_DATE_LOW VARCHAR2(128);
88 
89   LP_RECEIPT_DATE_HIGH VARCHAR2(128);
90 
91   P_ORDER_TYPE_LOW NUMBER;
92 
93   P_ORDER_TYPE_HIGH NUMBER;
94 
95   P_ITEM_LOW VARCHAR2(800);
96 
97   P_ITEM_HIGH VARCHAR2(800);
98 
99   P_RECEIPT_DATE_LOW DATE;
100 
101   P_RECEIPT_DATE_HIGH DATE;
102 
103   OEL_INVENTORY_ITEM_ID VARCHAR2(40);
104 
105   LP_ORDER_BY VARCHAR2(100);
106 
107   L_ORDER_TYPE_LOW VARCHAR2(30);
108 
109   L_ORDER_TYPE_HIGH VARCHAR2(30);
110 
111   RP_DUMMY_ITEM VARCHAR2(20);
112 
113   RP_REPORT_NAME VARCHAR2(240);
114 
115   RP_COMPANY_NAME VARCHAR2(80);
116 
117   RP_ITEM_FLEX VARCHAR2(800) := 'MSI.SEGMENT1||MSI.SEGMENT2||MSI.SEGMENT3||MSI.SEGMENT4||MSI.SEGMENT5||MSI.SEGMENT6||MSI.SEGMENT7||MSI.SEGMENT8||MSI.SEGMENT9||MSI.SEGMENT10||MSI.SEGMENT11||MSI.SEGMENT12||MSI.SEGMENT13||MSI.SEGMENT14||
118   MSI.SEGMENT15||MSI.SEGMENT16||MSI.SEGMENT17||MSI.SEGMENT18||MSI.SEGMENT19||MSI.SEGMENT20';
119 
120   RP_SUB_TITLE VARCHAR2(240);
121 
122   RP_ORDER_RANGE VARCHAR2(60);
123 
124   RP_CUSTOMER_RANGE VARCHAR2(100);
125 
126   RP_ORDER_DATE_RANGE VARCHAR2(50);
127 
128   RP_ITEM_DISPLAY_METHOD VARCHAR2(80);
129 
130   RP_ORDER_TYPE_RANGE VARCHAR2(100);
131 
132   RP_ORDER_BY VARCHAR2(80);
133 
134   RP_ITEM_FLEX_ALL_SEG VARCHAR2(500) := 'MSI.SEGMENT1';
135 
136   RP_CUSTOMER_NUMBER_RANGE VARCHAR2(100);
137 
138   RP_ITEM_RANGE VARCHAR2(100);
139 
140   RP_DATA_FOUND VARCHAR2(30);
141 
142   RP_RECEIPT_DATE_RANGE VARCHAR2(50);
143 
144   FUNCTION AFTERPFORM RETURN BOOLEAN;
145 
146   FUNCTION BEFOREREPORT RETURN BOOLEAN;
147 
148   FUNCTION C_BUILD_LBLFORMULA RETURN VARCHAR2;
149 
150   FUNCTION AFTERREPORT RETURN BOOLEAN;
151 
152   FUNCTION RP_DUMMY_ITEM_P RETURN VARCHAR2;
153 
154   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
155 
156   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
157 
158   FUNCTION RP_ITEM_FLEX_P RETURN VARCHAR2;
159 
160   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
161 
162   FUNCTION RP_ORDER_RANGE_P RETURN VARCHAR2;
163 
164   FUNCTION RP_CUSTOMER_RANGE_P RETURN VARCHAR2;
165 
166   FUNCTION RP_ORDER_DATE_RANGE_P RETURN VARCHAR2;
167 
168   FUNCTION RP_ITEM_DISPLAY_METHOD_P RETURN VARCHAR2;
169 
170   FUNCTION RP_ORDER_TYPE_RANGE_P RETURN VARCHAR2;
171 
172   FUNCTION RP_ORDER_BY_P RETURN VARCHAR2;
173 
174   FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
175 
176   FUNCTION RP_CUSTOMER_NUMBER_RANGE_P RETURN VARCHAR2;
177 
178   FUNCTION RP_ITEM_RANGE_P RETURN VARCHAR2;
179 
180   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
181 
182   FUNCTION RP_RECEIPT_DATE_RANGE_P RETURN VARCHAR2;
183 
184   FUNCTION ITEM_DSPFORMULA(item_identifier_type in varchar2,oe_inventory_item_id1 in number ,
185 rp_dummy_item in varchar2, item_dsp in varchar2, ORDERED_ITEM_ID in number,
186  ordered_item in varchar2,ORGANIZATION_ID in number ,INVENTORY_ITEM_ID in number)
187 RETURN VARCHAR2;
188 
189 END ONT_OEXCRDIS_XMLP_PKG;
190 
191