1 PACKAGE POS_REQUEST_UTILS_PKG AUTHID CURRENT_USER AS
2 /*$Header: POSRQUTS.pls 120.4 2005/08/04 12:51:56 bitang noship $ */
3
4 -- This procedure is called by Sourcing to invite a supplier to
5 -- register
6 PROCEDURE pos_src_register_supplier
7 ( p_supplier_reg_id IN NUMBER,
8 p_org_id IN NUMBER,
9 x_return_status OUT NOCOPY VARCHAR2,
10 x_msg_count OUT NOCOPY NUMBER,
11 x_msg_data OUT NOCOPY VARCHAR2
12 ) ;
13
14 -- This procedure is called by Sourcing to create a RFQ Only supplier
15 PROCEDURE pos_src_approve_rfq_supplier
16 ( p_supplier_reg_id IN NUMBER,
17 x_party_id OUT NOCOPY NUMBER,
18 x_vendor_id OUT NOCOPY NUMBER,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2
22 ) ;
23
24 PROCEDURE pos_src_get_supplier_det
25 (p_supplier_party_id IN NUMBER,
26 p_org_id IN NUMBER,
27 x_vendor_id OUT NOCOPY NUMBER,
28 x_party_site_id OUT NOCOPY NUMBER,
29 x_vendor_site_id OUT NOCOPY NUMBER,
30 x_contact_party_id OUT NOCOPY NUMBER,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2
34 ) ;
35
36 PROCEDURE pos_get_contact_approved_det
37 (p_contact_req_id IN NUMBER,
38 x_contact_party_id OUT NOCOPY NUMBER,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2
42 ) ;
43
44 END POS_REQUEST_UTILS_PKG;