1 PACKAGE JE_IT_LISTING_PKG AS
2 /* $Header: jeitlsts.pls 120.2 2008/05/10 10:38:44 pakumare noship $ */
3
4
5 TYPE tab_party_id IS TABLE OF
6 JE_IT_LIST_LINES_ALL.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
7 TYPE tab_trx_type_code IS TABLE OF
8 JE_IT_LIST_LINES_ALL.TRX_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
9 TYPE tab_trx_type_id IS TABLE OF
10 JE_IT_LIST_LINES_ALL.TRX_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
11 TYPE tab_doc_seq_num IS TABLE OF
12 JE_IT_LIST_LINES_ALL.DOC_SEQ_ID%TYPE INDEX BY BINARY_INTEGER;
13 TYPE tab_doc_seq_val IS TABLE OF
14 JE_IT_LIST_LINES_ALL.DOC_SEQ_NUM%TYPE INDEX BY BINARY_INTEGER;
15 TYPE tab_trx_date IS TABLE OF
16 JE_IT_LIST_LINES_ALL.TRX_DATE%TYPE INDEX BY BINARY_INTEGER;
17 TYPE tab_trx_id IS TABLE OF
18 JE_IT_LIST_LINES_ALL.TRX_ID%TYPE INDEX BY BINARY_INTEGER;
19 TYPE tab_trx_num IS TABLE OF
20 JE_IT_LIST_LINES_ALL.TRX_NUM%TYPE INDEX BY BINARY_INTEGER;
21 TYPE tab_trx_dist_id IS TABLE OF
22 JE_IT_LIST_LINES_ALL.TRX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
23 TYPE tab_trx_line_type_code IS TABLE OF
24 JE_IT_LIST_LINES_ALL.TRX_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25 TYPE tab_trx_line_tax_rate_id IS TABLE OF
26 JE_IT_LIST_LINES_ALL.TAX_RATE_ID%TYPE INDEX BY BINARY_INTEGER;
27 TYPE tab_inv_line_amount IS TABLE OF
28 ap_invoice_distributions_all.amount%TYPE INDEX BY BINARY_INTEGER;
29 TYPE tab_inv_tax_line_amount IS TABLE OF
30 ap_invoice_distributions_all.amount%TYPE INDEX BY BINARY_INTEGER;
31 TYPE tab_inv_type IS TABLE OF
32 ra_cust_trx_types_all.type%TYPE INDEX BY BINARY_INTEGER;
33 TYPE tab_party_vat_reg_num IS TABLE OF
34 JE_IT_LIST_PARTIES_ALL.vat_registration_num%TYPE INDEX BY BINARY_INTEGER;
35 TYPE tab_party_fiscal_id_num IS TABLE OF
36 JE_IT_LIST_PARTIES_ALL.fiscal_id_num%TYPE INDEX BY BINARY_INTEGER;
37
38
39 PROCEDURE Purge_trx_data(p_vat_reporting_entity_id IN NUMBER,p_year_of_declaration IN NUMBER);
40
41 PROCEDURE Final_data(
42 errbuf OUT NOCOPY VARCHAR2 ,
43 retcode OUT NOCOPY VARCHAR2,
44 p_vat_reporting_entity_id IN NUMBER,
45 p_year_of_declaration IN NUMBER);
46
47 PROCEDURE Extract_Data(
48 errbuf OUT NOCOPY VARCHAR2,
49 retcode OUT NOCOPY VARCHAR2,
50 P_VAT_REPORTING_ENTITY_ID IN NUMBER,
51 P_YEAR_OF_DECLARATION IN NUMBER,
52 P_REPORT_TYPE IN VARCHAR2,
53 P_DUMMY IN NUMBER,
54 P_VAT IN VARCHAR2,
55 P_REPORT_MODE IN VARCHAR2,
56 P_EFT IN VARCHAR2,
57 P_PARTY_LIMIT IN NUMBER,
58 P_CUST_SORT_COL IN VARCHAR2,
59 P_VEND_SORT_COL IN VARCHAR2,
60 P_GROUP_PARTIES_FLAG IN VARCHAR2
61 );
62
63 function get_bsv(ccid number) return varchar2;
64
65 END JE_IT_LISTING_PKG;