1 PACKAGE ja_zz_invoice_create AUTHID CURRENT_USER AS
2 /* $Header: jazzrics.pls 115.3 2004/02/09 20:34:23 thwon ship $ */
3
4 ----------------------------------------------------------------------------
5 -- PUBLIC FUNCTIONS/PROCEDURES --
6 ----------------------------------------------------------------------------
7 TYPE varchar2_150_tbl_type is Table of Varchar2(150) index by binary_integer;
8 TYPE varchar2_50_tbl_type is Table of Varchar2(50) index by binary_integer;
9 TYPE varchar2_20_tbl_type is Table of Varchar2(20) index by binary_integer;
10 TYPE number_tbl_type is Table of Number index by binary_integer;
11 TYPE date_tbl_type is Table of Date index by binary_integer;
12
13 Type R_interface_line is RECORD
14 (
15 trx_header_id Number_tbl_type,
16 trx_line_id Number_tbl_type,
17 customer_trx_id Number_tbl_type,
18 cust_trx_type_id Number_tbl_type,
19 trx_date Date_tbl_type,
20 vat_tax_id Number_tbl_type,
21 line_type Varchar2_20_tbl_type
22 );
23
24 Type R_interface_line1 is RECORD
25 (
26 trx_line_id Number_tbl_type,
27 customer_trx_id Number_tbl_type,
28 cust_trx_type_id Number_tbl_type,
29 trx_date Date_tbl_type,
30 last_issued_date Date_tbl_type,
31 advance_days Number_tbl_type,
32 vat_tax_id Number_tbl_type,
33 line_type Varchar2_20_tbl_type
34 );
35
36 FUNCTION validate_gdff (p_request_id IN NUMBER) RETURN NUMBER;
37
38 END ja_zz_invoice_create;
39