PACKAGE: APPS.OKE_MDS_RELIEF_PKG

Source

1 PACKAGE OKE_MDS_RELIEF_PKG AUTHID CURRENT_USER AS
2 /* $Header: OKEMDSFS.pls 115.6 2002/12/04 08:45:56 alaw ship $ */
3 
4 
5 TYPE mds_rec_type IS RECORD (
6 	  mtl_transaction_id Number
7 	, organization_id Number
8 	, inventory_item_id Number
9 	, transaction_source_id Number
10 	, transaction_source_type_id Number
11 	, trx_source_delivery_id Number
12 	, trx_source_line_id Number
13 	, revision Varchar2(3)
14 	, subinventory_code Varchar2(10)
15 	, locator_id Number
16 	, primary_quantity Number
17 	, transaction_quantity Number
18 	, transaction_source_name Varchar2(30)
19 	, transaction_date Date
20 	, mps_transaction_id Number
21 	, quantity Number
22 	, order_quantity Number
23 	, project_id Number
24 	, task_id Number
25 	, unit_number Varchar2(30)
26   );
27 
28 
29 TYPE mds_tbl_type IS TABLE OF mds_rec_type
30 INDEX BY BINARY_INTEGER;
31 
32 -- GLOBAL MESSAGE CONSTANTS
33 
34   G_FND_APP			CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
35 
36   G_FORM_UNABLE_TO_RESERVE_REC 	CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
37   G_FORM_RECORD_DELETED 	CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
38 
39   G_FORM_RECORD_CHANGED 	CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
40 
41   G_RECORD_LOGICALLY_DELETED	CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
42   G_REQUIRED_VALUE		CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
43   G_INVALID_VALUE		CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
44   G_COL_NAME_TOKEN		CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
45   G_PARENT_TABLE_TOKEN		CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
46   G_CHILD_TABLE_TOKEN		CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
47   G_PKG_NAME			CONSTANT VARCHAR2(200) := 'OKE_MDS_RELIEF';
48   G_APP_NAME			CONSTANT VARCHAR2(3)   :=  OKE_API.G_APP_NAME;
49 
50 
51 
52 Procedure Mds_Relief( ERRBUF	OUT NOCOPY VARCHAR2
53 		    , RETCODE	OUT NOCOPY NUMBER);
54 
55 
56 
57 END;
58 
59 
60