APPS.AP_WEB_LOCATIONS_PKG dependencies on AP_EXP_LOCATIONS

Line 27: -- in the AP_EXP_LOCATIONS table. If it exists, it does nothing.

23: function default_country_pvt(p_card_program_id in number) return varchar2;
24:
25: --
26: -- get_location procedure checks to see if an identical address exists
27: -- in the AP_EXP_LOCATIONS table. If it exists, it does nothing.
28: -- If it doesn't exist, it will populate AP_EXP_LOCATIONS. It will
29: -- also call out to eLocations to populate the spatial coordinates
30: -- NOTE: AP_EXP_LOCATIONS will only be populated if
31: -- MERCHANT_COUNTRY_CODE is non-null.

Line 28: -- If it doesn't exist, it will populate AP_EXP_LOCATIONS. It will

24:
25: --
26: -- get_location procedure checks to see if an identical address exists
27: -- in the AP_EXP_LOCATIONS table. If it exists, it does nothing.
28: -- If it doesn't exist, it will populate AP_EXP_LOCATIONS. It will
29: -- also call out to eLocations to populate the spatial coordinates
30: -- NOTE: AP_EXP_LOCATIONS will only be populated if
31: -- MERCHANT_COUNTRY_CODE is non-null.
32:

Line 30: -- NOTE: AP_EXP_LOCATIONS will only be populated if

26: -- get_location procedure checks to see if an identical address exists
27: -- in the AP_EXP_LOCATIONS table. If it exists, it does nothing.
28: -- If it doesn't exist, it will populate AP_EXP_LOCATIONS. It will
29: -- also call out to eLocations to populate the spatial coordinates
30: -- NOTE: AP_EXP_LOCATIONS will only be populated if
31: -- MERCHANT_COUNTRY_CODE is non-null.
32:
33: ------------------------------------------------------------
34: -- get_location using location_rec

Line 96: from ap_exp_locations

92:
93: begin
94: select location_id, geometry, geometry_status_code
95: into p_loc_array(i).location_id, p_loc_array(i).geometry, p_loc_array(i).geometry_status_code
96: from ap_exp_locations
97: where address_key = p_loc_array(i).address_key;
98:
99: exception
100: when no_data_found then

Line 101: select ap_exp_locations_s.nextval

97: where address_key = p_loc_array(i).address_key;
98:
99: exception
100: when no_data_found then
101: select ap_exp_locations_s.nextval
102: into p_loc_array(i).location_id
103: from dual;
104:
105: get_geometry(p_loc_array(i));

Line 107: insert into ap_exp_locations

103: from dual;
104:
105: get_geometry(p_loc_array(i));
106:
107: insert into ap_exp_locations
108: ( location_id,
109: address_key,
110: address1,
111: address2,