APPS.AMW_LOAD_CTRL_DATA dependencies on AMW_ASSESSMENT_COMPONENTS

Line 735: WHERE lookup_type='AMW_ASSESSMENT_COMPONENTS'

731: IS
732: CURSOR c_control_comp IS
733: SELECT lookup_code
734: FROM AMW_LOOKUPS
735: WHERE lookup_type='AMW_ASSESSMENT_COMPONENTS'
736: AND enabled_flag='Y'
737: AND tag=p_lookup_tag;
738:
739: l_ctrl_comp_code VARCHAR2(30);

Line 767: from amw_assessment_components

763:
764: if (l_ctrl_comp_flag = 'N') then
765: select count(*)
766: into l_comp_exists
767: from amw_assessment_components
768: where object_type='CONTROL'
769: AND object_id = vx_control_rev_id
770: AND component_code = l_ctrl_comp_code;
771:

Line 773: delete from amw_assessment_components

769: AND object_id = vx_control_rev_id
770: AND component_code = l_ctrl_comp_code;
771:
772: if(l_comp_exists > 0) then
773: delete from amw_assessment_components
774: where object_type='CONTROL'
775: AND object_id = vx_control_rev_id
776: AND component_code = l_ctrl_comp_code;
777: end if;

Line 785: from amw_assessment_components

781: --- this control objective has been selected
782: --- need to check if it is already present or not
783: select count(*)
784: into l_comp_exists
785: from amw_assessment_components
786: where object_type='CONTROL'
787: AND object_id = vx_control_rev_id
788: AND component_code = l_ctrl_comp_code;
789:

Line 792: INSERT INTO amw_assessment_components

788: AND component_code = l_ctrl_comp_code;
789:
790: if(l_comp_exists = 0) then
791: ---IF SQL%NOTFOUND THEN
792: INSERT INTO amw_assessment_components
793: (assessment_component_id
794: ,last_update_date
795: ,last_updated_by
796: ,creation_date

Line 804: amw_assessment_components_s.NEXTVAL

800: ,object_type
801: ,object_id
802: ,OBJECT_VERSION_NUMBER
803: ) VALUES (
804: amw_assessment_components_s.NEXTVAL
805: ,SYSDATE
806: ,v_user_id
807: ,SYSDATE
808: ,v_user_id

Line 828: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';

824: || p_lookup_tag
825: || 'using interface id of: '
826: || v_interface_id
827: || ' flag must be Y/N';
828: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';
829: update_interface_with_error (v_err_msg
830: ,v_table_name
831: ,v_interface_id
832: );

Line 841: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';

837: || p_lookup_tag
838: || 'using interface id of: '
839: || v_interface_id
840: || ' code does not exist';
841: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';
842: update_interface_with_error (v_err_msg
843: ,v_table_name
844: ,v_interface_id
845: );

Line 855: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';

851: || 'using interface id of: '
852: || v_interface_id
853: || ' '
854: || SUBSTR (SQLERRM, 1, 100);
855: v_table_name := 'AMW_ASSESSMENT_COMPONENTS';
856: update_interface_with_error (v_err_msg
857: ,v_table_name
858: ,v_interface_id
859: );