APPS.AP_POL_LOCATIONS_PKG dependencies on AP_POL_LOCATIONS_TL

Line 128: delete from AP_POL_LOCATIONS_TL

124: X_LOCATION_ID in NUMBER,
125: X_LANGUAGE in VARCHAR2 --bug 2650513
126: ) is
127: begin
128: delete from AP_POL_LOCATIONS_TL
129: where LOCATION_ID = X_LOCATION_ID;
130:
131: if (sql%notfound) then
132: raise no_data_found;

Line 207: insert into AP_POL_LOCATIONS_TL (

203: X_LAST_UPDATED_BY,
204: X_LAST_UPDATE_LOGIN
205: );
206:
207: insert into AP_POL_LOCATIONS_TL (
208: LOCATION_ID,
209: LOCATION,
210: DESCRIPTION,
211: CREATION_DATE,

Line 235: from AP_POL_LOCATIONS_TL T

231: where L.INSTALLED_FLAG in ('I', 'B')
232: AND BASE.INSTALLED_FLAG = 'B'
233: and not exists
234: (select NULL
235: from AP_POL_LOCATIONS_TL T
236: where T.LOCATION_ID = X_LOCATION_ID
237: and T.LANGUAGE = L.LANGUAGE_CODE);
238:
239: open c;

Line 284: from AP_POL_LOCATIONS_TL

280: cursor c1 is select
281: LOCATION,
282: DESCRIPTION,
283: decode(LANGUAGE, NVL(X_SOURCE_LANG,userenv('LANG')), 'Y', 'N') BASELANG
284: from AP_POL_LOCATIONS_TL
285: where LOCATION_ID = X_LOCATION_ID
286: and NVL(X_SOURCE_LANG,userenv('LANG')) in (LANGUAGE, SOURCE_LANG)
287: for update of LOCATION_ID nowait;
288: begin

Line 377: update AP_POL_LOCATIONS_TL set

373: if (sql%notfound) then
374: raise no_data_found;
375: end if;
376:
377: update AP_POL_LOCATIONS_TL set
378: LOCATION = X_LOCATION,
379: DESCRIPTION = X_DESCRIPTION,
380: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
381: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 396: delete from AP_POL_LOCATIONS_TL T

392:
393: procedure ADD_LANGUAGE (X_LANGUAGE in VARCHAR2,
394: X_SOURCE_LANG in VARCHAR2) is
395: begin
396: delete from AP_POL_LOCATIONS_TL T
397: where not exists
398: (select NULL
399: from AP_POL_LOCATIONS_B B
400: where B.LOCATION_ID = T.LOCATION_ID

Line 403: update AP_POL_LOCATIONS_TL T set (

399: from AP_POL_LOCATIONS_B B
400: where B.LOCATION_ID = T.LOCATION_ID
401: );
402:
403: update AP_POL_LOCATIONS_TL T set (
404: LOCATION,
405: DESCRIPTION
406: ) = (select
407: B.LOCATION,

Line 409: from AP_POL_LOCATIONS_TL B

405: DESCRIPTION
406: ) = (select
407: B.LOCATION,
408: B.DESCRIPTION
409: from AP_POL_LOCATIONS_TL B
410: where B.LOCATION_ID = T.LOCATION_ID
411: and B.LANGUAGE = T.SOURCE_LANG)
412: where (
413: T.LOCATION_ID,

Line 418: from AP_POL_LOCATIONS_TL SUBB, AP_POL_LOCATIONS_TL SUBT

414: T.LANGUAGE
415: ) in (select
416: SUBT.LOCATION_ID,
417: SUBT.LANGUAGE
418: from AP_POL_LOCATIONS_TL SUBB, AP_POL_LOCATIONS_TL SUBT
419: where SUBB.LOCATION_ID = SUBT.LOCATION_ID
420: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
421: and (SUBB.LOCATION <> SUBT.LOCATION
422: or (SUBB.LOCATION is null and SUBT.LOCATION is not null)

Line 429: insert into AP_POL_LOCATIONS_TL (

425: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
426: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
427: ));
428:
429: insert into AP_POL_LOCATIONS_TL (
430: LOCATION_ID,
431: LOCATION,
432: DESCRIPTION,
433: CREATION_DATE,

Line 451: from AP_POL_LOCATIONS_TL B, FND_LANGUAGES L

447: B.LAST_UPDATE_DATE,
448: B.LAST_UPDATED_BY,
449: L.LANGUAGE_CODE,
450: B.SOURCE_LANG
451: from AP_POL_LOCATIONS_TL B, FND_LANGUAGES L
452: where L.INSTALLED_FLAG in ('I', 'B')
453: and B.LANGUAGE = NVL(X_SOURCE_LANG,userenv('LANG'))
454: and not exists
455: (select NULL

Line 456: from AP_POL_LOCATIONS_TL T

452: where L.INSTALLED_FLAG in ('I', 'B')
453: and B.LANGUAGE = NVL(X_SOURCE_LANG,userenv('LANG'))
454: and not exists
455: (select NULL
456: from AP_POL_LOCATIONS_TL T
457: where T.LOCATION_ID = B.LOCATION_ID
458: and T.LANGUAGE = L.LANGUAGE_CODE);
459: end ADD_LANGUAGE;
460: