APPS.AMW_SETUP_RISK_TYPES_PVT dependencies on AMW_SETUP_RISK_TYPES_B

Line 73: delete from AMW_SETUP_RISK_TYPES_B

69: l_risk_type_list := GET_ALL_DESCENDANTS(l_setup_risk_type_id);
70:
71: IF (l_risk_type_list.FIRST is not NULL) THEN
72: FOR i in 0 .. l_risk_type_list.LAST LOOP
73: delete from AMW_SETUP_RISK_TYPES_B
74: where SETUP_RISK_TYPE_ID = l_risk_type_list(i);
75: END LOOP; -- end of for
76:
77: FOR i in 0 .. l_risk_type_list.LAST LOOP

Line 81: select SETUP_RISK_TYPE_ID from AMW_SETUP_RISK_TYPES_B

77: FOR i in 0 .. l_risk_type_list.LAST LOOP
78: delete from AMW_SETUP_RISK_TYPES_TL
79: where SETUP_RISK_TYPE_ID = l_risk_type_list(i)
80: and SETUP_RISK_TYPE_ID not in (
81: select SETUP_RISK_TYPE_ID from AMW_SETUP_RISK_TYPES_B
82: )
83: and SETUP_RISK_TYPE_ID not in (
84: select PARENT_SETUP_RISK_TYPE_ID from AMW_SETUP_RISK_TYPES_B
85: where parent_setup_risk_type_id is not null

Line 84: select PARENT_SETUP_RISK_TYPE_ID from AMW_SETUP_RISK_TYPES_B

80: and SETUP_RISK_TYPE_ID not in (
81: select SETUP_RISK_TYPE_ID from AMW_SETUP_RISK_TYPES_B
82: )
83: and SETUP_RISK_TYPE_ID not in (
84: select PARENT_SETUP_RISK_TYPE_ID from AMW_SETUP_RISK_TYPES_B
85: where parent_setup_risk_type_id is not null
86: );
87: END LOOP; -- end of for
88:

Line 93: from AMW_SETUP_RISK_TYPES_B

89: FOR i in 0 .. l_risk_type_list.LAST LOOP
90: delete from AMW_RISK_TYPE
91: where RISK_TYPE_CODE = (
92: select RISK_TYPE_CODE
93: from AMW_SETUP_RISK_TYPES_B
94: where SETUP_RISK_TYPE_ID = l_risk_type_list(i)
95: );
96: END LOOP; -- end of for
97:

Line 177: update AMW_SETUP_RISK_TYPES_B

173: l_risk_type_list := GET_ALL_DESCENDANTS(l_setup_risk_type_id);
174:
175: IF (l_risk_type_list.FIRST is not NULL) THEN
176: -- update its end_date
177: update AMW_SETUP_RISK_TYPES_B
178: set END_DATE = p_end_date
179: where SETUP_RISK_TYPE_ID = l_risk_type_list(0);
180:
181: -- should update those descendant's end_date to be the same as its end_date

Line 185: update AMW_SETUP_RISK_TYPES_B

181: -- should update those descendant's end_date to be the same as its end_date
182: -- if the descendant's end_date is null or end_date is later than its end_date
183: FOR i in 1 .. l_risk_type_list.LAST LOOP
184: --DBMS_OUTPUT.PUT_LINE(' l_risk_type_list('||i||') = '||l_risk_type_list(i));
185: update AMW_SETUP_RISK_TYPES_B
186: set END_DATE = p_end_date
187: where SETUP_RISK_TYPE_ID = l_risk_type_list(i)
188: and (END_DATE IS NULL OR END_DATE > p_end_date);
189: END LOOP; -- end of for

Line 319: amw_setup_risk_types_b rt,

315: -- find if specified risk type or any of its descendants are associated with the specified risk_rev_id
316: cursor is_assoc_risk_c (l_setup_risk_type_id IN NUMBER, l_risk_rev_id IN NUMBER, l_compliance_env_id IN NUMBER) is
317: SELECT assoc.risk_type_id
318: from amw_risk_type assoc,
319: amw_setup_risk_types_b rt,
320: amw_compliance_env_assocs compEnv
321: where assoc.risk_rev_id = l_risk_rev_id
322: and rt.setup_risk_type_id = l_setup_risk_type_id
323: and assoc.risk_type_code = rt.risk_type_code

Line 481: from amw_setup_risk_types_b

477:
478: -- find the direct children of specified setup risk type
479: cursor get_child_risk_type_c (l_setup_risk_type_id IN NUMBER) is
480: SELECT SETUP_RISK_TYPE_ID
481: from amw_setup_risk_types_b
482: where PARENT_SETUP_RISK_TYPE_ID = l_setup_risk_type_id;
483:
484: -- find how many direct children of specified setup risk type
485: cursor get_child_count_c (l_setup_risk_type_id IN NUMBER) is

Line 487: from amw_setup_risk_types_b

483:
484: -- find how many direct children of specified setup risk type
485: cursor get_child_count_c (l_setup_risk_type_id IN NUMBER) is
486: SELECT count(*)
487: from amw_setup_risk_types_b
488: where PARENT_SETUP_RISK_TYPE_ID = l_setup_risk_type_id;
489:
490: last_index PLS_INTEGER;
491: i NUMBER;

Line 599: from amw_setup_risk_types_b

595:
596: -- find the direct parent of specified setup risk type
597: cursor get_parent_risk_type_c (l_setup_risk_type_id IN NUMBER) is
598: SELECT PARENT_SETUP_RISK_TYPE_ID
599: from amw_setup_risk_types_b
600: where SETUP_RISK_TYPE_ID = l_setup_risk_type_id;
601:
602: BEGIN
603: isParent := 'N';

Line 737: amw_setup_risk_types_b rt

733: -- find if there's associated risk of specified setup risk type
734: cursor get_assoc_risk_count_c (l_setup_risk_type_id IN NUMBER) is
735: SELECT count(*)
736: from amw_risk_type assoc,
737: amw_setup_risk_types_b rt
738: where rt.setup_risk_type_id = l_setup_risk_type_id
739: and assoc.risk_type_code = rt.risk_type_code;
740:
741: BEGIN