APPS.AMW_RISKS_PKG dependencies on AMW_RISKS_TL

Line 130: insert into AMW_RISKS_TL (

126: X_LAST_UPDATE_LOGIN,
127: X_CLASSIFICATION
128: );
129:
130: insert into AMW_RISKS_TL (
131: LAST_UPDATE_LOGIN,
132: SECURITY_GROUP_ID,
133: RISK_REV_ID,
134: CREATION_DATE,

Line 160: from AMW_RISKS_TL T

156: from FND_LANGUAGES L
157: where L.INSTALLED_FLAG in ('I', 'B')
158: and not exists
159: (select NULL
160: from AMW_RISKS_TL T
161: where T.RISK_REV_ID = X_RISK_REV_ID
162: and T.LANGUAGE = L.LANGUAGE_CODE);
163:
164: open c;

Line 255: from AMW_RISKS_TL

251: cursor c1 is select
252: NAME,
253: DESCRIPTION,
254: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
255: from AMW_RISKS_TL
256: where RISK_REV_ID = X_RISK_REV_ID
257: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
258: for update of RISK_REV_ID nowait;
259: begin

Line 432: update AMW_RISKS_TL set

428: if (sql%notfound) then
429: raise no_data_found;
430: end if;
431:
432: update AMW_RISKS_TL set
433: NAME = X_NAME,
434: DESCRIPTION = X_DESCRIPTION,
435: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
436: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 452: delete from AMW_RISKS_TL

448: procedure DELETE_ROW (
449: X_RISK_REV_ID in NUMBER
450: ) is
451: begin
452: delete from AMW_RISKS_TL
453: where RISK_REV_ID = X_RISK_REV_ID;
454:
455: if (sql%notfound) then
456: raise no_data_found;

Line 470: delete from AMW_RISKS_TL T

466:
467: procedure ADD_LANGUAGE
468: is
469: begin
470: delete from AMW_RISKS_TL T
471: where not exists
472: (select NULL
473: from AMW_RISKS_B B
474: where B.RISK_REV_ID = T.RISK_REV_ID

Line 477: update AMW_RISKS_TL T set (

473: from AMW_RISKS_B B
474: where B.RISK_REV_ID = T.RISK_REV_ID
475: );
476:
477: update AMW_RISKS_TL T set (
478: NAME,
479: DESCRIPTION
480: ) = (select
481: B.NAME,

Line 483: from AMW_RISKS_TL B

479: DESCRIPTION
480: ) = (select
481: B.NAME,
482: B.DESCRIPTION
483: from AMW_RISKS_TL B
484: where B.RISK_REV_ID = T.RISK_REV_ID
485: and B.LANGUAGE = T.SOURCE_LANG)
486: where (
487: T.RISK_REV_ID,

Line 492: from AMW_RISKS_TL SUBB, AMW_RISKS_TL SUBT

488: T.LANGUAGE
489: ) in (select
490: SUBT.RISK_REV_ID,
491: SUBT.LANGUAGE
492: from AMW_RISKS_TL SUBB, AMW_RISKS_TL SUBT
493: where SUBB.RISK_REV_ID = SUBT.RISK_REV_ID
494: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
495: and (SUBB.NAME <> SUBT.NAME
496: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 501: insert into AMW_RISKS_TL (

497: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
498: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
499: ));
500:
501: insert into AMW_RISKS_TL (
502: LAST_UPDATE_LOGIN,
503: SECURITY_GROUP_ID,
504: RISK_REV_ID,
505: CREATION_DATE,

Line 527: from AMW_RISKS_TL B, FND_LANGUAGES L

523: B.LAST_UPDATE_DATE,
524: B.LAST_UPDATED_BY,
525: L.LANGUAGE_CODE,
526: B.SOURCE_LANG
527: from AMW_RISKS_TL B, FND_LANGUAGES L
528: where L.INSTALLED_FLAG in ('I', 'B')
529: and B.LANGUAGE = userenv('LANG')
530: and not exists
531: (select NULL

Line 532: from AMW_RISKS_TL T

528: where L.INSTALLED_FLAG in ('I', 'B')
529: and B.LANGUAGE = userenv('LANG')
530: and not exists
531: (select NULL
532: from AMW_RISKS_TL T
533: where T.RISK_REV_ID = B.RISK_REV_ID
534: and T.LANGUAGE = L.LANGUAGE_CODE);
535: end ADD_LANGUAGE;
536: