APPS.JAI_RCV_TAX_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 65: v_receipt_modify_flag JAI_CMN_INVENTORY_ORGS.receipt_modify_flag % TYPE;

61: -- v_form_id VARCHAR2(30); --File.Sql.35 Cbabu := 'JAINPORE';
62: v_chk_form VARCHAR2(30);
63: -- v_rowid JAI_CMN_LOCATORS_T.row_id % TYPE;
64: v_conf NUMBER;
65: v_receipt_modify_flag JAI_CMN_INVENTORY_ORGS.receipt_modify_flag % TYPE;
66: v_cor_quantity NUMBER;
67: v_rg_location_id JAI_INV_SUBINV_DTLS.location_id % TYPE;
68: v_po_header_date DATE;
69: v_vendor_site_id po_headers_all.vendor_site_id % TYPE;

Line 103: v_trading JAI_CMN_INVENTORY_ORGS.trading % TYPE;

99: v_picking_line_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE; --added
100: v_rsh_organization_id rcv_shipment_headers.organization_id % TYPE;
101: v_internal_vendor JAI_CMN_TAXES_ALL.vendor_id % TYPE;
102: v_current_tax NUMBER;
103: v_trading JAI_CMN_INVENTORY_ORGS.trading % TYPE;
104: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing % TYPE;
105: v_bonded JAI_INV_SUBINV_DTLS.bonded % TYPE;
106: v_claimable_amount JAI_RCV_LINE_TAXES.claimable_amount % TYPE;
107: -- Start of addition by Srihari on 30-NOV-99

Line 104: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing % TYPE;

100: v_rsh_organization_id rcv_shipment_headers.organization_id % TYPE;
101: v_internal_vendor JAI_CMN_TAXES_ALL.vendor_id % TYPE;
102: v_current_tax NUMBER;
103: v_trading JAI_CMN_INVENTORY_ORGS.trading % TYPE;
104: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing % TYPE;
105: v_bonded JAI_INV_SUBINV_DTLS.bonded % TYPE;
106: v_claimable_amount JAI_RCV_LINE_TAXES.claimable_amount % TYPE;
107: -- Start of addition by Srihari on 30-NOV-99
108: v_uom_rate NUMBER;

Line 702: lv_tax_change_on_roi_recpts JAI_CMN_INVENTORY_ORGS.tax_change_on_open_int_recpts%TYPE;

698: --------------------------------- Deciding tax modified flag --------------------------------
699: PROCEDURE set_receipt_flag IS
700:
701: /* Start Vijay Shankar for Bug#4199929 */
702: lv_tax_change_on_roi_recpts JAI_CMN_INVENTORY_ORGS.tax_change_on_open_int_recpts%TYPE;
703: lv_tax_change_on_wms_recpts JAI_CMN_INVENTORY_ORGS.tax_change_on_wms_recpts%TYPE;
704: /*lv_mobile_txn_flag rcv_transactions_interface.mobile_txn%TYPE;
705: above declaration fails incase client has a lower BASE VERSION like 11.5.5
706: So modified as below so that the procedure gets compiled. 4252036(4245089)

Line 703: lv_tax_change_on_wms_recpts JAI_CMN_INVENTORY_ORGS.tax_change_on_wms_recpts%TYPE;

699: PROCEDURE set_receipt_flag IS
700:
701: /* Start Vijay Shankar for Bug#4199929 */
702: lv_tax_change_on_roi_recpts JAI_CMN_INVENTORY_ORGS.tax_change_on_open_int_recpts%TYPE;
703: lv_tax_change_on_wms_recpts JAI_CMN_INVENTORY_ORGS.tax_change_on_wms_recpts%TYPE;
704: /*lv_mobile_txn_flag rcv_transactions_interface.mobile_txn%TYPE;
705: above declaration fails incase client has a lower BASE VERSION like 11.5.5
706: So modified as below so that the procedure gets compiled. 4252036(4245089)
707: */

Line 753: FROM JAI_CMN_INVENTORY_ORGS

749: nvl(manufacturing, 'N') manufacturing
750: /* following added by Vijay Shankar for Bug#4199929 */
751: , nvl(tax_change_on_open_int_recpts, 'N') tax_change_on_open_int_recpts
752: , nvl(tax_change_on_wms_recpts, 'N') tax_change_on_wms_recpts
753: FROM JAI_CMN_INVENTORY_ORGS
754: WHERE organization_id = p_organization_id
755: AND location_id = v_rg_location_id)
756: LOOP
757: v_receipt_modify_flag := rec_upd_rec.receipt_modify_flag;

Line 4543: FOR i IN (select manufacturing from JAI_CMN_INVENTORY_ORGS where organization_id=p_organization_id) loop

4539: ||', v_manufacturing:' || v_manufacturing ||', v_non_bonded_flag:' || v_non_bonded_delivery_flag
4540: ||', unclaim_flag:'||v_unclaim_cenvat_flag);
4541: END IF;*/
4542:
4543: FOR i IN (select manufacturing from JAI_CMN_INVENTORY_ORGS where organization_id=p_organization_id) loop
4544: v_manufacturing := i.manufacturing;
4545: EXIT WHEN v_manufacturing IS NOT NULL;
4546: END LOOP;
4547: