APPS.GMD_RESULTS_GRP dependencies on GMD_QUALITY_CONFIG

Line 56: --| gmd_quality_config. |

52: --| with this evaluation. |
53: --| rboddu 13-Sep-2004 Bug 376341. Replaced '1X' with '1Z' |
54: --| J. DiIorio Jan-05-2006 Bug#4691545 - Replaced profile retrieval of |
55: --| GMD_INCLUDE_OPTIONAL_TEST with call to |
56: --| gmd_quality_config. |
57: --| RLNAGARA 22-MAR-2006 Bug#5097709. Modified the procedure |
58: --| calc_expression so that expression type tests results are calculated |
59: --| properly when their refernce tests evaluation is changed but not results.|
60: --| RLNAGARA 27-MAR-2006 Bug#5106039 Modified the proc change_sample_disposition |

Line 5085: l_reason_id gmd_quality_config.transaction_reason_id%TYPE;

5081: , x_return_status OUT NOCOPY VARCHAR2
5082: ) IS
5083:
5084: -- Local Variables
5085: l_reason_id gmd_quality_config.transaction_reason_id%TYPE;
5086: l_message_data VARCHAR2(2000);
5087:
5088: -- this is almost the same cursor as cur_global_configurator
5089: -- in the samples form.

Line 5092: FROM gmd_quality_config

5088: -- this is almost the same cursor as cur_global_configurator
5089: -- in the samples form.
5090: CURSOR Cur_quality_config (p_organization_id NUMBER) IS
5091: SELECT transaction_reason_id
5092: FROM gmd_quality_config
5093: WHERE organization_id = p_organization_id
5094: AND transaction_reason_id IS NOT NULL
5095: ;
5096:

Line 6243: FROM gmd_quality_config

6239: -- Sample has a Spec
6240: --RLNAGARA B5106039 start
6241: --RLNAGARA B5106039 Added the below select stmt. Here I am checking whether the quality parameters has been defined for the sample organization
6242: SELECT count(1) INTO l_qlty_config_present
6243: FROM gmd_quality_config
6244: WHERE organization_id = l_sample.organization_id;
6245:
6246: IF l_qlty_config_present = 0 THEN --IF the process parameters for the sample org is not defined then consider only the non-optional test
6247:

Line 6271: FROM gmd_results r, gmd_spec_tests st, gmd_spec_results sr,gmd_quality_config gc

6267: ;
6268: ELSE --IF the process parameters for the sample org is defined then consider the tests based on the vlaue of include_optional_test_rslt_ind checkbox
6269: SELECT count(1)
6270: INTO l_incomplete_count_from_spec
6271: FROM gmd_results r, gmd_spec_tests st, gmd_spec_results sr,gmd_quality_config gc
6272: WHERE sr.event_spec_disp_id = l_event_spec_disp.event_spec_disp_id
6273: AND sr.result_id = r.result_id
6274: AND r.sample_id = l_sample.sample_id
6275: AND st.spec_id = l_event_spec_disp.spec_id

Line 6471: l_lot_status_id GMD_QUALITY_CONFIG.in_spec_lot_status_id%TYPE;

6467:
6468: l_req_cnt NUMBER;
6469: l_lot_disp VARCHAR2(30);
6470: l_count NUMBER;
6471: l_lot_status_id GMD_QUALITY_CONFIG.in_spec_lot_status_id%TYPE;
6472: l_message_data VARCHAR2(2000);
6473:
6474: l_include_optional VARCHAR2(3);
6475: l_count_with_spec NUMBER;

Line 6484: FROM gmd_quality_config

6480: ====================*/
6481:
6482: CURSOR get_config_opt (p_org_id NUMBER) IS
6483: SELECT include_optional_test_rslt_ind
6484: FROM gmd_quality_config
6485: WHERE organization_id = p_org_id;
6486:
6487: l_config_opt VARCHAR2(1);
6488:

Line 6874: FROM gmd_quality_config

6870: ;
6871:
6872: CURSOR Cur_quality_config (p_organization_id VARCHAR2) IS
6873: SELECT transaction_reason_id
6874: FROM gmd_quality_config
6875: WHERE organization_id = p_organization_id
6876: AND transaction_reason_id IS NOT NULL;
6877:
6878:

Line 6900: l_reason_id gmd_quality_config.transaction_reason_id%TYPE;

6896: l_message_data VARCHAR2(2000);
6897: l_organization_id NUMBER;
6898:
6899: l_include_optional VARCHAR2(3);
6900: l_reason_id gmd_quality_config.transaction_reason_id%TYPE;
6901:
6902:
6903: /*
6904: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;

Line 6923: FROM gmd_quality_config

6919: ====================*/
6920:
6921: CURSOR get_config_opt (p_org_id NUMBER) IS
6922: SELECT include_optional_test_rslt_ind
6923: FROM gmd_quality_config
6924: WHERE organization_id = p_org_id;
6925:
6926: l_config_opt VARCHAR2(1);
6927: