APPS.AR_DUNNING_LETTERS_PKG dependencies on AR_DUNNING_LETTERS_TL

Line 89: insert into AR_DUNNING_LETTERS_TL (

85: X_LAST_UPDATED_BY,
86: X_LAST_UPDATE_LOGIN
87: );
88:
89: insert into AR_DUNNING_LETTERS_TL (
90: LAST_UPDATE_DATE,
91: CREATION_DATE,
92: CREATED_BY,
93: LAST_UPDATED_BY,

Line 115: from AR_DUNNING_LETTERS_TL T

111: from FND_LANGUAGES L
112: where L.INSTALLED_FLAG in ('I', 'B')
113: and not exists
114: (select NULL
115: from AR_DUNNING_LETTERS_TL T
116: where T.DUNNING_LETTER_ID = X_DUNNING_LETTER_ID
117: and T.LANGUAGE = L.LANGUAGE_CODE);
118:
119: open c;

Line 180: from AR_DUNNING_LETTERS_TL

176: cursor c1 is select
177: LETTER_NAME,
178: DESCRIPTION,
179: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
180: from AR_DUNNING_LETTERS_TL
181: where DUNNING_LETTER_ID = X_DUNNING_LETTER_ID
182: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
183: for update of DUNNING_LETTER_ID nowait;
184: begin

Line 307: update AR_DUNNING_LETTERS_TL set

303: if (sql%notfound) then
304: raise no_data_found;
305: end if;
306:
307: update AR_DUNNING_LETTERS_TL set
308: LETTER_NAME = X_LETTER_NAME,
309: DESCRIPTION = X_DESCRIPTION,
310: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
311: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 326: delete from AR_DUNNING_LETTERS_TL

322: procedure DELETE_ROW (
323: X_DUNNING_LETTER_ID in NUMBER
324: ) is
325: begin
326: delete from AR_DUNNING_LETTERS_TL
327: where DUNNING_LETTER_ID = X_DUNNING_LETTER_ID;
328:
329: if (sql%notfound) then
330: raise no_data_found;

Line 344: delete from AR_DUNNING_LETTERS_TL T

340:
341: procedure ADD_LANGUAGE
342: is
343: begin
344: delete from AR_DUNNING_LETTERS_TL T
345: where not exists
346: (select NULL
347: from AR_DUNNING_LETTERS_B B
348: where B.DUNNING_LETTER_ID = T.DUNNING_LETTER_ID

Line 351: update AR_DUNNING_LETTERS_TL T set (

347: from AR_DUNNING_LETTERS_B B
348: where B.DUNNING_LETTER_ID = T.DUNNING_LETTER_ID
349: );
350:
351: update AR_DUNNING_LETTERS_TL T set (
352: LETTER_NAME,
353: DESCRIPTION
354: ) = (select
355: B.LETTER_NAME,

Line 357: from AR_DUNNING_LETTERS_TL B

353: DESCRIPTION
354: ) = (select
355: B.LETTER_NAME,
356: B.DESCRIPTION
357: from AR_DUNNING_LETTERS_TL B
358: where B.DUNNING_LETTER_ID = T.DUNNING_LETTER_ID
359: and B.LANGUAGE = T.SOURCE_LANG)
360: where (
361: T.DUNNING_LETTER_ID,

Line 366: from AR_DUNNING_LETTERS_TL SUBB, AR_DUNNING_LETTERS_TL SUBT

362: T.LANGUAGE
363: ) in (select
364: SUBT.DUNNING_LETTER_ID,
365: SUBT.LANGUAGE
366: from AR_DUNNING_LETTERS_TL SUBB, AR_DUNNING_LETTERS_TL SUBT
367: where SUBB.DUNNING_LETTER_ID = SUBT.DUNNING_LETTER_ID
368: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
369: and (SUBB.LETTER_NAME <> SUBT.LETTER_NAME
370: or (SUBB.LETTER_NAME is null and SUBT.LETTER_NAME is not null)

Line 377: insert into AR_DUNNING_LETTERS_TL (

373: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
374: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
375: ));
376:
377: insert into AR_DUNNING_LETTERS_TL (
378: LAST_UPDATE_DATE,
379: CREATION_DATE,
380: CREATED_BY,
381: LAST_UPDATED_BY,

Line 399: from AR_DUNNING_LETTERS_TL B, FND_LANGUAGES L

395: B.DESCRIPTION,
396: B.LETTER_NAME,
397: L.LANGUAGE_CODE,
398: B.SOURCE_LANG
399: from AR_DUNNING_LETTERS_TL B, FND_LANGUAGES L
400: where L.INSTALLED_FLAG in ('I', 'B')
401: and B.LANGUAGE = userenv('LANG')
402: and not exists
403: (select NULL

Line 404: from AR_DUNNING_LETTERS_TL T

400: where L.INSTALLED_FLAG in ('I', 'B')
401: and B.LANGUAGE = userenv('LANG')
402: and not exists
403: (select NULL
404: from AR_DUNNING_LETTERS_TL T
405: where T.DUNNING_LETTER_ID = B.DUNNING_LETTER_ID
406: and T.LANGUAGE = L.LANGUAGE_CODE);
407: end ADD_LANGUAGE;
408:

Line 515: update AR_DUNNING_LETTERS_TL set

511: BEGIN
512:
513: -- only update rows that have not been altered by user
514:
515: update AR_DUNNING_LETTERS_TL set
516: letter_name = X_LETTER_NAME,
517: description = X_DESCRIPTION,
518: source_lang = userenv('LANG'),
519: last_update_date = sysdate,