1 PACKAGE icx_por_wf_util_pkg AUTHID CURRENT_USER AS
2 /* $Header: ICXWFUTS.pls 115.1 2004/03/31 18:47:53 vkartik noship $ */
3
4 /* Function returns po number for the given line_location_id */
5 FUNCTION get_po_number(p_line_location_id IN NUMBER) RETURN VARCHAR2;
6
7 /* Function returns sales order number for the given requsition_line_id */
8 FUNCTION get_so_number(p_req_line_id IN NUMBER) RETURN VARCHAR2;
9
10 /* Function returns cost center for the given requsition_line_id */
11 FUNCTION get_cost_center(p_req_line_id IN NUMBER) RETURN VARCHAR2 ;
12
13 END icx_por_wf_util_pkg;