DBA Data[Home] [Help]

APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on JAI_PO_TAX_PKG

Line 699: /* jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_requisition_line_id , v_requisition_header_id, NULL,

695: FETCH Fetch_Uom_Code_Cur INTO v_uom_code;
696: CLOSE Fetch_Uom_Code_Cur;
697: /*4281841...end*/
698:
699: /* jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_requisition_line_id , v_requisition_header_id, NULL,
700: v_line_quantity, v_unit_price*v_line_quantity, NVL( v_currency, v_hdr_currency ) ,
701: v_assessable_value, v_assessable_value, NULL, conv_rate ); */
702:
703: /* ELSE -- pramasub FP commented

Line 743: /*jai_po_tax_pkg.calculate_tax( 'REQUISITION_BLANKET', v_requisition_line_id , v_po_line_id, v_line_location_id,

739: END LOOP;
740: end if; -- added by sriram -- Bug # 2977200
741:
742: END IF;*/
743: /*jai_po_tax_pkg.calculate_tax( 'REQUISITION_BLANKET', v_requisition_line_id , v_po_line_id, v_line_location_id,
744: v_line_quantity, v_unit_price*v_line_quantity, NVL( v_currency, v_hdr_currency ) ,
745: v_assessable_value, v_assessable_value,ln_vat_assess_value, NULL, conv_rate ); -- Ravi for VAT*/ --pramasub FP commented
746: --ja_in_po_calc_tax is renamed to jai_po_tax_pkg.calc_tax
747: jai_po_tax_pkg.calc_tax(p_type => 'REQUISITION_BLANKET',

Line 746: --ja_in_po_calc_tax is renamed to jai_po_tax_pkg.calc_tax

742: END IF;*/
743: /*jai_po_tax_pkg.calculate_tax( 'REQUISITION_BLANKET', v_requisition_line_id , v_po_line_id, v_line_location_id,
744: v_line_quantity, v_unit_price*v_line_quantity, NVL( v_currency, v_hdr_currency ) ,
745: v_assessable_value, v_assessable_value,ln_vat_assess_value, NULL, conv_rate ); -- Ravi for VAT*/ --pramasub FP commented
746: --ja_in_po_calc_tax is renamed to jai_po_tax_pkg.calc_tax
747: jai_po_tax_pkg.calc_tax(p_type => 'REQUISITION_BLANKET',
748: p_header_id => v_blanket_hdr,
749: p_requisition_line_id => v_requisition_line_id ,
750: P_line_id => v_po_line_id,

Line 747: jai_po_tax_pkg.calc_tax(p_type => 'REQUISITION_BLANKET',

743: /*jai_po_tax_pkg.calculate_tax( 'REQUISITION_BLANKET', v_requisition_line_id , v_po_line_id, v_line_location_id,
744: v_line_quantity, v_unit_price*v_line_quantity, NVL( v_currency, v_hdr_currency ) ,
745: v_assessable_value, v_assessable_value,ln_vat_assess_value, NULL, conv_rate ); -- Ravi for VAT*/ --pramasub FP commented
746: --ja_in_po_calc_tax is renamed to jai_po_tax_pkg.calc_tax
747: jai_po_tax_pkg.calc_tax(p_type => 'REQUISITION_BLANKET',
748: p_header_id => v_blanket_hdr,
749: p_requisition_line_id => v_requisition_line_id ,
750: P_line_id => v_po_line_id,
751: p_line_location_id => v_line_location_id,

Line 1107: This is resolved by defaulting taxes from setup with an API call to jai_po_tax_pkg.ja_in_po_case2 procedure

1103:
1104: 5 18/11/2003 Vijay Shankar for Bug# 3193592, FileVersion# 617.1
1105: when multiple requisitions are merged to form a single PO Shipment during Autocreation process, then this trigger
1106: is erroring out as taxes from multiple requisition lines are getting populated into the same line_location_id.
1107: This is resolved by defaulting taxes from setup with an API call to jai_po_tax_pkg.ja_in_po_case2 procedure
1108: instead of carrying taxes from requisition lines to PO Shipment
1109:
1110: 6.02/08/2004 ssumaith - bug# 3729015 file version 115.1
1111: commented call to jai_po_cmn_pkg.process_release_shipment because in the ja_in_po_tax_insert_trg

Line 1439: jai_po_tax_pkg.ja_in_po_case2(v_type_lookup_code,

1435: FETCH c_inventory_org_id INTO v_inventory_org_id;
1436: CLOSE c_inventory_org_id;
1437:
1438:
1439: jai_po_tax_pkg.ja_in_po_case2(v_type_lookup_code,
1440: v_quot_class_code,
1441: v_po_vendor_id,
1442: v_po_vendor_site_id,
1443: v_po_curr,

Line 1673: jai_po_tax_pkg.calculate_tax( 'STANDARDPO',

1669:
1670: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, DUMMY, v_po_curr, v_curr_conv_factor); -- TO get the conversion rate .
1671:
1672: /* Added ln_vat_assess_value for bug# for VAT */
1673: jai_po_tax_pkg.calculate_tax( 'STANDARDPO',
1674: v_po_hdr_id ,
1675: v_po_line_id,
1676: v_line_loc_id,
1677: -- Bug 4513549. Added by LGOPALSA

Line 1900: Call to jai_po_tax_pkg.calculate_tax is not invoked properly, which is made proper with this fix

1896: FETCH Fetch_Book_Id_Curr INTO v_gl_set_of_books_id;
1897: CLOSE Fetch_Book_Id_Curr;
1898:
1899: 2 10/10/2003 Vijay Shankar for Bug# 3190872, FileVersion: 616.1
1900: Call to jai_po_tax_pkg.calculate_tax is not invoked properly, which is made proper with this fix
1901:
1902: 3. 30/11/2005 Aparajita for bug#4036241. Version#115.1
1903:
1904: Introduced the call to centralized packaged procedure,

Line 2368: jai_po_tax_pkg.calc_tax(p_type => 'REQUISITION_BLANKET',

2364: v_quantity, v_line_amount , NVL( v_currency, v_hdr_curr ) ,
2365: v_assessable_value, v_assessable_value,ln_vat_assess_value, NULL, conv_rate ); -- Ravi for VAT*/
2366:
2367: /*5852041 ..commented the above and made call to ja_in_po_calc_tax*/
2368: jai_po_tax_pkg.calc_tax(p_type => 'REQUISITION_BLANKET',
2369: p_header_id => v_blanket_hdr,
2370: p_requisition_line_id => v_line_id ,
2371: P_line_id => v_po_line_id,
2372: p_line_location_id => v_line_location_id,

Line 2437: -- jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id, -999, -999, -999, ' ', v_line_amount, v_assessable_value, NULL, conv_rate );

2433:
2434: END IF; --pramasub FP 115.12
2435:
2436: -- following procedure call commented and modified in the next line by Vijay Shankar for Bug# 3190872
2437: -- jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id, -999, -999, -999, ' ', v_line_amount, v_assessable_value, NULL, conv_rate );
2438: /*jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id,
2439: -999, -999, v_line_amount, v_uom_code, v_line_amount,
2440: v_assessable_value,ln_vat_assess_value, v_inventory_item_id, conv_rate ); */-- Ravi for VAT | commented by pramasub FP
2441:

Line 2438: /*jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id,

2434: END IF; --pramasub FP 115.12
2435:
2436: -- following procedure call commented and modified in the next line by Vijay Shankar for Bug# 3190872
2437: -- jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id, -999, -999, -999, ' ', v_line_amount, v_assessable_value, NULL, conv_rate );
2438: /*jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id,
2439: -999, -999, v_line_amount, v_uom_code, v_line_amount,
2440: v_assessable_value,ln_vat_assess_value, v_inventory_item_id, conv_rate ); */-- Ravi for VAT | commented by pramasub FP
2441:
2442: /*rchandan for bug#5852041. Commented the above and added the call to ja_in_po_calc_tax*/ --pramasub FP

Line 2443: /*jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id,

2439: -999, -999, v_line_amount, v_uom_code, v_line_amount,
2440: v_assessable_value,ln_vat_assess_value, v_inventory_item_id, conv_rate ); */-- Ravi for VAT | commented by pramasub FP
2441:
2442: /*rchandan for bug#5852041. Commented the above and added the call to ja_in_po_calc_tax*/ --pramasub FP
2443: /*jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id,
2444: -999, v_quantity, v_line_amount, v_uom_code, v_line_amount,
2445: v_assessable_value,ln_vat_assess_value, v_inventory_item_id, conv_rate ); -- Ravi for VAT*/
2446: --ja_in_po_calc_tax is FPed to jai_po_tax_pkg.calc_tax pramasub FP
2447: jai_po_tax_pkg.calc_tax(p_type => 'REQUISITION',

Line 2446: --ja_in_po_calc_tax is FPed to jai_po_tax_pkg.calc_tax pramasub FP

2442: /*rchandan for bug#5852041. Commented the above and added the call to ja_in_po_calc_tax*/ --pramasub FP
2443: /*jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id,
2444: -999, v_quantity, v_line_amount, v_uom_code, v_line_amount,
2445: v_assessable_value,ln_vat_assess_value, v_inventory_item_id, conv_rate ); -- Ravi for VAT*/
2446: --ja_in_po_calc_tax is FPed to jai_po_tax_pkg.calc_tax pramasub FP
2447: jai_po_tax_pkg.calc_tax(p_type => 'REQUISITION',
2448: p_header_id => v_header_id,
2449: P_line_id => v_line_id,
2450: p_line_location_id => NULL,

Line 2447: jai_po_tax_pkg.calc_tax(p_type => 'REQUISITION',

2443: /*jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id,
2444: -999, v_quantity, v_line_amount, v_uom_code, v_line_amount,
2445: v_assessable_value,ln_vat_assess_value, v_inventory_item_id, conv_rate ); -- Ravi for VAT*/
2446: --ja_in_po_calc_tax is FPed to jai_po_tax_pkg.calc_tax pramasub FP
2447: jai_po_tax_pkg.calc_tax(p_type => 'REQUISITION',
2448: p_header_id => v_header_id,
2449: P_line_id => v_line_id,
2450: p_line_location_id => NULL,
2451: p_line_focus_id => NULL,

Line 2950: jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id, -999, -999, -999, ' ', v_line_tax_amount, v_assessable_value,

2946: WHERE Requisition_Header_Id = v_header_id
2947: AND Requisition_Line_Id = v_line_id
2948: AND Currency = NVL( v_currency, v_hdr_curr )
2949: AND Tax_Rate is Not Null;
2950: jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id, -999, -999, -999, ' ', v_line_tax_amount, v_assessable_value,
2951: ln_vat_assess_value, NULL, conv_rate );
2952: UPDATE JAI_PO_REQ_LINES
2953: SET Last_Update_Date = pr_new.last_update_date,
2954: Last_Updated_By = pr_new.last_updated_by,