1 PACKAGE jg_zz_journal_ap_pkg
2 -- $Header: jgzzjournalaps.pls 120.7.12010000.1 2008/07/28 07:57:22 appldev ship $
3 AS
4 P_VAT_REP_ENTITY_ID NUMBER ;
5 -- P_PERIOD VARCHAR2(10);
6 P_PERIOD JG_ZZ_VAT_REP_STATUS.TAX_CALENDAR_PERIOD%TYPE;
7 P_DOCUMENT_SEQUENCE_NAME_FROM VARCHAR2(100);
8 P_DOCUMENT_SEQUENCE_NAME_TO VARCHAR2(100);
9 P_VENDOR_NAME_FROM VARCHAR2(100);
10 P_VENDOR_NAME_TO VARCHAR2(100);
11 P_DETAIL_SUMMARY VARCHAR2(100);
12 P_VAT_REGISTER_ID NUMBER ;
13 P_BALANCING_SEGMENT VARCHAR2(100);
14 P_TAX_TYPE VARCHAR2(100);
15 P_REGISTER_TYPE VARCHAR2(100);
16 P_START_INV_SEQUENCE NUMBER ;
17 P_REPORT_NAME VARCHAR2(100);
18 P_FIRST_PAGE_NUM NUMBER;
19 l_err_msg VARCHAR2(5000);
20 l_rec_count NUMBER;
21 p_debug_flag VARCHAR2(1) ;
22
23 FUNCTION beforeReport RETURN BOOLEAN;
24 FUNCTION afterReport RETURN BOOLEAN;
25 FUNCTION get_current_date RETURN VARCHAR2;
26 FUNCTION get_sequence_number RETURN NUMBER;
27 PROCEDURE jebedv08(p_vat_rep_entity_id IN NUMBER
28 ,p_period IN VARCHAR2
29 ,p_document_sequence_name_from IN VARCHAR2
30 ,p_document_sequence_name_to IN VARCHAR2
31 ,p_vendor_name_from IN VARCHAR2
32 ,p_vendor_name_to IN VARCHAR2
33 ,p_detail_summary IN VARCHAR2
34 ,x_err_msg OUT NOCOPY VARCHAR2);
35 PROCEDURE jeitapsr(p_vat_rep_entity_id IN NUMBER
36 ,p_period IN VARCHAR2
37 ,p_vat_register_id IN VARCHAR2
38 ,x_err_msg OUT NOCOPY VARCHAR2);
39 PROCEDURE jeitappv(p_vat_rep_entity_id IN NUMBER
40 ,p_period IN VARCHAR2
41 ,p_vat_register_id IN VARCHAR2
42 ,x_err_msg OUT NOCOPY VARCHAR2);
43 PROCEDURE jeesrvar(p_vat_rep_entity_id IN NUMBER
44 ,p_period IN VARCHAR2
45 ,p_tax_type IN VARCHAR2
46 ,p_balancing_segment IN VARCHAR2
47 ,p_start_inv_sequence IN VARCHAR2
48 ,x_err_msg OUT NOCOPY VARCHAR2);
49 PROCEDURE jeesrpvp(p_vat_rep_entity_id IN NUMBER
50 ,p_period IN VARCHAR2
51 ,p_tax_type IN VARCHAR2
52 ,p_register_type IN VARCHAR2
53 ,p_balancing_segment IN VARCHAR2
54 ,p_start_inv_sequence IN VARCHAR2
55 ,x_err_msg OUT NOCOPY VARCHAR2);
56 PROCEDURE journal_ap(p_vat_rep_entity_id IN NUMBER
57 ,p_period IN VARCHAR2
58 ,x_err_msg OUT NOCOPY VARCHAR2);
59 FUNCTION lcu_trans_line_tax_taxable_amt (p_trx_id IN NUMBER) RETURN NUMBER;
60 FUNCTION lcu_trans_line_tax_amt (p_trx_id IN NUMBER) RETURN NUMBER;
61 END jg_zz_journal_ap_pkg;