4325: calculation is handled by the following code. */
4326: OPEN cur_get_interface_id;
4327: FETCH cur_get_interface_id INTO l_interface_id;
4328: CLOSE cur_get_interface_id;
4329: inv_calculate_exp_date.set_txn_id (p_table => 1, p_header_id => l_interface_id);
4330: inv_calculate_exp_date.set_lot_txn_id (p_table => 1, p_header_id => l_lotrowid);
4331:
4332: /* this api will validate all the added new lot attributes intoduced in INVCONV
4333: project */
4326: OPEN cur_get_interface_id;
4327: FETCH cur_get_interface_id INTO l_interface_id;
4328: CLOSE cur_get_interface_id;
4329: inv_calculate_exp_date.set_txn_id (p_table => 1, p_header_id => l_interface_id);
4330: inv_calculate_exp_date.set_lot_txn_id (p_table => 1, p_header_id => l_lotrowid);
4331:
4332: /* this api will validate all the added new lot attributes intoduced in INVCONV
4333: project */
4334: l_attr_check := VALIDATE_ADDITIONAL_ATTR(
14856: AND PRIMARY_TRANSACTION_QUANTITY > 0
14857: AND rownum = 1;
14858:
14859: IF (l_lot_onhand = 0) THEN
14860: inv_calculate_exp_date.get_origination_date
14861: ( p_inventory_item_id => p_inventory_item_id
14862: ,p_organization_id => p_organization_id
14863: ,p_lot_number => p_lot_number
14864: ,x_orig_date => l_orig_date