[Home] [Help]
224: -- Intercompany Payables cess amt
225:
226: cursor c_delivery_cur(cp_delivery_Detail_id number) is
227: select delivery_id , org_id
228: from JAI_OM_WSH_LINES_ALL
229: where delivery_detail_id = cp_delivery_Detail_id;
230:
231: cursor c_cess_amount(cp_delivery_id number) is
232: select sum(a.tax_amount)
232: select sum(a.tax_amount)
233: from JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
234: where delivery_detail_id in
235: (select delivery_detail_id
236: from JAI_OM_WSH_LINES_ALL
237: where delivery_id = cp_delivery_id
238: )
239: and a.tax_id = b.tax_id
240: and upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
245: select sum(a.tax_amount)
246: from JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
247: where delivery_detail_id in
248: (select delivery_detail_id
249: from JAI_OM_WSH_LINES_ALL
250: where delivery_id = cp_delivery_id
251: )
252: and a.tax_id = b.tax_id
253: and upper(b.tax_type) in (JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS);
274:
275:
276: v_precision fnd_currencies.precision%type;
277: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
278: v_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type;
279: v_cess_amount number;
280: v_sh_cess_amount number;/*Bug 5989740 bduvarag*/
281: v_cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;
282: v_org_id JAI_OM_WSH_LINES_ALL.org_id%type;
278: v_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type;
279: v_cess_amount number;
280: v_sh_cess_amount number;/*Bug 5989740 bduvarag*/
281: v_cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;
282: v_org_id JAI_OM_WSH_LINES_ALL.org_id%type;
283: ln_sh_Cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;/*Bug 5989740 bduvarag*/
284: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_entries';
285:
286: /*
633:
634: /********************************************************************************************************************** */
635:
636: /************************************START JA_IN_OM_CESS_REGISTER_ENTRIES***********************************************/
637: procedure ja_in_om_cess_register_entries(p_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
638: p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
639: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
640: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
641: p_register_type VARCHAR2 ,
639: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
640: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
641: p_register_type VARCHAR2 ,
642: p_cess_amount OUT NOCOPY NUMBER ,
643: p_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE DEFAULT NULL, -- added, Bug 4724137
644: p_cess_type VARCHAR2/*Bug 5989740 bduvarag*/
645: )
646: /**********************************************************************
647: CREATED BY : ssumaith
684: -- foll cursor added by ssumaith - bug# 5747126 - one off
685: CURSOR c_tax_type_for_delivery_rec IS
686: SELECT jtc.tax_type , round(sum(jsptl.func_tax_amount),0) tax_amount
687: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
688: JAI_OM_WSH_LINES_ALL jspl ,
689: JAI_CMN_TAXES_ALL jtc ,
690: JAI_INV_ITM_SETUPS jmsi /* Added by Ramananda for bug#5912620*/
691: WHERE jtc.tax_id = jsptl.tax_id
692: AND jspl.delivery_id = p_delivery_id
784: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
785: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
786: p_register_type VARCHAR2 ,
787: p_cess_amount OUT NOCOPY NUMBER ,
788: p_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE DEFAULT NULL, -- added for Bug 4724137
789: p_cess_type VARCHAR2/*Bug 5989740 bduvarag*/
790: )
791:
792: /**********************************************************************
894: **********************************************************************/
895: IS
896: cursor c_delivery_details is
897: select delivery_id , organization_id
898: from JAI_OM_WSH_LINES_ALL
899: where delivery_detail_id = p_transaction_hdr_id;
900:
901: cursor c_customer_trx_details is
902: select customer_trx_id
902: select customer_trx_id
903: from JAI_AR_TRX_LINES
904: where customer_trx_line_id = p_transaction_hdr_id;
905:
906: ln_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type;
907: ln_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%type;
908: ln_Cess_amount number;
909: ln_inv_orgn_id number;
910: ln_header_id number;
1195: WHERE organization_id = cp_organization_id
1196: AND location_id = cp_location_id;
1197:
1198:
1199: CURSOR c_delivery_cur (cp_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE) IS
1200: SELECT delivery_id
1201: FROM JAI_OM_WSH_LINES_ALL
1202: WHERE delivery_detail_id = cp_delivery_detail_id;
1203:
1197:
1198:
1199: CURSOR c_delivery_cur (cp_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE) IS
1200: SELECT delivery_id
1201: FROM JAI_OM_WSH_LINES_ALL
1202: WHERE delivery_detail_id = cp_delivery_detail_id;
1203:
1204: CURSOR c_cess_amount(cp_delivery_id number) is
1205: SELECT sum(a.tax_amount)
1205: SELECT sum(a.tax_amount)
1206: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
1207: WHERE delivery_detail_id in
1208: (SELECt delivery_detail_id
1209: FROM JAI_OM_WSH_LINES_ALL
1210: WHERE delivery_id = cp_delivery_id
1211: )
1212: AND a.tax_id = b.tax_id
1213: AND upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
1228: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1229: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1230: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1231: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
1232: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;
1233:
1234: BEGIN
1235:
1236: -- get the details of the delivery, the oreder header id
1767: v_to_other_fact_n_pay_ed_val NUMBER;
1768:
1769: CURSOR c_exc_exempt_dtls(p_delivery_detail_id IN NUMBER) IS
1770: SELECT excise_exempt_type
1771: FROM JAI_OM_WSH_LINES_ALL
1772: WHERE delivery_detail_id = p_delivery_detail_id;
1773: v_exc_exempt_dtls_rec c_exc_exempt_dtls%ROWTYPE;
1774: -- End, Vijay Shankar for Bug# 3408210
1775:
1871:
1872: 9. 09/02/2004 Vijay Shankar for Bug# 3408210, File Version: 618.1
1873: JA_IN_RG_I_ENTRY procedure:- CT3 Excise Exempted Issue transaction is hitting RG1 with Home Use fields, which is wrong and code is modified
1874: to hit To_other_factory_n_pay_ed_qty field with quantity. transactions is identified as CT3 by fetching data from
1875: JAI_OM_WSH_LINES_ALL through a cursor c_exc_exempt_dtls. Insert into JAI_CMN_RG_I_TRXS is modified to populate specified columns
1876: in case of CT3 transaction. following fields are added in the procedure
1877: v_to_other_fact_n_pay_ed_qty NUMBER;
1878: v_to_other_fact_n_pay_ed_val NUMBER;
1879: v_exc_exempt_dtls_rec c_exc_exempt_dtls%ROWTYPE;
1948: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
1949: as 'WSH' from jai_om_wsh.plb procedure Shipment.
1950: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
1951: For shipment and Ar receivable transaction currently the transaction_id is 33 and in some cases where the jai_cmn_rg_i_trxs.ref_doc_id
1952: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
1953: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
1954:
1955: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.
1956: This has been populated from this and jai_om_wsh_pkg.process_delivery procedure.
2836: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;
2837: v_rg_basic_balance NUMBER;
2838: v_rg_additional_balance NUMBER;
2839: v_rg_other_balance NUMBER;
2840: v_order_type_id JAI_OM_WSH_LINES_ALL.order_type_id%TYPE;
2841: --Variable declaration ends here.
2842:
2843: v_asst_register_id Number; -- variable added by sriram - bug # 3021588
2844:
2904:
2905: --Cursors Added by Nagaraj.s for ENH2415656..
2906: CURSOR c_order_type_id IS
2907: SELECT order_type_id
2908: FROM JAI_OM_WSH_LINES_ALL
2909: WHERE Organization_id=p_org_id AND
2910: location_id = p_location_id AND
2911: delivery_detail_id = p_header_id;
2912:
3556: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3557: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3558: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
3559: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;/*Bug 5989740 bduvarag*/
3560: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;
3561: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
3562: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
3563: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
3564: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
3963: where customer_trx_id = cp_order_header_id;
3964:
3965: cursor c_order_header_cur is
3966: select order_header_id
3967: from JAI_OM_WSH_LINES_ALL
3968: where delivery_id = p_header_id;
3969:
3970: cursor c_invoice_header_cur(cp_header_id number) is
3971: select customer_trx_id
3981: JAI_CMN_TAXES_ALL jtc
3982: where jtc.tax_id = jsptl.tax_id
3983: and delivery_detail_id in
3984: (select delivery_detail_id
3985: from JAI_OM_WSH_LINES_ALL
3986: where delivery_id = cp_delivery_id
3987: )
3988: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
3989: /*Bug 5989740 bduvarag*/
3993: JAI_CMN_TAXES_ALL jtc
3994: where jtc.tax_id = jsptl.tax_id
3995: and delivery_detail_id in
3996: (select delivery_detail_id
3997: from JAI_OM_WSH_LINES_ALL
3998: where delivery_id = cp_delivery_id
3999: )
4000: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess);
4001: