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_OEXIODIS_XMLP_PKG

Source


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