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 315: delete from AP_TERMS_TL

311: procedure DELETE_ROW (
312: X_TERM_ID in NUMBER
313: ) is
314: begin
315: delete from AP_TERMS_TL
316: where TERM_ID = X_TERM_ID;
317:
318: if (sql%notfound) then
319: raise no_data_found;

Line 327: update AP_TERMS_TL T set (

323:
324: procedure ADD_LANGUAGE
325: is
326: begin
327: update AP_TERMS_TL T set (
328: NAME,
329: DESCRIPTION
330: ) = (select
331: B.NAME,

Line 333: from AP_TERMS_TL B

329: DESCRIPTION
330: ) = (select
331: B.NAME,
332: B.DESCRIPTION
333: from AP_TERMS_TL B
334: where B.TERM_ID = T.TERM_ID
335: and B.LANGUAGE = T.SOURCE_LANG)
336: where (
337: T.TERM_ID,

Line 342: from AP_TERMS_TL SUBB, AP_TERMS_TL SUBT

338: T.LANGUAGE
339: ) in (select
340: SUBT.TERM_ID,
341: SUBT.LANGUAGE
342: from AP_TERMS_TL SUBB, AP_TERMS_TL SUBT
343: where SUBB.TERM_ID = SUBT.TERM_ID
344: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
345: and (SUBB.NAME <> SUBT.NAME
346: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 351: insert into AP_TERMS_TL (

347: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
348: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
349: ));
350:
351: insert into AP_TERMS_TL (
352: TERM_ID,
353: LAST_UPDATE_DATE,
354: LAST_UPDATED_BY,
355: CREATION_DATE,

Line 417: from AP_TERMS_TL B, FND_LANGUAGES L

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

Line 422: from AP_TERMS_TL T

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