APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 2080: FOR l_column_csr IN column_csr ('MTL_TRANSACTION_LOTS_INTERFACE'

2076: , l_industry
2077: , l_oracle_schema
2078: );
2079:
2080: FOR l_column_csr IN column_csr ('MTL_TRANSACTION_LOTS_INTERFACE'
2081: , l_oracle_schema
2082: )
2083: LOOP
2084: l_column_idx := l_column_idx + 1;

Line 5086: UPDATE mtl_transaction_lots_interface mtli

5082: , 'Compute Lot Exp'
5083: );
5084:
5085: BEGIN
5086: UPDATE mtl_transaction_lots_interface mtli
5087: SET lot_expiration_date =
5088: fnd_date.canonical_to_date (l_lotexpdate)
5089: WHERE transaction_interface_id IN (
5090: SELECT transaction_interface_id

Line 5100: , 'MTL_TRANSACTION_LOTS_INTERFACE'

5096: WHEN OTHERS
5097: THEN
5098: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5099: fnd_message.set_token ('ENTITY1'
5100: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5101: );
5102: fnd_msg_pub.ADD;
5103: RAISE fnd_api.g_exc_unexpected_error;
5104: END;

Line 5151: UPDATE mtl_transaction_lots_interface mtli

5147: p_rs_lot_exp_tbl (1) := fnd_date.canonical_to_date (l_lotexpdate);
5148:
5149: -- update the resulting lot with the exp. date.
5150: BEGIN
5151: UPDATE mtl_transaction_lots_interface mtli
5152: SET lot_expiration_date =
5153: fnd_date.canonical_to_date (l_lotexpdate)
5154: WHERE transaction_interface_id IN (
5155: SELECT transaction_interface_id

Line 5166: , 'MTL_TRANSACTION_LOTS_INTERFACE'

5162: WHEN OTHERS
5163: THEN
5164: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5165: fnd_message.set_token ('ENTITY1'
5166: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5167: );
5168: fnd_msg_pub.ADD;
5169: RAISE fnd_api.g_exc_unexpected_error;
5170: END;

Line 5206: UPDATE mtl_transaction_lots_interface mtli

5202: RAISE fnd_api.g_exc_unexpected_error;
5203: END IF;
5204:
5205: BEGIN
5206: UPDATE mtl_transaction_lots_interface mtli
5207: SET lot_expiration_date =
5208: fnd_date.canonical_to_date (l_lotexpdate)
5209: WHERE transaction_interface_id IN (
5210: SELECT transaction_interface_id

Line 5220: , 'MTL_TRANSACTION_LOTS_INTERFACE'

5216: WHEN OTHERS
5217: THEN
5218: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5219: fnd_message.set_token ('ENTITY1'
5220: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5221: );
5222: fnd_msg_pub.ADD;
5223: RAISE fnd_api.g_exc_unexpected_error;
5224: END;

Line 5277: UPDATE mtl_transaction_lots_interface mtli

5273: RAISE fnd_api.g_exc_unexpected_error;
5274: END IF;
5275:
5276: BEGIN
5277: UPDATE mtl_transaction_lots_interface mtli
5278: SET lot_expiration_date =
5279: fnd_date.canonical_to_date (l_lotexpdate)
5280: WHERE transaction_interface_id IN (
5281: SELECT transaction_interface_id

Line 5292: , 'MTL_TRANSACTION_LOTS_INTERFACE'

5288: WHEN OTHERS
5289: THEN
5290: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5291: fnd_message.set_token ('ENTITY1'
5292: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5293: );
5294: fnd_msg_pub.ADD;
5295: RAISE fnd_api.g_exc_unexpected_error;
5296: END;

Line 5366: UPDATE mtl_transaction_lots_interface mtli

5362: RAISE fnd_api.g_exc_unexpected_error;
5363: END IF;
5364:
5365: BEGIN
5366: UPDATE mtl_transaction_lots_interface mtli
5367: SET lot_expiration_date =
5368: fnd_date.canonical_to_date (l_lotexpdate)
5369: WHERE transaction_interface_id IN (
5370: SELECT transaction_interface_id

Line 5381: , 'MTL_TRANSACTION_LOTS_INTERFACE'

5377: WHEN OTHERS
5378: THEN
5379: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5380: fnd_message.set_token ('ENTITY1'
5381: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5382: );
5383: fnd_msg_pub.ADD;
5384: RAISE fnd_api.g_exc_unexpected_error;
5385: END;

Line 5426: UPDATE mtl_transaction_lots_interface mtli

5422: RAISE fnd_api.g_exc_unexpected_error;
5423: END IF;
5424:
5425: BEGIN
5426: UPDATE mtl_transaction_lots_interface mtli
5427: SET lot_expiration_date =
5428: fnd_date.canonical_to_date (l_lotexpdate)
5429: WHERE transaction_interface_id IN (
5430: SELECT transaction_interface_id

Line 5441: , 'MTL_TRANSACTION_LOTS_INTERFACE'

5437: WHEN OTHERS
5438: THEN
5439: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5440: fnd_message.set_token ('ENTITY1'
5441: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5442: );
5443: fnd_msg_pub.ADD;
5444: RAISE fnd_api.g_exc_unexpected_error;
5445: END;