[Home] [Help]
1: PACKAGE BODY inv_lot_trx_validation_pvt AS
2: /* $Header: INVVLTVB.pls 120.10 2006/07/26 11:39:03 pmadadi noship $ */
3:
4: /*Bug:5354721. The following table holds the name, value type and length of all the
5: lot Attributes of MTL_LOT_NUMBERS table which will then be used in
6: get_lot_att_record procedure to populate the values for the corresponding columns.
7: */
8:
9: g_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1211: x_return_status := fnd_api.g_ret_sts_error;
1212: END populate_records;
1213:
1214: /* Bug 5354721. The following procedure populates the column name, value type and length
1215: of all the Lot Attribute columns in MTL_LOT_NUMBERS in the global table g_lot_attr_tbl.
1216: And this table will be then used in get_lot_attr_record procedure to get the values of the
1217: corresponding columns. Moved this part of code from get_lot_Attr_record to here as this metadata
1218: poupulation can only be done once and be re-used for all the subsequent records.
1219: */
1530:
1531: BEGIN
1532: SELECT COUNT (lot_number)
1533: INTO l_lot_num
1534: FROM mtl_lot_numbers mtl
1535: WHERE lot_number = p_lot_number
1536: AND inventory_item_id = p_inventory_item_id
1537: AND organization_id = p_organization_id;
1538: EXCEPTION
1596: /*Bug:5354721. Appending FROM clause to the global statement. */
1597: l_select_stmt :=
1598: g_select_stmt
1599: || ' FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI, MTL_TRANSACTIONS_INTERFACE MTI, '
1600: || ' MTL_LOT_NUMBERS MLN '
1601: || ' WHERE mtli.transaction_interface_id = :b_interface_id '
1602: || ' AND mtli.lot_number = :b_lot_number '
1603: || ' AND mtli.transaction_interface_id = mti.transaction_interface_id '
1604: || ' AND mln.lot_number = mtli.lot_number (+)'
1611: -- which is the lot number of the parent lot.
1612: l_select_stmt :=
1613: g_select_stmt
1614: || ' FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI, MTL_TRANSACTIONS_INTERFACE MTI, '
1615: || ' MTL_LOT_NUMBERS MLN '
1616: || ' WHERE mtli.transaction_interface_id = :b_interface_id '
1617: || ' AND mtli.lot_number = :b_lot_number '
1618: || ' AND mtli.transaction_interface_id = mti.transaction_interface_id '
1619: || ' AND mln.lot_number = :b_starting_lot_number'