PACKAGE: APPS.OE_CNCL_ORDER_IMPORT_PVT

Source

1 PACKAGE OE_CNCL_ORDER_IMPORT_PVT AS
2 /* $Header: OEXVCIMS.pls 120.1 2005/07/18 11:13:10 sphatarp noship $ */
3 
4 --  Start of Comments
5 --  API name    "Cancelled" Order Import
6 --  Type        Private
7 --  Function
8 --  Pre-reqs
9 --  Parameters
10 --  Version     Current version = 1.0
11 --              Initial version = 1.0
12 --  Notes
13 --  End of Comments
14 
15 G_PKG_NAME         VARCHAR2(30) := 'OE_CNCL_ORDER_IMPORT_PVT';
16 
17 TYPE Action_Rec_Type IS RECORD (
18   orig_sys_line_ref                     varchar2(50)
19 , orig_sys_shipment_ref                 varchar2(50)
20 , action_code                           varchar2(30)
21 , entity_code                           varchar2(50)
22 , entity_id                             number
23 , hold_id                               number
24 , hold_type_code                       	varchar2(30)
25 , hold_type_id                        	number
26 , hold_until_date                       date
27 , release_reason_code                   varchar2(30)
28 , comments                              varchar2(2000)
29 , context                               varchar2(30)
30 , attribute1                            varchar2(240)
31 , attribute2                            varchar2(240)
32 , attribute3                            varchar2(240)
33 , attribute4                            varchar2(240)
34 , attribute5                            varchar2(240)
35 , attribute6                            varchar2(240)
36 , attribute7                            varchar2(240)
37 , attribute8                            varchar2(240)
38 , attribute9                            varchar2(240)
39 , attribute10                           varchar2(240)
40 , attribute11                           varchar2(240)
41 , attribute12                           varchar2(240)
42 , attribute13                           varchar2(240)
43 , attribute14                           varchar2(240)
44 , attribute15                           varchar2(240)
45 , request_id				number
46 , operation_code			varchar2(30)
47 , error_flag				varchar2(1)
48 , status_flag				varchar2(1)
49 , interface_status			varchar2(1000)
50 );
51 
52 PROCEDURE Import_Order(
53    p_request_id			IN  NUMBER   DEFAULT FND_API.G_MISS_NUM
54   ,p_order_source_id		IN  NUMBER
55   ,p_orig_sys_document_ref      IN  VARCHAR2
56   ,p_sold_to_org_id             IN  NUMBER   := NULL
57   ,p_sold_to_org                IN  VARCHAR2 := NULL
58   ,p_change_sequence      	IN  VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
59   ,p_validate_only		IN  VARCHAR2 DEFAULT FND_API.G_FALSE
60   ,p_init_msg_list		IN  VARCHAR2 DEFAULT FND_API.G_TRUE
61   ,p_org_id                     IN  NUMBER  DEFAULT NULL
62   ,p_msg_count                  OUT NOCOPY /* file.sql.39 change */ NUMBER
63   ,p_msg_data                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64   ,p_return_status              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65 );
66 
67 END OE_CNCL_ORDER_IMPORT_PVT;