DBA Data[Home] [Help]

PACKAGE: APPS.PO_FBO_MAPPING

Source


1 PACKAGE PO_FBO_MAPPING AUTHID CURRENT_USER AS
2 -- $Header: PO_FBO_MAPPING.pls 120.0 2011/12/19 11:49:51 inagdeo noship $
3 
4 -------------------------------------------------------------------------------
5 --Start of Comments
6 -- Plsql table of FBO codes - Statutory Authority indexed by
7 -- Seeded values of No Competition Reason.
8 --End of Comments
9 -------------------------------------------------------------------------------
10 TYPE g_stauth_map_tl
11      IS TABLE OF po_lookup_codes.LOOKUP_CODE%TYPE
12      INDEX BY po_lookup_codes.LOOKUP_CODE%TYPE;
13 
14 g_stauth_map g_stauth_map_tl;
15 
16 -------------------------------------------------------------------------------
17 --Start of Comments
18 --Name: get_fbo_stauth
19 --Pre-reqs: None.
20 --Function:
21 -- This procedure returns the corresponding FBO code for
22 -- seeded value of No competition Reason.
23 --Parameters:
24 --IN:
25 --p_no_comp_code
26 --	Seeded No Competition Reason code.
27 --End of Comments
28 -------------------------------------------------------------------------------
29 FUNCTION get_fbo_stauth(p_no_comp_code IN po_lookup_codes.LOOKUP_CODE%TYPE)
30 RETURN VARCHAR2;
31 
32 END PO_FBO_MAPPING;