DBA Data[Home] [Help]

APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on JAI_CMN_TAX_DEFAULTATION_PKG

Line 241: requisition line. The issue occured because jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes accepts the Inventory

237: This check has been added at 2 places , before insert into JAI_PO_REQ_LINE_TAXES
238:
239: 3 21/10/2003 Vijay Shankar for Bug# 3207886, FileVersion# 616.2
240: Taxes are not getting defaulted from ITEM_CLASS and TAX_CATEGORY setup if Supplier information is not provided
241: requisition line. The issue occured because jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes accepts the Inventory
242: organization id as first argument, but we are passing Operating Unit Id as first parameter. Fixed the issue
243: by passing Destination Organization as parameter.
244:
245: 4. 30/11/2005 Aparajita for bug#4036241. Version#115.1

Line 818: -- Reason: jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes accepts INV_ORGANIZATION_ID as Parameter but we are passing OPT Unit id

814: -- lv_enable_gst_flag := JAI_GST_GENERAL_PKG.IS_GST_ENABLED;--Added by Xiao Lv for bug 10043656
815: IF v_type_lookup_code = 'PURCHASE' THEN
816:
817: -- Following line modified by Vijay Shankar for Bug# 3207886
818: -- Reason: jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes accepts INV_ORGANIZATION_ID as Parameter but we are passing OPT Unit id
819: -- jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(NVL(v_org_id,0), v_vendor_id,
820: -- IF nvl(lv_enable_gst_flag,'N') = 'N' THEN --Added by Xiao Lv for bug 10043656
821: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,
822: v_site_id, v_inventory_item_id, v_requisition_header_id,

Line 819: -- jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(NVL(v_org_id,0), v_vendor_id,

815: IF v_type_lookup_code = 'PURCHASE' THEN
816:
817: -- Following line modified by Vijay Shankar for Bug# 3207886
818: -- Reason: jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes accepts INV_ORGANIZATION_ID as Parameter but we are passing OPT Unit id
819: -- jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(NVL(v_org_id,0), v_vendor_id,
820: -- IF nvl(lv_enable_gst_flag,'N') = 'N' THEN --Added by Xiao Lv for bug 10043656
821: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,
822: v_site_id, v_inventory_item_id, v_requisition_header_id,
823: v_requisition_line_id, v_tax_category_id);

Line 821: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,

817: -- Following line modified by Vijay Shankar for Bug# 3207886
818: -- Reason: jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes accepts INV_ORGANIZATION_ID as Parameter but we are passing OPT Unit id
819: -- jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(NVL(v_org_id,0), v_vendor_id,
820: -- IF nvl(lv_enable_gst_flag,'N') = 'N' THEN --Added by Xiao Lv for bug 10043656
821: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,
822: v_site_id, v_inventory_item_id, v_requisition_header_id,
823: v_requisition_line_id, v_tax_category_id);
824: /*
825: ELSE

Line 840: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_requisition_header_id,

836: -----------------------------------------------------------------------
837: --Added by Xiao Lv for bug 10043656, end
838: END IF;
839: */
840: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_requisition_header_id,
841: v_requisition_line_id, v_assessable_value, v_line_amount, v_inventory_item_id, v_line_quantity ,
842: v_uom_code, v_vendor_id, NVL( v_currency, v_hdr_currency ), conv_rate,
843: v_creation_date, v_created_by, v_last_update_date,
844: v_last_updated_by, v_last_update_login,p_vat_assessable_value => ln_vat_assess_value, -- Ravi for VAT

Line 853: jai_cmn_tax_defaultation_pkg.Ja_In_Org_Default_Taxes( v_src_org_id, v_inventory_item_id, v_tax_category_id );

849:
850: ELSIF v_type_lookup_code = 'INTERNAL' THEN
851:
852: --IF nvl(lv_enable_gst_flag,'N') = 'N' THEN --Added by Xiao Lv for bug 10043656
853: jai_cmn_tax_defaultation_pkg.Ja_In_Org_Default_Taxes( v_src_org_id, v_inventory_item_id, v_tax_category_id );
854:
855: /*ELSE
856: jai_gst_tax_defaultation_pkg.jai_gst_org_default_taxes(
857: pn_organization_id =>v_src_org_id,

Line 867: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_requisition_header_id,

863: pd_transaction_date =>v_creation_date,
864: pn_tax_category_id =>v_tax_category_id );
865: END IF;--Added by Xiao Lv for bug 10043656, ends
866: */
867: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_requisition_header_id,
868: v_requisition_line_id, v_assessable_value, v_line_amount, v_inventory_item_id, v_line_quantity ,
869: v_uom_code, NULL, NVL( v_currency, v_hdr_currency ), conv_rate,
870: v_creation_date, v_created_by, v_last_update_date,
871: v_last_updated_by, v_last_update_login, -1*v_src_org_id,p_vat_assessable_value => ln_vat_assess_value ,

Line 2470: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES( v_dest_org_id, v_vendor_id, /*rchandan for bug# replaced NVL(v_org_id,0) with v_dest_org_id*/ --pramasub FP

2466:
2467: Delete From JAI_PO_REQ_LINE_TAXES
2468: Where Requisition_Line_Id = v_line_id;
2469: -- IF nvl(lv_enable_gst_flag,'N') = 'N' THEN--Added by Xiao Lv for bug 10043656
2470: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES( v_dest_org_id, v_vendor_id, /*rchandan for bug# replaced NVL(v_org_id,0) with v_dest_org_id*/ --pramasub FP
2471: v_site_id, v_inventory_item_id, v_header_id,
2472: v_line_id, v_tax_category_id );
2473: /*
2474: ELSE

Line 2495: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES( 'PO_REQN', v_tax_category_id, v_header_id,

2491: IF v_type_lookup_code = 'INTERNAL' THEN
2492: v_src_org_id := -1*v_src_org_id;
2493: END IF;
2494:
2495: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES( 'PO_REQN', v_tax_category_id, v_header_id,
2496: v_line_id, v_assessable_value, v_line_amount, v_inventory_item_id,
2497: v_quantity , v_uom_code, v_vendor_id, NVL( v_currency, v_hdr_curr ),
2498: conv_rate, v_creation_date, v_created_by, v_last_update_date,
2499: v_last_updated_by, v_last_update_login, v_src_org_id,p_vat_assessable_value => ln_vat_assess_value -- Ravi for VAT

Line 2566: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,

2562: ); -- Added by Jia for GST Bug#10091373 on 2010/09/10
2563: ELSIF v_blanket_hdr IS NULL AND v_blanket_line IS NULL THEN
2564: IF v_type_lookup_code = 'PURCHASE' THEN
2565: -- IF nvl(lv_enable_gst_flag,'N') = 'N' THEN--Added by Xiao Lv for bug 10043656
2566: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,
2567: v_site_id, v_inventory_item_id,
2568: v_header_id,v_line_id, v_tax_category_id);
2569: /*
2570: ELSE

Line 2585: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_header_id,

2581: END IF;
2582: */
2583: -----------------------------------------------------------------------------
2584: --Added by Xiao Lv for bug 10043656, end
2585: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_header_id,
2586: v_line_id, v_assessable_value, v_line_amount, v_inventory_item_id, v_quantity ,
2587: v_uom_code, v_vendor_id, NVL( v_currency, v_hdr_curr ), conv_rate,
2588: v_creation_date, v_created_by, v_last_update_date,
2589: v_last_updated_by, v_last_update_login,p_vat_assessable_value => ln_vat_assess_value

Line 2595: jai_cmn_tax_defaultation_pkg.Ja_In_Org_Default_Taxes( v_src_org_id, v_inventory_item_id,

2591: ); -- Added by Jia for GST Bug#10091373 on 2010/09/10
2592:
2593: ELSIF v_type_lookup_code = 'INTERNAL' THEN
2594: -- IF nvl(lv_enable_gst_flag,'N') = 'N' THEN--Added by Xiao Lv for bug 10043656
2595: jai_cmn_tax_defaultation_pkg.Ja_In_Org_Default_Taxes( v_src_org_id, v_inventory_item_id,
2596: v_tax_category_id );
2597: /*
2598: ELSE
2599: --Added by Xiao Lv for bug 10043656, begin

Line 2614: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_header_id,

2610: END IF;*/
2611: -----------------------------------------------------------------------------
2612: --Added by Xiao Lv for bug 10043656, end
2613:
2614: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_header_id,
2615: v_line_id, v_assessable_value, v_line_amount, v_inventory_item_id, v_quantity ,
2616: v_uom_code, NULL, NVL( v_currency, v_hdr_curr ), conv_rate,
2617: v_creation_date, v_created_by, v_last_update_date,
2618: v_last_updated_by, v_last_update_login,

Line 3171: jai_cmn_tax_defaultation_pkg.Ja_In_vendor_Default_Taxes( nvl(v_org_id,0),

3167: --lv_enable_gst_flag := JAI_GST_GENERAL_PKG.IS_GST_ENABLED;--Added by Xiao Lv for bug 10043656
3168: --IF nvl(lv_enable_gst_flag,'N') = 'N' THEN
3169: --Added by Xiao Lv for bug 10043656, begin
3170: ----------------------------------------------------------------------------------------
3171: jai_cmn_tax_defaultation_pkg.Ja_In_vendor_Default_Taxes( nvl(v_org_id,0),
3172: v_vendor_id, v_site_id,
3173: v_inventory_item_id, v_header_id, v_line_id,
3174: v_tax_category_id );
3175: /*

Line 3194: jai_cmn_tax_defaultation_pkg.Ja_In_Calc_Prec_Taxes( 'PO_REQN', v_tax_category_id, v_header_id, v_line_id,

3190: ELSE
3191: v_src_org_id := -1 * v_src_org_id;
3192: END IF;
3193:
3194: jai_cmn_tax_defaultation_pkg.Ja_In_Calc_Prec_Taxes( 'PO_REQN', v_tax_category_id, v_header_id, v_line_id,
3195: v_assessable_value, v_line_amount, v_inventory_item_id,
3196: v_quantity , v_uom_code, v_vendor_id, NVL( v_currency, v_hdr_curr ),
3197: conv_rate, v_creation_date, v_created_by, v_last_update_date,
3198: v_last_updated_by, v_last_update_login, v_src_org_id, ln_vat_assess_value