DBA Data[Home] [Help]

APPS.INV_RECEIVING_TRANSACTION dependencies on INV_CACHE

Line 506: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))

502: IF (l_debug = 1) THEN
503: print_debug('Number of MOL updated: '||SQL%rowcount,4);
504: END IF;
505: -- 13564609 starts
506: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
507:
508: THEN
509: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
510:

Line 509: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;

505: -- 13564609 starts
506: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
507:
508: THEN
509: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
510:
511: END IF;
512:
513: print_debug('serial control code :'||l_ser_ctrl_code,4);

Line 658: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))

654: print_debug('Number of MOL updated: '||SQL%rowcount,4);
655: END IF;
656:
657: -- 13564609 starts
658: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
659:
660: THEN
661: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
662:

Line 661: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;

657: -- 13564609 starts
658: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
659:
660: THEN
661: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
662:
663: END IF;
664:
665: print_debug('serial control code :'||l_ser_ctrl_code,4);

Line 812: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))

808: IF (l_debug = 1) THEN
809: print_debug('Number of MOL updated: '||SQL%rowcount,4);
810: END IF;
811: -- 13564609 starts
812: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
813:
814: THEN
815: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
816:

Line 815: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;

811: -- 13564609 starts
812: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
813:
814: THEN
815: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
816:
817: END IF;
818:
819: print_debug('serial control code :'||l_ser_ctrl_code,4);

Line 968: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))

964: IF (l_debug = 1) THEN
965: print_debug('Number of MOL updated: '||SQL%rowcount,4);
966: END IF;
967: -- 13564609 starts
968: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
969:
970: THEN
971: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
972:

Line 971: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;

967: -- 13564609 starts
968: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
969:
970: THEN
971: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
972:
973: END IF;
974:
975: print_debug('serial control code :'||l_ser_ctrl_code,4);