[Home] [Help]
670: tester_id = temp_table_rslt_row.tester_id,
671: tester = temp_table_rslt_row.tester,
672: parent_result_id = temp_table_rslt_row.parent_result_id,
673: last_update_date = sysdate,
674: last_updated_by = fnd_global.USER_ID,
675: text_code = decode(p_copy_edit_text,'Y',
676: temp_table_rslt_row.text_code,text_code),
677: attribute_category = decode(p_copy_flex,'Y',temp_table_rslt_row.attribute_category, attribute_category),
678: attribute1 = decode(p_copy_flex,'Y',temp_table_rslt_row.attribute1, attribute1),
745: SET IN_SPEC_IND = l_validate_res.in_spec,
746: evaluation_ind = l_validate_res.evaluation_ind,
747: action_code = l_validate_res.result_action_code,
748: last_update_date = SYSDATE,
749: last_updated_by = fnd_global.user_id
750: WHERE event_spec_disp_id = l_event_spec_disp_id
751: AND result_id = temp_table_rslt_row.child_result_id;
752:
753: --Now if the evaluation is reject make sure that you add a test
882: range= c_temp_table_cmpt_row.range,
883: non_validated_result = c_temp_table_cmpt_row.non_validated_result,
884: standard_deviation = c_temp_table_cmpt_row.standard_deviation,
885: last_update_date = SYSDATE,
886: last_updated_by = fnd_global.USER_ID,
887: text_code = decode(p_copy_edit_text,'Y',
888: c_temp_table_cmpt_row.text_code,text_code),
889: parent_composite_result_id = c_temp_table_cmpt_row.parent_result_id,
890: attribute_category = decode(p_copy_flex,'Y',c_temp_table_cmpt_row.attribute_category, attribute_category),
1042: range= l_previous_row.range,
1043: non_validated_result = l_previous_row.non_validated_result,
1044: standard_deviation = l_previous_row.standard_deviation,
1045: last_update_date = SYSDATE,
1046: last_updated_by = fnd_global.USER_ID,
1047: text_code =l_previous_row.text_code,
1048: parent_composite_result_id = l_previous_row.parent_composite_result_id,
1049: attribute_category = l_previous_row.attribute_category,
1050: attribute1 = l_previous_row.attribute1,