[Home] [Help]
PACKAGE: APPS.JAI_CMN_RGM_TAX_DIST_PKG
Source
1 package jai_cmn_rgm_tax_dist_pkg AS
2 /* $Header: jai_cmn_rgm_dist.pls 120.10.12010000.2 2008/10/17 09:49:00 jmeena ship $ */
3 /***************************************************************************************************
4 CREATED BY : ssumaith
5 CREATED DATE : 11-JAN-2005
6 ENHANCEMENT BUG : 4068911
7 PURPOSE : To get the balances , to insert records into repository
8 CALLED FROM : JAI_RGM_SETTLEMENT_PKG , JAIRGMDT.fmb , JAIRGMDT.fmb
9 CHANGE HISTORY
10 1. 01-NOV-2006 SACSETHI FOR BUG#5631784. FILE VERSION 120.5
11
12 FORWARD PORTING BUG FROM 11I BUG 4742259
13 NEW ENH: TAX COLLECTION AT SOURCE IN RECEIVABLES
14 Changes -
15
16 Object Type Object Name Change Description
17 ----------------------------------------------------------------+
18 Procedure Get_balances Column Added Column P_ITEM_CLASSIFICATION is added
19 23/04/2007 bduvarag for the Bug#5879769, file version 120.6
20 Forward porting the changes done in 11i bug#5694855
21
22 7-June-2007 ssawant for bug 5662296
23 Forward porting R11 bug 5642053 to R12 bug 5662296.
24
25 22-jun2007 kunkumar made changes for 6127194 file version 120.9
26 Added two sh_cess parameters to create_io_register_entry
27 24-Jul-2007 CSahoo for bug#6268513, File Version 120.2.12000000.3
28 Corrected the GSCC error.
29 14-OCT-2008 JMEENA for bug#7445742
30 Incorporate the changes of bug#6835541
31 ***************************************************************************************************/
32 procedure get_balances(p_request_id Number ,
33 p_balance_date date ,
34 p_called_from varchar2 ,
35 p_regime_id Number Default NULL ,
36 p_regn_no varchar2 default NULL ,
37 p_regn_id number default NULL ,
38 p_org_id number default NULL ,
39 p_org_type varchar2 default NULL ,
40 p_settlement_id number default NULL ,
41 P_ITEM_CLASSIFICATION VARCHAR2 DEFAULT NULL ,-- Added by sacsethi for bug 5631784 on 30-01-2007
42 p_transfer_type VARCHAR2 default NULL ,/*Bug 5879769 bduvarag*/
43 p_service_type_code VARCHAR2 default NULL ,/*Bug 5879769 bduvarag*/
44 p_location_id NUMBER DEFAULT NULL /*added by ssawant for bug 5662296*/
45 );
46
47 procedure insert_records_into_register(
48 p_repository_id OUT NOCOPY NUMBER ,
49 p_regime_id NUMBER ,
50 p_from_party_type VARCHAR2 ,
51 p_from_party_id NUMBER ,
52 p_from_locn_id NUMBER ,
53 p_from_tax_type VARCHAR2 ,
54 p_from_trx_amount NUMBER ,
55 p_to_party_type VARCHAR2 ,
56 p_to_party_id NUMBER ,
57 p_to_tax_type VARCHAR2 ,
58 p_to_trx_amount IN OUT NOCOPY NUMBER ,
59 p_to_locn_id NUMBER ,
60 p_called_from VARCHAR2 ,
61 p_trx_date DATE ,
62 p_acct_req VARCHAR2 ,
63 p_source VARCHAR2 ,
64 P_SOURCE_TRX_TYPE VARCHAR2 ,
65 P_SOURCE_TABLE_NAME VARCHAR2 ,
66 p_source_doc_id NUMBER ,
67 p_settlement_id NUMBER ,
68 p_reference_id NUMBER ,
69 p_process_flag OUT NOCOPY VARCHAR2 ,
70 p_process_message OUT NOCOPY VARCHAR2 ,
71 p_accounting_date Date ,
72 p_from_service_type VARCHAR2 default null, -- bduvarag for Bug 5694855
73 p_to_service_type VARCHAR2 default null -- bduvarag for Bug 5694855
74
75 );
76
77 procedure delete_records(p_request_id number);
78 g_start_date constant date := to_date('01/03/2004','dd/mm/yyyy'); /* This variable is used to store the start date*/
79 ln_rounding_precision constant number := 4;
80 -- added, Harshita for Bug 5096787
81 /* Can be removed..
82 Added the changes of bug#6835541 by JMEENA for bug#7445742
83 Removed the comment as it is removed in the mainline version 120.11 for bug#6835541 */
84 PROCEDURE insert_records_into_temp(
85 p_request_id NUMBER ,
86 p_regime_id NUMBER ,
87 p_party_type VARCHAR2 ,
88 p_party_id NUMBER ,
89 p_location_id NUMBER ,
90 p_bal_date DATE ,
91 p_tax_type VARCHAR2 ,
92 p_debit_amt NUMBER ,
93 p_credit_amt NUMBER ,
94 p_pla_balance NUMBER default null,
95 p_service_type_code VARCHAR2 DEFAULT NULL -- Bug6835541 Added by Lakshmi Gopalsami (JMEENA bug#7445742)
96 ) ;
97
98 PROCEDURE calculate_balances_for_io
99 (p_regime_id number ,
100 p_balance_date date ,
101 p_request_id number,
102 p_service_type_code VARCHAR2 DEFAULT NULL -- Bug6835541 Added by Lakshmi Gopalsami (JMEENA bug#7445742)
103 ) ;
104
105 PROCEDURE punch_settlement_id
106 ( p_regime_id number ,
107 p_settlement_id number ,
108 p_regn_id number ,
109 p_balance_date date ,
110 p_tan_no VARCHAR2 DEFAULT NULL, /*6835541*/ --(JMEENA bug#7445742)
111 p_org_id NUMBER default NULL, /*6835541*/
112 p_location_id NUMBER default NULL, /*6835541*/
113 p_item_classification VARCHAR2 DEFAULT NULL, /*6835541*/
114 p_regn_no VARCHAR2 default NULL /*6835541*/
115 ) ;
116
117
118 PROCEDURE calculate_balances_for_ou
119 (p_regime_id number ,
120 p_balance_date date ,
121 p_request_id number ,
122 p_org_id number ,
123 p_org_type varchar2 ,
124 p_regn_id number ,
125 p_regn_no varchar2 ,
126 p_settlement_id number ,
127 p_called_from varchar2 ,
128 p_location_id NUMBER DEFAULT NULL, -- Bug6835541 Added by Lakshmi Gopalsami (JMEENA bug#7445742)
129 p_service_type_code VARCHAR2 DEFAULT NULL -- Bug6835541 Added by Lakshmi Gopalsami (JMEENA bug#7445742)
130 ) ;
131 /*check and remove the above
132 */
133 PROCEDURE create_io_register_entry (
134 p_register_type IN JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ,
135 p_tax_type IN VARCHAR2 ,
136 p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE ,
137 p_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE ,
138 p_cr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE ,
139 p_cr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE ,
140 p_cr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE ,
141 p_dr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE ,
142 p_dr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE ,
143 p_dr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE ,
144 p_excise_invoice_no IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE ,
145 p_remarks IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE ,
146 p_vendor_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE ,
147 p_vendor_site_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE ,
148 p_transaction_date IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE ,
149 p_charge_account_id IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE ,
150 p_other_tax_credit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE ,
151 p_other_tax_debit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE ,
152 p_transaction_type IN VARCHAR2 ,
153 p_transaction_source IN VARCHAR2 ,
154 p_called_from IN VARCHAR2 ,
155 p_simulate_flag IN VARCHAR2 ,
156 p_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
157 p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
158 p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194
159 p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
160 p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,
161 p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,
162 p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,
163 p_excise_invoice_date IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE Default NULL ,
164 p_customer_id IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE Default NULL ,
165 p_customer_site_id IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE Default NULL ,
166 p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,
167 p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,
168 p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
169 p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
170 p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
171 p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
172 p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
173 p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
174 p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,
175 p_vendor_cust_flag IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE Default NULL ,
176 p_process_flag OUT NOCOPY VARCHAR2 ,
177 p_process_message OUT NOCOPY VARCHAR2
178 ) ;
179
180 FUNCTION f_get_io_register ( p_party_id JAI_RGM_BALANCE_T.PARTY_ID%TYPE ,
181 p_from_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE ,
182 p_to_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE
183 )
184 RETURN VARCHAR2 ;
185 -- ended, Harshita for Bug 5096787
186 end jai_cmn_rgm_tax_dist_pkg;