APPS.AP_WEB_UPLOAD_PDM_PKG dependencies on AP_POL_LOCATIONS_TL

Line 401: insert into AP_POL_LOCATIONS_TL (

397: --COUNTRY
398: initcap(p_country)
399: );
400:
401: insert into AP_POL_LOCATIONS_TL (
402: LOCATION_ID,
403: LOCATION,
404: DESCRIPTION,
405: CREATION_DATE,

Line 439: from AP_POL_LOCATIONS_TL T

435: where L.INSTALLED_FLAG in ('I', 'B')
436: AND BASE.INSTALLED_FLAG = 'B'
437: and not exists
438: (select NULL
439: from AP_POL_LOCATIONS_TL T
440: where T.LOCATION_ID = l_location_id
441: and T.LANGUAGE = L.LANGUAGE_CODE);
442:
443: if (p_location_type = 'CITY') then