1 PACKAGE GMF_RA_GET_FOB_CODES AUTHID CURRENT_USER AS
2 /* $Header: gmffobcs.pls 115.0 99/07/16 04:17:41 porting shi $ */
3 /* SIERRA changed the datatypes of start_date and end_date to date */
4 /* PROCEDURE ra_get_fob_codes( startdate in varchar2,
5 enddate in varchar2, */
6 PROCEDURE ra_get_fob_codes( startdate in date,
7 enddate in date,
8 lookupcode in out varchar2,
9 description out varchar2,
10 creation_date out varchar2,
11 created_by out number,
12 last_update_date out varchar2,
13 last_updated_by out number,
14 row_to_fetch in out number,
15 statuscode out number,
16 inactive_status out number);
17 function get_name(usr_id number) return varchar2;
18 END GMF_RA_GET_FOB_CODES;