eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 5254: l_reason_id gmd_quality_config.transaction_reason_id%TYPE;

5250: , x_return_status OUT NOCOPY VARCHAR2
5251: ) IS
5252:
5253: -- Local Variables
5254: l_reason_id gmd_quality_config.transaction_reason_id%TYPE;
5255: l_message_data VARCHAR2(2000);
5256:
5257: -- this is almost the same cursor as cur_global_configurator
5258: -- in the samples form.

Line 5261: FROM gmd_quality_config

5257: -- this is almost the same cursor as cur_global_configurator
5258: -- in the samples form.
5259: CURSOR Cur_quality_config (p_organization_id NUMBER) IS
5260: SELECT transaction_reason_id
5261: FROM gmd_quality_config
5262: WHERE organization_id = p_organization_id
5263: AND transaction_reason_id IS NOT NULL
5264: ;
5265:

Line 6505: FROM gmd_quality_config

6501: -- Sample has a Spec
6502: --RLNAGARA B5106039 start
6503: --RLNAGARA B5106039 Added the below select stmt. Here I am checking whether the quality parameters has been defined for the sample organization
6504: SELECT count(1) INTO l_qlty_config_present
6505: FROM gmd_quality_config
6506: WHERE organization_id = l_sample.organization_id;
6507:
6508: 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
6509:

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

6529: ;
6530: 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
6531: /* SELECT count(1)
6532: INTO l_incomplete_count_from_spec
6533: FROM gmd_results r, gmd_spec_tests st, gmd_spec_results sr,gmd_quality_config gc
6534: WHERE sr.event_spec_disp_id = l_event_spec_disp.event_spec_disp_id
6535: AND sr.result_id = r.result_id
6536: AND r.sample_id = l_sample.sample_id
6537: AND st.spec_id = l_event_spec_disp.spec_id

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

6557:
6558:
6559: SELECT count(1)
6560: INTO l_incomplete_count_from_spec
6561: FROM gmd_results r, gmd_spec_tests st, gmd_spec_results sr,gmd_quality_config gc
6562: WHERE sr.event_spec_disp_id = l_event_spec_disp.event_spec_disp_id
6563: AND sr.result_id = r.result_id
6564: AND r.sample_id = l_sample.sample_id
6565: AND st.spec_id = l_event_spec_disp.spec_id

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

6588: -- replace above with below for bug 15885923 rework and bug 15942047
6589:
6590: SELECT count(1)
6591: INTO l_incomplete_count_from_spec
6592: FROM gmd_results r, gmd_spec_tests st, gmd_spec_results sr,gmd_quality_config gc
6593: WHERE sr.event_spec_disp_id = l_event_spec_disp.event_spec_disp_id
6594: AND sr.result_id = r.result_id
6595: AND r.sample_id = l_sample.sample_id
6596: AND st.spec_id = l_event_spec_disp.spec_id

Line 6795: l_lot_status_id GMD_QUALITY_CONFIG.in_spec_lot_status_id%TYPE;

6791:
6792: l_req_cnt NUMBER;
6793: l_lot_disp VARCHAR2(30);
6794: l_count NUMBER;
6795: l_lot_status_id GMD_QUALITY_CONFIG.in_spec_lot_status_id%TYPE;
6796: l_message_data VARCHAR2(2000);
6797:
6798: l_include_optional VARCHAR2(3);
6799: l_count_with_spec NUMBER;

Line 6808: FROM gmd_quality_config

6804: ====================*/
6805:
6806: CURSOR get_config_opt (p_org_id NUMBER) IS
6807: SELECT include_optional_test_rslt_ind
6808: FROM gmd_quality_config
6809: WHERE organization_id = p_org_id;
6810:
6811: l_config_opt VARCHAR2(1);
6812:

Line 7251: FROM gmd_quality_config

7247: ;
7248:
7249: CURSOR Cur_quality_config (p_organization_id VARCHAR2) IS
7250: SELECT transaction_reason_id
7251: FROM gmd_quality_config
7252: WHERE organization_id = p_organization_id
7253: AND transaction_reason_id IS NOT NULL;
7254:
7255:

Line 7277: l_reason_id gmd_quality_config.transaction_reason_id%TYPE;

7273: l_message_data VARCHAR2(2000);
7274: l_organization_id NUMBER;
7275:
7276: l_include_optional VARCHAR2(3);
7277: l_reason_id gmd_quality_config.transaction_reason_id%TYPE;
7278:
7279:
7280: /*
7281: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;

Line 7300: FROM gmd_quality_config

7296: ====================*/
7297:
7298: CURSOR get_config_opt (p_org_id NUMBER) IS
7299: SELECT include_optional_test_rslt_ind
7300: FROM gmd_quality_config
7301: WHERE organization_id = p_org_id;
7302:
7303: l_config_opt VARCHAR2(1);
7304: