APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 2131: FOR l_column_csr IN column_csr ('MTL_TRANSACTION_LOTS_INTERFACE'

2127: , l_industry
2128: , l_oracle_schema
2129: );
2130:
2131: FOR l_column_csr IN column_csr ('MTL_TRANSACTION_LOTS_INTERFACE'
2132: , l_oracle_schema
2133: )
2134: LOOP
2135: l_column_idx := l_column_idx + 1;

Line 5115: UPDATE mtl_transaction_lots_interface mtli

5111: , 'Compute Lot Exp'
5112: );
5113:
5114: BEGIN
5115: UPDATE mtl_transaction_lots_interface mtli
5116: SET lot_expiration_date =
5117: fnd_date.canonical_to_date (l_lotexpdate)
5118: WHERE transaction_interface_id IN (
5119: SELECT transaction_interface_id

Line 5129: , 'MTL_TRANSACTION_LOTS_INTERFACE'

5125: WHEN OTHERS
5126: THEN
5127: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5128: fnd_message.set_token ('ENTITY1'
5129: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5130: );
5131: fnd_msg_pub.ADD;
5132: RAISE fnd_api.g_exc_unexpected_error;
5133: END;

Line 5180: UPDATE mtl_transaction_lots_interface mtli

5176: p_rs_lot_exp_tbl (1) := fnd_date.canonical_to_date (l_lotexpdate);
5177:
5178: -- update the resulting lot with the exp. date.
5179: BEGIN
5180: UPDATE mtl_transaction_lots_interface mtli
5181: SET lot_expiration_date =
5182: fnd_date.canonical_to_date (l_lotexpdate)
5183: WHERE transaction_interface_id IN (
5184: SELECT transaction_interface_id

Line 5195: , 'MTL_TRANSACTION_LOTS_INTERFACE'

5191: WHEN OTHERS
5192: THEN
5193: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5194: fnd_message.set_token ('ENTITY1'
5195: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5196: );
5197: fnd_msg_pub.ADD;
5198: RAISE fnd_api.g_exc_unexpected_error;
5199: END;

Line 5235: UPDATE mtl_transaction_lots_interface mtli

5231: RAISE fnd_api.g_exc_unexpected_error;
5232: END IF;
5233:
5234: BEGIN
5235: UPDATE mtl_transaction_lots_interface mtli
5236: SET lot_expiration_date =
5237: fnd_date.canonical_to_date (l_lotexpdate)
5238: WHERE transaction_interface_id IN (
5239: SELECT transaction_interface_id

Line 5249: , 'MTL_TRANSACTION_LOTS_INTERFACE'

5245: WHEN OTHERS
5246: THEN
5247: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5248: fnd_message.set_token ('ENTITY1'
5249: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5250: );
5251: fnd_msg_pub.ADD;
5252: RAISE fnd_api.g_exc_unexpected_error;
5253: END;

Line 5306: UPDATE mtl_transaction_lots_interface mtli

5302: RAISE fnd_api.g_exc_unexpected_error;
5303: END IF;
5304:
5305: BEGIN
5306: UPDATE mtl_transaction_lots_interface mtli
5307: SET lot_expiration_date =
5308: fnd_date.canonical_to_date (l_lotexpdate)
5309: WHERE transaction_interface_id IN (
5310: SELECT transaction_interface_id

Line 5321: , 'MTL_TRANSACTION_LOTS_INTERFACE'

5317: WHEN OTHERS
5318: THEN
5319: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5320: fnd_message.set_token ('ENTITY1'
5321: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5322: );
5323: fnd_msg_pub.ADD;
5324: RAISE fnd_api.g_exc_unexpected_error;
5325: END;

Line 5395: UPDATE mtl_transaction_lots_interface mtli

5391: RAISE fnd_api.g_exc_unexpected_error;
5392: END IF;
5393:
5394: BEGIN
5395: UPDATE mtl_transaction_lots_interface mtli
5396: SET lot_expiration_date =
5397: fnd_date.canonical_to_date (l_lotexpdate)
5398: WHERE transaction_interface_id IN (
5399: SELECT transaction_interface_id

Line 5410: , 'MTL_TRANSACTION_LOTS_INTERFACE'

5406: WHEN OTHERS
5407: THEN
5408: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5409: fnd_message.set_token ('ENTITY1'
5410: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5411: );
5412: fnd_msg_pub.ADD;
5413: RAISE fnd_api.g_exc_unexpected_error;
5414: END;

Line 5455: UPDATE mtl_transaction_lots_interface mtli

5451: RAISE fnd_api.g_exc_unexpected_error;
5452: END IF;
5453:
5454: BEGIN
5455: UPDATE mtl_transaction_lots_interface mtli
5456: SET lot_expiration_date =
5457: fnd_date.canonical_to_date (l_lotexpdate)
5458: WHERE transaction_interface_id IN (
5459: SELECT transaction_interface_id

Line 5470: , 'MTL_TRANSACTION_LOTS_INTERFACE'

5466: WHEN OTHERS
5467: THEN
5468: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5469: fnd_message.set_token ('ENTITY1'
5470: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5471: );
5472: fnd_msg_pub.ADD;
5473: RAISE fnd_api.g_exc_unexpected_error;
5474: END;