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_ASSESSMENT_COMPONENTS

Line 2451: WHERE lookup_type='AMW_ASSESSMENT_COMPONENTS'

2447: IS
2448: CURSOR c_control_comp IS
2449: SELECT lookup_code
2450: FROM AMW_LOOKUPS
2451: WHERE lookup_type='AMW_ASSESSMENT_COMPONENTS'
2452: AND enabled_flag='Y'
2453: AND tag=p_lookup_tag;
2454:
2455: l_ctrl_comp_code VARCHAR2(30);

Line 2483: from amw_assessment_components

2479:
2480: if (l_ctrl_comp_flag = 'N') then
2481: select count(*)
2482: into l_comp_exists
2483: from amw_assessment_components
2484: where object_type='CONTROL'
2485: AND object_id = vx_control_rev_id
2486: AND component_code = l_ctrl_comp_code;
2487:

Line 2489: delete from amw_assessment_components

2485: AND object_id = vx_control_rev_id
2486: AND component_code = l_ctrl_comp_code;
2487:
2488: if(l_comp_exists > 0) then
2489: delete from amw_assessment_components
2490: where object_type='CONTROL'
2491: AND object_id = vx_control_rev_id
2492: AND component_code = l_ctrl_comp_code;
2493: end if;

Line 2501: from amw_assessment_components

2497: --- this control objective has been selected
2498: --- need to check if it is already present or not
2499: select count(*)
2500: into l_comp_exists
2501: from amw_assessment_components
2502: where object_type='CONTROL'
2503: AND object_id = vx_control_rev_id
2504: AND component_code = l_ctrl_comp_code;
2505:

Line 2508: INSERT INTO amw_assessment_components

2504: AND component_code = l_ctrl_comp_code;
2505:
2506: if(l_comp_exists = 0) then
2507: ---IF SQL%NOTFOUND THEN
2508: INSERT INTO amw_assessment_components
2509: (assessment_component_id
2510: ,last_update_date
2511: ,last_updated_by
2512: ,creation_date

Line 2520: amw_assessment_components_s.NEXTVAL

2516: ,object_type
2517: ,object_id
2518: ,OBJECT_VERSION_NUMBER
2519: ) VALUES (
2520: amw_assessment_components_s.NEXTVAL
2521: ,SYSDATE
2522: ,v_user_id
2523: ,SYSDATE
2524: ,v_user_id

Line 2544: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';

2540: || p_lookup_tag
2541: || 'using interface id of: '
2542: || v_interface_id
2543: || ' flag must be Y/N';
2544: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';
2545: update_interface_with_error (v_err_msg
2546: ,v_table_name
2547: ,v_interface_id
2548: );

Line 2557: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';

2553: || p_lookup_tag
2554: || 'using interface id of: '
2555: || v_interface_id
2556: || ' code does not exist';
2557: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';
2558: update_interface_with_error (v_err_msg
2559: ,v_table_name
2560: ,v_interface_id
2561: );

Line 2571: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';

2567: || 'using interface id of: '
2568: || v_interface_id
2569: || ' '
2570: || SUBSTR (SQLERRM, 1, 100);
2571: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';
2572: update_interface_with_error (v_err_msg
2573: ,v_table_name
2574: ,v_interface_id
2575: );