1 PACKAGE ECEPOI AS
2 /* $Header: ECPOIS.pls 120.3.12010000.1 2008/07/25 07:26:00 appldev ship $ */
3
4 Procedure Process_POI_Inbound (
5 errbuf OUT NOCOPY varchar2,
6 retcode OUT NOCOPY varchar2,
7 i_file_path IN varchar2,
8 i_file_name IN varchar2,
9 i_debug_mode IN number,
10 i_run_import IN varchar2,
11 i_num_instances IN number default 1,
12 i_transaction_type IN varchar2,
13 i_map_id IN number,
14 i_data_file_characterset IN varchar2
15 );
16
17 Procedure Concat_Strings(
18 String1 IN VARCHAR2,
19 String2 IN VARCHAR2,
20 String3 IN VARCHAR2,
21 OUT_String OUT NOCOPY VARCHAR2
22 );
23
24 Procedure Get_Ship_To_Org_Id(
25 p_address_id IN NUMBER,
26 p_customer_id IN NUMBER,
27 x_ship_to_org_id OUT NOCOPY NUMBER
28 );
29
30 Procedure Get_Bill_To_Org_Id(
31 p_address_id IN NUMBER,
32 p_customer_id IN NUMBER,
33 x_bill_to_org_id OUT NOCOPY NUMBER
34 );
35
36 -- Fix for the bug 2627330
37 Procedure Concat_Instructions(
38 String1 IN VARCHAR2,
39 String2 IN VARCHAR2,
40 String3 IN VARCHAR2,
41 String4 IN VARCHAR2,
42 String5 IN VARCHAR2,
43 Concat_String OUT NOCOPY VARCHAR2
44 );
45 -- Fix ends
46
47 Function EM_Transaction_Type
48 ( p_txn_code IN VARCHAR2
49 ) Return Varchar2;
50
51 Procedure Raise_Event_Hist (
52 p_order_source_id IN Number,
53 p_orig_sys_document_ref IN Varchar2,
54 p_sold_to_org_id IN Number,
55 p_transaction_type IN Varchar2,
56 p_document_id IN Number DEFAULT NULL,
57 p_change_sequence IN Varchar2 DEFAULT NULL,
58 p_order_number IN Number DEFAULT NULL,
59 p_itemtype IN Varchar2 DEFAULT NULL,
60 p_itemkey IN Varchar2 DEFAULT NULL,
61 p_status IN Varchar2 DEFAULT NULL,
62 p_message_text IN Varchar2 DEFAULT NULL,
63 p_processing IN Varchar2 DEFAULT NULL,
64 p_xmlg_party_id IN Number DEFAULT NULL,
65 p_xmlg_party_site_id IN Number DEFAULT NULL,
66 p_order_type_id IN Number DEFAULT NULL,
67 p_header_id IN Number DEFAULT NULL,
68 p_org_id IN Number,
69 x_return_status OUT NOCOPY Varchar2
70 );
71
72 PROCEDURE Get_Item_Description
73 ( p_org_id IN NUMBER
74 , p_item_identifier_type IN VARCHAR2
75 , p_inventory_item_id IN NUMBER
76 , p_ordered_item_id IN NUMBER
77 , p_sold_to_org_id IN NUMBER
78 , p_ordered_item IN VARCHAR2
79 , x_item_description OUT NOCOPY VARCHAR2
80 );
81
82
83 END ECEPOI;