[Home] [Help]
126: 29 17/06/2007 ssumaith - bug# 6131804 - bond register is not gettnig hit in INR for foreign currency trxs.
127: Code changes are done in this package for handling the cess amount.
128:
129: 30. 28/06/2007 CSahoo - BUG#6155839, File Version 120.16
130: replaced RG Register Data Entry by jai_constants.je_category_rg_entry
131: 31. 02/07/2007 vkaranam - BUG#6159579, File Version 120.17
132: 1.In Procedure ja_in_cess_entries while calling ja_in_om_cess_register_entries p_delivery_detail_id parameter is not passed.
133:
134: 32. 05/07/2007 kunkumar for Bug#5745729 file version 120.18
275: from JAI_OM_WSH_LINES_ALL
276: where delivery_id = cp_delivery_id
277: )
278: and a.tax_id = b.tax_id
279: and upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
280:
281:
282: /*Bug 5989740 bduvarag start*/
283: cursor c_sh_cess_amount(cp_delivery_id number) is
288: from JAI_OM_WSH_LINES_ALL
289: where delivery_id = cp_delivery_id
290: )
291: and a.tax_id = b.tax_id
292: and upper(b.tax_type) in (JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS);
293:
294: /*Bug 5989740 bduvarag end*/
295: cursor c_fetch_cess_account(cp_organization_id number , cp_location_id number) is
296: select cess_paid_payable_account_id
700: JAI_CMN_TAXES_ALL jtc
701: WHERE jtc.tax_id = jsptl.tax_id
702: --Modified for bug5747126
703: AND delivery_detail_id = p_delivery_detail_id
704: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC') --Date 12/03/2007 by SACSETHI for bug#5907436
705: OR
706: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )
707: GROUP BY jtc.tax_type
708: HAVING SUM(jsptl.func_tax_amount) <> 0;
702: --Modified for bug5747126
703: AND delivery_detail_id = p_delivery_detail_id
704: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC') --Date 12/03/2007 by SACSETHI for bug#5907436
705: OR
706: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )
707: GROUP BY jtc.tax_type
708: HAVING SUM(jsptl.func_tax_amount) <> 0;
709: -- added, Harshita for Bug 4714518
710: /*AND
730: JAI_INV_ITM_SETUPS jmsi /* Added by Ramananda for bug#5912620*/
731: WHERE jtc.tax_id = jsptl.tax_id
732: AND jspl.delivery_id = p_delivery_id
733: AND jspl.delivery_detail_id = jsptl.delivery_detail_id
734: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC') --Date 12/03/2007 by SACSETHI for bug#5907436
735: OR
736: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )
737: /* Added for bug#5912620, Starts */
738: AND jmsi.inventory_item_id = jspl.inventory_item_id
732: AND jspl.delivery_id = p_delivery_id
733: AND jspl.delivery_detail_id = jsptl.delivery_detail_id
734: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC') --Date 12/03/2007 by SACSETHI for bug#5907436
735: OR
736: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )
737: /* Added for bug#5912620, Starts */
738: AND jmsi.inventory_item_id = jspl.inventory_item_id
739: AND jmsi.organization_id = jspl.organization_id
740: AND jmsi.excise_flag = 'Y'
770: );
771:
772: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
773: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
774: IF lv_process_flag <> jai_constants.successful THEN
775: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
776: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);
777: END IF;
778:
804: );
805:
806: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
807: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
808: IF lv_process_flag <> jai_constants.successful THEN
809: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
810: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);
811: END IF;
812:
869: FROM JAI_AR_TRX_TAX_LINES jrctl ,
870: JAI_CMN_TAXES_ALL jtc
871: WHERE jtc.tax_id = jrctl.tax_id
872: AND link_to_cust_trx_line_id = p_customer_trx_id -- added, aiyer for Bug 4541303 /*Bug 5989740 bduvarag*/
873: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC')
874: OR
875: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )
876:
877:
871: WHERE jtc.tax_id = jrctl.tax_id
872: AND link_to_cust_trx_line_id = p_customer_trx_id -- added, aiyer for Bug 4541303 /*Bug 5989740 bduvarag*/
873: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC')
874: OR
875: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )
876:
877:
878: GROUP BY jtc.tax_type
879: HAVING SUM(jrctl.func_tax_amount) <> 0;
1023: p_cess_type => p_cess_type /*Bug 5989740 bduvarag*/
1024: );
1025:
1026:
1027: elsif p_je_source_name = 'Receivables India' and p_je_category_name = jai_constants.je_category_rg_entry then --replaced RG Register Data Entry, csahoo for bug#6155839
1028: /*
1029: Do all things needed to populate records into the register table , picking up taxes from the ja_in_customer_trx_tax_lines table
1030: */
1031: ln_header_id := ln_customer_trx_id;
1255: FROM JAI_OM_WSH_LINES_ALL
1256: WHERE delivery_id = cp_delivery_id
1257: )
1258: AND a.tax_id = b.tax_id
1259: AND upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
1260:
1261:
1262:
1263: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;
3825: SELECT sum(a.tax_amount)
3826: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
3827: WHERE delivery_detail_id = p_reference_line_id
3828: AND a.tax_id = b.tax_id
3829: AND upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
3830: /*Bug 5989740 bduvarag*/
3831: CURSOR c_sh_cess_amount IS
3832: SELECT sum(a.tax_amount)
3833: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
3832: SELECT sum(a.tax_amount)
3833: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
3834: WHERE delivery_detail_id = p_reference_line_id
3835: AND a.tax_id = b.tax_id
3836: AND upper(b.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess);
3837:
3838:
3839:
3840: /*
4376: (select delivery_detail_id
4377: from JAI_OM_WSH_LINES_ALL
4378: where delivery_id = cp_delivery_id
4379: )
4380: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
4381: /*Bug 5989740 bduvarag*/
4382: cursor c_get_om_sh_cess_amount(cp_delivery_id number) is
4383: select NVL(sum(jsptl.func_tax_amount),0) tax_amount
4384: from JAI_OM_WSH_LINE_TAXES jsptl ,
4388: (select delivery_detail_id
4389: from JAI_OM_WSH_LINES_ALL
4390: where delivery_id = cp_delivery_id
4391: )
4392: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess);
4393:
4394:
4395: cursor c_get_ar_cess_amount(cp_customer_trx_id number) is
4396: select nvl(sum(jrctl.func_tax_amount),0) tax_amount
4401: (select customer_trx_line_id
4402: from JAI_AR_TRX_LINES
4403: where customer_trx_id = cp_customer_trx_id
4404: )
4405: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS) ;
4406: /*Bug 5989740 bduvarag*/
4407: cursor c_get_ar_sh_cess_amount(cp_customer_trx_id number) is
4408: select nvl(sum(jrctl.func_tax_amount),0) tax_amount
4409: from JAI_AR_TRX_TAX_LINES jrctl ,
4413: (select customer_trx_line_id
4414: from JAI_AR_TRX_LINES
4415: where customer_trx_id = cp_customer_trx_id
4416: )
4417: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;
4418:
4419: cursor c_ar_cess_ctr(cp_customer_trx_id number) is
4420: select count(1)
4421: from JAI_AR_TRX_TAX_LINES jrctl ,
4425: (select customer_trx_line_id
4426: from JAI_AR_TRX_LINES
4427: where customer_trx_id = cp_customer_trx_id
4428: )
4429: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS) ;
4430: /*Bug 5989740 bduvarag*/
4431: cursor c_ar_sh_cess_ctr(cp_customer_trx_id number) is
4432: select count(1)
4433: from JAI_AR_TRX_TAX_LINES jrctl ,
4437: (select customer_trx_line_id
4438: from JAI_AR_TRX_LINES
4439: where customer_trx_id = cp_customer_trx_id
4440: )
4441: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;
4442:
4443: -- added by nkodakan for the bug 16014871 starts
4444:
4445: Cursor get_ref_header_line_id(cp_line_id number)
4574: from JAI_AR_TRX_TAX_LINES jrctl ,
4575: JAI_CMN_TAXES_ALL jtc
4576: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4577: and jtc.tax_id = jrctl.tax_id
4578: and jtc.tax_type in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS)
4579: )
4580: Loop
4581: for cess_amt_rec in
4582: (
4639: from JAI_AR_TRX_TAX_LINES jrctl ,
4640: JAI_CMN_TAXES_ALL jtc
4641: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4642: and jtc.tax_id = jrctl.tax_id
4643: and jtc.tax_type in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess)
4644: )
4645: Loop
4646: for cess_amt_rec in
4647: (