APPS.FND_BUSINESS_PURPOSES_PKG dependencies on FND_BUSINESS_PURPOSES_TL

Line 95: insert into FND_BUSINESS_PURPOSES_TL (

91: X_LAST_UPDATE_LOGIN,
92: X_PURPOSE_DEFAULT_CODE
93: );
94:
95: insert into FND_BUSINESS_PURPOSES_TL (
96: PURPOSE_CODE,
97: PURPOSE_NAME,
98: DESCRIPTION,
99: DESCRIPTION_INT,

Line 123: from FND_BUSINESS_PURPOSES_TL T

119: from FND_LANGUAGES L
120: where L.INSTALLED_FLAG in ('I', 'B')
121: and not exists
122: (select NULL
123: from FND_BUSINESS_PURPOSES_TL T
124: where T.PURPOSE_CODE = X_PURPOSE_CODE
125: and T.LANGUAGE = L.LANGUAGE_CODE);
126:
127: open c;

Line 194: from FND_BUSINESS_PURPOSES_TL

190: PURPOSE_NAME,
191: DESCRIPTION,
192: DESCRIPTION_INT,
193: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
194: from FND_BUSINESS_PURPOSES_TL
195: where PURPOSE_CODE = X_PURPOSE_CODE
196: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
197: for update of PURPOSE_CODE nowait;
198: begin

Line 329: update FND_BUSINESS_PURPOSES_TL set

325: if (sql%notfound) then
326: raise no_data_found;
327: end if;
328:
329: update FND_BUSINESS_PURPOSES_TL set
330: PURPOSE_NAME = X_PURPOSE_NAME,
331: DESCRIPTION = X_DESCRIPTION,
332: DESCRIPTION_INT = X_DESCRIPTION_INT,
333: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 349: delete from FND_BUSINESS_PURPOSES_TL

345: procedure DELETE_ROW (
346: X_PURPOSE_CODE in VARCHAR2
347: ) is
348: begin
349: delete from FND_BUSINESS_PURPOSES_TL
350: where PURPOSE_CODE = X_PURPOSE_CODE;
351:
352: if (sql%notfound) then
353: raise no_data_found;

Line 367: delete from FND_BUSINESS_PURPOSES_TL T

363:
364: procedure ADD_LANGUAGE
365: is
366: begin
367: delete from FND_BUSINESS_PURPOSES_TL T
368: where not exists
369: (select NULL
370: from FND_BUSINESS_PURPOSES_B B
371: where B.PURPOSE_CODE = T.PURPOSE_CODE

Line 374: update FND_BUSINESS_PURPOSES_TL T set (

370: from FND_BUSINESS_PURPOSES_B B
371: where B.PURPOSE_CODE = T.PURPOSE_CODE
372: );
373:
374: update FND_BUSINESS_PURPOSES_TL T set (
375: PURPOSE_NAME,
376: DESCRIPTION,
377: DESCRIPTION_INT
378: ) = (select

Line 382: from FND_BUSINESS_PURPOSES_TL B

378: ) = (select
379: B.PURPOSE_NAME,
380: B.DESCRIPTION,
381: B.DESCRIPTION_INT
382: from FND_BUSINESS_PURPOSES_TL B
383: where B.PURPOSE_CODE = T.PURPOSE_CODE
384: and B.LANGUAGE = T.SOURCE_LANG)
385: where (
386: T.PURPOSE_CODE,

Line 391: from FND_BUSINESS_PURPOSES_TL SUBB, FND_BUSINESS_PURPOSES_TL SUBT

387: T.LANGUAGE
388: ) in (select
389: SUBT.PURPOSE_CODE,
390: SUBT.LANGUAGE
391: from FND_BUSINESS_PURPOSES_TL SUBB, FND_BUSINESS_PURPOSES_TL SUBT
392: where SUBB.PURPOSE_CODE = SUBT.PURPOSE_CODE
393: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
394: and (SUBB.PURPOSE_NAME <> SUBT.PURPOSE_NAME
395: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 403: insert into FND_BUSINESS_PURPOSES_TL (

399: or (SUBB.DESCRIPTION_INT is null and SUBT.DESCRIPTION_INT is not null)
400: or (SUBB.DESCRIPTION_INT is not null and SUBT.DESCRIPTION_INT is null)
401: ));
402:
403: insert into FND_BUSINESS_PURPOSES_TL (
404: PURPOSE_CODE,
405: PURPOSE_NAME,
406: DESCRIPTION,
407: DESCRIPTION_INT,

Line 427: from FND_BUSINESS_PURPOSES_TL B, FND_LANGUAGES L

423: B.LAST_UPDATE_DATE,
424: B.LAST_UPDATE_LOGIN,
425: L.LANGUAGE_CODE,
426: B.SOURCE_LANG
427: from FND_BUSINESS_PURPOSES_TL B, FND_LANGUAGES L
428: where L.INSTALLED_FLAG in ('I', 'B')
429: and B.LANGUAGE = userenv('LANG')
430: and not exists
431: (select NULL

Line 432: from FND_BUSINESS_PURPOSES_TL T

428: where L.INSTALLED_FLAG in ('I', 'B')
429: and B.LANGUAGE = userenv('LANG')
430: and not exists
431: (select NULL
432: from FND_BUSINESS_PURPOSES_TL T
433: where T.PURPOSE_CODE = B.PURPOSE_CODE
434: and T.LANGUAGE = L.LANGUAGE_CODE);
435: end ADD_LANGUAGE;
436:

Line 446: Update FND_BUSINESS_PURPOSES_TL set

442: x_last_update_login in number)
443: is
444: begin
445:
446: Update FND_BUSINESS_PURPOSES_TL set
447: purpose_name = nvl(x_PURPOSE_NAME,purpose_name),
448: last_update_date = nvl(x_last_update_date,sysdate),
449: last_updated_by = x_last_updated_by,
450: last_update_login = 0,