APPS.AMW_LOAD_CTRL_DATA dependencies on AMW_CONTROL_ASSERTIONS

Line 15: /* Insert into AMW_CONTROL_ASSERTIONS */

11: /* Insert into AMW_CONTROLS_B and AMW_CONTROLS_TL */
12: /* Insert into AMW_CONTROL_ASSOCIATIONS */
13: /* Insert into AMW_RISK_ASSOCIATIONS */
14: /* Insert into AMW_CONTROL_OBJECTIVES */
15: /* Insert into AMW_CONTROL_ASSERTIONS */
16: /* Updates amw_risk-ctrl_interface, with error messages */
17: /* Deleting successful production inserts, based on profile */
18: /* */
19: /*****************************************************************************/

Line 1008: WHERE lookup_type='AMW_CONTROL_ASSERTIONS'

1004: IS
1005: CURSOR c_control_assert IS
1006: SELECT lookup_code
1007: FROM AMW_LOOKUPS
1008: WHERE lookup_type='AMW_CONTROL_ASSERTIONS'
1009: AND enabled_flag='Y'
1010: AND tag=p_lookup_tag;
1011:
1012: l_ctrl_assert_code VARCHAR2(30);

Line 1038: UPDATE amw_control_assertions

1034: END IF;
1035: CLOSE c_control_assert;
1036:
1037: /*
1038: UPDATE amw_control_assertions
1039: SET effective_date_to = DECODE (l_ctrl_assert_flag, 'N', SYSDATE, NULL)
1040: ,last_update_date = SYSDATE
1041: ,last_updated_by = v_user_id
1042: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1

Line 1050: from amw_control_assertions

1046:
1047: if (l_ctrl_assert_flag = 'N') then
1048: select count(*)
1049: into l_assert_exists
1050: from amw_control_assertions
1051: where control_rev_id = vx_control_rev_id
1052: AND assertion_code = l_ctrl_assert_code;
1053:
1054: if(l_assert_exists > 0) then

Line 1055: delete from amw_control_assertions

1051: where control_rev_id = vx_control_rev_id
1052: AND assertion_code = l_ctrl_assert_code;
1053:
1054: if(l_assert_exists > 0) then
1055: delete from amw_control_assertions
1056: where control_rev_id = vx_control_rev_id
1057: AND assertion_code = l_ctrl_assert_code;
1058: end if;
1059: end if;

Line 1064: from amw_control_assertions

1060:
1061: if(l_ctrl_assert_flag = 'Y') then
1062: select count(*)
1063: into l_assert_exists
1064: from amw_control_assertions
1065: where control_rev_id = vx_control_rev_id
1066: AND assertion_code = l_ctrl_assert_code;
1067:
1068: if(l_assert_exists = 0)then

Line 1070: INSERT INTO amw_control_assertions

1066: AND assertion_code = l_ctrl_assert_code;
1067:
1068: if(l_assert_exists = 0)then
1069: ---IF SQL%NOTFOUND THEN
1070: INSERT INTO amw_control_assertions
1071: (control_assertion_id
1072: ,last_update_date
1073: ,last_updated_by
1074: ,creation_date

Line 1083: amw_control_assertions_s.NEXTVAL

1079: ----,effective_date_from
1080: ----,effective_date_to
1081: ,OBJECT_VERSION_NUMBER
1082: ) VALUES (
1083: amw_control_assertions_s.NEXTVAL
1084: ,SYSDATE
1085: ,v_user_id
1086: ,SYSDATE
1087: ,v_user_id

Line 1107: v_table_name := 'AMW_CONTROL_ASSERTIONS';

1103: || p_lookup_tag
1104: || 'using interface id of: '
1105: || v_interface_id
1106: || ' flag must be Y/N';
1107: v_table_name := 'AMW_CONTROL_ASSERTIONS';
1108: update_interface_with_error (v_err_msg
1109: ,v_table_name
1110: ,v_interface_id
1111: );

Line 1120: v_table_name := 'AMW_CONTROL_ASSERTIONS';

1116: || p_lookup_tag
1117: || 'using interface id of: '
1118: || v_interface_id
1119: || ' code does not exist';
1120: v_table_name := 'AMW_CONTROL_ASSERTIONS';
1121: update_interface_with_error (v_err_msg
1122: ,v_table_name
1123: ,v_interface_id
1124: );

Line 1134: v_table_name := 'AMW_CONTROL_ASSERTIONS';

1130: || 'using interface id of: '
1131: || v_interface_id
1132: || ' '
1133: || SUBSTR (SQLERRM, 1, 100);
1134: v_table_name := 'AMW_CONTROL_ASSERTIONS';
1135: update_interface_with_error (v_err_msg
1136: ,v_table_name
1137: ,v_interface_id
1138: );