1 PACKAGE OE_ORDER_IMPORT_MAIN_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVIMNS.pls 120.5 2006/09/13 09:06:11 dmitra noship $ */
3
4 -- Start of Comments
5 -- API name Order Import Main
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_MAIN_PVT';
16 G_ORG_ID NUMBER;
17
18 -- Added this to create new conc. program for FND_STAT
19 PROCEDURE ORDER_IMPORT_STATS_CONC_PGM(
20 errbuf OUT NOCOPY VARCHAR2
21
22 ,retcode OUT NOCOPY NUMBER
23
24 );
25
26
27 PROCEDURE ORDER_IMPORT_CONC_PGM(
28 errbuf OUT NOCOPY VARCHAR2
29
30 ,retcode OUT NOCOPY NUMBER
31 ,p_operating_unit IN NUMBER DEFAULT NULL
32 ,p_order_source IN VARCHAR2
33 ,p_orig_sys_document_ref IN VARCHAR2
34 ,p_operation_code IN VARCHAR2
35 ,p_validate_only IN VARCHAR2 DEFAULT 'N'
36 ,p_debug_level IN NUMBER
37 ,p_num_instances IN NUMBER DEFAULT 1
38 ,p_sold_to_org_id IN NUMBER := NULL
39 ,p_sold_to_org IN VARCHAR2 := NULL
40 ,p_change_sequence IN VARCHAR2 := NULL
41 ,p_perf_param IN VARCHAR2 := 'Y'
42 ,p_rtrim_data IN VARCHAR2 := 'N'
43 ,p_process_orders_with_null_org IN VARCHAR2 DEFAULT 'Y'
44 ,p_default_org_id IN NUMBER DEFAULT NULL
45 ,p_validate_desc_flex IN VARCHAR2 DEFAULT 'Y' --bug 4343612
46 );
47
48 PROCEDURE ORDER_IMPORT_FORM(
49 p_request_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
50 ,p_order_source_id IN NUMBER
51 ,p_orig_sys_document_ref IN VARCHAR2
52 ,p_sold_to_org_id IN NUMBER DEFAULT NULL
53 ,p_sold_to_org IN VARCHAR2 DEFAULT NULL
54 ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
55 ,p_org_id IN NUMBER DEFAULT NULL
56 ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
57 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
58 ,p_rtrim_data In Varchar2 Default Null
59 ,p_msg_count OUT NOCOPY NUMBER
60
61 ,p_msg_data OUT NOCOPY VARCHAR2
62
63 ,p_return_status OUT NOCOPY VARCHAR2
64
65
66 );
67 -- Retreive the client info for bug no 5493479
68 G_CONTEXT_ID NUMBER := NULL;
69 END OE_ORDER_IMPORT_MAIN_PVT;