[Home] [Help]
PACKAGE: APPS.JG_ZZ_JOURNAL_AP_PKG
Source
1 PACKAGE jg_zz_journal_ap_pkg
2 -- $Header: jgzzjournalaps.pls 120.10.12020000.1 2012/06/27 12:09:50 appldev noship $
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_PERIOD_TO JG_ZZ_VAT_REP_STATUS.TAX_CALENDAR_PERIOD%TYPE; -- Bug8267272
8 P_DOCUMENT_SEQUENCE_NAME_FROM VARCHAR2(100);
9 P_DOCUMENT_SEQUENCE_NAME_TO VARCHAR2(100);
10 P_VENDOR_NAME_FROM VARCHAR2(100);
11 P_VENDOR_NAME_TO VARCHAR2(100);
12 P_DETAIL_SUMMARY VARCHAR2(100);
13 P_VAT_REGISTER_ID NUMBER ;
14 P_BALANCING_SEGMENT VARCHAR2(100);
15 P_TAX_TYPE VARCHAR2(100);
16 P_REGISTER_TYPE VARCHAR2(100);
17 P_START_INV_SEQUENCE NUMBER ;
18 P_REPORT_NAME VARCHAR2(100);
19 P_FIRST_PAGE_NUM NUMBER;
20 l_err_msg VARCHAR2(5000);
21 l_rec_count NUMBER;
22 p_debug_flag VARCHAR2(1) ;
23 g_precision NUMBER; --Bug8201935
24
25 FUNCTION beforeReport RETURN BOOLEAN;
26 FUNCTION afterReport RETURN BOOLEAN;
27 FUNCTION get_current_date RETURN VARCHAR2;
28 FUNCTION get_sequence_number RETURN NUMBER;
29 PROCEDURE jebedv08(p_vat_rep_entity_id IN NUMBER
30 ,p_period IN VARCHAR2
31 ,p_document_sequence_name_from IN VARCHAR2
32 ,p_document_sequence_name_to IN VARCHAR2
33 ,p_vendor_name_from IN VARCHAR2
34 ,p_vendor_name_to IN VARCHAR2
35 ,p_detail_summary IN VARCHAR2
36 ,x_err_msg OUT NOCOPY VARCHAR2);
37 PROCEDURE jeitapsr(p_vat_rep_entity_id IN NUMBER
38 ,p_period IN VARCHAR2
39 ,p_vat_register_id IN VARCHAR2
40 ,x_err_msg OUT NOCOPY VARCHAR2);
41 PROCEDURE jeitappv(p_vat_rep_entity_id IN NUMBER
42 ,p_period IN VARCHAR2
43 ,p_vat_register_id IN VARCHAR2
44 ,x_err_msg OUT NOCOPY VARCHAR2);
45 PROCEDURE jeesrvar(p_vat_rep_entity_id IN NUMBER
46 ,p_period IN VARCHAR2
47 ,p_period_to IN VARCHAR2 -- Bug8267272
48 ,p_tax_type IN VARCHAR2
49 ,p_balancing_segment IN VARCHAR2
50 ,p_start_inv_sequence IN VARCHAR2
51 ,x_err_msg OUT NOCOPY VARCHAR2);
52 PROCEDURE jeesrpvp(p_vat_rep_entity_id IN NUMBER
53 ,p_period IN VARCHAR2
54 ,p_period_to IN VARCHAR2 -- Bug8267272
55 ,p_tax_type IN VARCHAR2
56 ,p_register_type IN VARCHAR2
57 ,p_balancing_segment IN VARCHAR2
58 ,p_start_inv_sequence IN VARCHAR2
59 ,x_err_msg OUT NOCOPY VARCHAR2);
60 PROCEDURE journal_ap(p_vat_rep_entity_id IN NUMBER
61 ,p_period IN VARCHAR2
62 ,x_err_msg OUT NOCOPY VARCHAR2);
63 FUNCTION lcu_trans_line_tax_taxable_amt (p_trx_id IN NUMBER) RETURN NUMBER;
64 FUNCTION lcu_trans_line_tax_amt (p_trx_id IN NUMBER) RETURN NUMBER;
65 END jg_zz_journal_ap_pkg;