1 PACKAGE FTE_PO_INTEGRATION_GRP AUTHID CURRENT_USER AS
2 /* $Header: FTEGPOIS.pls 120.1 2005/07/21 15:02:19 schennal noship $ */
3 /*
4 -- Global constants
5 -- +======================================================================+
6 -- Procedure :
7 -- Estimated Rate for the given Shipment Header Id
8 --
9 -- Description:
10 --
11 -- Inputs: Shipment Header Id
12 -- Output: Table of Receipt Lines w/ Cost and Currency Code
13 -- See the Record structure for more info
14 -- +======================================================================+
15 */
16 /*Receipt Record Type for the output table for the calling API*/
17
18 TYPE FTE_RECEIPT_LINE_REC IS RECORD
19 (VENDOR_ID NUMBER,
20 VENDOR_SITE_ID NUMBER,
21 RCV_SHIPMENT_LINE_ID NUMBER,
22 CURRENCY_CODE VARCHAR2(15),
23 TOTAL_COST NUMBER,
24 RETURN_STATUS VARCHAR2(1),
25 MESSAGE_TEXT VARCHAR2(1000));
26
27 /**Receipt_Table Type*/
28
29 TYPE FTE_RECEIPT_LINES_TAB IS TABLE OF FTE_RECEIPT_LINE_REC INDEX BY BINARY_INTEGER ;
30
31 /* Variable Tables for any number, currency ( 15 chars ), uom ( 3 chars )*/
32
33 -- use from wsh_util_core.api
34 TYPE fte_number_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
35 TYPE fte_varchar15_table IS TABLE OF VARCHAR2(15) INDEX BY BINARY_INTEGER;
36 TYPE fte_varchar3_table IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
37 TYPE fte_varchar25_table IS TABLE OF VARCHAR2(25) INDEX BY BINARY_INTEGER;
38
39 /* This procedure will be used to get the estimated rate from pre-rated shipments */
40 /* This API will not rate or re-rate during this process. Extract only pre-rated info */
41 PROCEDURE GET_ESTIMATED_RATES(
42 p_init_msg_list IN VARCHAR2,
43 p_api_version_number IN NUMBER,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 p_shipment_header_id IN NUMBER,
48 x_receipt_lines_tab OUT NOCOPY FTE_PO_INTEGRATION_GRP.FTE_RECEIPT_LINES_TAB);
49
50 END FTE_PO_INTEGRATION_GRP;