DBA Data[Home] [Help]

APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on JAI_CMN_TAX_DEFAULTATION_PKG

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

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

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

765:
766: IF v_type_lookup_code = 'PURCHASE' THEN
767:
768: -- Following line modified by Vijay Shankar for Bug# 3207886
769: -- Reason: jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes accepts INV_ORGANIZATION_ID as Parameter but we are passing OPT Unit id
770: -- jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(NVL(v_org_id,0), v_vendor_id,
771: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,
772: v_site_id, v_inventory_item_id, v_requisition_header_id,
773: v_requisition_line_id, v_tax_category_id);

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

766: IF v_type_lookup_code = 'PURCHASE' THEN
767:
768: -- Following line modified by Vijay Shankar for Bug# 3207886
769: -- Reason: jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes accepts INV_ORGANIZATION_ID as Parameter but we are passing OPT Unit id
770: -- jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(NVL(v_org_id,0), v_vendor_id,
771: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,
772: v_site_id, v_inventory_item_id, v_requisition_header_id,
773: v_requisition_line_id, v_tax_category_id);
774:

Line 771: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,

767:
768: -- Following line modified by Vijay Shankar for Bug# 3207886
769: -- Reason: jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes accepts INV_ORGANIZATION_ID as Parameter but we are passing OPT Unit id
770: -- jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(NVL(v_org_id,0), v_vendor_id,
771: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,
772: v_site_id, v_inventory_item_id, v_requisition_header_id,
773: v_requisition_line_id, v_tax_category_id);
774:
775: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_requisition_header_id,

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

771: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,
772: v_site_id, v_inventory_item_id, v_requisition_header_id,
773: v_requisition_line_id, v_tax_category_id);
774:
775: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_requisition_header_id,
776: v_requisition_line_id, v_assessable_value, v_line_amount, v_inventory_item_id, v_line_quantity ,
777: v_uom_code, v_vendor_id, NVL( v_currency, v_hdr_currency ), conv_rate,
778: v_creation_date, v_created_by, v_last_update_date,
779: v_last_updated_by, v_last_update_login,p_vat_assessable_value => ln_vat_assess_value); -- Ravi for VAT

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

779: v_last_updated_by, v_last_update_login,p_vat_assessable_value => ln_vat_assess_value); -- Ravi for VAT
780:
781: ELSIF v_type_lookup_code = 'INTERNAL' THEN
782:
783: jai_cmn_tax_defaultation_pkg.Ja_In_Org_Default_Taxes( v_src_org_id, v_inventory_item_id, v_tax_category_id );
784:
785: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_requisition_header_id,
786: v_requisition_line_id, v_assessable_value, v_line_amount, v_inventory_item_id, v_line_quantity ,
787: v_uom_code, NULL, NVL( v_currency, v_hdr_currency ), conv_rate,

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

781: ELSIF v_type_lookup_code = 'INTERNAL' THEN
782:
783: jai_cmn_tax_defaultation_pkg.Ja_In_Org_Default_Taxes( v_src_org_id, v_inventory_item_id, v_tax_category_id );
784:
785: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_requisition_header_id,
786: v_requisition_line_id, v_assessable_value, v_line_amount, v_inventory_item_id, v_line_quantity ,
787: v_uom_code, NULL, NVL( v_currency, v_hdr_currency ), conv_rate,
788: v_creation_date, v_created_by, v_last_update_date,
789: v_last_updated_by, v_last_update_login, -1*v_src_org_id,p_vat_assessable_value => ln_vat_assess_value );

Line 2311: 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

2307:
2308: Delete From JAI_PO_REQ_LINE_TAXES
2309: Where Requisition_Line_Id = v_line_id;
2310:
2311: 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
2312: v_site_id, v_inventory_item_id, v_header_id,
2313: v_line_id, v_tax_category_id );
2314:
2315: IF v_type_lookup_code = 'INTERNAL' THEN

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

2315: IF v_type_lookup_code = 'INTERNAL' THEN
2316: v_src_org_id := -1*v_src_org_id;
2317: END IF;
2318:
2319: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES( 'PO_REQN', v_tax_category_id, v_header_id,
2320: v_line_id, v_assessable_value, v_line_amount, v_inventory_item_id,
2321: v_quantity , v_uom_code, v_vendor_id, NVL( v_currency, v_hdr_curr ),
2322: conv_rate, v_creation_date, v_created_by, v_last_update_date,
2323: v_last_updated_by, v_last_update_login, v_src_org_id,p_vat_assessable_value => ln_vat_assess_value ); -- Ravi for VAT

Line 2385: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,

2381: p_conv_rate => 1/conv_rate,
2382: p_po_curr => v_currency);
2383: ELSIF v_blanket_hdr IS NULL AND v_blanket_line IS NULL THEN
2384: IF v_type_lookup_code = 'PURCHASE' THEN
2385: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,
2386: v_site_id, v_inventory_item_id,
2387: v_header_id,v_line_id, v_tax_category_id);
2388:
2389: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_header_id,

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

2385: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES(v_dest_org_id, v_vendor_id,
2386: v_site_id, v_inventory_item_id,
2387: v_header_id,v_line_id, v_tax_category_id);
2388:
2389: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_header_id,
2390: v_line_id, v_assessable_value, v_line_amount, v_inventory_item_id, v_quantity ,
2391: v_uom_code, v_vendor_id, NVL( v_currency, v_hdr_curr ), conv_rate,
2392: v_creation_date, v_created_by, v_last_update_date,
2393: v_last_updated_by, v_last_update_login,p_vat_assessable_value => ln_vat_assess_value);

Line 2395: jai_cmn_tax_defaultation_pkg.Ja_In_Org_Default_Taxes( v_src_org_id, v_inventory_item_id,

2391: v_uom_code, v_vendor_id, NVL( v_currency, v_hdr_curr ), conv_rate,
2392: v_creation_date, v_created_by, v_last_update_date,
2393: v_last_updated_by, v_last_update_login,p_vat_assessable_value => ln_vat_assess_value);
2394: ELSIF v_type_lookup_code = 'INTERNAL' THEN
2395: jai_cmn_tax_defaultation_pkg.Ja_In_Org_Default_Taxes( v_src_org_id, v_inventory_item_id,
2396: v_tax_category_id );
2397:
2398: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_header_id,
2399: v_line_id, v_assessable_value, v_line_amount, v_inventory_item_id, v_quantity ,

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

2394: ELSIF v_type_lookup_code = 'INTERNAL' THEN
2395: jai_cmn_tax_defaultation_pkg.Ja_In_Org_Default_Taxes( v_src_org_id, v_inventory_item_id,
2396: v_tax_category_id );
2397:
2398: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES('PO_REQN', v_tax_category_id, v_header_id,
2399: v_line_id, v_assessable_value, v_line_amount, v_inventory_item_id, v_quantity ,
2400: v_uom_code, NULL, NVL( v_currency, v_hdr_curr ), conv_rate,
2401: v_creation_date, v_created_by, v_last_update_date,
2402: v_last_updated_by, v_last_update_login,

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

2916:
2917: Delete From JAI_PO_REQ_LINE_TAXES
2918: Where Requisition_Line_Id = v_line_id;
2919:
2920: jai_cmn_tax_defaultation_pkg.Ja_In_vendor_Default_Taxes( nvl(v_org_id,0),
2921: v_vendor_id, v_site_id,
2922: v_inventory_item_id, v_header_id, v_line_id,
2923: v_tax_category_id );
2924: IF v_type_lookup_code <> 'INTERNAL' THEN

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

2926: ELSE
2927: v_src_org_id := -1 * v_src_org_id;
2928: END IF;
2929:
2930: jai_cmn_tax_defaultation_pkg.Ja_In_Calc_Prec_Taxes( 'PO_REQN', v_tax_category_id, v_header_id, v_line_id,
2931: v_assessable_value, v_line_amount, v_inventory_item_id,
2932: v_quantity , v_uom_code, v_vendor_id, NVL( v_currency, v_hdr_curr ),
2933: conv_rate, v_creation_date, v_created_by, v_last_update_date,
2934: v_last_updated_by, v_last_update_login, v_src_org_id, ln_vat_assess_value );