APPS.AR_AGING_BUCKET_LINES_PKG dependencies on AR_AGING_BUCKET_LINES_TL

Line 98: insert into AR_AGING_BUCKET_LINES_TL (

94: X_LAST_UPDATED_BY,
95: X_LAST_UPDATE_LOGIN
96: );
97:
98: insert into AR_AGING_BUCKET_LINES_TL (
99: REPORT_HEADING1,
100: REPORT_HEADING2,
101: LAST_UPDATE_DATE,
102: CREATION_DATE,

Line 124: from AR_AGING_BUCKET_LINES_TL T

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

Line 195: from AR_AGING_BUCKET_LINES_TL

191: cursor c1 is select
192: REPORT_HEADING1,
193: REPORT_HEADING2,
194: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
195: from AR_AGING_BUCKET_LINES_TL
196: where AGING_BUCKET_LINE_ID = X_AGING_BUCKET_LINE_ID
197: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
198: for update of AGING_BUCKET_LINE_ID nowait;
199: begin

Line 334: update AR_AGING_BUCKET_LINES_TL set

330: if (sql%notfound) then
331: raise no_data_found;
332: end if;
333:
334: update AR_AGING_BUCKET_LINES_TL set
335: REPORT_HEADING1 = X_REPORT_HEADING1,
336: REPORT_HEADING2 = X_REPORT_HEADING2,
337: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
338: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 353: delete from AR_AGING_BUCKET_LINES_TL

349: procedure DELETE_ROW (
350: X_AGING_BUCKET_LINE_ID in NUMBER
351: ) is
352: begin
353: delete from AR_AGING_BUCKET_LINES_TL
354: where AGING_BUCKET_LINE_ID = X_AGING_BUCKET_LINE_ID;
355:
356: if (sql%notfound) then
357: raise no_data_found;

Line 371: delete from AR_AGING_BUCKET_LINES_TL T

367:
368: procedure ADD_LANGUAGE
369: is
370: begin
371: delete from AR_AGING_BUCKET_LINES_TL T
372: where not exists
373: (select NULL
374: from AR_AGING_BUCKET_LINES_B B
375: where B.AGING_BUCKET_LINE_ID = T.AGING_BUCKET_LINE_ID

Line 378: update AR_AGING_BUCKET_LINES_TL T set (

374: from AR_AGING_BUCKET_LINES_B B
375: where B.AGING_BUCKET_LINE_ID = T.AGING_BUCKET_LINE_ID
376: );
377:
378: update AR_AGING_BUCKET_LINES_TL T set (
379: REPORT_HEADING1,
380: REPORT_HEADING2
381: ) = (select
382: B.REPORT_HEADING1,

Line 384: from AR_AGING_BUCKET_LINES_TL B

380: REPORT_HEADING2
381: ) = (select
382: B.REPORT_HEADING1,
383: B.REPORT_HEADING2
384: from AR_AGING_BUCKET_LINES_TL B
385: where B.AGING_BUCKET_LINE_ID = T.AGING_BUCKET_LINE_ID
386: and B.LANGUAGE = T.SOURCE_LANG)
387: where (
388: T.AGING_BUCKET_LINE_ID,

Line 393: from AR_AGING_BUCKET_LINES_TL SUBB, AR_AGING_BUCKET_LINES_TL SUBT

389: T.LANGUAGE
390: ) in (select
391: SUBT.AGING_BUCKET_LINE_ID,
392: SUBT.LANGUAGE
393: from AR_AGING_BUCKET_LINES_TL SUBB, AR_AGING_BUCKET_LINES_TL SUBT
394: where SUBB.AGING_BUCKET_LINE_ID = SUBT.AGING_BUCKET_LINE_ID
395: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
396: and (SUBB.REPORT_HEADING1 <> SUBT.REPORT_HEADING1
397: or (SUBB.REPORT_HEADING1 is null and SUBT.REPORT_HEADING1 is not null)

Line 404: insert into AR_AGING_BUCKET_LINES_TL (

400: or (SUBB.REPORT_HEADING2 is null and SUBT.REPORT_HEADING2 is not null)
401: or (SUBB.REPORT_HEADING2 is not null and SUBT.REPORT_HEADING2 is null)
402: ));
403:
404: insert into AR_AGING_BUCKET_LINES_TL (
405: REPORT_HEADING1,
406: REPORT_HEADING2,
407: LAST_UPDATE_DATE,
408: CREATION_DATE,

Line 426: from AR_AGING_BUCKET_LINES_TL B, FND_LANGUAGES L

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

Line 431: from AR_AGING_BUCKET_LINES_TL T

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

Line 547: update AR_AGING_BUCKET_LINES_TL set

543: begin
544:
545: -- only update rows that have not been altered by user
546:
547: update AR_AGING_BUCKET_LINES_TL set
548: report_heading1 = X_REPORT_HEADING1,
549: report_heading2 = X_REPORT_HEADING2,
550: source_lang = userenv('LANG'),
551: last_update_date = sysdate,