PACKAGE: APPS.PO_VENDORS_PVT

Source

1 PACKAGE PO_VENDORS_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVVENS.pls 115.2 2003/10/31 00:59:16 sahegde noship $ */
3 
4 -- define the supplier user table type for get_supplier_userlist
5 SUBTYPE supplier_user_tbl_type IS po_vendors_grp.external_user_tbl_type;
6 
7 -- Read the profile option that enables/disables the debug log
8 g_fnd_debug CONSTANT VARCHAR2(1) :=
9   NVL (FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
10 
11 
12 -- other
13 g_pkg_name CONSTANT VARCHAR2(30) := 'PO_VENDORS_PVT';
14 g_module_prefix CONSTANT VARCHAR2(50) := 'po.plsql.'||g_pkg_name||'.';
15 
16 PROCEDURE get_supplier_userlist(p_document_id               IN  NUMBER
17                                ,p_document_type             IN  VARCHAR2
18 			       ,p_external_contact_id       IN  NUMBER DEFAULT NULL
19                                ,x_return_status             OUT NOCOPY VARCHAR2
20                                ,x_supplier_user_tbl         OUT NOCOPY supplier_user_tbl_type
21                                ,x_supplier_userlist         OUT NOCOPY VARCHAR2
22                                ,x_supplier_userlist_for_sql OUT NOCOPY VARCHAR2
23                                ,x_num_users                 OUT NOCOPY NUMBER
24                                ,x_vendor_id                 OUT NOCOPY NUMBER);
25 
26 END PO_VENDORS_PVT ;