APPS.GMD_MASS_RESULTS_GRP dependencies on GMD_MASS_RESULTS_GT

Line 36: --| the table - GMD_MASS_RESULTS_GT. |

32: --| TYPE : Group |
33: --| Notes : This procedure receives as input parameters, a seq_id. |
34: --| It extracts all the results and related data for the |
35: --| sample_ids associated with the SEQ_ID passed and populates
36: --| the table - GMD_MASS_RESULTS_GT. |
37: --| |
38: --| This erything is fine then OUT parameter |
39: --| x_return_status is set to 'S' else appropriate |
40: --| error message is put on the stack and error |

Line 78: DELETE FROM gmd_mass_results_gt;

74: -- Initialize API return status to success
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: -- First clear the TEMP table.
78: DELETE FROM gmd_mass_results_gt;
79:
80: -- Now populate fresh
81:
82: INSERT INTO gmd_mass_results_gt

Line 82: INSERT INTO gmd_mass_results_gt

78: DELETE FROM gmd_mass_results_gt;
79:
80: -- Now populate fresh
81:
82: INSERT INTO gmd_mass_results_gt
83: (
84: -- Sampling Event Info
85: SAMPLING_EVENT_ID
86: , SAMPLE_ACTIVE_CNT

Line 302: INSERT INTO gmd_mass_results_gt

298: and nvl(s.retain_as, 'X') not in ('A', 'R') ; -- B3358725
299:
300: --RLNAGARA Bug # 4913637
301:
302: INSERT INTO gmd_mass_results_gt
303: (
304: -- Sampling Event Info
305: SAMPLING_EVENT_ID
306: , SAMPLE_ACTIVE_CNT

Line 519: gmd_debug.put_line(' No. of rows inserted into GMD_MASS_RESULTS_GT : ' || SQL%ROWCOUNT);

515:
516:
517:
518: IF (l_debug = 'Y') THEN
519: gmd_debug.put_line(' No. of rows inserted into GMD_MASS_RESULTS_GT : ' || SQL%ROWCOUNT);
520: END IF;
521:
522: UPDATE gmd_mass_results_gt
523: SET update_allowed = 0

Line 522: UPDATE gmd_mass_results_gt

518: IF (l_debug = 'Y') THEN
519: gmd_debug.put_line(' No. of rows inserted into GMD_MASS_RESULTS_GT : ' || SQL%ROWCOUNT);
520: END IF;
521:
522: UPDATE gmd_mass_results_gt
523: SET update_allowed = 0
524: WHERE (result_date IS NOT NULL OR test_type = 'E')
525: ;
526:

Line 562: FROM gmd_mass_results_gt

558: ) IS
559:
560: CURSOR c1 IS
561: SELECT *
562: FROM gmd_mass_results_gt
563: WHERE sample_id = nvl(p_sample_id, sample_id)
564: AND result_id = nvl(p_result_id, result_id)
565: AND test_id = nvl(test_id, p_test_id)
566: ORDER BY sample_id, result_id;

Line 571: gmd_debug.put_line('Data in session table - gmd_mass_results_gt');

567:
568: BEGIN
569: IF (l_debug = 'Y') THEN
570: gmd_debug.put_line('');
571: gmd_debug.put_line('Data in session table - gmd_mass_results_gt');
572: gmd_debug.put_line(' Sample ID Result ID Test ID Data Num Data Char UA RU');
573: gmd_debug.put_line('---------- ---------- ---------- --------------- --------------- -- --');
574: END IF;
575: