[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.12.12020000.2 2012/12/11 06:40:24 qioliu 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 ***************************************************************************************************/
30 procedure get_balances(p_request_id Number ,
31 p_balance_date date ,
32 p_called_from varchar2 ,
33 p_regime_id Number Default NULL ,
34 p_regn_no varchar2 default NULL ,
35 p_regn_id number default NULL ,
36 p_org_id number default NULL ,
37 p_org_type varchar2 default NULL ,
38 p_settlement_id number default NULL ,
39 P_ITEM_CLASSIFICATION VARCHAR2 DEFAULT NULL ,-- Added by sacsethi for bug 5631784 on 30-01-2007
40 p_transfer_type VARCHAR2 default NULL ,/*Bug 5879769 bduvarag*/
41 p_service_type_code VARCHAR2 default NULL ,/*Bug 5879769 bduvarag*/
42 p_location_id NUMBER DEFAULT NULL /*added by ssawant for bug 5662296*/
43 ,p_reverse_charge_flag VARCHAR2 DEFAULT NULL --Added by Qiong for reverse charge settlement
44 );
45
46 procedure insert_records_into_register(
47 p_repository_id OUT NOCOPY NUMBER ,
48 p_regime_id NUMBER ,
49 p_from_party_type VARCHAR2 ,
50 p_from_party_id NUMBER ,
51 p_from_locn_id NUMBER ,
52 p_from_tax_type VARCHAR2 ,
53 p_from_trx_amount NUMBER ,
54 p_to_party_type VARCHAR2 ,
55 p_to_party_id NUMBER ,
56 p_to_tax_type VARCHAR2 ,
57 p_to_trx_amount IN OUT NOCOPY NUMBER ,
58 p_to_locn_id NUMBER ,
59 p_called_from VARCHAR2 ,
60 p_trx_date DATE ,
61 p_acct_req VARCHAR2 ,
62 p_source VARCHAR2 ,
63 P_SOURCE_TRX_TYPE VARCHAR2 ,
64 P_SOURCE_TABLE_NAME VARCHAR2 ,
65 p_source_doc_id NUMBER ,
66 p_settlement_id NUMBER ,
67 p_reference_id NUMBER ,
68 p_process_flag OUT NOCOPY VARCHAR2 ,
69 p_process_message OUT NOCOPY VARCHAR2 ,
70 p_accounting_date Date ,
71 p_from_service_type VARCHAR2 default null, -- bduvarag for Bug 5694855
72 p_to_service_type VARCHAR2 default null -- bduvarag for Bug 5694855
73
74 );
75
76 procedure delete_records(p_request_id number);
77 g_start_date constant date := to_date('01/03/2004','dd/mm/yyyy'); /* This variable is used to store the start date*/
78 ln_rounding_precision constant number := 4;
79 -- added, Harshita for Bug 5096787
80
81 PROCEDURE insert_records_into_temp(
82 p_request_id NUMBER ,
83 p_regime_id NUMBER ,
84 p_party_type VARCHAR2 ,
85 p_party_id NUMBER ,
86 p_location_id NUMBER ,
87 p_bal_date DATE ,
88 p_tax_type VARCHAR2 ,
89 p_debit_amt NUMBER ,
90 p_credit_amt NUMBER ,
91 p_pla_balance NUMBER default null,
92 p_service_type_code VARCHAR2 DEFAULT NULL -- Bug6835541 Added by Lakshmi Gopalsami
93 ,/**added p_credit_utilized for bug#11821537 by vkaranam,budget 2011 phase2*/
94 p_credit_utilized NUMBER default null
95 ,p_reverse_charge_flag VARCHAR2 DEFAULT NULL --Added by Qiong for reverse charge settlement
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
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*/
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 ,p_reverse_charge_flag VARCHAR2 default NULL--Added by Qiong for reverse charege settlement
116 ) ;
117
118
119 PROCEDURE calculate_balances_for_ou
120 (p_regime_id number ,
121 p_balance_date date ,
122 p_request_id number ,
123 p_org_id number ,
124 p_org_type varchar2 ,
125 p_regn_id number ,
126 p_regn_no varchar2 ,
127 p_settlement_id number ,
128 p_called_from varchar2 ,
129 p_location_id NUMBER DEFAULT NULL, -- Bug6835541 Added by Lakshmi Gopalsami
130 p_service_type_code VARCHAR2 DEFAULT NULL -- Bug6835541 Added by Lakshmi Gopalsami
131 ,p_reverse_charge_flag VARCHAR2 DEFAULT NULL --Added by Qiong for reverse charge settlement
132 ) ;
133
134 PROCEDURE create_io_register_entry (
135 p_register_type IN JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ,
136 p_tax_type IN VARCHAR2 ,
137 p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE ,
138 p_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE ,
139 p_cr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE ,
140 p_cr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE ,
141 p_cr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE ,
142 p_dr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE ,
143 p_dr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE ,
144 p_dr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE ,
145 p_excise_invoice_no IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE ,
146 p_remarks IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE ,
147 p_vendor_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE ,
148 p_vendor_site_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE ,
149 p_transaction_date IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE ,
150 p_charge_account_id IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE ,
151 p_other_tax_credit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE ,
152 p_other_tax_debit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE ,
153 p_transaction_type IN VARCHAR2 ,
154 p_transaction_source IN VARCHAR2 ,
155 p_called_from IN VARCHAR2 ,
156 p_simulate_flag IN VARCHAR2 ,
157 p_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
158 p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
159 p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194
160 p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
161 p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,
162 p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,
163 p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,
164 p_excise_invoice_date IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE Default NULL ,
165 p_customer_id IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE Default NULL ,
166 p_customer_site_id IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE Default NULL ,
167 p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,
168 p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,
169 p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
170 p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
171 p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
172 p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
173 p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
174 p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
175 p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,
176 p_vendor_cust_flag IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE Default NULL ,
177 p_process_flag OUT NOCOPY VARCHAR2 ,
178 p_process_message OUT NOCOPY VARCHAR2
179 ) ;
180
181 FUNCTION f_get_io_register ( p_party_id JAI_RGM_BALANCE_T.PARTY_ID%TYPE ,
182 p_from_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE ,
183 p_to_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE
184 )
185 RETURN VARCHAR2 ;
186 -- ended, Harshita for Bug 5096787
187 end jai_cmn_rgm_tax_dist_pkg;