DBA Data[Home] [Help]

PACKAGE: APPS.OE_INLINE_CUSTOMER_PUB

Source


1 PACKAGE OE_INLINE_CUSTOMER_PUB AUTHID CURRENT_USER 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;