DBA Data[Home] [Help]

APPS.GMD_RESULT_TRANSFER_GRP dependencies on GMD_COMPOSITE_RESULT_ASSOC

Line 1105: delete gmd_composite_result_assoc

1101: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1102: -- There can never be any issue with locking as exiting the form should always delete single
1103: -- composites.
1104: l_place := 10;
1105: delete gmd_composite_result_assoc
1106: where composite_result_id IN
1107: (select composite_result_id
1108: from gmd_composite_results
1109: where composite_spec_disp_id = p_composite_spec_disp_id);

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

1107: (select composite_result_id
1108: from gmd_composite_results
1109: where composite_spec_disp_id = p_composite_spec_disp_id);
1110: IF (l_debug = 'Y') THEN
1111: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_result_assoc for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');
1112: END IF;
1113: l_place := 20;
1114: delete gmd_composite_results
1115: where composite_spec_disp_id = p_composite_spec_disp_id;