eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_SETUP_RISK_TYPES_PKG dependencies on AMW_SETUP_RISK_TYPES_B

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 40: cursor C is select ROWID from AMW_SETUP_RISK_TYPES_B

36: X_TAG in VARCHAR2,
37: X_SETUP_RISK_TYPE_NAME in VARCHAR2,
38: X_SETUP_RISK_TYPE_DESCRIPTION in VARCHAR2
39: ) is
40: cursor C is select ROWID from AMW_SETUP_RISK_TYPES_B
41: where SETUP_RISK_TYPE_ID = X_SETUP_RISK_TYPE_ID;
42: begin
43: insert into AMW_SETUP_RISK_TYPES_B (
44: SETUP_RISK_TYPE_ID,

Line 43: insert into AMW_SETUP_RISK_TYPES_B (

39: ) is
40: cursor C is select ROWID from AMW_SETUP_RISK_TYPES_B
41: where SETUP_RISK_TYPE_ID = X_SETUP_RISK_TYPE_ID;
42: begin
43: insert into AMW_SETUP_RISK_TYPES_B (
44: SETUP_RISK_TYPE_ID,
45: RISK_TYPE_CODE,
46: PARENT_SETUP_RISK_TYPE_ID,
47: START_DATE,

Line 142: from AMW_SETUP_RISK_TYPES_B

138: END_DATE,
139: SECURITY_GROUP_ID,
140: OBJECT_VERSION_NUMBER,
141: TAG
142: from AMW_SETUP_RISK_TYPES_B
143: where SETUP_RISK_TYPE_ID = X_SETUP_RISK_TYPE_ID
144: and PARENT_SETUP_RISK_TYPE_ID = X_PARENT_SETUP_RISK_TYPE_ID
145: for update of SETUP_RISK_TYPE_ID nowait;
146: recinfo c%rowtype;

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 225: update AMW_SETUP_RISK_TYPES_B set

221: X_SETUP_RISK_TYPE_NAME in VARCHAR2,
222: X_SETUP_RISK_TYPE_DESCRIPTION in VARCHAR2
223: ) is
224: begin
225: update AMW_SETUP_RISK_TYPES_B set
226: RISK_TYPE_CODE = X_RISK_TYPE_CODE,
227: PARENT_SETUP_RISK_TYPE_ID = X_PARENT_SETUP_RISK_TYPE_ID,
228: START_DATE = X_START_DATE,
229: END_DATE = X_END_DATE,

Line 263: -- load AMW_SETUP_RISK_TYPE to AMW_SETUP_RISK_TYPES_B(_TL)

259: -- ===============================================================
260: -- Procedure name
261: -- LOAD_ROW
262: -- Purpose
263: -- load AMW_SETUP_RISK_TYPE to AMW_SETUP_RISK_TYPES_B(_TL)
264: -- ===============================================================
265: procedure LOAD_ROW (
266: X_SETUP_RISK_TYPE_ID in NUMBER,
267: X_RISK_TYPE_CODE in VARCHAR2,

Line 301: from amw_setup_risk_types_b b

297: l_msg_data varchar2(2000);
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;

Line 309: from amw_setup_risk_types_b b

305: and tl.name = l_setup_risk_type_name;
306:
307: cursor is_risk_type_code_exist(l_risk_type_code in varchar2) is
308: select b.risk_type_code
309: from amw_setup_risk_types_b b
310: where b.risk_type_code = l_risk_type_code;
311:
312: cursor get_new_setup_risk_type_id is
313: select AMW_SETUP_RISK_TYPE_S.nextval

Line 451: from AMW_SETUP_RISK_TYPES_B

447: ELSE
448: -- handle Root Setup Risk Type (aka, X_SETUP_RISK_TYPE_ID = -1)
449: BEGIN
450: select SETUP_RISK_TYPE_ID into l_setup_risk_type_id
451: from AMW_SETUP_RISK_TYPES_B
452: where SETUP_RISK_TYPE_ID = X_SETUP_RISK_TYPE_ID;
453:
454: AMW_SETUP_RISK_TYPES_PKG.UPDATE_ROW (
455: X_SETUP_RISK_TYPE_ID => X_SETUP_RISK_TYPE_ID,

Line 513: delete from AMW_SETUP_RISK_TYPES_B

509: X_SETUP_RISK_TYPE_ID in NUMBER,
510: X_PARENT_SETUP_RISK_TYPE_ID in NUMBER
511: ) is
512: begin
513: delete from AMW_SETUP_RISK_TYPES_B
514: where SETUP_RISK_TYPE_ID = X_SETUP_RISK_TYPE_ID
515: and PARENT_SETUP_RISK_TYPE_ID = X_PARENT_SETUP_RISK_TYPE_ID;
516:
517: if (sql%notfound) then

Line 524: select SETUP_RISK_TYPE_ID from AMW_SETUP_RISK_TYPES_B

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: )
526: and SETUP_RISK_TYPE_ID not in (
527: select PARENT_SETUP_RISK_TYPE_ID from AMW_SETUP_RISK_TYPES_B
528: );

Line 527: select PARENT_SETUP_RISK_TYPE_ID from AMW_SETUP_RISK_TYPES_B

523: and SETUP_RISK_TYPE_ID not in (
524: select SETUP_RISK_TYPE_ID from AMW_SETUP_RISK_TYPES_B
525: )
526: and SETUP_RISK_TYPE_ID not in (
527: select PARENT_SETUP_RISK_TYPE_ID from AMW_SETUP_RISK_TYPES_B
528: );
529:
530: if (sql%notfound) then
531: raise no_data_found;

Line 550: from AMW_SETUP_RISK_TYPES_B B

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
552: );
553:
554: update AMW_SETUP_RISK_TYPES_TL T set (