[Home] [Help]
PACKAGE: APPS.JG_ZZ_SUMMARY_ALL_PKG
Source
1 PACKAGE JG_ZZ_SUMMARY_ALL_PKG
2 -- $Header: jgzzsummaryalls.pls 120.13 2012/01/25 15:16:30 mbarrett 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 AUTHID CURRENT_USER 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 -- 25-Jun-2010 Aniz Buissa Jr ER 9155483 for Israeli
31 -- Ichud Oskim Number
32 -- +=======================================================================+
33 AS
34 P_TRN_NUM VARCHAR2(100);
35 P_VAT_REP_ENTITY_ID NUMBER;
36 -- ER 9155483 (Ichud Oskim) - Start
37 P_VAT_REP_ENTITY_ID2 NUMBER;
38 P_VAT_REP_ENTITY_ID3 NUMBER;
39 P_VAT_REP_ENTITY_ID4 NUMBER;
40 P_VAT_REP_ENTITY_ID5 NUMBER;
41 P_VAT_REP_ENTITY_ID6 NUMBER;
42 P_VAT_REP_ENTITY_ID7 NUMBER;
43 P_VAT_REP_ENTITY_ID8 NUMBER;
44 P_VAT_REP_ENTITY_ID9 NUMBER;
45 P_VAT_REP_ENTITY_ID10 NUMBER;
46 P_ICHUD_OSKIM_NUM NUMBER;
47 -- ER 9155483 (Ichud Oskim) - End
48 P_VAR_ON_PURCHASES NUMBER;
49 P_VAR_ON_SALES NUMBER;
50 P_PERIOD VARCHAR2(100);
51 P_VAT_BOX VARCHAR2(100);
52 P_VAT_TRX_TYPE_LOW VARCHAR2(100);
53 P_VAT_TRX_TYPE_HIGH VARCHAR2(100);
54 P_VAT_TRX_TYPE VARCHAR2(100);
55 P_REPORT_FORMAT VARCHAR2(1);
56 P_SOURCE VARCHAR2(10);
57 P_DOC_NAME VARCHAR2(100);
58 P_DOC_SEQ_VALUE VARCHAR2(100);
59 P_REPORT_NAME VARCHAR2(20);
60 P_LOCATION VARCHAR2(100);
61 L_ERR_MSG VARCHAR2(5000);
62 P_FUNC_CURR VARCHAR2(10);
63 P_LEGAL_ENTITY_NAME VARCHAR2(240);
64 P_BOX_FROM VARCHAR2(10);
65 P_BOX_TO VARCHAR2(10);
66 P_LEGAL_ENTITY_ID NUMBER;
67 P_DEBUG_FLAG VARCHAR2(1) := 'Y';
68 P_DETAIL_SUMMARY VARCHAR2(30);
69 P_OPERATION_CODE VARCHAR2(4);
70 P_FIRST_PAGE_NUM NUMBER;
71 TEMP_FLAG NUMBER := 0; --Flag variable for function JEITPSSR_AMOUNT_TO_PAY
72 -- IL VAT Reporting 2010 - ER
73 l_vat_rep_status_id NUMBER;
74 l_vat_aggregation_limit_amt NUMBER;
75 g_precision NUMBER;
76 l_ledger_id NUMBER;
77
78
79 FUNCTION before_report
80 RETURN BOOLEAN;
81 FUNCTION a_real_tax_amount(p_payment_amt IN NUMBER
82 , p_tax_amount IN NUMBER
83 , p_cust_trx_id IN NUMBER)
84 RETURN NUMBER;
85 FUNCTION a_real_invoice_amount(p_payment_amt IN NUMBER
86 , p_invoice_amount IN NUMBER
87 , p_cust_trx_id IN NUMBER)
88 RETURN NUMBER;
89 FUNCTION a_total_invoices(p_cust_trx_id IN NUMBER)
90 RETURN NUMBER;
91
92 FUNCTION get_report_format
93 RETURN VARCHAR2;
94
95 FUNCTION get_location_name
96 RETURN VARCHAR2;
97
98 FUNCTION get_start_exempt_limit
99 RETURN NUMBER;
100
101 FUNCTION get_adjustment_exempt_limit
102 RETURN NUMBER;
103
104 FUNCTION get_old_debit_vat
105 RETURN NUMBER;
106
107 PROCEDURE jebeva06(p_vat_rep_entity_id IN NUMBER
108 ,p_period IN VARCHAR2
109 ,p_vat_box IN VARCHAR2
110 ,p_vat_trx_type_low IN VARCHAR2
111 ,p_vat_trx_type_high IN VARCHAR2
112 ,p_source IN VARCHAR2
113 ,p_doc_name IN VARCHAR2
114 ,p_doc_seq_value IN VARCHAR2
115 ,x_err_msg OUT NOCOPY VARCHAR2);
116
117 PROCEDURE jeptavat(p_vat_rep_entity_id IN NUMBER
118 ,p_period IN VARCHAR2
119 ,p_location IN VARCHAR2
120 ,x_err_msg OUT NOCOPY VARCHAR2);
121
122 PROCEDURE jeptpvat(p_vat_rep_entity_id IN NUMBER
123 ,p_period IN VARCHAR2
124 ,p_location IN VARCHAR2
125 ,x_err_msg OUT NOCOPY VARCHAR2);
126
127 PROCEDURE jeitpssr(p_vat_rep_entity_id IN NUMBER
128 ,p_period IN VARCHAR2
129 ,p_var_on_purchases IN NUMBER
130 ,p_var_on_sales IN NUMBER
131 ,x_err_msg OUT NOCOPY VARCHAR2);
132
133 -- ER 9155483
134 PROCEDURE jeilr835(p_vat_rep_entity_id IN NUMBER
135 ,p_vat_rep_entity_id2 IN NUMBER
136 ,p_vat_rep_entity_id3 IN NUMBER
137 ,p_vat_rep_entity_id4 IN NUMBER
138 ,p_vat_rep_entity_id5 IN NUMBER
139 ,p_vat_rep_entity_id6 IN NUMBER
140 ,p_vat_rep_entity_id7 IN NUMBER
141 ,p_vat_rep_entity_id8 IN NUMBER
142 ,p_vat_rep_entity_id9 IN NUMBER
143 ,p_vat_rep_entity_id10 IN NUMBER
144 ,p_ichud_oskim_num IN NUMBER
145 ,p_period IN VARCHAR2
146 ,p_vat_trx_type IN VARCHAR2
147 ,p_report_name IN VARCHAR2
148 ,p_operation_code IN VARCHAR2
149 ,x_err_msg OUT NOCOPY VARCHAR2);
150
151 FUNCTION JEITPSSR_AMOUNT_TO_PAY(A_TOT_TOT_TAX_AMT_SUM IN NUMBER,
152 B_TOT_TAX_AMT_SUM IN NUMBER,
153 D_TOT_TAX_AMT_SUM IN NUMBER,
154 D_VAT_REC_SUM IN NUMBER,
155 C_VAT_REC_SUM IN NUMBER,
156 C_VAT_NON_RECC_SUM IN NUMBER) RETURN NUMBER;
157 FUNCTION JEILR835_INV_NUM( p_str IN VARCHAR2) RETURN VARCHAR2;
158
159 FUNCTION JEITPSSR_AMOUNT_TO_PAY_UPDATE(AMOUNT_TO_PAY IN NUMBER) RETURN BOOLEAN;
160
161 END JG_ZZ_SUMMARY_ALL_PKG;