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_LOAD_RC_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 2257: WHERE lookup_type='AMW_CONTROL_ASSERTIONS'

2253: IS
2254: CURSOR c_control_assert IS
2255: SELECT lookup_code
2256: FROM AMW_LOOKUPS
2257: WHERE lookup_type='AMW_CONTROL_ASSERTIONS'
2258: AND enabled_flag='Y'
2259: AND tag=p_lookup_tag;
2260:
2261: l_ctrl_assert_code VARCHAR2(30);

Line 2289: from amw_control_assertions

2285:
2286: if (l_ctrl_assert_flag = 'N') then
2287: select count(*)
2288: into l_assert_exists
2289: from amw_control_assertions
2290: where control_rev_id = vx_control_rev_id
2291: AND assertion_code = l_ctrl_assert_code;
2292:
2293: if(l_assert_exists > 0) then

Line 2294: delete from amw_control_assertions

2290: where control_rev_id = vx_control_rev_id
2291: AND assertion_code = l_ctrl_assert_code;
2292:
2293: if(l_assert_exists > 0) then
2294: delete from amw_control_assertions
2295: where control_rev_id = vx_control_rev_id
2296: AND assertion_code = l_ctrl_assert_code;
2297: end if;
2298: end if;

Line 2303: from amw_control_assertions

2299:
2300: if(l_ctrl_assert_flag = 'Y') then
2301: select count(*)
2302: into l_assert_exists
2303: from amw_control_assertions
2304: where control_rev_id = vx_control_rev_id
2305: AND assertion_code = l_ctrl_assert_code;
2306:
2307: if(l_assert_exists = 0)then

Line 2309: INSERT INTO amw_control_assertions

2305: AND assertion_code = l_ctrl_assert_code;
2306:
2307: if(l_assert_exists = 0)then
2308: ---IF SQL%NOTFOUND THEN
2309: INSERT INTO amw_control_assertions
2310: (control_assertion_id
2311: ,last_update_date
2312: ,last_updated_by
2313: ,creation_date

Line 2322: amw_control_assertions_s.NEXTVAL

2318: ----,effective_date_from
2319: ----,effective_date_to
2320: ,OBJECT_VERSION_NUMBER
2321: ) VALUES (
2322: amw_control_assertions_s.NEXTVAL
2323: ,SYSDATE
2324: ,v_user_id
2325: ,SYSDATE
2326: ,v_user_id

Line 2346: v_table_name := 'AMW_CONTROL_ASSERTIONS';

2342: || p_lookup_tag
2343: || 'using interface id of: '
2344: || v_interface_id
2345: || ' flag must be Y/N';
2346: v_table_name := 'AMW_CONTROL_ASSERTIONS';
2347: update_interface_with_error (v_err_msg
2348: ,v_table_name
2349: ,v_interface_id
2350: );

Line 2359: v_table_name := 'AMW_CONTROL_ASSERTIONS';

2355: || p_lookup_tag
2356: || 'using interface id of: '
2357: || v_interface_id
2358: || ' code does not exist';
2359: v_table_name := 'AMW_CONTROL_ASSERTIONS';
2360: update_interface_with_error (v_err_msg
2361: ,v_table_name
2362: ,v_interface_id
2363: );

Line 2373: v_table_name := 'AMW_CONTROL_ASSERTIONS';

2369: || 'using interface id of: '
2370: || v_interface_id
2371: || ' '
2372: || SUBSTR (SQLERRM, 1, 100);
2373: v_table_name := 'AMW_CONTROL_ASSERTIONS';
2374: update_interface_with_error (v_err_msg
2375: ,v_table_name
2376: ,v_interface_id
2377: );