507:
508: select opinion_component_id into v_overall from amw_opinion_componts_b
509: where opinion_component_code = 'OVERALL' and object_opinion_type_id =
510: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
511: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
512:
513: select opinion_component_id into v_design from amw_opinion_componts_b
514: where opinion_component_code = 'DESIGN' and object_opinion_type_id =
515: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
512:
513: select opinion_component_id into v_design from amw_opinion_componts_b
514: where opinion_component_code = 'DESIGN' and object_opinion_type_id =
515: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
516: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
517:
518: select opinion_component_id into v_operating from amw_opinion_componts_b
519: where opinion_component_code = 'OPERATING' and object_opinion_type_id =
520: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
517:
518: select opinion_component_id into v_operating from amw_opinion_componts_b
519: where opinion_component_code = 'OPERATING' and object_opinion_type_id =
520: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
521: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
522:
523: select object_opinion_type_id into v_opinion_object_id from AMW_OBJECT_OPINION_TYPES
524: where opinion_type_id = (select opinion_type_id from AMW_OPINION_TYPES_b
525: where opinion_type_code = 'EVALUATION') and object_id = (select object_id from
522:
523: select object_opinion_type_id into v_opinion_object_id from AMW_OBJECT_OPINION_TYPES
524: where opinion_type_id = (select opinion_type_id from AMW_OPINION_TYPES_b
525: where opinion_type_code = 'EVALUATION') and object_id = (select object_id from
526: fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL');
527:
528: fnd_file.put_line (fnd_file.LOG, 'Updating Control evaluation details');
529: FOR eff_details_rec IN c_effec_details LOOP
530: