APPS.GMD_RESULTS_GRP dependencies on GMD_COMPOSITE_RESULT_ASSOC

Line 3599: FROM gmd_composite_spec_disp csd, gmd_composite_results cr, gmd_composite_result_assoc cra

3595:
3596: -- Cursors
3597: CURSOR c_composite (p_event_spec_disp_id NUMBER, p_result_id NUMBER) IS
3598: SELECT 1
3599: FROM gmd_composite_spec_disp csd, gmd_composite_results cr, gmd_composite_result_assoc cra
3600: WHERE csd.event_spec_disp_id = p_event_spec_disp_id
3601: AND csd.composite_spec_disp_id = cr.composite_spec_disp_id
3602: AND cr.composite_result_id = cra.composite_result_id
3603: AND cra.result_id = p_result_id

Line 3973: l_composite_result_assoc GMD_COMPOSITE_RESULT_ASSOC%ROWTYPE;

3969: sample_cnt PLS_INTEGER;
3970:
3971: l_composite_spec_disp GMD_COMPOSITE_SPEC_DISP%ROWTYPE;
3972: l_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;
3973: l_composite_result_assoc GMD_COMPOSITE_RESULT_ASSOC%ROWTYPE;
3974:
3975: l_out_composite_spec_disp GMD_COMPOSITE_SPEC_DISP%ROWTYPE;
3976: l_out_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;
3977:

Line 4234: -- Create a new record in GMD_COMPOSITE_RESULT_ASSOC

4230:
4231: -- Now record all the result_ids that made up this composite
4232: FOR result_rec IN c_all_test_data(test_rec.test_id)
4233: LOOP
4234: -- Create a new record in GMD_COMPOSITE_RESULT_ASSOC
4235:
4236: -- Construct the record
4237: l_composite_result_assoc.COMPOSITE_RESULT_ID := l_composite_result.composite_result_id;
4238: l_composite_result_assoc.RESULT_ID := result_rec.result_id;

Line 4244: -- We are ready for insert in GMD_COMPOSITE_RESULT_ASSOC, so then lets do it.

4240: l_composite_result_assoc.CREATED_BY := l_user_id;
4241: l_composite_result_assoc.LAST_UPDATE_DATE := l_date;
4242: l_composite_result_assoc.LAST_UPDATED_BY := l_user_id;
4243:
4244: -- We are ready for insert in GMD_COMPOSITE_RESULT_ASSOC, so then lets do it.
4245: IF NOT(GMD_COMPOSITE_RESULT_ASSOC_PVT.Insert_Row(
4246: p_composite_result_assoc => l_composite_result_assoc)
4247: )
4248: THEN

Line 4245: IF NOT(GMD_COMPOSITE_RESULT_ASSOC_PVT.Insert_Row(

4241: l_composite_result_assoc.LAST_UPDATE_DATE := l_date;
4242: l_composite_result_assoc.LAST_UPDATED_BY := l_user_id;
4243:
4244: -- We are ready for insert in GMD_COMPOSITE_RESULT_ASSOC, so then lets do it.
4245: IF NOT(GMD_COMPOSITE_RESULT_ASSOC_PVT.Insert_Row(
4246: p_composite_result_assoc => l_composite_result_assoc)
4247: )
4248: THEN
4249: -- Insert Error

Line 4260: gmd_debug.put_line(' Created record in GMD_COMPOSITE_RESULT_ASSOC for associated Result ID -' || result_rec.result_id);

4256: sample_cnt := sample_cnt + 1;
4257: END IF;
4258:
4259: IF (l_debug = 'Y') THEN
4260: gmd_debug.put_line(' Created record in GMD_COMPOSITE_RESULT_ASSOC for associated Result ID -' || result_rec.result_id);
4261: END IF;
4262:
4263: END LOOP; -- All atomic results for the test
4264: