DBA Data[Home] [Help]

PACKAGE: APPS.ONT_ICP_GET_USER_DETAILS

Source


1 package ONT_icp_get_user_details AUTHID CURRENT_USER as
2 /*$Header: OEXONTHS.pls 120.0 2005/06/01 03:06:32 appldev noship $ */
3 
4   procedure get_user_customer(in_user          IN NUMBER,
5 out_name OUT NOCOPY VARCHAR2,
6 
7 out_customer OUT NOCOPY VARCHAR2,
8 
9 out_customer_id OUT NOCOPY NUMBER,
10 
11 out_contact_id OUT NOCOPY NUMBER,
12 
13 out_status OUT NOCOPY VARCHAR2
14 
15 					    );
16 
17 end ONT_icp_get_user_details; /* end of package spec */