APPS.AMW_LOAD_RCM_ORG_DATA dependencies on AMW_RISK_TYPE

Line 1941: from amw_risk_type

1937: fnd_file.put_line(fnd_file.log,'~~~~~~~~~~~~~~~~~~~~~~ create_process_objectives: START');
1938: fnd_file.put_line(fnd_file.log,'p_process_objective_name: '||p_process_objective_name);
1939: /*
1940: select count(*) into l_risk_type_exists
1941: from amw_risk_type
1942: where risk_rev_id = lx_risk_rev_id
1943: and risk_type_code = l_risk_type_code;
1944: */
1945: open c_get_objective;

Line 2066: SELECT AMW_RISK_TYPE_S.NEXTVAL

2062: start_date <= sysdate AND (end_date IS NULL OR end_date >= sysdate)
2063: AND tag=p_lookup_tag;
2064:
2065: CURSOR c_risk_type_id IS
2066: SELECT AMW_RISK_TYPE_S.NEXTVAL
2067: FROM dual;
2068:
2069: l_risk_type_code VARCHAR2(30);
2070: l_risk_type_code_del VARCHAR2(30);

Line 2122: from amw_risk_type

2118:
2119: if(l_risk_type_flag = 'N') then
2120:
2121: select count(*) into l_risk_type_exists
2122: from amw_risk_type
2123: where risk_rev_id = lx_risk_rev_id
2124: and risk_type_code = l_risk_type_code;
2125:
2126: if(l_risk_type_exists > 0) then

Line 2127: delete from amw_risk_type

2123: where risk_rev_id = lx_risk_rev_id
2124: and risk_type_code = l_risk_type_code;
2125:
2126: if(l_risk_type_exists > 0) then
2127: delete from amw_risk_type
2128: where risk_rev_id=lx_risk_rev_id
2129: and risk_type_code=l_risk_type_code;
2130: end if;
2131: end if;

Line 2139: --need to check if this row already exists in amw_risk_type

2135:
2136: if(l_risk_type_flag = 'Y') then
2137:
2138: --this risk_type has been selected for this risk ....
2139: --need to check if this row already exists in amw_risk_type
2140: --for this risk_rev_id
2141:
2142: select count(*) into l_risk_type_exists
2143: from amw_risk_type

Line 2143: from amw_risk_type

2139: --need to check if this row already exists in amw_risk_type
2140: --for this risk_rev_id
2141:
2142: select count(*) into l_risk_type_exists
2143: from amw_risk_type
2144: where risk_rev_id = lx_risk_rev_id
2145: and risk_type_code = l_risk_type_code;
2146:
2147: --IF SQL%NOTFOUND THEN

Line 2157: INSERT INTO amw_risk_type

2153: OPEN c_risk_type_id;
2154: FETCH c_risk_type_id INTO l_RISK_type_id;
2155: CLOSE c_risk_type_id;
2156:
2157: INSERT INTO amw_risk_type
2158: (risk_type_id,
2159: last_update_date,
2160: last_updated_by,
2161: creation_date,

Line 2185: v_table_name := 'AMW_RISK_TYPE';

2181: WHEN e_invalid_risk_type_flag THEN
2182: v_err_msg :=
2183: 'Error working in procedure risk types: '
2184: || 'Atleast one Risk_Type flag must be Y/N';
2185: v_table_name := 'AMW_RISK_TYPE';
2186: update_interface_with_error (v_err_msg
2187: ,v_table_name
2188: ,v_interface_id
2189: );

Line 2199: v_table_name := 'AMW_RISK_TYPE';

2195: || p_lookup_tag
2196: || 'using interface id of: '
2197: || v_interface_id
2198: || ' flag must be Y/N';
2199: v_table_name := 'AMW_RISK_TYPE';
2200: update_interface_with_error (v_err_msg
2201: ,v_table_name
2202: ,v_interface_id
2203: );

Line 2212: v_table_name := 'AMW_RISK_TYPE';

2208: || p_lookup_tag
2209: || 'using interface id of: '
2210: || v_interface_id
2211: || ' code does not exist';
2212: v_table_name := 'AMW_RISK_TYPE';
2213: update_interface_with_error (v_err_msg
2214: ,v_table_name
2215: ,v_interface_id
2216: );

Line 2227: v_table_name := 'AMW_RISK_TYPE';

2223: || v_interface_id
2224: || ' '
2225: || SUBSTR (SQLERRM, 1, 100)
2226: || ' ';
2227: v_table_name := 'AMW_RISK_TYPE';
2228: update_interface_with_error (v_err_msg
2229: ,v_table_name
2230: ,v_interface_id
2231: );