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 235: v_item_class JAI_INV_ITM_SETUPS.item_class%type; --3202319

231:
232: v_tax_vendor_site_id JAI_CMN_VENDOR_SITES.vendor_site_id%type; --Added by Nagaraj.s for Bug3037075
233: v_third_party_flag JAI_RCV_LINE_TAXES.third_party_flag%type; --Added by Nagaraj.s for Bug3037075
234: --Ends over here.
235: v_item_class JAI_INV_ITM_SETUPS.item_class%type; --3202319
236:
237: CURSOR uom_cur(c_uom VARCHAR2) IS
238: SELECT uom_code
239: FROM mtl_units_of_measure

Line 822: v_item_class JAI_INV_ITM_SETUPS.item_class % type;

818: PROCEDURE pick_register_type (p_organization_id number,
819: p_item_id number,
820: p_register_type out nocopy varchar2) IS
821: v_register_type JAI_CMN_RG_23AC_I_TRXS.register_type % TYPE;
822: v_item_class JAI_INV_ITM_SETUPS.item_class % type;
823: BEGIN
824: For reg_rec IN (SELECT item_class
825: FROM JAI_INV_ITM_SETUPS
826: WHERE organization_id = p_organization_id

Line 825: FROM JAI_INV_ITM_SETUPS

821: v_register_type JAI_CMN_RG_23AC_I_TRXS.register_type % TYPE;
822: v_item_class JAI_INV_ITM_SETUPS.item_class % type;
823: BEGIN
824: For reg_rec IN (SELECT item_class
825: FROM JAI_INV_ITM_SETUPS
826: WHERE organization_id = p_organization_id
827: AND inventory_item_id = p_item_id)
828: LOOP
829: v_item_class := reg_rec.item_class;

Line 1691: FROM JAI_INV_ITM_SETUPS

1687: FOR mod_rec IN (SELECT
1688: modvat_flag,
1689: item_trading_flag,
1690: item_class --Added by Nagaraj.s for Bug3202319
1691: FROM JAI_INV_ITM_SETUPS
1692: WHERE organization_id = v_organization_id
1693: AND inventory_item_id = v_item_id)
1694: LOOP
1695: v_item_modvat_flag := NVL(mod_rec.modvat_flag, 'N');