[Home] [Help]
PACKAGE: APPS.JG_ZZ_SUMMARY_AP_PKG
Source
1 PACKAGE JG_ZZ_SUMMARY_AP_PKG AUTHID CURRENT_USER
2 /* $Header: jgzzsummaryaps.pls 120.4.12010000.2 2008/11/17 10:08:57 vkejriwa ship $ */
3
4
5 AS
6 P_VAT_REPORTING_ENTITY_ID NUMBER(15);
7 P_TAX_CALENDAR_PERIOD VARCHAR2(10);
8 P_VAT_TRX_TYPE VARCHAR2(200);
9 P_EX_VAT_TRX_TYPE VARCHAR2(200);
10 P_INC_PREPAYMENTS VARCHAR2(1);
11 P_CALLING_REPORT VARCHAR2(100);
12 P_WHERE_CLAUSE VARCHAR2(4000); /* UT TEST. increased the size of P_WHERE_CLAUSE */
13 G_VAT_TRX_TYPE_MEANING VARCHAR2(100);
14 G_EX_VAT_TRX_TYPE_MEANING VARCHAR2(100);
15 G_INC_PREPAYMENTS VARCHAR2(100);
16 G_FUNCTIONAL_CURRENCY VARCHAR2(3);
17 G_COMPANY_NAME VARCHAR2(70);
18 G_SEQ_NO NUMBER(15) := 0;
19 G_EX_VAT_TRX_TYPE_DESC VARCHAR2(100);
20 G_VAT_TRX_TYPE_DESC VARCHAR2(100);
21 G_PRECISION NUMBER;
22
23 FUNCTION before_report
24 RETURN BOOLEAN;
25
26 FUNCTION get_vat_trx_type_meaning
27 RETURN VARCHAR2;
28
29 FUNCTION get_ex_vat_trx_type_meaning
30 RETURN VARCHAR2;
31
32 FUNCTION get_vat_trx_type_desc
33 RETURN VARCHAR2;
34
35 FUNCTION get_ex_vat_trx_type_desc
36 RETURN VARCHAR2;
37
38 FUNCTION get_prepayments_meaning
39 RETURN VARCHAR2;
40
41 FUNCTION get_functional_currency
42 RETURN VARCHAR2;
43
44 FUNCTION CF_Tax_Code_Type_Code (TAX_CODE_TYPE_CODE IN VARCHAR2)
45 RETURN NUMBER;
46
47 FUNCTION get_trn
48 RETURN VARCHAR2;
49
50 FUNCTION CF_seq_no
51 RETURN NUMBER;
52
53 END JG_ZZ_SUMMARY_AP_PKG;