APPS.INV_ROI_INTEGRATION_GRP dependencies on MTL_LOT_NUMBERS

Line 1486: P_MLN_REC IN mtl_lot_numbers%ROWTYPE ,

1482: p_secondary_unit_of_measure IN VARCHAR2 ,
1483: p_uom_code IN VARCHAR2 ,
1484: p_secondary_uom_code IN VARCHAR2 ,
1485: p_reason_id IN NUMBER ,
1486: P_MLN_REC IN mtl_lot_numbers%ROWTYPE ,
1487: p_mtlt_rowid IN ROWID
1488: )
1489:
1490: IS

Line 1491: /* copy all values from mtl_lot_numbers for inter org transfer */

1487: p_mtlt_rowid IN ROWID
1488: )
1489:
1490: IS
1491: /* copy all values from mtl_lot_numbers for inter org transfer */
1492: CURSOR C_MLN (l_lot_number VARCHAR2,
1493: l_item_id NUMBER,
1494: l_from_organization_id NUMBER
1495: ) IS

Line 1497: FROM mtl_lot_numbers

1493: l_item_id NUMBER,
1494: l_from_organization_id NUMBER
1495: ) IS
1496: SELECT *
1497: FROM mtl_lot_numbers
1498: WHERE lot_number = l_lot_number
1499: AND inventory_item_id=l_item_id
1500: AND organization_id = l_from_organization_id;
1501:

Line 1504: L_MLN_REC mtl_lot_numbers%ROWTYPE ;

1500: AND organization_id = l_from_organization_id;
1501:
1502: ---local variables declaration
1503: l_lot_rec C_MLN%ROWTYPE ;
1504: L_MLN_REC mtl_lot_numbers%ROWTYPE ;
1505: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
1506: p_lot_uom_conv_rec mtl_lot_uom_class_conversions%ROWTYPE ;
1507: l_source NUMBER ;
1508: l_permission_value NUMBER ;

Line 1505: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;

1501:
1502: ---local variables declaration
1503: l_lot_rec C_MLN%ROWTYPE ;
1504: L_MLN_REC mtl_lot_numbers%ROWTYPE ;
1505: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
1506: p_lot_uom_conv_rec mtl_lot_uom_class_conversions%ROWTYPE ;
1507: l_source NUMBER ;
1508: l_permission_value NUMBER ;
1509: l_conv_info_exists NUMBER ;

Line 1596: ----Populate l_lot_rec (MTL_LOT_NUMBERS%ROWTYPE ) as follows:

1592: END IF;
1593: RAISE g_exc_unexpected_error;
1594: END IF;
1595:
1596: ----Populate l_lot_rec (MTL_LOT_NUMBERS%ROWTYPE ) as follows:
1597: BEGIN
1598:
1599: OPEN C_MLN(p_lot_number,
1600: p_item_id,

Line 1609: mtl_lot-numbers will not have any data.

1605:
1606: /* If the lot in destination org for receive/deliver trx is already existing in the
1607: shipping org then the code works works fine.
1608: However if the lot is also new in the shipping org then the above cursor will fail as
1609: mtl_lot-numbers will not have any data.
1610: In this case erroring out as we cannot do an Inter Org transfer from an org with a new lot.
1611: We can only transfer in an existing lot.
1612: Thsi lot can nevertheless be be new in the destination org.
1613:

Line 1691: print_debug('inv_new_lot::fetched all records from mtl_lot_numbers(shipping org values)

1687:
1688: ELSE
1689: --*/
1690: IF g_debug = 1 THEN
1691: print_debug('inv_new_lot::fetched all records from mtl_lot_numbers(shipping org values)
1692: for an Inter Org Transfer:' || l_progress, 1);
1693: END IF;
1694: CLOSE C_MLN;
1695: END IF;

Line 1726: Populate p_lot_rec (MTL_LOT_NUMBERS%ROWTYPE ) with the lot record coming from validate_lot_serial_info.

1722: ELSE ---------IF p_source_document_code IN ( 'INVENTORY','REQ') THEN
1723:
1724: /*Not an Inter-Org Transfers.
1725: Default the lot attributes from destination item master.
1726: Populate p_lot_rec (MTL_LOT_NUMBERS%ROWTYPE ) with the lot record coming from validate_lot_serial_info.
1727: All these parameters are to be used in the serias of API calls starting Create_Inv_Lot */
1728:
1729: l_lot_rec := P_MLN_REC ;
1730: