1 PACKAGE PO_APPROVED_SUPPLIER_LIST_S1 AUTHID CURRENT_USER as
2 /*$Header: POXSCASS.pls 115.1 2002/11/27 00:01:51 sbull noship $*/
3 /*===========================================================================
4 PACKAGE NAME: PO_APPROVED_SUPPLIER_LIST_S1
5 DESCRIPTION: This package contains the server side of Supplier Scheduling
6 APIs to select the ASL information.
7
8 CLIENT/SERVER: Server
9
10 OWNER: Shawna Liu
11
12 FUNCTION/
13 get_asl_info()
14
15 ============================================================================*/
16
17 /*===========================================================================
18 PROCEDURE NAME : get_asl_info
19
20 DESCRIPTION : GET_ASL_INFO is a procedure that selects the ASL
21 information for the Organization, Supplier, Supplier
22 Site and Item combination from PO_APPROVED_SUPPLIER_LIST
23 and pass the enable authorizations flag to the calling
24 procedure.
25
26 PARAMETERS : x_organization_id IN NUMBER,
27 x_vendor_id IN NUMBER,
28 x_vendor_site_id IN NUMBER,
29 x_item_id IN NUMBER,
30 x_asl_id OUT NUMBER,
31 x_enable_authorizations_flag OUT VARCHAR2
32
33 DESIGN REFERENCES :
34
35 ALGORITHM : Select ASL_ID, enable_authorizations_flag based on
36 the organization_id, vendor_id, vendor_site_id and
37 return ASL_ID and enable_authorization_flag.
38
39 NOTES : 1. An explicit cursor is used even though the select
40 should only return one row, in compliance with
41 the coding standard.
42 2. For now, po_message.show is used to handle errors.
43
44 OPEN ISSUES :
45
46 CLOSED ISSUES : 1. Approval_status should be 'APPROVED'.
47 2. Need to handle NO_DATA_FOUND, but not TOO_MANY_ROWS
48 (confirmed with Sri).
49
50 CHANGE HISTORY : Created 29-MAR-1995 SXLIU
51 ==========================================================================*/
52 PROCEDURE get_asl_info(x_organization_id in NUMBER,
53 x_vendor_id in NUMBER,
54 x_vendor_site_id in NUMBER,
55 x_item_id in NUMBER,
56 x_asl_id out NOCOPY NUMBER,
57 x_enable_authorizations_flag out NOCOPY VARCHAR2);
58
59 END PO_APPROVED_SUPPLIER_LIST_S1;