APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_LOCATIONS_VL

Line 815: from ap_pol_locations_vl

811: FUNCTION get_location(p_location_id IN NUMBER) RETURN VARCHAR2 IS
812:
813: CURSOR loc_cur IS
814: select location_id, location
815: from ap_pol_locations_vl
816: where location_type in ('CITY','COUNTRY');
817: l_location varchar2(240);
818: BEGIN
819: IF p_location_id is null THEN

Line 826: select location into l_location from ap_pol_locations_vl where location_id = p_location_id;

822:
823: IF pg_locations_rec.EXISTS(p_location_id) THEN
824: return pg_locations_rec(p_location_id);
825: ELSIF pg_locations_rec.COUNT > 1 THEN
826: select location into l_location from ap_pol_locations_vl where location_id = p_location_id;
827: pg_locations_rec(p_location_id) := l_location;
828: ELSE
829: FOR loc_rec IN loc_cur LOOP
830: pg_locations_rec(loc_rec.location_id) := loc_rec.location;

Line 4420: from ap_pol_locations_vl

4416: PROCEDURE end_date_active_loc_options IS
4417:
4418: CURSOR loc_def_cur IS
4419: select location_id, end_date
4420: from ap_pol_locations_vl
4421: where end_date is not null;
4422:
4423: l_location_id NUMBER;
4424: l_end_date DATE;

Line 7806: from ap_pol_locations_vl

7802: FUNCTION get_location_desc(p_location_id IN NUMBER) RETURN VARCHAR2 IS
7803:
7804: CURSOR loc_desc_cur IS
7805: select location_id, description
7806: from ap_pol_locations_vl
7807: Where Location_Type In ('CITY','COUNTRY');
7808: l_location_desc varchar2(240);
7809: BEGIN
7810: IF p_location_id is null THEN

Line 7817: select description into l_location_desc from ap_pol_locations_vl where location_id = p_location_id;

7813:
7814: IF pg_locations_desc_rec.EXISTS(p_location_id) THEN
7815: return pg_locations_desc_rec(p_location_id);
7816: Elsif pg_locations_desc_rec.Count > 1 Then
7817: select description into l_location_desc from ap_pol_locations_vl where location_id = p_location_id;
7818: pg_locations_desc_rec(p_location_id) := l_location_desc;
7819: ELSE
7820: FOR loc_rec IN loc_desc_cur LOOP
7821: pg_locations_desc_rec(loc_rec.location_id) := loc_rec.description;