[Home] [Help]
PACKAGE: APPS.OE_ORDER_IMPORT_PVT
Source
1 PACKAGE OE_ORDER_IMPORT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVIMPS.pls 120.3.12010000.1 2008/07/25 08:03:42 appldev ship $ */
3
4 -- Start of Comments
5 -- API name 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_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 , fulfillment_set_name varchar2(30)
48 , error_flag varchar2(1)
49 , status_flag varchar2(1)
50 , interface_status varchar2(1000)
51 --myerrams, start, added the following fields for R12 Customer Acceptance Project
52 ,char_param1 varchar2(2000)
53 ,char_param2 varchar2(240)
54 ,char_param3 varchar2(240)
55 ,char_param4 varchar2(240)
56 ,char_param5 varchar2(240)
57 ,date_param1 date
58 ,date_param2 date
59 ,date_param3 date
60 ,date_param4 date
61 ,date_param5 date
62 --myerrams, end;
63 );
64
65 PROCEDURE Import_Order(
66 p_request_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
67 ,p_order_source_id IN NUMBER
68 ,p_orig_sys_document_ref IN VARCHAR2
69 ,p_sold_to_org_id IN NUMBER := NULL
70 ,p_sold_to_org IN VARCHAR2 := NULL
71 ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
72 ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
73 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
74 ,p_rtrim_data In Varchar2 := 'N'
75 ,p_org_id IN NUMBER DEFAULT NULL
76 ,p_msg_count OUT NOCOPY NUMBER
77
78 ,p_msg_data OUT NOCOPY VARCHAR2
79
80 ,p_return_status OUT NOCOPY VARCHAR2
81 ,p_validate_desc_flex in varchar2 default 'Y' -- bug4343612
82 );
83
84 END OE_ORDER_IMPORT_PVT;