APPS.GMD_RESULTS_GRP dependencies on GMD_COMPOSITE_RESULT_ASSOC

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

3426:
3427: -- Cursors
3428: CURSOR c_composite (p_event_spec_disp_id NUMBER, p_result_id NUMBER) IS
3429: SELECT 1
3430: FROM gmd_composite_spec_disp csd, gmd_composite_results cr, gmd_composite_result_assoc cra
3431: WHERE csd.event_spec_disp_id = p_event_spec_disp_id
3432: AND csd.composite_spec_disp_id = cr.composite_spec_disp_id
3433: AND cr.composite_result_id = cra.composite_result_id
3434: AND cra.result_id = p_result_id

Line 3804: l_composite_result_assoc GMD_COMPOSITE_RESULT_ASSOC%ROWTYPE;

3800: sample_cnt PLS_INTEGER;
3801:
3802: l_composite_spec_disp GMD_COMPOSITE_SPEC_DISP%ROWTYPE;
3803: l_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;
3804: l_composite_result_assoc GMD_COMPOSITE_RESULT_ASSOC%ROWTYPE;
3805:
3806: l_out_composite_spec_disp GMD_COMPOSITE_SPEC_DISP%ROWTYPE;
3807: l_out_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;
3808:

Line 4065: -- Create a new record in GMD_COMPOSITE_RESULT_ASSOC

4061:
4062: -- Now record all the result_ids that made up this composite
4063: FOR result_rec IN c_all_test_data(test_rec.test_id)
4064: LOOP
4065: -- Create a new record in GMD_COMPOSITE_RESULT_ASSOC
4066:
4067: -- Construct the record
4068: l_composite_result_assoc.COMPOSITE_RESULT_ID := l_composite_result.composite_result_id;
4069: l_composite_result_assoc.RESULT_ID := result_rec.result_id;

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

4071: l_composite_result_assoc.CREATED_BY := l_user_id;
4072: l_composite_result_assoc.LAST_UPDATE_DATE := l_date;
4073: l_composite_result_assoc.LAST_UPDATED_BY := l_user_id;
4074:
4075: -- We are ready for insert in GMD_COMPOSITE_RESULT_ASSOC, so then lets do it.
4076: IF NOT(GMD_COMPOSITE_RESULT_ASSOC_PVT.Insert_Row(
4077: p_composite_result_assoc => l_composite_result_assoc)
4078: )
4079: THEN

Line 4076: IF NOT(GMD_COMPOSITE_RESULT_ASSOC_PVT.Insert_Row(

4072: l_composite_result_assoc.LAST_UPDATE_DATE := l_date;
4073: l_composite_result_assoc.LAST_UPDATED_BY := l_user_id;
4074:
4075: -- We are ready for insert in GMD_COMPOSITE_RESULT_ASSOC, so then lets do it.
4076: IF NOT(GMD_COMPOSITE_RESULT_ASSOC_PVT.Insert_Row(
4077: p_composite_result_assoc => l_composite_result_assoc)
4078: )
4079: THEN
4080: -- Insert Error

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

4087: sample_cnt := sample_cnt + 1;
4088: END IF;
4089:
4090: IF (l_debug = 'Y') THEN
4091: gmd_debug.put_line(' Created record in GMD_COMPOSITE_RESULT_ASSOC for associated Result ID -' || result_rec.result_id);
4092: END IF;
4093:
4094: END LOOP; -- All atomic results for the test
4095: