eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_CITY_PKG dependencies on PER_ADDRESSES

Line 803: -- To check a given city exists in the per_addresses table

799: ------------------------------------------------------------------------------
800: -- Name
801: -- chk_city_in_addr
802: -- Purpose
803: -- To check a given city exists in the per_addresses table
804: -- It would not allow the city to be deleted if it is referenced in
805: -- the per_addresses table. Validation check to prevent deletion
806: -- if city is referenced.
807: -- Notes

Line 805: -- the per_addresses table. Validation check to prevent deletion

801: -- chk_city_in_addr
802: -- Purpose
803: -- To check a given city exists in the per_addresses table
804: -- It would not allow the city to be deleted if it is referenced in
805: -- the per_addresses table. Validation check to prevent deletion
806: -- if city is referenced.
807: -- Notes
808: -- This only confirms the existence of a city in the per_addresses
809: -- table if and only if the city within an state and county

Line 808: -- This only confirms the existence of a city in the per_addresses

804: -- It would not allow the city to be deleted if it is referenced in
805: -- the per_addresses table. Validation check to prevent deletion
806: -- if city is referenced.
807: -- Notes
808: -- This only confirms the existence of a city in the per_addresses
809: -- table if and only if the city within an state and county
810: -- matches to that of the per_addresses table.
811: ------------------------------------------------------------------------------
812: PROCEDURE chk_city_in_addr(p_state_abbrev VARCHAR2,

Line 810: -- matches to that of the per_addresses table.

806: -- if city is referenced.
807: -- Notes
808: -- This only confirms the existence of a city in the per_addresses
809: -- table if and only if the city within an state and county
810: -- matches to that of the per_addresses table.
811: ------------------------------------------------------------------------------
812: PROCEDURE chk_city_in_addr(p_state_abbrev VARCHAR2,
813: p_county_name VARCHAR2,
814: p_city_name VARCHAR2) IS

Line 823: FROM per_addresses

819: CURSOR C1 is SELECT 'x'
820: FROM dual
821: where exists(
822: SELECT region_1,town_or_city
823: FROM per_addresses
824: WHERE region_1 = l_prov_abbrev
825: AND town_or_city = p_city_name
826: AND ROWNUM < 2);
827:

Line 833: -- Note that in per_addresses table town_or_city, region 2 and region 1

829: CURSOR C2 is SELECT 'x'
830: FROM dual
831: where exists(
832: SELECT region_1,region_2,town_or_city
833: -- Note that in per_addresses table town_or_city, region 2 and region 1
834: -- are refered to as
835: -- city name, state abbreviation and county name respectively.
836: FROM per_addresses
837: WHERE region_2 = p_state_abbrev

Line 836: FROM per_addresses

832: SELECT region_1,region_2,town_or_city
833: -- Note that in per_addresses table town_or_city, region 2 and region 1
834: -- are refered to as
835: -- city name, state abbreviation and county name respectively.
836: FROM per_addresses
837: WHERE region_2 = p_state_abbrev
838: AND region_1 = p_county_name
839: AND town_or_city = p_city_name
840: AND ROWNUM < 2);