APPS.AP_TERMS_PKG dependencies on AP_TERMS_TL

Line 37: cursor C is select ROWID from AP_TERMS_TL

33: X_LAST_UPDATE_DATE in DATE,
34: X_LAST_UPDATED_BY in NUMBER,
35: X_LAST_UPDATE_LOGIN in NUMBER
36: ) is
37: cursor C is select ROWID from AP_TERMS_TL
38: where TERM_ID = X_TERM_ID
39: and LANGUAGE = userenv('LANG')
40: ;
41: begin

Line 42: insert into AP_TERMS_TL (

38: where TERM_ID = X_TERM_ID
39: and LANGUAGE = userenv('LANG')
40: ;
41: begin
42: insert into AP_TERMS_TL (
43: TERM_ID,
44: LAST_UPDATE_DATE,
45: LAST_UPDATED_BY,
46: CREATION_DATE,

Line 112: from AP_TERMS_TL T

108: from FND_LANGUAGES L
109: where L.INSTALLED_FLAG in ('I', 'B')
110: and not exists
111: (select NULL
112: from AP_TERMS_TL T
113: where T.TERM_ID = X_TERM_ID
114: and T.LANGUAGE = L.LANGUAGE_CODE);
115:
116: open c;

Line 179: from AP_TERMS_TL

175: ATTRIBUTE15,
176: NAME,
177: DESCRIPTION,
178: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
179: from AP_TERMS_TL
180: where TERM_ID = X_TERM_ID
181: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
182: for update of TERM_ID nowait;
183: begin

Line 274: update AP_TERMS_TL set

270: X_LAST_UPDATED_BY in NUMBER,
271: X_LAST_UPDATE_LOGIN in NUMBER
272: ) is
273: begin
274: update AP_TERMS_TL set
275: ENABLED_FLAG = X_ENABLED_FLAG,
276: DUE_CUTOFF_DAY = X_DUE_CUTOFF_DAY,
277: TYPE = X_TYPE,
278: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 319: delete from AP_TERMS_TL

315: procedure DELETE_ROW (
316: X_TERM_ID in NUMBER
317: ) is
318: begin
319: delete from AP_TERMS_TL
320: where TERM_ID = X_TERM_ID;
321:
322: if (sql%notfound) then
323: raise no_data_found;

Line 331: update AP_TERMS_TL T set (

327:
328: procedure ADD_LANGUAGE
329: is
330: begin
331: update AP_TERMS_TL T set (
332: NAME,
333: DESCRIPTION
334: ) = (select
335: B.NAME,

Line 337: from AP_TERMS_TL B

333: DESCRIPTION
334: ) = (select
335: B.NAME,
336: B.DESCRIPTION
337: from AP_TERMS_TL B
338: where B.TERM_ID = T.TERM_ID
339: and B.LANGUAGE = T.SOURCE_LANG)
340: where (
341: T.TERM_ID,

Line 346: from AP_TERMS_TL SUBB, AP_TERMS_TL SUBT

342: T.LANGUAGE
343: ) in (select
344: SUBT.TERM_ID,
345: SUBT.LANGUAGE
346: from AP_TERMS_TL SUBB, AP_TERMS_TL SUBT
347: where SUBB.TERM_ID = SUBT.TERM_ID
348: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
349: and (SUBB.NAME <> SUBT.NAME
350: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 355: insert into AP_TERMS_TL (

351: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
352: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
353: ));
354:
355: insert into AP_TERMS_TL (
356: TERM_ID,
357: LAST_UPDATE_DATE,
358: LAST_UPDATED_BY,
359: CREATION_DATE,

Line 421: from AP_TERMS_TL B, FND_LANGUAGES L

417: B.ATTRIBUTE14,
418: B.ATTRIBUTE15,
419: L.LANGUAGE_CODE,
420: B.SOURCE_LANG
421: from AP_TERMS_TL B, FND_LANGUAGES L
422: where L.INSTALLED_FLAG in ('I', 'B')
423: and B.LANGUAGE = userenv('LANG')
424: and not exists
425: (select NULL

Line 426: from AP_TERMS_TL T

422: where L.INSTALLED_FLAG in ('I', 'B')
423: and B.LANGUAGE = userenv('LANG')
424: and not exists
425: (select NULL
426: from AP_TERMS_TL T
427: where T.TERM_ID = B.TERM_ID
428: and T.LANGUAGE = L.LANGUAGE_CODE);
429: end ADD_LANGUAGE;
430: