[Home] [Help]
PACKAGE: APPS.OE_INLINE_CUSTOMER_PUB
Source
1 PACKAGE OE_INLINE_CUSTOMER_PUB AS
2 /* $Header: OEXPINLS.pls 120.1.12010000.1 2008/07/25 07:53:07 appldev ship $ */
3 -- Start of Comments
4 -- API name OE_INLINE_CUSTOMER_PUB
5 -- Type Public
6 -- Purpose Order Import customer creation
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 CONSTANT VARCHAR2(30) := 'OE_INLINE_CUSTOMER_PUB';
16 G_SOLD_TO_CUST NUMBER;
17
18 PROCEDURE Create_Customer_Info(
19 p_customer_info_ref IN Varchar2,
20 p_customer_info_type_code IN Varchar2,
21 p_usage IN Varchar2,
22 p_orig_sys_document_ref IN Varchar2 Default null,
23 p_orig_sys_line_ref IN Varchar2 Default null,
24 p_order_source_id IN Number Default null,
25 p_org_id IN Number Default null,
26 x_customer_info_id OUT NOCOPY /* file.sql.39 change */ Number,
27 x_customer_info_number OUT NOCOPY /* file.sql.39 change */ Varchar2,
28 x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2
29 );
30
31 Procedure Delete_Customer_Info(
32 p_header_customer_rec In OE_ORDER_IMPORT_SPECIFIC_PVT.Customer_Rec_Type,
33 p_line_customer_tbl In OE_ORDER_IMPORT_SPECIFIC_PVT.Customer_Tbl_Type);
34
35 End OE_INLINE_CUSTOMER_PUB;