APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on FND_TERRITORIES_VL

Line 1496: x_code fnd_territories_vl.territory_code%TYPE := NULL;

1492: ===========================================================================*/
1493: PROCEDURE validate_country_of_origin(
1494: x_country_of_origin_record IN OUT NOCOPY rcv_shipment_line_sv.country_of_origin_record_type
1495: ) IS
1496: x_code fnd_territories_vl.territory_code%TYPE := NULL;
1497: x_progress VARCHAR2(3);
1498: x_error_status VARCHAR2(1);
1499: BEGIN
1500: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 1504: FROM fnd_territories_vl

1500: x_error_status := rcv_error_pkg.g_ret_sts_error;
1501:
1502: SELECT NVL(MAX(territory_code), 'FF')
1503: INTO x_code
1504: FROM fnd_territories_vl
1505: WHERE territory_code = x_country_of_origin_record.country_of_origin_code;
1506:
1507: IF (x_code = 'FF') THEN
1508: rcv_error_pkg.set_error_message('RCV_ASN_ORIGIN_COUNTRY_INVALID');