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.XDP_TYPES

Source


1 PACKAGE XDP_TYPES AUTHID CURRENT_USER AS
2 /* $Header: XDPTYPES.pls 115.15 2002/05/21 19:05:02 pkm ship        $ */
3 
4 -- PL/SQL Specification
5 -- Datastructure Definitions
6 
7 -- SFM order header
8  TYPE ORDER_HEADER IS RECORD
9  (
10 	order_number  VARCHAR2(40),
11 	order_version VARCHAR2(40) default NULL,
12 	provisioning_date DATE default sysdate,
13 	priority NUMBER default 100,
14 	due_date DATE default NULL,
15 	customer_required_date DATE default NULL,
16 	order_type  VARCHAR2(40) default NULL,
17 	order_action  VARCHAR2(40) default NULL,
18 	order_source VARCHAR2(40) default NULL,
19 	related_order_id NUMBER default NULL,
20 	org_id NUMBER default NULL,
21 	customer_name VARCHAR2(80) default NULL,
22 	customer_id  NUMBER  default NULL,
23 	service_provider_id NUMBER default NULL,
24 	telephone_number  VARCHAR2(40) default NULL,
25 	order_status VARCHAR2(40) default NULL,
26 	order_state  VARCHAR2(40) default NULL,
27 	actual_provisioning_date DATE default NULL,
28 	completion_date  DATE default NULL,
29 	previous_order_id number default NULL,
30 	next_order_id number default null,
31 	sdp_order_id number default null,
32 	jeopardy_enabled_flag VARCHAR2(1) default 'N',
33 	order_ref_name VARCHAR2(80) default null,
34 	order_ref_value VARCHAR2(300) default null,
35 	sp_order_number VARCHAR2(80) default null,
36 	sp_userid NUMBER default null);
37 
38 -- List of order Header records
39   TYPE ORDER_HEADER_LIST IS TABLE OF ORDER_HEADER
40 	  INDEX BY BINARY_INTEGER;
41 
42 -- order parameter record
43   TYPE ORDER_PARAMETER IS RECORD
44   (
45     PARAMETER_NAME VARCHAR2(40),
46     PARAMETER_VALUE VARCHAR2(4000));
47 
48 -- list of the order parameter
49   TYPE ORDER_PARAMETER_LIST IS TABLE OF ORDER_PARAMETER
50 	 INDEX BY BINARY_INTEGER;
51 
52 -- order line item record
53   TYPE LINE_ITEM IS RECORD
54   (
55   	LINE_NUMBER NUMBER,
56   	LINE_ITEM_NAME VARCHAR2(40),
57   	VERSION VARCHAR2(40) DEFAULT NULL ,
58 	IS_WORKITEM_FLAG VARCHAR2(1) DEFAULT 'N',
59   	ACTION VARCHAR2(30),
60 	PROVISIONING_DATE DATE,
61 	PROVISIONING_REQUIRED_FLAG  VARCHAR2(1) DEFAULT 'Y',
62   	PROVISIONING_SEQUENCE NUMBER := 0,
63     BUNDLE_ID	NUMBER default NULL,
64 	BUNDLE_SEQUENCE  NUMBER DEFAULT NULL,
65 	PRIORITY NUMBER := 100,
66 	due_date DATE default NULL,
67 	customer_required_date DATE default NULL,
68 	line_status VARCHAR2(40) default NULL,
69 	completion_date  DATE default NULL,
70 	service_id NUMBER default NULL,
71 	package_id NUMBER default NULL,
72 	workitem_id NUMBER default NULL,
73 	line_state   VARCHAR2(40) default 'PREPROCESS',
74 	line_item_id NUMBER default null,
75 	jeopardy_enabled_flag VARCHAR2(1) default 'N',
76 	starting_number NUMBER default NULL,
77 	ending_number NUMBER default NULL );
78 
79 
80 -- list of order line items
81   TYPE ORDER_LINE_LIST IS TABLE OF LINE_ITEM
82 	INDEX BY BINARY_INTEGER;
83 
84 -- list item parameter record
85   TYPE LINE_PARAM IS RECORD
86   (
87 	line_number NUMBER,
88 	parameter_name VARCHAR2(40),
89 	parameter_value VARCHAR2(4000),
90 	parameter_ref_value VARCHAR2(4000) DEFAULT NULL);
91 
92 -- line item parameter list
93   TYPE LINE_PARAM_LIST IS TABLE OF LINE_PARAM
94 	 INDEX BY BINARY_INTEGER;
95 
96 -- work item record
97   TYPE WORKITEM_REC IS RECORD
98   (
99 	workitem_name varchar2(40),
100 	workitem_id   number,
101 	provisioning_sequence number,
102 	provisioning_date date,
103 	priority	number,
104 	workitem_status varchar2(40),
105 	workitem_state varchar2(40),
106 	workitem_instance_id number,
107 	line_item_id number,
108 	line_number number,
109 	error_description varchar2(4000));
110 
111 -- list of workitem records
112   TYPE WORKITEM_LIST IS TABLE OF WORKITEM_REC
113 	 INDEX BY BINARY_INTEGER;
114 
115 -- fulfillment action record
116   TYPE FULFILLMENT_ACTION_REC IS RECORD
117   (
118 	fulfillment_action varchar2(40),
119 	fulfillment_action_id   number,
120 	provisioning_sequence number,
121 	priority	number,
122 	FA_status varchar2(40),
123 	FA_state varchar2(40),
124 	FA_instance_id number,
125 	error_description varchar2(4000));
126 
127 -- list of fulfillment action records
128   TYPE FULFILLMENT_ACTION_LIST IS TABLE OF FULFILLMENT_ACTION_REC
129       INDEX BY BINARY_INTEGER;
130 
131 
132 -- fulfillment action command record
133   TYPE FA_COMMAND_REC IS RECORD
134   (
135 	FA_instance_id number,
136 	command_sequence number,
137 	fulfillment_action varchar2(40),
138 	fulfillment_action_id   number,
139 	fulfillment_element_name varchar2(40),
140 	command_sent varchar2(4000),
141 	command_sent_date DATE,
142 	FE_response varchar2(4000),
143 	response_date DATE,
144     USER_RESPONSE varchar2(4000),
145 	message_id  number,
146 	fulfillment_procedure_name  varchar2(40));
147 
148 -- list of fulfillment action records
149   TYPE FA_COMMAND_AUDIT_TRAIL IS TABLE OF FA_COMMAND_REC
150 	  INDEX BY BINARY_INTEGER;
151 
152 -- Order relationship enumerated constant
153   IS_PREREQUISITE_OF 	CONSTANT BINARY_INTEGER := 1;
154 -- Order relationship enumerated constant
155   COMES_BEFORE       	CONSTANT BINARY_INTEGER := 2;
156 -- Order relationship enumerated constant
157   IS_CHILD_OF        	CONSTANT BINARY_INTEGER := 3;
158 -- Order relationship enumerated constant
159   COMES_AFTER		CONSTANT BINARY_INTEGER := 4;
160 
161 -- Workitem relationship enumerated constant
162   MERGED_INTO  		CONSTANT BINARY_INTEGER := 1;
163 
164 -- Copy mode enumerated constant
165   APPEND_TO			CONSTANT BINARY_INTEGER := 1;
166 -- Copy mode enumerated constant
167   OVERRIDE			CONSTANT BINARY_INTEGER := 2;
168 
169 -- Datastructure Definitions required by error handling routines
170 
171 -- Structure for the message which is to be displayed to the user
172   TYPE MESSAGE_REC IS RECORD
173   (
174     MESSAGE_TYPE VARCHAR2(30),
175     MESSAGE_TIME DATE,
176     MESSAGE_TEXT VARCHAR2(2000));
177 
178 -- Structure for the message token name and value
179   TYPE MESSAGE_TOKEN_REC IS RECORD
180   (
181     MESSAGE_TOKEN_NAME VARCHAR2(30),
182     MESSAGE_TOKEN_VALUE VARCHAR2(2000));
183 
184 -- List of the messages to be displayed to the user
185   TYPE MESSAGE_LIST IS TABLE OF MESSAGE_REC
186 	  INDEX BY BINARY_INTEGER;
187 
188 -- List of the messages tokens required to be saved for a message
189   TYPE MESSAGE_TOKEN_LIST IS TABLE OF MESSAGE_TOKEN_REC
190 	 INDEX BY BINARY_INTEGER;
191 
192 -- Structure for the message token name and value
193   TYPE NAME_VALUE_REC IS RECORD
194   (
195     NAME VARCHAR2(4000),
196     VALUE VARCHAR2(4000));
197 
198 -- List of the messages tokens required to be saved for a message
199   TYPE NAME_VALUE_LIST IS TABLE OF NAME_VALUE_REC
200     INDEX BY BINARY_INTEGER;
201 
202 -- FMC retry parameter change record
203  TYPE FMC_PARAM_CHANGE_REC IS RECORD
204  (
205    PARAMETER_NAME varchar2(40),
206    PARAM_PREVIOUS_VAL varchar2(4000),
207    PARAM_RETRY_VAL VARCHAR2(4000));
208 
209 -- FMC retry parameter list
210  TYPE FMC_RETRY_PARAM_LIST IS TABLE OF FMC_PARAM_CHANGE_REC
211 	INDEX BY BINARY_INTEGER;
212 
213 -- vrachur : 10/18/1999 : Added Type definitions for XDP OE Order Records.
214 -- XDP OE Order Header Definition
215 	TYPE OE_ORDER_HEADER IS RECORD
216 	(
217 		ORDER_NUMBER		VARCHAR2(40),
218 		ORDER_VERSION		VARCHAR2(40) DEFAULT NULL,
219 		PROVISIONING_DATE	DATE DEFAULT SYSDATE,
220 		COMPLETION_DATE		DATE DEFAULT NULL,
221 		ORDER_TYPE		VARCHAR2(40) DEFAULT NULL,
222 		ORDER_ACTION		VARCHAR2(30) DEFAULT NULL,
223 		ORDER_SOURCE		VARCHAR2(40) DEFAULT NULL,
224 		PRIORITY		NUMBER DEFAULT NULL,
225 		STATUS			VARCHAR2(40) DEFAULT NULL,
226 		SDP_ORDER_ID		NUMBER DEFAULT NULL,
227 		DUE_DATE		DATE DEFAULT NULL,
228 		CUSTOMER_REQUIRED_DATE	DATE DEFAULT NULL,
229 		CUSTOMER_NAME		VARCHAR2(40) DEFAULT NULL,
230 		CUSTOMER_ID		NUMBER DEFAULT NULL,
231 		ORG_ID			NUMBER DEFAULT NULL,
232 		SERVICE_PROVIDER_ID	NUMBER DEFAULT NULL,
233 		TELEPHONE_NUMBER	VARCHAR2(40) DEFAULT NULL,
234 		RELATED_ORDER_ID	NUMBER DEFAULT NULL,
235 		ORDER_COMMENT		VARCHAR2(4000) DEFAULT NULL,
236 		SP_ORDER_NUMBER		VARCHAR2(80) DEFAULT NULL,
237 		SP_USERID		NUMBER DEFAULT NULL,
238 		JEOPARDY_ENABLED_FLAG	VARCHAR2(1) DEFAULT NULL,
239 		ORDER_REF_NAME		VARCHAR2(80) DEFAULT NULL,
240 		ORDER_REF_VALUE		VARCHAR2(300) DEFAULT NULL
241 	) ;
242 
243 -- XDP OE Order Parameter
244 	TYPE OE_ORDER_PARAMETER IS RECORD
245 	(
246 		PARAMETER_NAME	VARCHAR2(40),
247 		PARAMETER_VALUE	VARCHAR2(4000)
248 	) ;
249 
250 -- List of Parameters for a given Order
251 	TYPE OE_ORDER_PARAMETER_LIST IS TABLE OF OE_ORDER_PARAMETER
252 		INDEX BY BINARY_INTEGER ;
253 
254 -- XDP OE Order Lines
255 	TYPE OE_ORDER_LINE IS RECORD
256 	(
257 		ORDER_NUMBER			VARCHAR2(40),
258 		ORDER_VERSION			VARCHAR2(40),
259 		LINE_NUMBER			NUMBER,
260 		LINE_ITEM_NAME			VARCHAR2(40),
261 		LINE_ITEM_VERSION		VARCHAR2(40),
262 		LINE_ITEM_ACTION		VARCHAR2(30),
263 		PROVISIONING_REQUIRED_FLAG	VARCHAR2(1),
264 		IS_WORKITEM_FLAG		VARCHAR2(1),
265 		LINE_ITEM_TYPE			VARCHAR2(20),
266 		STATUS				VARCHAR2(40),
267 		PROVISIONING_SEQUENCE		NUMBER,
268 		PRIORITY			NUMBER,
269 		PROVISIONING_DATE		DATE,
270 		DUE_DATE			DATE,
271 		CUSTOMER_REQUIRED_DATE		DATE,
272 		COMPLETION_DATE			DATE,
273 		BUNDLE_ID			NUMBER,
274 		BUNDLE_SEQUENCE			NUMBER,
275 		STARTING_NUMBER			NUMBER,
276 		ENDING_NUMBER			NUMBER,
277 		JEOPARDY_ENABLED_FLAG		VARCHAR2(1)
278 	) ;
279 
280 -- XDP OE Order Line Details
281 	TYPE OE_ORDER_LINE_DETAIL IS RECORD
282 	(
283 		PARAMETER_NAME		VARCHAR2(40),
284 		PARAMETER_VALUE		VARCHAR2(4000),
285 		PARAMETER_REF_VALUE	VARCHAR2(4000)
286 	) ;
287 
288 -- List of Line Details for a given Order Line
289 	TYPE OE_ORDER_LINE_DETAIL_LIST IS TABLE OF OE_ORDER_LINE_DETAIL
290 	   INDEX BY BINARY_INTEGER ;
291 
292 
293 -- From here on, all the types are used for new open interface APIs.
294 
295     TYPE SERVICE_ORDER_HEADER IS RECORD
296     (
297         order_number  		        VARCHAR2(40)	DEFAULT	FND_API.G_MISS_CHAR,
298         order_version		        VARCHAR2(40) 	DEFAULT	1,
299         required_fulfillment_date 	DATE 		DEFAULT	SYSDATE,
300         priority 		            NUMBER 		DEFAULT	100,
301         jeopardy_enabled_flag	    VARCHAR2(1)	DEFAULT	'N',
302         execution_mode		        VARCHAR2(5)	DEFAULT	'ASYNC',
303         account_number		        VARCHAR2(30)	DEFAULT	FND_API.G_MISS_CHAR,
304         cust_account_id		            NUMBER		DEFAULT	FND_API.G_MISS_NUM,
305         due_date 	                DATE 		DEFAULT	FND_API.G_MISS_DATE,
306         customer_required_date 	    DATE 		DEFAULT	FND_API.G_MISS_DATE,
307         order_type  		        VARCHAR2(40) 	DEFAULT	FND_API.G_MISS_CHAR,
308         order_source 		        VARCHAR2(40) 	DEFAULT	FND_API.G_MISS_CHAR,
309         org_id	 		            NUMBER		DEFAULT	FND_API.G_MISS_NUM,
310         related_order_id 	        NUMBER 		DEFAULT	FND_API.G_MISS_NUM,
311         previous_order_id 	        NUMBER		DEFAULT	FND_API.G_MISS_NUM,
312         next_order_id 		        NUMBER		DEFAULT	FND_API.G_MISS_NUM,
313         order_ref_name 		        VARCHAR2(80) 	DEFAULT	FND_API.G_MISS_CHAR,
314         order_ref_value 		    VARCHAR2(300) 	DEFAULT	FND_API.G_MISS_CHAR,
315         order_comments		        VARCHAR2(4000)	DEFAULT	FND_API.G_MISS_CHAR,
316         order_id		            NUMBER		DEFAULT	FND_API.G_MISS_NUM,
317         order_status		        VARCHAR2(40)	DEFAULT	FND_API.G_MISS_CHAR,
318         fulfillment_status	        VARCHAR2(40)	DEFAULT	FND_API.G_MISS_CHAR,
319         fulfillment_result	        VARCHAR2(4000)	DEFAULT	FND_API.G_MISS_CHAR,
320         completion_date		        DATE		DEFAULT	FND_API.G_MISS_DATE,
321         actual_fulfillment_date		DATE		DEFAULT	FND_API.G_MISS_DATE,
322         customer_id                              NUMBER DEFAULT	FND_API.G_MISS_NUM,
323         customer_name                            VARCHAR2(80) DEFAULT  FND_API.G_MISS_CHAR,
324         telephone_number                       VARCHAR2(40)   DEFAULT  FND_API.G_MISS_CHAR,
325         attribute_category              VARCHAR2(30)   DEFAULT	FND_API.G_MISS_CHAR,
326         attribute1	 		    	VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
327         attribute2		    		VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
328         attribute3		    		VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
329         attribute4	   	    		VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
330         attribute5	   	    		VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
331         attribute6	  	    		VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
332         attribute7	 	    		VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
333         attribute8	 	    		VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
334         attribute9	  				VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
335         attribute10	 				VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
336         attribute11					VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
337         attribute12					VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
338         attribute13	  				VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
339         attribute14					VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
340         attribute15					VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
341         attribute16					VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
342         attribute17					VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
343         attribute18					VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
344         attribute19					VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
345         attribute20	  				VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR
346     );
347 
348     G_MISS_SERVICE_ORDER_HEADER SERVICE_ORDER_HEADER;
349 --   Modified by SXBANERJ 07/05. Parent_line_Id, Is_virtual_Flag and Attribute_Category
350 
351     TYPE SERVICE_LINE_ITEM IS RECORD
352     (
353         line_number 		NUMBER		DEFAULT 	FND_API.G_MISS_NUM,
354         line_source		VARCHAR2(30)	DEFAULT 	FND_API.G_MISS_CHAR,
355         inventory_item_id	NUMBER		DEFAULT 	FND_API.G_MISS_NUM,
356         service_item_name	VARCHAR2(40)	DEFAULT 	FND_API.G_MISS_CHAR,
357         version		        VARCHAR2(40)	DEFAULT 	FND_API.G_MISS_CHAR,
358         action_code		VARCHAR2(30)    DEFAULT 	FND_API.G_MISS_CHAR,
359         organization_code	VARCHAR2(4) 	DEFAULT	FND_API.G_MISS_CHAR,
360         organization_id		NUMBER	 	DEFAULT	FND_API.G_MISS_NUM,
361         site_use_id		NUMBER		DEFAULT	FND_API.G_MISS_NUM,
362         ib_source		VARCHAR2(20)	DEFAULT	'NONE',
363         ib_source_id		NUMBER		DEFAULT	FND_API.G_MISS_NUM,
367         fulfillment_sequence 	NUMBER 		DEFAULT	0,
364         required_fulfillment_date DATE		DEFAULT FND_API.G_MISS_DATE,
365         fulfillment_required_flag VARCHAR2(1)	DEFAULT	'Y',
366         is_package_flag         VARCHAR2(1)     DEFAULT 'N',
368         bundle_id		NUMBER 		DEFAULT	FND_API.G_MISS_NUM,
369         bundle_sequence 	NUMBER 		DEFAULT	FND_API.G_MISS_NUM,
370         priority 		NUMBER 		DEFAULT	100,
371         due_date 		DATE 		DEFAULT	FND_API.G_MISS_DATE,
372         jeopardy_enabled_flag 	VARCHAR2(1) 	DEFAULT	'N',
373         customer_required_date 	DATE 		DEFAULT	FND_API.G_MISS_DATE,
374         starting_number         NUMBER 		DEFAULT	FND_API.G_MISS_NUM,
375         ending_number 		NUMBER 		DEFAULT	FND_API.G_MISS_NUM,
376         line_item_id		NUMBER		DEFAULT	FND_API.G_MISS_NUM,
377         workitem_id             NUMBER          DEFAULT	FND_API.G_MISS_NUM,
378         line_status		VARCHAR2(40)	DEFAULT	FND_API.G_MISS_CHAR,
379         completion_date		DATE		DEFAULT	FND_API.G_MISS_DATE,
380         actual_fulfillment_date	DATE		DEFAULT	FND_API.G_MISS_DATE,
381         parent_line_number     NUMBER           DEFAULT FND_API.G_MISS_NUM,
382         is_virtual_line_flag         VARCHAR2(1)        DEFAULT 'N',
383         attribute_category           VARCHAR2(30)       DEFAULT FND_API.G_MISS_CHAR,
384         attribute1		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
385         attribute2		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
386         attribute3		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
387         attribute4		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
388         attribute5		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
389         attribute6		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
390         attribute7		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
391         attribute8		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
392         attribute9		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
393         attribute10		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
394         attribute11		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
395         attribute12		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
396         attribute13		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
397         attribute14		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
398         attribute15		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
399         attribute16		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
400         attribute17		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
401         attribute18		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
402         attribute19		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR,
403         attribute20		    VARCHAR2(240)	DEFAULT	FND_API.G_MISS_CHAR
404     );
405 
406 -- list of order line items
407     TYPE SERVICE_ORDER_LINE_LIST IS TABLE OF SERVICE_LINE_ITEM
408 	    INDEX BY BINARY_INTEGER;
409 
410     G_MISS_SERVICE_LINE_ITEM SERVICE_LINE_ITEM;
411     G_MISS_SERVICE_ORDER_LINE_LIST SERVICE_ORDER_LINE_LIST;
412 
413 
414     TYPE SERVICE_ORDER_PARAM IS RECORD
415     (
416   	parameter_name 		VARCHAR2(40)	DEFAULT	FND_API.G_MISS_CHAR,
417       	parameter_value 		VARCHAR2(4000)	DEFAULT	FND_API.G_MISS_CHAR
418     );
419     TYPE SERVICE_ORDER_PARAM_LIST IS TABLE OF SERVICE_ORDER_PARAM
420 	    INDEX BY BINARY_INTEGER;
421     G_MISS_ORDER_PARAMETER SERVICE_ORDER_PARAM;
422     G_MISS_ORDER_PARAM_LIST SERVICE_ORDER_PARAM_LIST;
423 
424     TYPE SERVICE_LINE_PARAM IS RECORD
425     (
426 	line_number 		NUMBER		DEFAULT	FND_API.G_MISS_NUM,
427     	parameter_name 		VARCHAR2(40)	DEFAULT	FND_API.G_MISS_CHAR,
428       	parameter_value 	VARCHAR2(4000)	DEFAULT	FND_API.G_MISS_CHAR,
429         parameter_ref_value 	VARCHAR2(4000)	DEFAULT	FND_API.G_MISS_CHAR
430     );
431     TYPE SERVICE_LINE_PARAM_LIST IS TABLE OF SERVICE_LINE_PARAM
432         INDEX BY BINARY_INTEGER;
433     G_MISS_LINE_PARAM SERVICE_LINE_PARAM;
434     G_MISS_LINE_PARAM_LIST SERVICE_LINE_PARAM_LIST;
435 
436     TYPE SERVICE_ORDER_STATUS IS RECORD
437     (
438         order_id            NUMBER		DEFAULT	FND_API.G_MISS_NUM,
439         order_status		VARCHAR2(40)	DEFAULT	FND_API.G_MISS_CHAR,
440         order_number  		VARCHAR2(40)	DEFAULT	FND_API.G_MISS_CHAR,
441         order_version		VARCHAR2(40) 	DEFAULT	1,
442         fulfillment_status	VARCHAR2(40)	DEFAULT	FND_API.G_MISS_CHAR,
443         fulfillment_result	VARCHAR2(4000)	DEFAULT	FND_API.G_MISS_CHAR,
444         completion_date		DATE		    DEFAULT	FND_API.G_MISS_DATE,
445         actual_fulfillment_date	DATE		DEFAULT	FND_API.G_MISS_DATE
446     );
447 
448 --     Added by SXBANERJ 07/05/2001
449 --     Table of Primitives  used for bulk inserts
450 
451         TYPE NUMBER_TAB         IS TABLE OF NUMBER          INDEX BY BINARY_INTEGER;
452         TYPE DATE_TAB           IS TABLE OF DATE            INDEX BY BINARY_INTEGER;
453         TYPE VARCHAR2_1_TAB     IS TABLE OF VARCHAR2(1)     INDEX BY BINARY_INTEGER;
454         TYPE VARCHAR2_30_TAB    IS TABLE OF VARCHAR2(30)    INDEX BY BINARY_INTEGER;
455         TYPE VARCHAR2_40_TAB    IS TABLE OF VARCHAR2(40)    INDEX BY BINARY_INTEGER;
456         TYPE VARCHAR2_240_TAB   IS TABLE OF VARCHAR2(240)   INDEX BY BINARY_INTEGER;
457         TYPE VARCHAR2_4000_TAB  IS TABLE OF VARCHAR2(4000)  INDEX BY BINARY_INTEGER;
458         TYPE VARCHAR2_32767_TAB IS TABLE OF VARCHAR2(32767) INDEX BY BINARY_INTEGER;
459 
460 -- Added by SXBANERJ 07/05/2001
461  TYPE SERVICE_LINE_ITEM_RELATIONSHIP IS RECORD
462   (
463        LINE_ITEM_ID NUMBER            ,
464        RELATED_LINE_ITEM_ID NUMBER    ,
465        LINE_RELATIONSHIP VARCHAR2(40)
466   );
467 
468 -- Added by SXBANERJ 07/05/2001
469  TYPE SERVICE_LINE_REL_LIST IS TABLE OF SERVICE_LINE_ITEM_RELATIONSHIP
470         INDEX BY BINARY_INTEGER ;
471 
472 
473 
477         LINE_ITEM_ID     NUMBER               ,
474 -- Added Line Attribute record. Holds all possible values for a line item parameter
475 
476    TYPE SERVICE_LINE_ATTRIB IS RECORD (
478         LINE_NUMBER              NUMBER          ,
479         WORKITEM_INSTANCE_ID     NUMBER          ,
480         WI_PARAMETER_ID          NUMBER          ,
481         WORKITEM_ID              NUMBER          ,
482         WORKITEM_NAME            VARCHAR2(40)    DEFAULT NULL ,
483         PARAMETER_NAME           VARCHAR2(40)    ,
484         PARAMETER_VALUE          VARCHAR2(4000)  ,
485         PARAMETER_REF_VALUE      VARCHAR2(4000)  ,
486         TXN_EXT_ATTRIB_DETAIL_ID NUMBER          ,
487         ATTRIB_SOURCE_TABLE      VARCHAR2(30)    ,
488         ATTRIB_SOURCE_ID         NUMBER         ,
489         IS_VALUE_EVALUATED       VARCHAR2(1)     ,
490         MODIFIED_FLAG            VARCHAR2(1)     ,
491         REQUIRED_FLAG            VARCHAR2(1)     ,
492         VALUE_LOOKUP_SQL         VARCHAR2(1996)  ,
493         VALIDATION_PROCEDURE     VARCHAR2(80)    ,
494         EVALUATION_MODE          VARCHAR2(20)    ,
495         EVALUATION_SEQ           NUMBER          ,
496         EVALUATION_PROCEDURE     VARCHAR2(80)    ,
497         DISPLAY_SEQ              NUMBER          ,
498         DEFAULT_VALUE            VARCHAR2(4000)
499 --        SECURITY_GROUP_ID        NUMBER
500        );
501 
502 -- Added line item parameter list
503   TYPE SERVICE_LINE_ATTRIB_LIST IS TABLE OF SERVICE_LINE_ATTRIB
504   INDEX BY BINARY_INTEGER;
505 
506 -- Added Type for Fulfill Worklist
507 
508 TYPE FULFILL_WORKLIST IS RECORD (
509      WORKITEM_INSTANCE_ID      NUMBER       ,
510      SERVICE_ITEM_NAME         NUMBER       ,
511      LINE_NUMBER               NUMBER       ,
512      VALIDATION_PROCEDURE      VARCHAR2(80) ,
513      VALIDATION_ENABLED_FLAG   VARCHAR2(1) DEFAULT 'N',
514      VERSION                   VARCHAR2(40) ,
515      FA_EXEC_MAP_PROC          VARCHAR2(80) ,
516      USER_WF_ITEM_KEY_PREFIX   VARCHAR2(240),
517      USER_WF_ITEM_TYPE         VARCHAR2(80) ,
518      USER_WF_PROCESS_NAME      VARCHAR2(40),
519      WF_EXEC_PROC              VARCHAR2(80) ,
520      TIME_ESTIMATE             NUMBER       ,
521      PROTECTED_FLAG            VARCHAR2(1)  ,
522      ROLE_NAME                 VARCHAR2(100) ,
523      WORKITEM_ID               NUMBER       ,
524      STATUS_CODE               VARCHAR2(40) ,
525      LINE_ITEM_ID              NUMBER       ,
526      WORKITEM_NAME             VARCHAR2(40) ,
527      REQUIRED_FULFILLMENT_DATE DATE         ,
528      WI_SEQUENCE               NUMBER       ,
529      PRIORITY                  NUMBER       ,
530      DUE_DATE                  DATE         ,
531      CUSTOMER_REQUIRED_DATE    DATE         ,
532      COMPLETION_DATE           DATE         ,
533      CANCEL_FULFILLMENT_DATE   DATE         ,
534      CANCELLED_BY              VARCHAR2(40) ,
535      HOLD_FULFILLMENT_DATE     DATE         ,
536      HELD_BY                   VARCHAR2(40) ,
537      RESUME_FULFILLMENT_DATE   DATE         ,
538      RESUMED_BY                VARCHAR2(40) ,
539      ACTUAL_FULFILLMENT_DATE   DATE         ,
540      WF_ITEM_TYPE              VARCHAR2(8)  ,
541      WF_ITEM_KEY               VARCHAR2(240),
542      ERROR_REF_ID              NUMBER       ,
543 --     SECURITY_GROUP_ID         NUMBER       ,
544      ATTRIBUTE_CATEGORY        VARCHAR2(30) ,
545      ATTRIBUTE1                VARCHAR2(240),
546      ATTRIBUTE2                VARCHAR2(240),
547      ATTRIBUTE3                VARCHAR2(240),
548      ATTRIBUTE4                VARCHAR2(240),
549      ATTRIBUTE5                VARCHAR2(240),
550      ATTRIBUTE6                VARCHAR2(240),
551      ATTRIBUTE7                VARCHAR2(240),
552      ATTRIBUTE8                VARCHAR2(240),
553      ATTRIBUTE9                VARCHAR2(240),
554      ATTRIBUTE10               VARCHAR2(240),
555      ATTRIBUTE11               VARCHAR2(240),
556      ATTRIBUTE12               VARCHAR2(240),
557      ATTRIBUTE13               VARCHAR2(240),
558      ATTRIBUTE14               VARCHAR2(240),
559      ATTRIBUTE15               VARCHAR2(240),
560      ATTRIBUTE16               VARCHAR2(240),
561      ATTRIBUTE17               VARCHAR2(240),
562      ATTRIBUTE18               VARCHAR2(240),
563      ATTRIBUTE19               VARCHAR2(240),
564      ATTRIBUTE20               VARCHAR2(240));
565 
566   -- fulfill worklist list
567   TYPE FULFILL_WORKLIST_LIST IS TABLE OF FULFILL_WORKLIST
568          INDEX BY BINARY_INTEGER;
569 
570 END XDP_TYPES;