APPS.FA_RX_ATTRSETS_PKG dependencies on FA_RX_ATTRSETS_TL

Line 83: insert into FA_RX_ATTRSETS_TL (

79: X_LAST_UPDATED_BY,
80: X_LAST_UPDATE_LOGIN
81: );
82:
83: insert into FA_RX_ATTRSETS_TL (
84: REPORT_ID,
85: ATTRIBUTE_SET,
86: REPORT_TITLE,
87: USER_ATTRIBUTE_SET,

Line 111: from FA_RX_ATTRSETS_TL T

107: from FND_LANGUAGES L
108: where L.INSTALLED_FLAG in ('I', 'B')
109: and not exists
110: (select NULL
111: from FA_RX_ATTRSETS_TL T
112: where T.REPORT_ID = X_REPORT_ID
113: and T.ATTRIBUTE_SET = X_ATTRIBUTE_SET
114: and T.LANGUAGE = L.LANGUAGE_CODE);
115:

Line 173: from FA_RX_ATTRSETS_TL

169: cursor c1 is select
170: REPORT_TITLE,
171: USER_ATTRIBUTE_SET,
172: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
173: from FA_RX_ATTRSETS_TL
174: where REPORT_ID = X_REPORT_ID
175: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
176: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
177: for update of REPORT_ID nowait;

Line 294: update FA_RX_ATTRSETS_TL set

290: if (sql%notfound) then
291: raise no_data_found;
292: end if;
293:
294: update FA_RX_ATTRSETS_TL set
295: REPORT_TITLE = X_REPORT_TITLE,
296: USER_ATTRIBUTE_SET = X_USER_ATTRIBUTE_SET,
297: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
298: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 315: delete from FA_RX_ATTRSETS_TL

311: X_REPORT_ID in NUMBER,
312: X_ATTRIBUTE_SET in VARCHAR2
313: ) is
314: begin
315: delete from FA_RX_ATTRSETS_TL
316: where REPORT_ID = X_REPORT_ID
317: and ATTRIBUTE_SET = X_ATTRIBUTE_SET;
318:
319: if (sql%notfound) then

Line 335: delete from FA_RX_ATTRSETS_TL T

331:
332: procedure ADD_LANGUAGE
333: is
334: begin
335: delete from FA_RX_ATTRSETS_TL T
336: where not exists
337: (select NULL
338: from FA_RX_ATTRSETS_B B
339: where B.REPORT_ID = T.REPORT_ID

Line 343: update FA_RX_ATTRSETS_TL T set (

339: where B.REPORT_ID = T.REPORT_ID
340: and B.ATTRIBUTE_SET = T.ATTRIBUTE_SET
341: );
342:
343: update FA_RX_ATTRSETS_TL T set (
344: REPORT_TITLE,
345: USER_ATTRIBUTE_SET
346: ) = (select
347: B.REPORT_TITLE,

Line 349: from FA_RX_ATTRSETS_TL B

345: USER_ATTRIBUTE_SET
346: ) = (select
347: B.REPORT_TITLE,
348: B.USER_ATTRIBUTE_SET
349: from FA_RX_ATTRSETS_TL B
350: where B.REPORT_ID = T.REPORT_ID
351: and B.ATTRIBUTE_SET = T.ATTRIBUTE_SET
352: and B.LANGUAGE = T.SOURCE_LANG)
353: where (

Line 361: from FA_RX_ATTRSETS_TL SUBB, FA_RX_ATTRSETS_TL SUBT

357: ) in (select
358: SUBT.REPORT_ID,
359: SUBT.ATTRIBUTE_SET,
360: SUBT.LANGUAGE
361: from FA_RX_ATTRSETS_TL SUBB, FA_RX_ATTRSETS_TL SUBT
362: where SUBB.REPORT_ID = SUBT.REPORT_ID
363: and SUBB.ATTRIBUTE_SET = SUBT.ATTRIBUTE_SET
364: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
365: and (SUBB.REPORT_TITLE <> SUBT.REPORT_TITLE

Line 373: insert into FA_RX_ATTRSETS_TL (

369: or (SUBB.USER_ATTRIBUTE_SET is null and SUBT.USER_ATTRIBUTE_SET is not null)
370: or (SUBB.USER_ATTRIBUTE_SET is not null and SUBT.USER_ATTRIBUTE_SET is null)
371: ));
372:
373: insert into FA_RX_ATTRSETS_TL (
374: REPORT_ID,
375: ATTRIBUTE_SET,
376: REPORT_TITLE,
377: USER_ATTRIBUTE_SET,

Line 397: from FA_RX_ATTRSETS_TL B, FND_LANGUAGES L

393: B.CREATED_BY,
394: B.CREATION_DATE,
395: L.LANGUAGE_CODE,
396: B.SOURCE_LANG
397: from FA_RX_ATTRSETS_TL B, FND_LANGUAGES L
398: where L.INSTALLED_FLAG in ('I', 'B')
399: and B.LANGUAGE = userenv('LANG')
400: and not exists
401: (select NULL

Line 402: from FA_RX_ATTRSETS_TL T

398: where L.INSTALLED_FLAG in ('I', 'B')
399: and B.LANGUAGE = userenv('LANG')
400: and not exists
401: (select NULL
402: from FA_RX_ATTRSETS_TL T
403: where T.REPORT_ID = B.REPORT_ID
404: and T.ATTRIBUTE_SET = B.ATTRIBUTE_SET
405: and T.LANGUAGE = L.LANGUAGE_CODE);
406: end ADD_LANGUAGE;

Line 517: from fa_rx_attrsets_tl

513:
514: Begin
515: select LAST_UPDATED_BY, LAST_UPDATE_DATE
516: into db_luby_tl, db_ludate_tl
517: from fa_rx_attrsets_tl
518: where report_id = X_Report_Id
519: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
520: and language = userenv('LANG');
521: Exception

Line 633: update fa_rx_attrsets_tl

629: f_ludate := nvl(to_date(X_Last_Update_Date, 'YYYY/MM/DD HH24:MI:SS'), sysdate);
630:
631: --* End
632: --*
633: update fa_rx_attrsets_tl
634: set user_attribute_set = X_USER_ATTRIBUTE_SET,
635: report_title = X_REPORT_TITLE,
636: LAST_UPDATE_DATE = f_ludate,
637: LAST_UPDATED_BY = f_luby,