[Home] [Help]
263: -- Intercompany Payables cess amt
264:
265: cursor c_delivery_cur(cp_delivery_Detail_id number) is
266: select delivery_id , org_id
267: from JAI_OM_WSH_LINES_ALL
268: where delivery_detail_id = cp_delivery_Detail_id;
269:
270: cursor c_cess_amount(cp_delivery_id number) is
271: select sum(a.tax_amount)
271: select sum(a.tax_amount)
272: from JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
273: where delivery_detail_id in
274: (select delivery_detail_id
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);
284: select sum(a.tax_amount)
285: from JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
286: where delivery_detail_id in
287: (select delivery_detail_id
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);
313:
314:
315: v_precision fnd_currencies.precision%type;
316: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
317: v_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type;
318: v_cess_amount number;
319: v_sh_cess_amount number;/*Bug 5989740 bduvarag*/
320: v_cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;
321: v_org_id JAI_OM_WSH_LINES_ALL.org_id%type;
317: v_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type;
318: v_cess_amount number;
319: v_sh_cess_amount number;/*Bug 5989740 bduvarag*/
320: v_cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;
321: v_org_id JAI_OM_WSH_LINES_ALL.org_id%type;
322: ln_sh_Cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;/*Bug 5989740 bduvarag*/
323: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_entries';
324:
325: /*
673:
674: /********************************************************************************************************************** */
675:
676: /************************************START JA_IN_OM_CESS_REGISTER_ENTRIES***********************************************/
677: procedure ja_in_om_cess_register_entries(p_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
678: p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
679: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
680: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
681: p_register_type VARCHAR2 ,
679: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
680: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
681: p_register_type VARCHAR2 ,
682: p_cess_amount OUT NOCOPY NUMBER ,
683: p_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE DEFAULT NULL, -- added, Bug 4724137
684: p_cess_type VARCHAR2/*Bug 5989740 bduvarag*/
685: )
686: /**********************************************************************
687: CREATED BY : ssumaith
724: -- foll cursor added by ssumaith - bug# 5747126 - one off
725: CURSOR c_tax_type_for_delivery_rec IS
726: SELECT jtc.tax_type , sum(jsptl.func_tax_amount) tax_amount /*Removed rounding factor by mmurtuza for bug 16534065*/
727: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
728: JAI_OM_WSH_LINES_ALL jspl ,
729: JAI_CMN_TAXES_ALL jtc ,
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
824: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
825: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
826: p_register_type VARCHAR2 ,
827: p_cess_amount OUT NOCOPY NUMBER ,
828: p_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE DEFAULT NULL, -- added for Bug 4724137
829: p_cess_type VARCHAR2/*Bug 5989740 bduvarag*/
830: )
831:
832: /**********************************************************************
940: **********************************************************************/
941: IS
942: cursor c_delivery_details is
943: select delivery_id , organization_id
944: from JAI_OM_WSH_LINES_ALL
945: where delivery_detail_id = p_transaction_hdr_id;
946:
947: cursor c_customer_trx_details is
948: select customer_trx_id
948: select customer_trx_id
949: from JAI_AR_TRX_LINES
950: where customer_trx_line_id = p_transaction_hdr_id;
951:
952: ln_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type;
953: ln_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%type;
954: ln_Cess_amount number;
955: ln_inv_orgn_id number;
956: ln_header_id number;
1241: WHERE organization_id = cp_organization_id
1242: AND location_id = cp_location_id;
1243:
1244:
1245: CURSOR c_delivery_cur (cp_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE) IS
1246: SELECT delivery_id
1247: FROM JAI_OM_WSH_LINES_ALL
1248: WHERE delivery_detail_id = cp_delivery_detail_id;
1249:
1243:
1244:
1245: CURSOR c_delivery_cur (cp_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE) IS
1246: SELECT delivery_id
1247: FROM JAI_OM_WSH_LINES_ALL
1248: WHERE delivery_detail_id = cp_delivery_detail_id;
1249:
1250: CURSOR c_cess_amount(cp_delivery_id number) is
1251: SELECT sum(a.tax_amount)
1251: SELECT sum(a.tax_amount)
1252: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
1253: WHERE delivery_detail_id in
1254: (SELECt delivery_detail_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);
1274: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1275: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1276: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1277: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
1278: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;
1279:
1280: BEGIN
1281:
1282: -- get the details of the delivery, the oreder header id
1848: and temp.delivery_detail_id = p_delivery_detail_id;
1849:
1850: CURSOR c_exc_exempt_dtls(p_delivery_detail_id IN NUMBER) IS
1851: SELECT excise_exempt_type
1852: FROM JAI_OM_WSH_LINES_ALL
1853: WHERE delivery_detail_id = p_delivery_detail_id;
1854: v_exc_exempt_dtls_rec c_exc_exempt_dtls%ROWTYPE;
1855: -- End, Vijay Shankar for Bug# 3408210
1856:
1964:
1965: 9. 09/02/2004 Vijay Shankar for Bug# 3408210, File Version: 618.1
1966: 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
1967: to hit To_other_factory_n_pay_ed_qty field with quantity. transactions is identified as CT3 by fetching data from
1968: 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
1969: in case of CT3 transaction. following fields are added in the procedure
1970: v_to_other_fact_n_pay_ed_qty NUMBER;
1971: v_to_other_fact_n_pay_ed_val NUMBER;
1972: v_exc_exempt_dtls_rec c_exc_exempt_dtls%ROWTYPE;
2041: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
2042: as 'WSH' from jai_om_wsh.plb procedure Shipment.
2043: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
2044: 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
2045: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
2046: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
2047:
2048: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.
2049: This has been populated from this and jai_om_wsh_pkg.process_delivery procedure.
3068: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;
3069: v_rg_basic_balance NUMBER;
3070: v_rg_additional_balance NUMBER;
3071: v_rg_other_balance NUMBER;
3072: v_order_type_id JAI_OM_WSH_LINES_ALL.order_type_id%TYPE;
3073: --Variable declaration ends here.
3074:
3075: v_asst_register_id Number; -- variable added by sriram - bug # 3021588
3076:
3136:
3137: --Cursors Added by Nagaraj.s for ENH2415656..
3138: CURSOR c_order_type_id IS
3139: SELECT order_type_id
3140: FROM JAI_OM_WSH_LINES_ALL
3141: WHERE Organization_id=p_org_id AND
3142: location_id = p_location_id AND
3143: delivery_detail_id = p_header_id;
3144:
3855: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3856: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3857: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
3858: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;/*Bug 5989740 bduvarag*/
3859: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;
3860: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
3861: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
3862: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
3863: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
4355: where customer_trx_id = cp_order_header_id;
4356:
4357: cursor c_order_header_cur is
4358: select order_header_id
4359: from JAI_OM_WSH_LINES_ALL
4360: where delivery_id = p_header_id;
4361:
4362: cursor c_invoice_header_cur(cp_header_id number) is
4363: select customer_trx_id
4373: JAI_CMN_TAXES_ALL jtc
4374: where jtc.tax_id = jsptl.tax_id
4375: and delivery_detail_id in
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*/
4385: JAI_CMN_TAXES_ALL jtc
4386: where jtc.tax_id = jsptl.tax_id
4387: and delivery_detail_id in
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:
4450:
4451: Cursor get_rma_delivery_id (cp_ref_header_id number,cp_ref_line_id number)
4452: is
4453: select delivery_id
4454: from JAI_OM_WSH_LINES_ALL
4455: where order_header_id=cp_ref_header_id
4456: and order_line_id=cp_ref_line_id;
4457:
4458: -- added by nkodakan for the bug 16014871 ends