APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on RCV_LOT_TRANSACTIONS

Line 2835: from rcv_lot_transactions

2831: IF l_lot_ctl_code = 2 THEN
2832: BEGIN
2833: Select lot_num
2834: into l_lot_number
2835: from rcv_lot_transactions
2836: where source_transaction_id = I.transaction_id;
2837: EXCEPTION
2838: WHEN NO_DATA_FOUND THEN
2839: IF ( l_error_level >= G_debug_level) THEN

Line 3752: from rcv_lot_transactions

3748: IF RCV.lot_control_code = 2 THEN
3749: BEGIN
3750: Select lot_num
3751: into l_lot_num
3752: from rcv_lot_transactions
3753: where source_transaction_id = DEL.transaction_id;
3754: EXCEPTION
3755: WHEN NO_DATA_FOUND THEN
3756: IF ( l_error_level >= G_debug_level) THEN

Line 4120: from rcv_lot_transactions

4116: IF RCV.lot_control_code = 2 THEN
4117: BEGIN
4118: Select lot_num
4119: into l_lot_num
4120: from rcv_lot_transactions
4121: where source_transaction_id = DEL.transaction_id;
4122: EXCEPTION
4123: WHEN NO_DATA_FOUND THEN
4124: IF ( l_error_level >= G_debug_level) THEN

Line 4395: from rcv_lot_transactions

4391: IF RCV.lot_control_code = 2 THEN
4392: BEGIN
4393: Select lot_num
4394: into l_lot_num
4395: from rcv_lot_transactions
4396: where source_transaction_id = RCV.transaction_id;
4397: EXCEPTION
4398: WHEN NO_DATA_FOUND THEN
4399: IF ( l_error_level >= G_debug_level) THEN

Line 5168: from rcv_lot_transactions

5164: IF RCV.lot_control_code = 2 THEN
5165: BEGIN
5166: Select lot_num
5167: into l_lot_num
5168: from rcv_lot_transactions
5169: where source_transaction_id = DEL.transaction_id;
5170: EXCEPTION
5171: WHEN NO_DATA_FOUND THEN
5172: IF ( l_error_level >= G_debug_level) THEN

Line 5541: from rcv_lot_transactions

5537: IF RCV.lot_control_code = 2 THEN
5538: BEGIN
5539: Select lot_num
5540: into l_lot_num
5541: from rcv_lot_transactions
5542: where source_transaction_id = DEL.transaction_id;
5543: EXCEPTION
5544: WHEN NO_DATA_FOUND THEN
5545: IF ( l_error_level >= G_debug_level) THEN

Line 5829: from rcv_lot_transactions

5825: IF RCV.lot_control_code = 2 THEN
5826: BEGIN
5827: Select lot_num
5828: into l_lot_num
5829: from rcv_lot_transactions
5830: where source_transaction_id = RCV.transaction_id;
5831: EXCEPTION
5832: WHEN NO_DATA_FOUND THEN
5833: IF ( l_error_level >= G_debug_level) THEN