APPS.GMD_RESULT_TRANSFER_GRP dependencies on GMD_COMPOSITE_SPEC_DISP

Line 124: gmd_composite_spec_disp sd,

120: r.non_validated_result,
121: r.standard_deviation , ges.spec_id,
122: r.creation_date
123: from gmd_composite_results r,
124: gmd_composite_spec_disp sd,
125: gmd_event_spec_disp ges
126: where r.composite_spec_disp_id =sd.composite_spec_disp_id
127: --and sd.event_spec_disp_id = 1
128: and sd.event_spec_disp_id = ges.event_spec_disp_id

Line 134: gmd_composite_spec_disp gcs,

130: and nvl(sd.latest_ind,'N') = 'Y'
131: and ges.sampling_event_id = p_parent_id
132: and r.test_id in (select r1.test_id
133: from gmd_composite_results r1,
134: gmd_composite_spec_disp gcs,
135: gmd_event_spec_disp ges
136: where ges.event_spec_disp_id = gcs.event_spec_disp_id
137: and gcs.latest_ind = 'Y'
138: and gcs.composite_spec_disp_id = r1.composite_spec_disp_id

Line 146: gmd_composite_spec_disp gcs,

142: Cursor c_get_child_composite(p_sampling_event_id IN NUMBER,
143: p_test_id IN NUMBER) IS
144: select r1.composite_result_id
145: from gmd_composite_results r1,
146: gmd_composite_spec_disp gcs,
147: gmd_event_spec_disp ges
148: where ges.event_spec_disp_id = gcs.event_spec_disp_id
149: and gcs.latest_ind = 'Y'
150: and gcs.composite_spec_disp_id = r1.composite_spec_disp_id

Line 1004: gmd_composite_spec_disp a --Bug 3017743, added to get event spec disp id.

1000: r.ATTRIBUTE28,
1001: r.ATTRIBUTE29,
1002: r.ATTRIBUTE30
1003: FROM gmd_composite_results r,
1004: gmd_composite_spec_disp a --Bug 3017743, added to get event spec disp id.
1005: WHERE r.composite_spec_disp_id = p_composite_spec_disp_id
1006: AND r.composite_spec_disp_id = a.composite_spec_disp_id
1007: AND r.parent_composite_result_id IS NOT NULL
1008: ;

Line 1016: FROM gmd_composite_results a, gmd_composite_spec_disp b

1012:
1013: CURSOR c_curr_compo_rec(p_event_spec_disp_id IN NUMBER,
1014: p_test_id IN NUMBER) IS
1015: SELECT composite_result_id
1016: FROM gmd_composite_results a, gmd_composite_spec_disp b
1017: WHERE a.composite_spec_disp_id = b.composite_spec_disp_id
1018: AND b.latest_ind = 'Y'
1019: AND b.event_spec_disp_id = p_event_spec_disp_id
1020: AND a.test_id = p_test_id

Line 1122: delete gmd_composite_spec_disp

1118: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_results for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');
1119: END IF;
1120:
1121: l_place := 30;
1122: delete gmd_composite_spec_disp
1123: where composite_spec_disp_id = p_composite_spec_disp_id;
1124: IF (l_debug = 'Y') THEN
1125: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_spec_disp for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');
1126: END IF;

Line 1125: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_spec_disp for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');

1121: l_place := 30;
1122: delete gmd_composite_spec_disp
1123: where composite_spec_disp_id = p_composite_spec_disp_id;
1124: IF (l_debug = 'Y') THEN
1125: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_spec_disp for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');
1126: END IF;
1127: --Bug 3334382, single sample group transaction not gettting deleted
1128: COMMIT;
1129: --end bug 3334382