APPS.GMD_RESULT_TRANSFER_GRP dependencies on GMD_RESULTS_GRP

Line 476: l_validate_res gmd_results_grp.result_data;

472: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
473: l_lot_number mtl_lot_numbers.lot_number%TYPE;
474: l_update_instance_id NUMBER;
475:
476: l_validate_res gmd_results_grp.result_data;
477: l_message_data VARCHAR2(100);
478:
479: l_return_status VARCHAR2(100);
480: -- l_sample_disp VARCHAR2(3);

Line 494: l_rslt_tbl gmd_results_grp.rslt_tbl;

490: l_in_spec VARCHAR2(1);
491: l_place NUMBER:=0;
492: l_msg VARCHAR2(150);
493: p_copy_flex VARCHAR2(1);
494: l_rslt_tbl gmd_results_grp.rslt_tbl;
495: l_composite_flag VARCHAR2(1) := 'N';
496: l_sample_active_cnt NUMBER;
497:
498:

Line 499: l_rslt_tbl_expression gmd_results_grp.rslt_tbl;

495: l_composite_flag VARCHAR2(1) := 'N';
496: l_sample_active_cnt NUMBER;
497:
498:
499: l_rslt_tbl_expression gmd_results_grp.rslt_tbl;
500: l_return_status_expression VARCHAR2(10);
501:
502:
503: BEGIN

Line 643: -- gmd_results_grp.validate_result(l_validate_res,

639:
640:
641:
642:
643: -- gmd_results_grp.validate_result(l_validate_res,
644: -- l_return_status);
645: GMD_RESULTS_GRP.validate_result
646: ( p_result_rec => l_validate_res,
647: x_return_status => l_return_status

Line 645: GMD_RESULTS_GRP.validate_result

641:
642:
643: -- gmd_results_grp.validate_result(l_validate_res,
644: -- l_return_status);
645: GMD_RESULTS_GRP.validate_result
646: ( p_result_rec => l_validate_res,
647: x_return_status => l_return_status
648: );
649: l_place := 35;

Line 715: gmd_results_grp.calc_expression

711: --B3356274 Now atleast one result is updated, so need to mark the composite result as invalid...
712: l_composite_flag := 'Y';
713:
714: IF (l_validate_res.test_type = 'E') THEN
715: gmd_results_grp.calc_expression
716: ( p_sample_id => p_sample_id
717: , p_event_spec_disp_id => l_event_spec_disp_id
718: , p_spec_id => l_spec_tests.spec_id
719: , x_rslt_tbl => l_rslt_tbl

Line 773: gmd_results_grp.add_tests_to_sample

769: into l_test_qty, l_test_qty_uom
770: from gmd_results
771: where result_id = temp_table_rslt_row.child_result_id;
772:
773: gmd_results_grp.add_tests_to_sample
774: (p_sample => l_sample
775: ,p_test_ids => test_ids
776: ,p_event_spec_disp_id => l_event_spec_disp_id
777: ,x_results_tab => add_rslt_tab_out

Line 813: gmd_results_grp.calc_expression

809: END LOOP;
810:
811: -- Bug 3892771
812: -- Need to calculate expressions
813: gmd_results_grp.calc_expression
814: ( p_sample_id => p_sample_id
815: , p_event_spec_disp_id => l_event_spec_disp_id
816: , p_spec_id => l_spec_tests.spec_id
817: , x_rslt_tbl => l_rslt_tbl_expression

Line 841: GMD_RESULTS_GRP.se_recomposite_required ( p_sampling_event_id => p_sampling_event_id

837: END;
838: END IF;
839:
840: IF (nvl(l_sample_active_cnt, 0) > 1) THEN
841: GMD_RESULTS_GRP.se_recomposite_required ( p_sampling_event_id => p_sampling_event_id
842: , p_event_spec_disp_id => l_event_spec_disp_id
843: , x_return_status => l_return_status
844: );
845: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 852: GMD_RESULTS_GRP.change_sample_disposition

848: END IF;
849:
850:
851: --B3356274, end invalidate composite result on result association
852: GMD_RESULTS_GRP.change_sample_disposition
853: ( p_sample_id => p_sample_id,
854: x_change_disp_to => x_sample_disp,
855: x_return_status => l_return_status,
856: x_message_data => l_message_data

Line 866: l_in_spec := gmd_results_grp.rslt_is_in_spec(l_spec_id,

862: p_copy_flex := 'Y';
863: END IF;
864: FOR c_temp_table_cmpt_row IN c_temp_table_cmpt LOOP
865: l_place := 50;
866: l_in_spec := gmd_results_grp.rslt_is_in_spec(l_spec_id,
867: c_temp_table_cmpt_row.test_id,
868: to_char(c_temp_table_cmpt_row.mean),
869: c_temp_table_cmpt_row.mode_char);
870: l_place := 55;