APPS.AMW_LOAD_RCM_ORG_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 2379: WHERE lookup_type='AMW_CONTROL_ASSERTIONS'

2375: IS
2376: CURSOR c_control_assert IS
2377: SELECT lookup_code
2378: FROM AMW_LOOKUPS
2379: WHERE lookup_type='AMW_CONTROL_ASSERTIONS'
2380: AND enabled_flag='Y'
2381: AND tag=p_lookup_tag;
2382:
2383: l_ctrl_assert_code VARCHAR2(30);

Line 2409: UPDATE amw_control_assertions

2405: END IF;
2406: CLOSE c_control_assert;
2407:
2408: /*
2409: UPDATE amw_control_assertions
2410: SET effective_date_to = DECODE (l_ctrl_assert_flag, 'N', SYSDATE, NULL)
2411: ,last_update_date = SYSDATE
2412: ,last_updated_by = v_user_id
2413: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1

Line 2421: from amw_control_assertions

2417:
2418: if (l_ctrl_assert_flag = 'N') then
2419: select count(*)
2420: into l_assert_exists
2421: from amw_control_assertions
2422: where control_rev_id = vx_control_rev_id
2423: AND assertion_code = l_ctrl_assert_code;
2424:
2425: if(l_assert_exists > 0) then

Line 2426: delete from amw_control_assertions

2422: where control_rev_id = vx_control_rev_id
2423: AND assertion_code = l_ctrl_assert_code;
2424:
2425: if(l_assert_exists > 0) then
2426: delete from amw_control_assertions
2427: where control_rev_id = vx_control_rev_id
2428: AND assertion_code = l_ctrl_assert_code;
2429: end if;
2430: end if;

Line 2435: from amw_control_assertions

2431:
2432: if(l_ctrl_assert_flag = 'Y') then
2433: select count(*)
2434: into l_assert_exists
2435: from amw_control_assertions
2436: where control_rev_id = vx_control_rev_id
2437: AND assertion_code = l_ctrl_assert_code;
2438:
2439: if(l_assert_exists = 0)then

Line 2441: INSERT INTO amw_control_assertions

2437: AND assertion_code = l_ctrl_assert_code;
2438:
2439: if(l_assert_exists = 0)then
2440: ---IF SQL%NOTFOUND THEN
2441: INSERT INTO amw_control_assertions
2442: (control_assertion_id
2443: ,last_update_date
2444: ,last_updated_by
2445: ,creation_date

Line 2454: amw_control_assertions_s.NEXTVAL

2450: ----,effective_date_from
2451: ----,effective_date_to
2452: ,OBJECT_VERSION_NUMBER
2453: ) VALUES (
2454: amw_control_assertions_s.NEXTVAL
2455: ,SYSDATE
2456: ,v_user_id
2457: ,SYSDATE
2458: ,v_user_id

Line 2478: v_table_name := 'AMW_CONTROL_ASSERTIONS';

2474: || p_lookup_tag
2475: || 'using interface id of: '
2476: || v_interface_id
2477: || ' flag must be Y/N';
2478: v_table_name := 'AMW_CONTROL_ASSERTIONS';
2479: update_interface_with_error (v_err_msg
2480: ,v_table_name
2481: ,v_interface_id
2482: );

Line 2491: v_table_name := 'AMW_CONTROL_ASSERTIONS';

2487: || p_lookup_tag
2488: || 'using interface id of: '
2489: || v_interface_id
2490: || ' code does not exist';
2491: v_table_name := 'AMW_CONTROL_ASSERTIONS';
2492: update_interface_with_error (v_err_msg
2493: ,v_table_name
2494: ,v_interface_id
2495: );

Line 2505: v_table_name := 'AMW_CONTROL_ASSERTIONS';

2501: || 'using interface id of: '
2502: || v_interface_id
2503: || ' '
2504: || SUBSTR (SQLERRM, 1, 100);
2505: v_table_name := 'AMW_CONTROL_ASSERTIONS';
2506: update_interface_with_error (v_err_msg
2507: ,v_table_name
2508: ,v_interface_id
2509: );