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_RCM_ORG_DATA dependencies on AMW_ASSESSMENT_COMPONENTS

Line 2567: WHERE lookup_type='AMW_ASSESSMENT_COMPONENTS'

2563: IS
2564: CURSOR c_control_comp IS
2565: SELECT lookup_code
2566: FROM AMW_LOOKUPS
2567: WHERE lookup_type='AMW_ASSESSMENT_COMPONENTS'
2568: AND enabled_flag='Y'
2569: AND tag=p_lookup_tag;
2570:
2571: l_ctrl_comp_code VARCHAR2(30);

Line 2599: from amw_assessment_components

2595:
2596: if (l_ctrl_comp_flag = 'N') then
2597: select count(*)
2598: into l_comp_exists
2599: from amw_assessment_components
2600: where object_type='CONTROL'
2601: AND object_id = vx_control_rev_id
2602: AND component_code = l_ctrl_comp_code;
2603:

Line 2605: delete from amw_assessment_components

2601: AND object_id = vx_control_rev_id
2602: AND component_code = l_ctrl_comp_code;
2603:
2604: if(l_comp_exists > 0) then
2605: delete from amw_assessment_components
2606: where object_type='CONTROL'
2607: AND object_id = vx_control_rev_id
2608: AND component_code = l_ctrl_comp_code;
2609: end if;

Line 2617: from amw_assessment_components

2613: --- this control objective has been selected
2614: --- need to check if it is already present or not
2615: select count(*)
2616: into l_comp_exists
2617: from amw_assessment_components
2618: where object_type='CONTROL'
2619: AND object_id = vx_control_rev_id
2620: AND component_code = l_ctrl_comp_code;
2621:

Line 2624: INSERT INTO amw_assessment_components

2620: AND component_code = l_ctrl_comp_code;
2621:
2622: if(l_comp_exists = 0) then
2623: ---IF SQL%NOTFOUND THEN
2624: INSERT INTO amw_assessment_components
2625: (assessment_component_id
2626: ,last_update_date
2627: ,last_updated_by
2628: ,creation_date

Line 2636: amw_assessment_components_s.NEXTVAL

2632: ,object_type
2633: ,object_id
2634: ,OBJECT_VERSION_NUMBER
2635: ) VALUES (
2636: amw_assessment_components_s.NEXTVAL
2637: ,SYSDATE
2638: ,v_user_id
2639: ,SYSDATE
2640: ,v_user_id

Line 2660: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';

2656: || p_lookup_tag
2657: || 'using interface id of: '
2658: || v_interface_id
2659: || ' flag must be Y/N';
2660: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';
2661: update_interface_with_error (v_err_msg
2662: ,v_table_name
2663: ,v_interface_id
2664: );

Line 2673: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';

2669: || p_lookup_tag
2670: || 'using interface id of: '
2671: || v_interface_id
2672: || ' code does not exist';
2673: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';
2674: update_interface_with_error (v_err_msg
2675: ,v_table_name
2676: ,v_interface_id
2677: );

Line 2687: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';

2683: || 'using interface id of: '
2684: || v_interface_id
2685: || ' '
2686: || SUBSTR (SQLERRM, 1, 100);
2687: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';
2688: update_interface_with_error (v_err_msg
2689: ,v_table_name
2690: ,v_interface_id
2691: );