APPS.JAI_RCV_TAX_PKG dependencies on JAI_INV_ITM_SETUPS

Line 72: v_item_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE;

68: v_po_header_date DATE;
69: v_vendor_site_id po_headers_all.vendor_site_id % TYPE;
70: v_item_id rcv_shipment_lines.item_id % TYPE;
71: v_organization_id rcv_shipment_lines.to_organization_id % TYPE;
72: v_item_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE;
73: v_item_trading_flag JAI_INV_ITM_SETUPS.item_trading_flag % TYPE;
74: v_receipt_source_code rcv_shipment_headers.receipt_source_code % TYPE;
75: -- v_paddr v$session.paddr % TYPE;
76: -- v_temp_status ja_in_temp_receipt.status % TYPE; --Commented by Nagaraj.s for Bug#2692052

Line 73: v_item_trading_flag JAI_INV_ITM_SETUPS.item_trading_flag % TYPE;

69: v_vendor_site_id po_headers_all.vendor_site_id % TYPE;
70: v_item_id rcv_shipment_lines.item_id % TYPE;
71: v_organization_id rcv_shipment_lines.to_organization_id % TYPE;
72: v_item_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE;
73: v_item_trading_flag JAI_INV_ITM_SETUPS.item_trading_flag % TYPE;
74: v_receipt_source_code rcv_shipment_headers.receipt_source_code % TYPE;
75: -- v_paddr v$session.paddr % TYPE;
76: -- v_temp_status ja_in_temp_receipt.status % TYPE; --Commented by Nagaraj.s for Bug#2692052
77: v_paddr RAW(32); /*Bug 4644524 bduvarag*/

Line 78: v_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE; --Changed the %type by Nagaraj.s for Bug#2692052

74: v_receipt_source_code rcv_shipment_headers.receipt_source_code % TYPE;
75: -- v_paddr v$session.paddr % TYPE;
76: -- v_temp_status ja_in_temp_receipt.status % TYPE; --Commented by Nagaraj.s for Bug#2692052
77: v_paddr RAW(32); /*Bug 4644524 bduvarag*/
78: v_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE; --Changed the %type by Nagaraj.s for Bug#2692052
79: v_tax_total NUMBER; --File.Sql.35 Cbabu := 0;
80: -- v_line_id so_lines_all.line_id % type; --commented by GSri and Jagdish on 5-may-01
81: v_line_id oe_order_lines_all.line_id % TYPE; --added by GSri and Jagdish on 5-may-01
82: v_rg_type VARCHAR2(30);

Line 257: v_item_class JAI_INV_ITM_SETUPS.item_class%type; --3202319

253:
254: --v_tax_vendor_site_id JAI_CMN_VENDOR_SITES.vendor_site_id%type; Commented by by nprshar for bug # 10193326 --Added by Nagaraj.s for Bug3037075
255: v_third_party_flag JAI_RCV_LINE_TAXES.third_party_flag%type; --Added by Nagaraj.s for Bug3037075
256: --Ends over here.
257: v_item_class JAI_INV_ITM_SETUPS.item_class%type; --3202319
258:
259: CURSOR uom_cur(c_uom VARCHAR2) IS
260: SELECT uom_code
261: FROM mtl_units_of_measure

Line 914: v_item_class JAI_INV_ITM_SETUPS.item_class % type;

910: PROCEDURE pick_register_type (p_organization_id number,
911: p_item_id number,
912: p_register_type out nocopy varchar2) IS
913: v_register_type JAI_CMN_RG_23AC_I_TRXS.register_type % TYPE;
914: v_item_class JAI_INV_ITM_SETUPS.item_class % type;
915: BEGIN
916: For reg_rec IN (SELECT item_class
917: FROM JAI_INV_ITM_SETUPS
918: WHERE organization_id = p_organization_id

Line 917: FROM JAI_INV_ITM_SETUPS

913: v_register_type JAI_CMN_RG_23AC_I_TRXS.register_type % TYPE;
914: v_item_class JAI_INV_ITM_SETUPS.item_class % type;
915: BEGIN
916: For reg_rec IN (SELECT item_class
917: FROM JAI_INV_ITM_SETUPS
918: WHERE organization_id = p_organization_id
919: AND inventory_item_id = p_item_id)
920: LOOP
921: v_item_class := reg_rec.item_class;

Line 1915: FROM JAI_INV_ITM_SETUPS

1911: FOR mod_rec IN (SELECT
1912: modvat_flag,
1913: item_trading_flag,
1914: item_class --Added by Nagaraj.s for Bug3202319
1915: FROM JAI_INV_ITM_SETUPS
1916: WHERE organization_id = v_organization_id
1917: AND inventory_item_id = v_item_id)
1918: LOOP
1919: v_item_modvat_flag := NVL(mod_rec.modvat_flag, 'N');