[Home] [Help]
PACKAGE: APPS.JG_ZZ_SUMMARY_ALL_PKG
Source
1 PACKAGE JG_ZZ_SUMMARY_ALL_PKG
2 -- $Header: jgzzsummaryalls.pls 120.6.12010000.3 2009/01/29 09:56:41 rahulkum ship $
3 -- +======================================================================+
4 -- | Copyright (c) 1996 Oracle Corporation Redwood Shores, California, USA|
5 -- | All rights reserved. |
6 -- +======================================================================+
7 -- NAME: JG_ZZ_SUMMARY_ALL_PKG
8 --
9 -- DESCRIPTION: This Package is the default Package containing the Procedures
10 -- used by SUMMARY-ALL Extract
11 --
12 -- NOTES:
13 --
14 -- Change Record:
15 -- ===============
16 -- Version Date Author Remarks
17 -- ======= =========== ========================= =======================+
18 -- DRAFT 1A 04-Feb-2006 Balachander Ganesh Initial draft version
19 -- DRAFT 1B 21-Feb-2006 Balachander Ganesh Updated with Review
20 -- comments from IDC
21 -- DRAFT 1C 22-Feb-2006 Suresh Pasupunuri Included the code for RTP
22 -- DRAFT 1C 27-Feb-2006 Suresh Pasupunuri sum_fixedformula, sum_other_formula,
23 -- cf_total_vat_chargedformula, vat_total_chargedformula,
24 -- cf_vat_total_inputformula functions are removed.
25 -- DRAFT 1D 23-Mar-2006 Suresh Pasupunuri Added a function JEITPSSR_AMOUNT_TO_PAY for calculating
26 -- the AMOUNT_TO_PAY for Italy Payables Summary VAT Report.
27 -- DRAFT 1E 03-Apr-2006 Suresh Pasupunuri Added one new flag bit TEMP_FLAG. Usage in JEITPSSR_AMOUNT_TO_PAY
28 -- function.
29 -- DRAFT 1F 29-Jan-2009 Rahul Kumar Added one new function JEITPSSR_AMOUNT_TO_PAY_UPDATE.
30 -- +=======================================================================+
31 AS
32 P_TRN_NUM VARCHAR2(100);
33 P_VAT_REP_ENTITY_ID NUMBER;
34 P_VAR_ON_PURCHASES NUMBER;
35 P_VAR_ON_SALES NUMBER;
36 P_PERIOD VARCHAR2(100);
37 P_VAT_BOX VARCHAR2(100);
38 P_VAT_TRX_TYPE_LOW VARCHAR2(100);
39 P_VAT_TRX_TYPE_HIGH VARCHAR2(100);
40 P_VAT_TRX_TYPE VARCHAR2(100);
41 P_REPORT_FORMAT VARCHAR2(1);
42 P_SOURCE VARCHAR2(10);
43 P_DOC_NAME VARCHAR2(100);
44 P_DOC_SEQ_VALUE VARCHAR2(100);
45 P_REPORT_NAME VARCHAR2(20);
46 P_LOCATION VARCHAR2(100);
47 L_ERR_MSG VARCHAR2(5000);
48 P_FUNC_CURR VARCHAR2(10);
49 P_LEGAL_ENTITY_NAME VARCHAR2(240);
50 P_BOX_FROM VARCHAR2(10);
51 P_BOX_TO VARCHAR2(10);
52 P_LEGAL_ENTITY_ID NUMBER;
53 P_DEBUG_FLAG VARCHAR2(1) := 'Y';
54 P_DETAIL_SUMMARY VARCHAR2(30);
55 P_FIRST_PAGE_NUM NUMBER;
56 TEMP_FLAG NUMBER := 0; --Flag variable for function JEITPSSR_AMOUNT_TO_PAY
57
58 FUNCTION before_report
59 RETURN BOOLEAN;
60 FUNCTION a_real_tax_amount(p_payment_amt IN NUMBER
61 , p_tax_amount IN NUMBER
62 , p_cust_trx_id IN NUMBER)
63 RETURN NUMBER;
64 FUNCTION a_real_invoice_amount(p_payment_amt IN NUMBER
65 , p_invoice_amount IN NUMBER
66 , p_cust_trx_id IN NUMBER)
67 RETURN NUMBER;
68 FUNCTION a_total_invoices(p_cust_trx_id IN NUMBER)
69 RETURN NUMBER;
70
71 FUNCTION get_report_format
72 RETURN VARCHAR2;
73
74 FUNCTION get_location_name
75 RETURN VARCHAR2;
76
77 FUNCTION get_start_exempt_limit
78 RETURN NUMBER;
79
80 FUNCTION get_adjustment_exempt_limit
81 RETURN NUMBER;
82
83 FUNCTION get_old_debit_vat
84 RETURN NUMBER;
85
86 PROCEDURE jebeva06(p_vat_rep_entity_id IN NUMBER
87 ,p_period IN VARCHAR2
88 ,p_vat_box IN VARCHAR2
89 ,p_vat_trx_type_low IN VARCHAR2
90 ,p_vat_trx_type_high IN VARCHAR2
91 ,p_source IN VARCHAR2
92 ,p_doc_name IN VARCHAR2
93 ,p_doc_seq_value IN VARCHAR2
94 ,x_err_msg OUT NOCOPY VARCHAR2);
95
96 PROCEDURE jeptavat(p_vat_rep_entity_id IN NUMBER
97 ,p_period IN VARCHAR2
98 ,p_location IN VARCHAR2
99 ,x_err_msg OUT NOCOPY VARCHAR2);
100
101 PROCEDURE jeptpvat(p_vat_rep_entity_id IN NUMBER
102 ,p_period IN VARCHAR2
103 ,p_location IN VARCHAR2
104 ,x_err_msg OUT NOCOPY VARCHAR2);
105
106 PROCEDURE jeitpssr(p_vat_rep_entity_id IN NUMBER
107 ,p_period IN VARCHAR2
108 ,p_var_on_purchases IN NUMBER
109 ,p_var_on_sales IN NUMBER
110 ,x_err_msg OUT NOCOPY VARCHAR2);
111
112 FUNCTION JEITPSSR_AMOUNT_TO_PAY(A_TOT_TOT_TAX_AMT_SUM IN NUMBER,
113 B_TOT_TAX_AMT_SUM IN NUMBER,
114 D_TOT_TAX_AMT_SUM IN NUMBER,
115 D_VAT_REC_SUM IN NUMBER,
116 C_VAT_REC_SUM IN NUMBER,
117 C_VAT_NON_RECC_SUM IN NUMBER) RETURN NUMBER;
118 FUNCTION JEILR835_INV_NUM( p_str IN VARCHAR2) RETURN VARCHAR2;
119
120 FUNCTION JEITPSSR_AMOUNT_TO_PAY_UPDATE(AMOUNT_TO_PAY IN NUMBER) RETURN BOOLEAN;
121
122 END JG_ZZ_SUMMARY_ALL_PKG;