APPS.AMW_SETUP_RISK_TYPES_PKG dependencies on AMW_SETUP_RISK_TYPES_TL

Line 20: -- in AMW_SETUP_RISK_TYPES_B and AMW_SETUP_RISK_TYPES_TL

16: -- Procedure name
17: -- INSERT_ROW
18: -- Purpose
19: -- create new compliance environment
20: -- in AMW_SETUP_RISK_TYPES_B and AMW_SETUP_RISK_TYPES_TL
21: -- ===============================================================
22: procedure INSERT_ROW (
23: X_ROWID in out nocopy VARCHAR2,
24: X_SETUP_RISK_TYPE_ID in NUMBER,

Line 73: insert into AMW_SETUP_RISK_TYPES_TL (

69: X_OBJECT_VERSION_NUMBER,
70: X_TAG
71: );
72:
73: insert into AMW_SETUP_RISK_TYPES_TL (
74: LAST_UPDATE_LOGIN,
75: SETUP_RISK_TYPE_ID,
76: NAME,
77: DESCRIPTION,

Line 101: from AMW_SETUP_RISK_TYPES_TL T

97: from FND_LANGUAGES L
98: where L.INSTALLED_FLAG in ('I', 'B')
99: and not exists
100: (select NULL
101: from AMW_SETUP_RISK_TYPES_TL T
102: where T.SETUP_RISK_TYPE_ID = X_SETUP_RISK_TYPE_ID
103: and T.LANGUAGE = L.LANGUAGE_CODE);
104:
105: open c;

Line 152: from AMW_SETUP_RISK_TYPES_TL

148: cursor c1 is select
149: NAME,
150: DESCRIPTION,
151: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
152: from AMW_SETUP_RISK_TYPES_TL
153: where SETUP_RISK_TYPE_ID = X_SETUP_RISK_TYPE_ID
154: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
155: for update of SETUP_RISK_TYPE_ID nowait;
156: begin

Line 207: -- update AMW_SETUP_RISK_TYPES_B and AMW_SETUP_RISK_TYPES_TL

203: -- ===============================================================
204: -- Procedure name
205: -- UPDATE_ROW
206: -- Purpose
207: -- update AMW_SETUP_RISK_TYPES_B and AMW_SETUP_RISK_TYPES_TL
208: -- ===============================================================
209: procedure UPDATE_ROW (
210: X_SETUP_RISK_TYPE_ID in NUMBER,
211: X_RISK_TYPE_CODE in VARCHAR2,

Line 242: update AMW_SETUP_RISK_TYPES_TL set

238: if (sql%notfound) then
239: raise no_data_found;
240: end if;
241:
242: update AMW_SETUP_RISK_TYPES_TL set
243: NAME = X_SETUP_RISK_TYPE_NAME,
244: DESCRIPTION = X_SETUP_RISK_TYPE_DESCRIPTION,
245: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
246: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 302: ,amw_setup_risk_types_tl tl

298:
299: cursor is_setup_risk_type_exist(l_setup_risk_type_name in varchar2) is
300: select b.setup_risk_type_id
301: from amw_setup_risk_types_b b
302: ,amw_setup_risk_types_tl tl
303: where b.setup_risk_type_id = tl.setup_risk_type_id
304: and tl.LANGUAGE = USERENV('LANG')
305: and tl.name = l_setup_risk_type_name;
306:

Line 521: delete from AMW_SETUP_RISK_TYPES_TL

517: if (sql%notfound) then
518: raise no_data_found;
519: end if;
520:
521: delete from AMW_SETUP_RISK_TYPES_TL
522: where SETUP_RISK_TYPE_ID = X_SETUP_RISK_TYPE_ID
523: and SETUP_RISK_TYPE_ID not in (
524: select SETUP_RISK_TYPE_ID from AMW_SETUP_RISK_TYPES_B
525: )

Line 547: delete from AMW_SETUP_RISK_TYPES_TL T

543: -- ===============================================================
544: procedure ADD_LANGUAGE
545: is
546: begin
547: delete from AMW_SETUP_RISK_TYPES_TL T
548: where not exists
549: (select NULL
550: from AMW_SETUP_RISK_TYPES_B B
551: where B.SETUP_RISK_TYPE_ID = T.SETUP_RISK_TYPE_ID

Line 554: update AMW_SETUP_RISK_TYPES_TL T set (

550: from AMW_SETUP_RISK_TYPES_B B
551: where B.SETUP_RISK_TYPE_ID = T.SETUP_RISK_TYPE_ID
552: );
553:
554: update AMW_SETUP_RISK_TYPES_TL T set (
555: NAME,
556: DESCRIPTION
557: ) = (select
558: B.NAME,

Line 560: from AMW_SETUP_RISK_TYPES_TL B

556: DESCRIPTION
557: ) = (select
558: B.NAME,
559: B.DESCRIPTION
560: from AMW_SETUP_RISK_TYPES_TL B
561: where B.SETUP_RISK_TYPE_ID = T.SETUP_RISK_TYPE_ID
562: and B.LANGUAGE = T.SOURCE_LANG)
563: where (
564: T.SETUP_RISK_TYPE_ID,

Line 569: from AMW_SETUP_RISK_TYPES_TL SUBB, AMW_SETUP_RISK_TYPES_TL SUBT

565: T.LANGUAGE
566: ) in (select
567: SUBT.SETUP_RISK_TYPE_ID,
568: SUBT.LANGUAGE
569: from AMW_SETUP_RISK_TYPES_TL SUBB, AMW_SETUP_RISK_TYPES_TL SUBT
570: where SUBB.SETUP_RISK_TYPE_ID = SUBT.SETUP_RISK_TYPE_ID
571: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
572: and (SUBB.NAME <> SUBT.NAME
573: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 578: insert into AMW_SETUP_RISK_TYPES_TL (

574: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
575: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
576: ));
577:
578: insert into AMW_SETUP_RISK_TYPES_TL (
579: LAST_UPDATE_LOGIN,
580: SETUP_RISK_TYPE_ID,
581: NAME,
582: DESCRIPTION,

Line 602: from AMW_SETUP_RISK_TYPES_TL B, FND_LANGUAGES L

598: B.CREATED_BY,
599: B.SECURITY_GROUP_ID,
600: L.LANGUAGE_CODE,
601: B.SOURCE_LANG
602: from AMW_SETUP_RISK_TYPES_TL B, FND_LANGUAGES L
603: where L.INSTALLED_FLAG in ('I', 'B')
604: and B.LANGUAGE = userenv('LANG')
605: and not exists
606: (select NULL

Line 607: from AMW_SETUP_RISK_TYPES_TL T

603: where L.INSTALLED_FLAG in ('I', 'B')
604: and B.LANGUAGE = userenv('LANG')
605: and not exists
606: (select NULL
607: from AMW_SETUP_RISK_TYPES_TL T
608: where T.SETUP_RISK_TYPE_ID = B.SETUP_RISK_TYPE_ID
609: and T.LANGUAGE = L.LANGUAGE_CODE);
610: end ADD_LANGUAGE;
611:

Line 634: from AMW_SETUP_RISK_TYPES_TL

630: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
631:
632: select last_updated_by, last_update_date
633: into db_luby, db_ludate
634: from AMW_SETUP_RISK_TYPES_TL
635: where setup_risk_type_id = X_SETUP_RISK_TYPE_ID
636: and language = userenv('LANG');
637:
638: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then

Line 639: update AMW_SETUP_RISK_TYPES_TL

635: where setup_risk_type_id = X_SETUP_RISK_TYPE_ID
636: and language = userenv('LANG');
637:
638: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
639: update AMW_SETUP_RISK_TYPES_TL
640: set name = X_SETUP_RISK_TYPE_NAME,
641: description = nvl(X_SETUP_RISK_TYPE_DESCRIPTION, description),
642: source_lang = userenv('LANG'),
643: last_update_date = f_ludate,