APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on RCV_LOT_TRANSACTIONS

Line 2753: from rcv_lot_transactions

2749: IF l_lot_ctl_code = 2 THEN
2750: BEGIN
2751: Select lot_num
2752: into l_lot_number
2753: from rcv_lot_transactions
2754: where source_transaction_id = I.transaction_id;
2755: EXCEPTION
2756: WHEN NO_DATA_FOUND THEN
2757: IF ( l_error_level >= G_debug_level) THEN

Line 3591: from rcv_lot_transactions

3587: IF RCV.lot_control_code = 2 THEN
3588: BEGIN
3589: Select lot_num
3590: into l_lot_num
3591: from rcv_lot_transactions
3592: where source_transaction_id = DEL.transaction_id;
3593: EXCEPTION
3594: WHEN NO_DATA_FOUND THEN
3595: IF ( l_error_level >= G_debug_level) THEN

Line 3959: from rcv_lot_transactions

3955: IF RCV.lot_control_code = 2 THEN
3956: BEGIN
3957: Select lot_num
3958: into l_lot_num
3959: from rcv_lot_transactions
3960: where source_transaction_id = DEL.transaction_id;
3961: EXCEPTION
3962: WHEN NO_DATA_FOUND THEN
3963: IF ( l_error_level >= G_debug_level) THEN

Line 4234: from rcv_lot_transactions

4230: IF RCV.lot_control_code = 2 THEN
4231: BEGIN
4232: Select lot_num
4233: into l_lot_num
4234: from rcv_lot_transactions
4235: where source_transaction_id = RCV.transaction_id;
4236: EXCEPTION
4237: WHEN NO_DATA_FOUND THEN
4238: IF ( l_error_level >= G_debug_level) THEN

Line 5007: from rcv_lot_transactions

5003: IF RCV.lot_control_code = 2 THEN
5004: BEGIN
5005: Select lot_num
5006: into l_lot_num
5007: from rcv_lot_transactions
5008: where source_transaction_id = DEL.transaction_id;
5009: EXCEPTION
5010: WHEN NO_DATA_FOUND THEN
5011: IF ( l_error_level >= G_debug_level) THEN

Line 5380: from rcv_lot_transactions

5376: IF RCV.lot_control_code = 2 THEN
5377: BEGIN
5378: Select lot_num
5379: into l_lot_num
5380: from rcv_lot_transactions
5381: where source_transaction_id = DEL.transaction_id;
5382: EXCEPTION
5383: WHEN NO_DATA_FOUND THEN
5384: IF ( l_error_level >= G_debug_level) THEN

Line 5668: from rcv_lot_transactions

5664: IF RCV.lot_control_code = 2 THEN
5665: BEGIN
5666: Select lot_num
5667: into l_lot_num
5668: from rcv_lot_transactions
5669: where source_transaction_id = RCV.transaction_id;
5670: EXCEPTION
5671: WHEN NO_DATA_FOUND THEN
5672: IF ( l_error_level >= G_debug_level) THEN