1 PACKAGE OKC_REP_UDA_FUNCTIONS AUTHID CURRENT_USER AS
2 /* $Header: OKCVRUDAFS.pls 120.0.12020000.1 2013/03/18 19:09:36 nbingi noship $ */
3
4 g_pkg_name CONSTANT varchar2(50) := 'OKC_REP_UDA_FUNCTIONS';
5
6 FUNCTION getPoLineAmount(p_po_header_id NUMBER,
7 p_po_line_id NUMBER,
8 p_po_draft_id NUMBER) RETURN NUMBER;
9
10
11 PROCEDURE sbcr_source_doc_default(p_contract_id IN NUMBER
12 ,p_source_doc_id IN VARCHAR2
13 ,p_source_doc_type IN VARCHAR2
14 ,x_buyer_name IN OUT NOCOPY VARCHAR2
15 ,x_issuing_off_symbol IN OUT NOCOPY VARCHAR2
16 ,x_total_amount IN OUT NOCOPY NUMBER
17 ,x_currency IN OUT NOCOPY VARCHAR2
18 ,x_naics_code IN OUT NOCOPY VARCHAR2
19 ,x_size_standard IN OUT NOCOPY VARCHAR2
20 ,x_fsc_svc_code IN OUT NOCOPY VARCHAR2
21 ,x_item_long_desc IN OUT NOCOPY VARCHAR2
22 ,x_return_status OUT NOCOPY VARCHAR2
23 ,x_errorcode OUT NOCOPY VARCHAR2
24 ,x_msg_count OUT NOCOPY VARCHAR2
25 ,x_msg_data OUT NOCOPY VARCHAR2);
26
27 END OKC_REP_UDA_FUNCTIONS;